MySQL equivalent of DECODE function in Oracle
You can use IF() where in Oracle you would have used DECODE().
mysql
MySQL: What’s the difference between float and double?
They both represent floating point numbers. A FLOAT is for single-precision, while a DOUBLE is for double-precision numbers. MySQL uses four bytes for single-precision values and eight bytes for double-precision values. There is a big difference from floating point numbers and decimal (numeric) numbers, which you can use with the DECIMAL data type. This is … Read more
Error: select command denied to user ‘‘@’‘ for table ‘‘
database user does not have the permission to do select query. you can grant the permission to the user if you have root access to mysql http://dev.mysql.com/doc/refman/5.1/en/grant.html Your second query is on different database on different table. And the user you are connecting with does not have permission to access data from this database or … Read more
How to grant remote access permissions to mysql server for user?
If I do SHOW GRANTS in my mysql database I get If I am not mistaken, root@localhost means that user root can access the server only from localhost. How do I tell MySQL to grant root the permission to access this mysql server from every other machine (in the same network), too?
How to solve “Error: MySQL shutdown unexpectedly”?
IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases. Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps: 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 … Read more
Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
TL;DR: To access newer versions of mysql/mariadb as the root user, after a new install, you need to be in a root shell (ie sudo mysql -u root, or mysql -u root inside a shell started by su – or sudo -i first) Having just done the same upgrade, on Ubuntu, I had the same issue. What was odd was that Would accept … Read more
Check if MySQL table exists without using “select from” syntax?
If you want to be correct, use INFORMATION_SCHEMA. Alternatively, you can use SHOW TABLES If there is a row in the resultset, table exists.
Best way to test if a row exists in a MySQL table
You could also try EXISTS: and per the documentation, you can SELECT anything. Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference.
How to resolve Unable to load authentication plugin ‘caching_sha2_password’ issue
Starting with MySQL 8.0.4, they have changed the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password. You can run the below command to resolve the issue. sample username / password => student / pass123 Refer the official page for details: MySQL Reference Manual
mysqld: Can’t change dir to data. Server doesn’t start
Since you used the Windows installer, everything is set up for you to run MySQL 5.7 as a Windows service, which is a great option in most cases. Instead of running mysqld.exe from the command line, Win + R Run services.msc Right-click on MySQL57 Start the service.