How to enter Characters as HEX Numbers?
If you want to enter characters as HEX numbers, you can enter HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (Ox). A…
How MySQL Optimizes DISTINCT?
DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause. SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;
What is InnoDB?
lnnoDB is a transaction safe storage engine developed by Innobase Oy which is a Oracle Corporation now.
What is ISAM?
ISAM is abbreviated as Indexed Sequential Access Method.It was developed by IBM to store and retrieve data on secondary storage systems like tapes.
What are the different tables present in MySQL?
Total 5 types of tables are present: MyISAM Heap Merge INNO DB ISAM MyISAM is the default storage engine as of MySQL.
Where MyISAM table will be stored and also give their formats of storage?
Each MyISAM table is stored on disk in three formats: The ‘.frm’ file stores the table definition The data file has a ‘.MYD’ (MYData) extension The index file has a…
How can we run batch mode in mysql?
Following commands are used to run in batch mode: mysql ; mysql mysql.out
What is the difference between mysql_fetch_array and mysql_fetch_object?
Following are the differences between mysql_fetch_array and mysql_fetch_object: mysql_fetch_array() -Returns a result row as an associated array or a regular array from database. mysql_fetch_object – Returns a result row as object from database.
What is the difference between BLOB AND TEXT?
A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB – TINYBLOB BLOB MEDIUMBLOB and LONGBLOB They all differ…
What is the difference between the LIKE and REGEXP operators?
LIKE and REGEXP operators are used to express with ^ and %. SELECT * FROM employee WHERE emp_name REGEXP "^b"; SELECT * FROM employee WHERE emp_name LIKE "%b";