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.
Database
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.
MySQL Error “Operand should contain 1 column”
2 This question already has answers here: Operand Should Contain 1 Column – MySQL NOT IN (3 answers) Closed 7 years ago. I could find a lot of similar questions but no real solution for my problem. My SQL query: The error code I receive is If I just use the query in the parentheses … Read more
What is this JavaScript “require”?
So what is this “require?” require() is not part of the standard JavaScript API. But in Node.js, it’s a built-in function with a special purpose: to load modules. Modules are a way to split an application into separate files instead of having all of your application in one file. This concept is also present in other languages … Read more
MySQL Error: : ‘Access denied for user ‘root’@’localhost’
Open and edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distribution. Add skip-grant-tables under [mysqld] Restart MySQL You should be able to log in to MySQL now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart MySQL Now you will be able to login with the … Read more