MYSQL INTERVIEW QUESTION & ANSWERS
| 1. |
What command do you use to display all databases? |
| |
SHOW DATABASES; |
| 2. |
What command do you use to display current Date and Time ? |
| |
SELECT NOW(); |
| 3. |
Tell me some important rules for mysql. |
| |
- Comments and portability
- Case-sensitivity
- Escape characters
- Naming limitations
- Quoting
- ime zones
- haracter sets and collations
|
| 4. |
What are case-sensitive in mysql? |
| |
- Databases
- Tablespaces
- Tables
-
Views
- Aliases
- Triggers
- Log file groups
|
| 5. |
Define DESCRIBE Statement and SHOW COLUMS Statement. |
| |
| DESCRIBE |
SHOW COLUMS |
| DESCRIBE tblname; |
SHOW COLUMNS FROM tblname; |
| DESCRIBE tblname fldname; |
SHOW COLUMNS FROM tblname WHERE Field='fldname'; |
| DESCRIBE tblname 'fldname'; |
SHOW COLUMNS FROM fldname WHERE Field LIKE 'fldname'; |
|
