Category: MySQL

MySQL/PostgreSQL – how to improve and find issues 1

MySQL/PostgreSQL – how to improve and find issues

Things to consider to improve your queries Do you need to retrieve all the columns for each row in the database by executing queries like (Select * from user), try to avoid this especially...

MySQL – Validating your code 0

MySQL – Validating your code

It’s very important when you are writing your SQL queries to validate them. CREATE DB If you need to create a database, the SQL statement for that is:

But if you are going...