Useful tips for everyday
Can EC2 instances be stopped? You can stop and start your instance if it has an Amazon EBS volume as its root device. The instance…
What is rollback and Rollforward in database? Roll forward occurs during database, tablespace or datafile recovery and during crash recovery. Rollback is the process of…
What is transactional consistency? Consistency (or Correctness) in database systems refers to the requirement that any given database transaction must change affected data only in…
How backup and Restore MySQL database from command line? How to Restore MySQL with mysqldump Step 1: Create New Database. On the system that hosts…
How do I return non-NULL values in SQL? The IS NOT NULL condition is used in SQL to test for a non-NULL value. It returns…
How do I import a CSV file from Excel to MySQL? Here are the steps: Prepare the CSV file to have the fields in the…
Can TRUNCATE be rolled back? Unlike DELETE , however, TRUNCATE deletes the pages the data is stored on, not the individual rows. A log of…
How does GROUP BY eliminate duplicates? The group by clause can also be used to remove duplicates. The go to solution for removing duplicate rows…
How do you fill a table in MySQL? First, you must specify the name of the table. After that, in parenthesis, you must specify the…
How do you delete a row from related tables? To remove one or more rows in a table: First, you specify the table name where…