- MySQL Forums
Forum to discuss quality assurance techniques, such as bug reports, test cases, code patches
- Announcing October 2024 Releases featuring MySQL Server 9. 1. 0 . . .
MySQL NDB Cluster is the distributed, shared-nothing variant of MySQL MySQL Server 9 1 0 and MySQL NDB Cluster 9 1 0 are Innovation releases, which means it will have new features, deprecations removals, and bug fixes Innovation releases are supported until the next innovation release, and are recommended for production use
- How do I perform an IF. . . THEN in an SQL SELECT? - Stack Overflow
The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server SELECT CAST( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product You only need to use the CAST operator if you want the result as a Boolean value If you are happy with an int, this works: SELECT CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END
- How can I solve Error: MySQL shutdown unexpectedly?
Rename folder mysql data to mysql data_old Make a copy of mysql backup folder and name it as mysql data Copy all your database folders from mysql data_old into mysql data (except mysql, performance_schema, phpmyadmin, and test folders) Copy mysql data_old ibdata1 file into mysql data folder Start MySQL from XAMPP control panel And, voilà!
- MySQL :: Database initialization Issue
MySQL Forums Forum List » Newbie New Topic Database initialization Issue Posted by: Rafael Harmon Date: November 15, 2024 12:42AM
- MySQL :: MySQL ODBC Connector 9. 1. 0 - Connection Issues in ODBC Data . . .
I have downloaded tried installing the MySQL ODBC Connector Version 9 1 0 from the General Availability Releases page; the installation completes successfully, but when I configure the DSN in 64-bit ODBC Data Source Administrator, and click "Test" (or click the "Database" dropdown), ODBC Data Source Administrator crashes
- MySQL :: Painfully slow import
A MySQL guru recommended that I set TRX_COMMIT=2 and disable QUERY_CACHE using the "set global" command I did that, and I see no improvement Thanks for any clues as to what is going on and to how I can speed this up At this rate, the import will take weeks!
- MySQL :: MySQL Forums :: General
mysql should have a faster storage engine than "InnoDB" like MariaDB "RocksDB"
|