sql tag

625 questions


1 answers
54 views
0
MySQL on Plesk 12 is unable to access the database externally

I use Plesk 12.Attempts to access the MySQL database remotely from an external server fail.Allowing any host to connect did not change.When I read the log, there was nothing to do with it.

1 years ago

1 answers
143 views
0
Handling Chinese Characters in Queries When Accessing AZURE SQL

select Name from Customer Basic Information where Name = 'Kanji'If so, the result is zero.On the AZURE SQL management site select Name from Customer Basic Information where Name = N 'Kanji'If you add ...


1 answers
68 views
0
Handling Chinese Characters in Queries When Accessing AZURE SQL

select Name from Customer Basic Information where Name = 'Kanji'If so, the result is zero.On the AZURE SQL management site select Name from Customer Basic Information where Name = N 'Kanji'If you add ...


2 answers
90 views
0
The SQL I inquired about once on Oracle has not returned the results since the second time.

In the Oracle database, the results will be returned in a few seconds, but if you contact the exact same SQL immediately afterwards, the results will not be returned immediately.I'm sorry that I can't...

1 years ago

2 answers
80 views
0
The SQL I inquired about once on Oracle has not returned the results since the second time.

In the Oracle database, the results will be returned in a few seconds, but if you contact the exact same SQL immediately afterwards, the results will not be returned immediately.I'm sorry that I can't...

1 years ago

2 answers
47 views
0
Learn how to write SQL to register and update large amounts of DB data faster

The INSERT and UPDATE statements used to register data in DB can be written by registering multiple data in one SQL, but if the amount of data is large, how can I create SQL faster?I thought it would ...

1 years ago

2 answers
55 views
0
Learn how to write SQL to register and update large amounts of DB data faster

The INSERT and UPDATE statements used to register data in DB can be written by registering multiple data in one SQL, but if the amount of data is large, how can I create SQL faster?I thought it would ...

1 years ago

1 answers
37 views
0
SQL query to sort data from two tables (MySQL)

Table A ID_A,Name_ATable B ID_B,Name_B,Gender,ID_AI'd like to sort out all the data (ID_B, Name_B, Gender, ID_A, Name_A) from these two data tables, but the sorting condition is ①Name_BDESC,②If there ...

1 years ago

1 answers
100 views
0
MySQL no longer starts.Please let me know the solution!

I'm a beginner in programming.I tried it through trial and error, but I couldn't solve it, so I have a question.Mysql installed on xampp has stopped starting, and the database is not available and the...

1 years ago

1 answers
37 views
0
InnoDB: The OS said file flush did not succeed

ERROR InnoDB: The OS said file flush did not succeed What kind of error is ?

1 years ago
« - 13 - »

© 2024 OneMinuteCode. All rights reserved.