Sql truncate table

Truncate table

TRUNCATE TABLE table;

Sql truncate table

TRUNCATE TABLE Categories;

Truncate syntax in sql

+----+----------+-----+-----------+----------+
| ID | NAME     | AGE | ADDRESS   | SALARY   |
+----+----------+-----+-----------+----------+
|  1 | Ramesh   |  32 | Ahmedabad |  2000.00 |
|  2 | Khilan   |  25 | Delhi     |  1500.00 |
|  3 | kaushik  |  23 | Kota      |  2000.00 |
|  4 | Chaitali |  25 | Mumbai    |  6500.00 |
|  5 | Hardik   |  27 | Bhopal    |  8500.00 |
|  6 | Komal    |  22 | MP        |  4500.00 |
|  7 | Muffy    |  24 | Indore    | 10000.00 |
+----+----------+-----+-----------+----------+

-1

Source: tutorialspoint.com

Similar codes

0 vote182 views1 answer
Select milliseconds mysql
SQL
4 votes151 views2 answers
DB::transaction
SQL
1 vote147 views1 answer
Sqlalchemy on delete set null
SQL
0 vote221 views1 answer
Oracle sql alter view add column
SQL
-2 votes141 views1 answer
Modify column name in tsql
SQL
4 votes128 views1 answer
Psql get sequences
SQL
2 votes147 views2 answers
How to run postgresql in linux
SQL
0 vote128 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote138 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes137 views1 answer
Date conversion in mysql column
SQL