What is MySQL?
MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle).
What are the features of MySQL?
MySQL database software is a client or server system which includes.
Why MySQL is used?.
MySQL database server is reliable, fast and very easy to use. This software can be downloaded as freeware and can be downloaded from the internet.
What are the advantages of MySQL when compared with Oracle?
Difference between CHAR and VARCHAR?
Following are the differences between CHAR and VARCHAR:
How to get current MySQL version?
SELECT VERSION ();
is used to get the current version of MySQL.
What is TEXT?
TEXT is case-insensitive BLOB. The four types of TEXT are:
What is the difference between primary key and candidate key?
Every row of a table is identified uniquely by primary key and there is only one primary key fore each table.
These are those keys which is candidate for primary key of a table means a key which full fill all the requirements of primary key.
What is ISAM?
ISAM stands for Indexed Sequential Access Method, a method for indexing data for fast retrieval.
What is command to check table is exist?
CHECK TABLE table_name;
What are string datatype in MySQL?
How will you obtain list of all the databases?
To list all currently running databases run the command on mysql shell as: show databases;
What is BLOB?
BLOB stands for binary large object.
It that can hold a variable amount of data.
There are four types of BLOB based on the maximum length of values they can hold:
How You Will Show All Data From A Table.
SELECT * FROM Tablename;
How To Show Certain Selected Rows With The Value “Abcd”.
SELECT * FROM Tablename WHERE Fieldname = “Abcd”;
How You Will Show Unique Records.
SELECT DISTINCT Columnname FROM Tablename;
How We Will Show Selected Records Sorted In An Ascending (Asc) Or Descending (Desc).
How To Return Total Number Of Rows.
SELECT COUNT(*) FROM Tablename;
What does UNION do? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. The difference between UNION andUNION ALL is that UNION will omit duplicate records whereas UNION ALL will include duplicate records.
It is important to note that the performance of UNION ALL will typically be better than UNION, since UNION requires the server to do the additional work of removing any duplicates. So, in cases where is is certain that there will not be any duplicates, or where having duplicates is not a problem, use of UNION ALL would be recommended for performance reasons.