MYSQL INTERVIEW QUESTION & ANSWERS
| 41. |
Define MYSQL fetures. |
| |
- It is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- It uses a standard form of the well-known SQL data language.
- It is released under an open-source license.
- It works on many operating systems and with many languages.
- It works very quickly and works well even with large data sets.
- PHP ships with a number of functions designed to support MySQL databases.
|
| 42. |
What are the steps you handle to edit a table in phpMyAdmin? |
| |
- Select the table from the table list on the left side of the SQL screen. The table appears in a spreadsheet like format in the main part of the screen. We can edit the contents of the table in this window.
- Edit or delete a record by clicking the appropriate icon displayed near the record.
- Add a row by clicking the corresponding link near the bottom of the table.
- Leave the cell you edited or press the Enter key. Any changes you make on the table data are automatically converted into the appropriate SQL code.
|
| 43. |
How many columns can we create for index? |
| |
There can be a maximum of 16 indexed columns for any standard table. |
| 44. |
What statement do you use to delete an INDEX? |
| |
ALTER TABLE table_name DROP INDEX index_name
|
| 45. |
What statement do you use to change a column name in a table? |
| |
ALTER TABLE my_table CHANGE my_col2 my_col3 INT NOT NULL;
|
