How do you insert a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

How to return query output in html format?

0 Answers  


Where is the mysql data directory?

0 Answers  


How to do login in mysql with unix shell.

0 Answers  


if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  


How can I connect mysql database?

0 Answers  






What is innodb mysql?

0 Answers  


What is the role of a limit in a mysql query?

0 Answers  


What do you understand by mysql terminal?

0 Answers  


What are the types of queries?

0 Answers  


how can you test for null values in a database? : Mysql dba

0 Answers  


How do I copy an entire mysql database?

0 Answers  


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 Answers  


Categories