Useful tips for everyday
How do I change InnoDB to Barracuda? Change InnoDB file format to Barracuda mysql> select version(); mysql> show variables like “%innodb_file%”; mysql> SET GLOBAL innodb_file_format…
Is MariaDB a drop in replacement for MySQL? MariaDB 10.0 and MariaDB 10.1 function as limited drop-in replacements for MySQL 5.6, as far as InnoDB…
Does MySQL support BLOB? MySQL supports 4 types of BLOB data types, which only differ in the maximum length of data they can store. BLOB:…
What are the different kinds of joins in SQL? Four types of joins: left, right, inner, and outer. In general, you’ll only really need to…
What are the types of partitions in Oracle? Partitioning Types ( Range , List, Hash, Interval .. ) in Oracle Database Range partitioning (introduced in…
How does SSMS connect to local SQL Server? Use SSMS to Connect to the Local Default Instance For Server Type it is Database Engine. For…
What is help desk query? Help Desk Query Examples: A few most common queries that a help desk management system helps solve include: Product-specific customer…
How do you stop a SQL Server rollback? There isn’t a way to stop a rollback once it’s under way. Nope. Even if you restart…
What is the procedure to execute shell script? Steps to write and execute a script Open the terminal. Go to the directory where you want…
How do you update and SELECT in the same query in MySQL? You do not need to declare it. To select its value, just execute:…