Values of Auto Incremented Columns

Q

Assuming that the structure of a table shows two columns like this:

--------+------------+------+-----+--------+---------------
Field   | Type       | Null | Key | Default| Extra         
--------+------------+------+-----+--------+---------------
user_id | int(15)    |      | PRI | NULL   | auto_increment
email   | varchar(80)| YES  |     | NULL   |               
--------+------------+------+-----+--------+---------------

Assumming also that the value of user_id of the last record is 2345. What will be value of user_id if a new record is inserted after deleting all the rows in this table?

✍: FYIcenter.com

A

The value of user_id of the new record will be 2346.

2006-09-01, 7037👍, 0💬

About interview.FYIcenter.com
interview.FYIcenter.com offers a collections of interview questions and answers for software and Web developers. 2016-06-25, 11174👍, 0💬

Tag <?= ... ?> in PHP
What does a special set of tags <?= and ?> do in a PHP script page? <?= expression ?> allows you to output the value of the specified expression into the HTML document directly. 2006-09-01, 7970👍, 0💬

printf() Function
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print the value of x. But as here, there is nothing after "%d", so compiler will show in output window gurbage value. 2. When we use %d the compiler internally uses it to access the argument in the stack (a... 2007-02-26, 7754👍, 0💬

calloc() and malloc() Functions
What is the difference between "calloc(...)" and "malloc(...)"? 1. calloc(...) allocates a block of memory for an array of elements of a certain size. By default the block is initialized to 0. The total number of memory allocated will be (number_of_elements * size). malloc(...) takes in only a singl... 2007-02-26, 7744👍, 0💬

Math
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she open to? a. 122 and 123 b. 242 and 243 c. 16 and 17 d. 24 and 25 a. 2006-09-01, 7701👍, 0💬

Expression Evaluation
What is the value of this expression? +1-2*3/4 -0.5 2006-09-01, 7404👍, 0💬

What Is C Language
What Is C Language? The C programming language is a standardized programming language developed in the early 1970s by Ken Thompson and Dennis Ritchie for use on the UNIX operating system. It has since spread to many other operating systems, and is one of the most widely used programming languages. C... 2007-02-26, 7032👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.