0. What is MySQL ?
1. What is DDL, DML and DCL?
2. What is primary key?
3. What Is Foreign Key?
4. What Is Index?
5. What Is Join?
6. What Is Union?
7. What Is ISAM?
8. What Is InnoDB?
9. What Is CSV?
10. What Is Transaction?
11. What Is Commit?
12. What Is Rollback?
13. how Many Groups of Data Types?
14. What Are the Differences between CHAR and NCHAR?
15. How To Escape Special Characters in SQL statements?
16. How To Concatenate Two Character Strings?
17. How To Enter Characters as HEX Numbers?
18. How To Enter Boolean Values in SQL Statements?
19. How To Convert Numeric Values to Character Strings?
20. How to get rid of the last 2 0’s?
21. How To Use IN Conditions?
22. How To Use LIKE Conditions?
23. How To Increment Dates by 1111 MvSQL?
24. How To Calculate the Difference between Two Dates?
25. Flow To Present a Past Time in Hours, Minutes and Seconds?
26. How To Add a New Column to an Existing Table in MySQL?
27. How To Delete an Existing Column in a Table?
28. Flow To Rename an Existing Column in a Table?
29. How To Rename an Existing Table in MySQL?
30. How To Create a Table Index in MvSQL?
31. How To Get a List of Indexes of an Existing Table?
32. How To Drop an Existing Index in MySQL?
33. How To Create a New View in MySQL?
34. How To Drop an Existing View in MySQL?
35. What are HEAP tables in MySQL?
36. How do you control the max size of a HEAP table?
37. What are CSV tables?
38. Explain federated tables. ?
39. What is SERIAL data type in MySQL?
40. What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
41. Explain the difference between BOOL, TINYINT and BIT. ?
42. Explain the difference between FLOAT, DOUBLE and REAL. ?
43. If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
44. What happens if a table has one column defined as TIMESTAMP?
45. But what if you really want to store the timestamp data, such as the publication date of the article?
46. What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
47. Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP. ?
48. If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
49. How MySQL Optimizes DISTINCT ?
50. How MySQL Optimizes LEFT JOIN and RIGHT JOIN ?
1. What is DDL, DML and DCL?
2. What is primary key?
3. What Is Foreign Key?
4. What Is Index?
5. What Is Join?
6. What Is Union?
7. What Is ISAM?
8. What Is InnoDB?
9. What Is CSV?
10. What Is Transaction?
11. What Is Commit?
12. What Is Rollback?
13. how Many Groups of Data Types?
14. What Are the Differences between CHAR and NCHAR?
15. How To Escape Special Characters in SQL statements?
16. How To Concatenate Two Character Strings?
17. How To Enter Characters as HEX Numbers?
18. How To Enter Boolean Values in SQL Statements?
19. How To Convert Numeric Values to Character Strings?
20. How to get rid of the last 2 0’s?
21. How To Use IN Conditions?
22. How To Use LIKE Conditions?
23. How To Increment Dates by 1111 MvSQL?
24. How To Calculate the Difference between Two Dates?
25. Flow To Present a Past Time in Hours, Minutes and Seconds?
26. How To Add a New Column to an Existing Table in MySQL?
27. How To Delete an Existing Column in a Table?
28. Flow To Rename an Existing Column in a Table?
29. How To Rename an Existing Table in MySQL?
30. How To Create a Table Index in MvSQL?
31. How To Get a List of Indexes of an Existing Table?
32. How To Drop an Existing Index in MySQL?
33. How To Create a New View in MySQL?
34. How To Drop an Existing View in MySQL?
35. What are HEAP tables in MySQL?
36. How do you control the max size of a HEAP table?
37. What are CSV tables?
38. Explain federated tables. ?
39. What is SERIAL data type in MySQL?
40. What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
41. Explain the difference between BOOL, TINYINT and BIT. ?
42. Explain the difference between FLOAT, DOUBLE and REAL. ?
43. If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
44. What happens if a table has one column defined as TIMESTAMP?
45. But what if you really want to store the timestamp data, such as the publication date of the article?
46. What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
47. Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP. ?
48. If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
49. How MySQL Optimizes DISTINCT ?
50. How MySQL Optimizes LEFT JOIN and RIGHT JOIN ?
