MySQL Workbench dark theme

How to change MySQLWorkbench settings so that it uses dark theme?

From [MySQLdiscussion group] 2023-10-14 10:51:40 0  2  1497

php mysqli_connect: Authentication method unknown to client

I'm using phpmysqli_connect to log into a MySQL database (all on localhost) <?php//DEFINE('DB_USER','user2'...

From [MySQLdiscussion group] 2023-10-13 18:02:37 0  2  779

MySQL - Convert rows to columns

I tried searching posts but only found solutions for SQLServer/Access. I need a solution in MySQL (5.X). I hav...

From [MySQLdiscussion group] 2023-10-13 11:50:31 0  1  719

Using variables to execute SQL statements in Python

I have the following Python code: cursor.execute("INSERTINTOtableVALUESvar1,var2,var3,") where var1 ...

From [MySQLdiscussion group] 2023-10-12 15:06:00 0  2  761

mysql update column with value from another table

I have two tables, both look like idnamevalue===================1Joe222Derk30 I need to copy the value of valu...

From [MySQLdiscussion group] 2023-10-11 20:04:57 0  2  605

Where clause used in left join

I need to retrieve all default settings from the settings table, but also get the character settings if the x ...

From [MySQLdiscussion group] 2023-10-11 12:46:28 0  2  761

MySQL error: "Each derived table must have its own alias" What does it mean?

I'm running this query on MySQL SELECTIDFROM(SELECTID,msisdnFROM(SELECT*FROMTT2)); and it gives this error: Ea...

From [MySQLdiscussion group] 2023-10-10 20:45:21 0  2  852

How to insert records extracted from another table into one table

I'm trying to write a query that extracts and transforms data from a table and then inserts that data into ano...

From [MySQLdiscussion group] 2023-10-10 17:36:09 0  2  778

How to import a MySQL database from the terminal?

How to import mysql database from terminal? I can't find the exact syntax.

From [MySQLdiscussion group] 2023-10-10 11:36:13 0  2  680

Please upgrade the MySQL client: MySQL 8.0 - The client does not support the authentication protocol requested by the server

For some reason I can't establish a simple connection to the server. I installed the latest MySQLCommunity8.0 ...

From [MySQLdiscussion group] 2023-10-10 09:34:48 0  2  847

Access denied for user 'root'@'localhost' (using password: yes) - No permission?

I keep getting this error. I'm using mySQLWorkbench and I found that root's schema permissions are empty. Ther...

From [MySQLdiscussion group] 2023-10-09 19:39:30 0  2  1347

MySQL: Get latest entry in each group

There is a table messages, which contains data like this: IdNameOther_Columns-------------------------1AA_data...

From [MySQLdiscussion group] 2023-10-09 15:34:01 0  2  687

How to import CSV file into MySQL table?

I have a non-normalized event log CSV from a client that I'm trying to load into a MySQL table so it can be re...

From [MySQLdiscussion group] 2023-10-09 14:59:12 0  2  875

What do "symbol not found" or "unable to resolve symbol" errors mean?

Please explain the following about "symbol not found", "cannot resolve symbol" or "sy...

From [MySQLdiscussion group] 2023-10-09 13:52:29 0  2  1476

MySQL: Get latest entry in each group

There is a table messages, which contains data like this: IdNameOther_Columns-------------------------1AA_data...

From [MySQLdiscussion group] 2023-10-09 12:38:29 0  2  611