Useful tips for everyday
How are date and time data types formatted? The date and time data types have a wide variety of formats to help meet your unique…
How to get all rows in a group in MySQL? FROM sold_items AS si1 JOIN (SELECT member_id FROM sold_items GROUP BY member_id HAVING SUM (amount)…
What is the database used in blockchain? List of Blockchain-based databases Sr.No. Blockchain-based Database Type of Traditional Database 1 BigchainDB Document-oriented database 2 Cassandra Key-value…
How do you UPDATE or modify the record in a table? The UPDATE statement changes existing data in one or more rows in a table….SQL…
How to optimize for InnoDB tables in MySQL? Invisible Indexes Descending Indexes Indexed Lookups from TIMESTAMP Columns Optimizing Database Structure Optimizing Data Size Optimizing MySQL…
Can an index be NULL? By default, relational databases ignore NULL values (because the relational model says that NULL means “not present”). So, Index does…
What is high availability in database? High availability (HA) is a characteristic of a system, which aims to ensure an agreed level of operational performance,…
What is the purpose of PG Rewind in PostgreSQL? pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster,…
How to create a database diagram in SSMS? Step 1 – New Database Diagram using SQL Server Management Studio In SSMS under the database WideWorldImporters,…
How do I restore MySQL database? Restore your MySQL database from a Backup Choose the database you want to restore from the left navigation tree.…