MySQL Forums
Mar 18, 2026 · Forum for MySQL Enterprise Monitor & Oracle Enterprise Manager for MySQL
How do you use the "WITH" clause in MySQL? - Stack Overflow
191 MySQL prior to version 8.0 doesn't support the WITH clause (CTE in SQL Server parlance; Subquery Factoring in Oracle), so you are left with using: TEMPORARY tables DERIVED tables …
MySQL: @variable vs. variable. What's the difference?
80 In MySQL, @variable indicates a user-defined variable. You can define your own. ... Outside of stored programs, a variable, without @, is a system variable, which you cannot define yourself. The …
MySQL :: Re: Database initialization Issue
Feb 1, 2025 · Even though permissions were granted, make sure the MySQL directories (`data` and `install`) have the appropriate write permissions for the user account running MySQL. 5. **Reinstall …
Where does MySQL store database files on Windows and what are the …
In Windows 7, the MySQL database is stored at C:\ProgramData\MySQL\MySQL Server 5.6\data Note: this is a hidden folder. And my example is for MySQL Server version 5.6; change the folder name …
How do I import CSV file into a MySQL table? - Stack Overflow
7 The mysql command line is prone to too many problems on import. Here is how you do it: use excel to edit the header names to have no spaces save as .csv use free Navicat Lite Sql Browser to import …
sql - MySQL query String contains - Stack Overflow
52 Mine is using LOCATE in mysql: LOCATE (substr,str), LOCATE (substr,str,pos) This function is multi-byte safe, and is case-sensitive only if at least one argument is a binary string. In your case:
sql - MySQL "NOT IN" query - Stack Overflow
MySQL, as well as all other systems except SQL Server, is able to optimize LEFT JOIN / IS NULL to return FALSE as soon the matching value is found, and it is the only system that cared to document …
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 - SQL keys, MUL vs PRI vs UNI - Stack Overflow
What is the difference between MUL, PRI and UNI in MySQL? I'm working on a MySQL query, using the command: desc mytable; One of the fields is shown as being a MUL key, others show up as UNI or P...