Home / Programming MCQs / MySQL MCQs / Question
J
Q. If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?
To only remove the data of the table without disturbing the definition of the table we use the TRUNCATE statement, this statement helps us to delete all the data of a table.
You must be Logged in to update hint/solution
What is the size of the BIT type?
Can we create a database named 01_test?
Is it possible to define a NOT NULL field in a record?
Which of the following returns a MySQL-specific numeric code?
The function used to convert a string to an int is
What is the maximum collations a character set can have?
Which statements are used to control a cursor variable?
MySQL does not provide a date type that has an optional time part.
Discusssion
Login to discuss.