TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Learn PHP, PHP Tutorial, PHP Code, PHP, MySQL, MySQL Database, SQL, SQL Code, HTML, Javascript, JQuery, Ajax, Wordpress
Category
- PHP Interview Questions and Answers (68)
- Wordpress (52)
- MySQL Interview question (33)
- MySQL (28)
- PHP (14)
- Download PHP Script (13)
- Object-Oriented PHP Programming (13)
- Prestashop (4)
- JQuery (2)
- SEO (1)
Search
My Favorite Blog List
Translate Blog
Blog Archive
-
▼
2009
(102)
-
▼
December
(85)
- Port Numbers
- If we login more than one browser windows at the s...
- What are the different functions in sorting an array?
- How many ways we can pass the variable through the...
- Sql injection
- How do I find out the number of parameters passed ...
- What's the difference between accessing a class me...
- Are objects passed by value or by reference?
- How do you call a constructor for a parent class?
- What’s the special meaning of __sleep and __wakeup?
- Explain the differences echo, print and printf ?
- What's the output of the ucwords function in this ...
- What’s the difference between htmlentities() and h...
- What’s the difference between md5(), crc32() and s...
- So if md5() generates the most secure hash, why wo...
- Write a simple program to get a row of information...
- How do you remove the last letter from a string?
- What do you need to use the image functions in PHP?
- What can be possible advantages/disadvantages of p...
- What changes I have to do in php.ini file for file...
- How can I set a cron and how can I execute it in U...
- What type of headers have to be added in the mail ...
- What is the difference between Reply-to and Return...
- How to store the uploaded file to the final location?
- jQuery's features break down accross eight major c...
- What is jQuery?
- Download watermark script
- Public, Protected, and Private Properties
- Constructors and Destructors
- Static modifier use in php
- Setters and Getters in Access Modifiers
- Access Modifiers
- Understanding Class Inheritance
- Would you initialize your strings with single quot...
- What’s the special meaning of __sleep and __wakeup?
- What are the differences between DROP a table and ...
- How can we encrypt the username and password using...
- What is the difference between mysql_fetch_object ...
- Explain the differences between echo, print and p...
- Download usersonline script
- Download phpaffiliate script
- Download Hitcounter script
- Download Guest book script
- Download greetings cards cript
- Download downloadcounter script
- Download dating script
- Download classifieds script
- Download calendar script
- Download bookmarks script
- Download adrotator script
- Download Oscommerce script
- Explain the difference between FLOAT, DOUBLE and REAL
- Explain the difference between BOOL, TINYINT and BIT.
- What does myisamchk do?
- Explain the difference between MyISAM Static and M...
- How can we know the number of days between two giv...
- How can I load data from a text file into a table?
- What is the difference between char and varchar da...
- What is the difference between GROUP BY and ORDER ...
- What is the difference between Primary Key and Uni...
- How many ways we can we find the current date usin...
- How can we find the number of rows in a table usin...
- Explain Normalization concept?
- Give the syntax of Grant and Revoke commands?
- What is maximum size of a database in MySQL?
- What is the purpose of the following files having ...
- How many tables will create when we create table, ...
- How many values can the SET function of MySQL take?
- What is the maximum length of a table name, databa...
- What are the advantages of stored procedures, trig...
- How can we repair a MySQL table?
- How can I retrieve values from one database server...
- How can we optimize or increase the speed of a MyS...
- How can we take a backup of a MySQL table and how ...
- How can we encrypt and decrypt a data present in a...
- Explain advantages of MyISAM over InnoDB?
- Explain advantages of InnoDB over MyISAM?
- What is the possible advantages/disadvantages of p...
- How can I set a cron and how can I execute it in U...
- What type of headers have to be added in the mail ...
- How to store the uploaded file to the final location?
- What is the difference between include and require?
- How To Read the Entire File into a Single String?
- How can we send mail using JavaScript?
- What is the functionality of STRSTR() and STRISTR()
-
▼
December
(85)
No comments:
Post a Comment