11. What are ENUMs used for in MySQL?
You can limit the possible values that go into the table.
CREATE TABLE months (month ENUM ’January’, ’February’, ’March’,); INSERT months VALUES (’April’).
12. What are the advantages of Mysql comparing with oracle?
MySql is Open source, which can be available any time. Provides Gui with Command Prompt. Supports the administration using MySQL Admin,MySQL Query Browser.Oracle is best database ever in Software development.
13. What is the difference between CHAR_LENGTH and LENGTH?
The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
14. How are ENUMs and SETs represented internally?
As unique integers representing the powers of two, due to storage optimizations.
15. How do you change a password for an existing user via mysqladmin?
mysqladmin -u root -p password "newpassword"
16. If the value in the column is repeatable, how do you find out the unique values?
SELECT DISTINCT user_firstname FROM users;
17. Explain the difference between FLOAT, DOUBLE and REAL?
FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.
18. How do you get the current version of mysql?
SELECT VERSION();
19. Is Mysql query has LETTERCASE?
No.
Ex :
SELECT VERSION(), CURRENT_DATE;
select version(), current_date;
SeLeCt vErSiOn(), current_DATE;
20. What is the LIKE?
A LIKE pattern match, which succeeds only if the pattern matches the entire value.
Share This :
You can limit the possible values that go into the table.
CREATE TABLE months (month ENUM ’January’, ’February’, ’March’,); INSERT months VALUES (’April’).
12. What are the advantages of Mysql comparing with oracle?
MySql is Open source, which can be available any time. Provides Gui with Command Prompt. Supports the administration using MySQL Admin,MySQL Query Browser.Oracle is best database ever in Software development.
13. What is the difference between CHAR_LENGTH and LENGTH?
The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
14. How are ENUMs and SETs represented internally?
As unique integers representing the powers of two, due to storage optimizations.
15. How do you change a password for an existing user via mysqladmin?
mysqladmin -u root -p password "newpassword"
16. If the value in the column is repeatable, how do you find out the unique values?
SELECT DISTINCT user_firstname FROM users;
17. Explain the difference between FLOAT, DOUBLE and REAL?
FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.
18. How do you get the current version of mysql?
SELECT VERSION();
19. Is Mysql query has LETTERCASE?
No.
Ex :
SELECT VERSION(), CURRENT_DATE;
select version(), current_date;
SeLeCt vErSiOn(), current_DATE;
20. What is the LIKE?
A LIKE pattern match, which succeeds only if the pattern matches the entire value.
0 comments:
Post a Comment