sql tag

625 questions


1 answers
109 views
0
garbled when inserted into mysql

Scrap elements in htmlsimpledom and Inserting a string into mysql in PDO causes garbled characters as follows:ティィフ𝹑ール&...

2 years ago

1 answers
54 views
0
Sort PostgreSQL in alphabetical and numeric ascending order

I'd like to sort PostgreSQL version 9.3 with ascending alphabetic characters and ascending numeric characters.Is there a way?000100030010a001d001k001i001z001↓ If I do ORDER BY, I would like to sort it...

2 years ago

1 answers
43 views
0
How to Find MySQL Deviation Values

I would like to obtain the deviation value (not the standard deviation) for each subject for the test table with the subject and point columns. What should I do?The standard deviation and average valu...

2 years ago

1 answers
42 views
0
If you strengthen the root password in MySQL, you will be asked to change the password again.

Thank you for your help.Please let me know if the database authorization is not successful.Create a user and database created with the root account.Grant permission to create a database so that it can...

2 years ago

1 answers
55 views
0
About jQuery fullcalendar

We are working with fullcalendar and Mysql to create applications.When you click the month switch button (month, month after month), you can view the event for that month.I'd like to switch and draw, ...

2 years ago

1 answers
41 views
0
Cannot connect to MySQL on another PC

I want to access MySQL on my server PC at home from another PC at home, but I can't.MySQL version is 8.0.From another PC in the same IP address as the server PC mysql-u admin-pERROR 1045 (28000): Acce...

2 years ago

1 answers
84 views
0
MySQL collate utf8_unicode_ci does not match Suzuki

I use Rails 3.2.13+MySQL5.Collation in MySQL is collate utf8_unicode_ci.I didn't know this function existed, so I was surprised that I searched and matched the data in full-width katakana in full-widt...


1 answers
42 views
0
I've been restoring a lot of dump files to mysql, but I keep getting Waiting for table flush.

Hello I'm restoring a large number of sql files (about 300MB per file) to mysql, but when I do the show process list, I sometimes see an insert statement and then I keep seeing Waiting for table flush...

2 years ago

1 answers
130 views
0
Export from Access DB to MySQL DB

You are trying to export from Access DB to MySQL using MySQL ODBC.Select the table in MS Access, export → ODBC database, and When you run it, ODBC - The call failed.                  Incorrect string ...

2 years ago

1 answers
46 views
0
I want to return it as true or false after it is summarized in Group By.

samples table id, A, B1, 1, 12, 1, 23, 1, 34, 1, 35, 2, 1For tables like the ones above, I would like to write SQL that returns true if B contains 2, or false if not.Response ExampleA,contains1, true2...

2 years ago
« - 22 - »

© 2024 OneMinuteCode. All rights reserved.