MySQL Forums
Jul 22, 2025 · Forum to discuss quality assurance techniques, such as bug reports, test cases, code patches
MySQL :: Database initialization Issue
Nov 15, 2024 · MySQL Forums Forum List » Newbie New Topic Database initialization Issue Posted by: Rafael Harmon Date: November 15, 2024 12:42AM
mysql - SQL select only rows with max value on a column - Stack …
At first glance... All you need is a GROUP BY clause with the MAX aggregate function: SELECT id, MAX(rev) FROM YourTable GROUP BY id It's never that simple, is it? I just noticed you …
How to set initial value and auto increment in MySQL?
Dec 30, 2014 · 36 MySQL Workbench If you want to avoid writing sql, you can also do it in MySQL Workbench by right clicking on the table, choose "Alter Table ..." in the menu. When …
mysql - DBeaver error resolving maven dependencies - Stack …
I am trying to connect to a remote MySQL database using DBeaver 3.6.3. But when I try to add the server as a new connection, I need to select a connection type. I select MySQL and as …
ERROR 1130 (HY000): Host '' is not allowed to connect to this …
Why oh why can I not connect to mysql? mysql -u root -ptest101 -h xxx.xxx.xxx.xxx ERROR 1130 (HY000): Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server In my.cnf I …
How to connect to MySQL from the command line - Stack Overflow
Feb 27, 2011 · How can you connect to MySQL from the command line in a Mac? (i.e. show me the code) I'm doing a PHP/SQL tutorial, but it starts by assuming you're already in MySQL.
mysql - Getting "Lock wait timeout exceeded; try restarting …
I'm running the following MySQL UPDATE statement: mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting …
MySQL :: MySQL Forums :: MySQL Workbench
Sep 17, 2024 · 1,953 Jim Edvardsson 10/25/2024 07:59AM MySQL Workbench crashing on Reverse Engineering, Forward Engineering, and Model Sync 740 Jorge Pimentel 10/14/2024 …
mysql - What does it mean `SELECT 1 FROM table`? - Stack Overflow
Jun 13, 2024 · I have seen many queries with something as follows: SELECT 1 FROM table What does this 1 mean, how will it be executed, and what will it return? Also, in what type of …