sql tag

625 questions


1 answers
143 views
0
Is there a name for the tool that needs to be restarted when updating without restarting?

I think there are a lot of different tools and operating systems that need to be rebooted when updating.Is there any name for updating without rebooting at this time?When I was asked to restart SQL Se...

2 years ago

1 answers
49 views
0
Warning: mysql_num_rows() expect parameter 1 to be resource, boolean given error

Error statement: Warning: mysql_num_rows() expectations parameter 1 to be resource, boolean give in/Applications/XAMPP/xamppfiles/htdocs/testsite/search.phponline33What is the cause?<html><he...

2 years ago

1 answers
46 views
0
Information About Adding Information to Java MySQL

Data Manipulation Classpublic class Toi3_db{ /** * @paramargs * @throws SQLException * @throws ClassNotFoundException */ public static void main(String[]args)rows SQLException, ClassNotFoundExce...

2 years ago

1 answers
109 views
0
MySQL goes down with only PDO connections.

To test the load on the rental server, we simulated it with 800 PV/sec access, but after a certain number of seconds (about 30 seconds) each time, the MySQL connection error occurs.負荷 If the load test...

2 years ago

2 answers
47 views
0
About creating SQL for search functions.

Creating search functionality using Java and SQL.The values entered in the search items (name, name, kana, hobby text box) on the form screen are filled in the placeholder specified in the where claus...

2 years ago

1 answers
96 views
0
An error occurs when Capistrano deploys the Rails app to EC2.PG::ConnectionBad:FATAL:Peer authentication failed for user "postgres"

AW I am a beginner at AWS.Until now, I have only used Heroku.AWS Configuration1 EC2 instancePostgreSQL on RDS, one I'd like to deploy the Rails app to EC2 via Capistrano.The following Capistrano comma...


1 answers
115 views
0
To run Oracle SQLcl in batches

I wrote the following batch file to output table data to CSV file using Oracle SQLcl in Windows environment, but it doesn't work except to access the database.Please teach me how to write correctly.@e...

2 years ago

1 answers
82 views
0
How do I reflect time zone settings in MySQL on a Docker container?

I have a question about MySQL time zone settings.If you build or run using the Dockerfile below, the container will print an error and exit.like loading timezone table information with the mysql_tzinf...

2 years ago

1 answers
55 views
0
I want to compile data with consecutive dates in SQLite.

I am using SQLite3 to assume the following data, but would it be possible to extract (type_id, start date, end date) for data with the same type_id and serial number?◇data·id: Integer(primary key)·typ...

2 years ago

2 answers
56 views
0
Does VACUUM (not FULL) in PostgreSQL make it easier to cache into memory?

According to the video below from 6:00, it will be difficult to cache into memory if unnecessary areas increase.On the other hand, according to 7:30~, non-FULL VACUUM only registers unnecessary areas ...

2 years ago
« - 18 - »

© 2024 OneMinuteCode. All rights reserved.