Web Development Blog: MySQL and Databases
Most Recent Post
How to find if a specific INDEX NAME / KEYNAME exists in a Table
How to know if a KEYNAME already exists?
Recent Posts
2022-09-26 Eduardo Ponce de Leom
How to find if a specific INDEX NAME / KEYNAME exists in a Table
How to know if a KEYNAME already exists?
2022-01-26 Eduardo Ponce de Leon
How to find all the Foreign Keys that reference a particular table and column in MySQL
Compatible with MySQL and Maria DB
2019-11-08 Eduardo Ponce de Leon
Error: Column cannot be Null, How do I modify a MySQL column to allow NULL?
Solved: This happens because when certain columns are not included in the INSERT query, in this case they become NULL by default, or if you are inserting NULL, in both cases your column must be set to allow NULL
2018-11-13 Eduardo Ponce de Leon
Strict Mode enabled by default, How to disable Strict Mode after upgrade to MySQL or Maria DB (10.1 - 10.2)
MySQL / Maria DB Upgrade - Strict Mode is enabled by default, how to go back if your web applications start to crash
2018-05-11 Eduardo
How to Insert into a table values from another Select From Table
This is a simple tutorial on how to Insert values into a table that comes from another table. (MySQL)
2022-09-26 Eduardo Ponce de Leom
How to find if a specific INDEX NAME / KEYNAME exists in a Table
How to know if a KEYNAME already exists?
2022-01-26 Eduardo Ponce de Leon
How to find all the Foreign Keys that reference a particular table and column in MySQL
Compatible with MySQL and Maria DB
2019-11-08 Eduardo Ponce de Leon
Error: Column cannot be Null, How do I modify a MySQL column to allow NULL?
Solved: This happens because when certain columns are not included in the INSERT query, in this case they become NULL by default, or if you are inserting NULL, in both cases your column must be set to allow NULL
2018-11-13 Eduardo Ponce de Leon
Strict Mode enabled by default, How to disable Strict Mode after upgrade to MySQL or Maria DB (10.1 - 10.2)
MySQL / Maria DB Upgrade - Strict Mode is enabled by default, how to go back if your web applications start to crash
2018-05-11 Eduardo
How to Insert into a table values from another Select From Table
This is a simple tutorial on how to Insert values into a table that comes from another table. (MySQL)
