
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
Sometimes database administrators need to import sql file in MySQL. Here are the different ways to do it.
Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.
Do you need to get list of foreign keys related to table or column in SQL? Here are the different ways to get foreign keys referencing table in MySQL.
Sometimes database developers need to reset auto increment column in MySQL. Here are different ways to set the auto increment value.
Database administrators need to determine the users in MySQL server. Here is how to list users in MySQL.
Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.
It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).
Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.