Access denied for user ‘root@localhost’ (using password:NO)
You can reset your root password. Have in mind that it is not advisable to use root without password.
Database
How to use MySQL DECIMAL?
I can’t quite get a grasp of MySQL’s DECIMAL. I need the row to be able to contain a number anywhere from 00.0001 to 99.9999. How would I structure it to work like so?
How can I do an UPDATE statement with JOIN in SQL Server?
Syntax strictly depends on which SQL DBMS you’re using. Here are some ways to do it in ANSI/ISO (aka should work on any SQL DBMS), MySQL, SQL Server, and Oracle. Be advised that my suggested ANSI/ISO method will typically be much slower than the other two methods, but if you’re using a SQL DBMS other … Read more
Online SQL Query Syntax Checker
SQLFiddle will let you test out your queries, while it doesn’t explicitly correct syntax etc. per se it does let you play around with the script and will definitely let you know if things are working or not.
NOT IN vs NOT EXISTS
I always default to NOT EXISTS. The execution plans may be the same at the moment but if either column is altered in the future to allow NULLs the NOT IN version will need to do more work (even if no NULLs are actually present in the data) and the semantics of NOT IN if NULLs are present are unlikely to be the ones you … Read more
SQL SELECT WHERE field contains words
Rather slow, but working method to include any of words: If you need all words to be present, use this: If you want something faster, you need to look into full text search, and this is very specific for each database type.
Rename a table in MySQL
Renaming a table is not working in MySQL The error message is The query is working fine on other tables for me, but not with the table group.
How to create Temp table with SELECT * INTO tempTable FROM CTE Query
Sample DDL Make sure that the table is deleted after use
error, string or binary data would be truncated when trying to insert
From @gmmastros’s answer Whenever you see the message…. string or binary data would be truncated Think to yourself… The field is NOT big enough to hold my data. Check the table structure for the customers table. I think you’ll find that the length of one or more fields is NOT big enough to hold the data … Read more
MySQL create table if not exists and insert record only if table was created
Combine the creation and insert into a single statement: If it doesn’t create the table, AS SELECT … clause is ignored.