| Other MySQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| is it possible to assign two primary key in a table
|
IBM | 7 |
| what do you mean by longblob Data type in MySql?
|
| 3 |
| Can anyone help me to create a good mysql database schema
with an example.
Thanks,
Sekar.jr |
| 1 |
| The structure of table view buyers is as follows:
+----------------+-------------+------+-----+---------+-----
-----------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-----
-----------+
| user_pri_id | int(15) | | PRI | NULL | auto_increment |
| userid | varchar(10) | YES | | NULL | |
+----------------+-------------+------+-----+---------+-----
-----------+
the value of user_pri_id the last row 2345 then What will
happen in the following conditions?
Condition1: Delete all the rows and insert another row
then. What is the starting value for this auto incremented
field user_pri_id ,
Condition2: Delete the last row(having the field value
2345) and insert another row then. What is the value for
this auto incremented field user_pri_id |
| 2 |
| about foregine |
| 2 |
| Explain the difference between FLOAT, DOUBLE and REAL. |
Yahoo | 12 |
| How many values can the SET function of MySQL take? |
Creative-Informatics | 2 |
| How do you start MySQL on Linux? |
| 3 |
| how to take mysql database structure backup |
| 6 |
| how fastest access of data can be done from database ? |
| 3 |
| What are the other commands to know the structure of table
using MySQL commands except explain command? |
SigmaTree | 2 |
| Explain the difference between MyISAM Static and MyISAM
Dynamic? |
| 1 |
| |
| For more MySQL Interview Questions Click Here |