Useful tips for everyday
How do I shutdown MySQL server? The proper way to shutdown your MySQL server is to the use “mysqladmin shutdown” command. Other ways to shutdown…
How do I store files in Cassandra? DataBase Schema Split up larger objects into smaller chunks and store them in different nodes of the Cassandra…
How do you resolve unique constraint violated error? There are a few solutions to the “ORA-00001 unique constraint violated” error: Change your SQL so that…
How to use raiserror statement in SQL Server? SQL Server RAISERROR statement 1 Message – It is the message that we want to print 2…
How does the before update trigger work in MySQL? The following statement creates a BEFORE UPDATE trigger on the sales table. The trigger is automatically…
How to improve MySQL performance with InnoDB buffer pool? Percona has a lot of information about some key metrics: Tuning MySQL and the InnoDB storage…
How do I compare two columns with NULL values in SQL? 2 Answers. Use <=> (null-safe equality operator) negated comparison which returns FALSE in case…
How do you test a database design? How to Test the Database (Step-by-step Process) Step #1) Prepare the environment. Step #2) Run a test. Step…
How do I search for a column name within all tables of a database? To get full information: column name, table name as well as…
How do I calculate difference in months between two dates in SQL? MONTHS_BETWEEN returns number of months between dates date1 and date2 . If date1…