|
| cool Statistics |
| | coolcommands: | 1338 | | Categories: | 83 | | Total queries: | 620330 | | Members: | 22813 |
|
|
|
|
 |
|
|
|
Search coolcommands.com
 |
Submitted by:
lvo |
coolcommand
how to delete all the data in a table while preserving the structure in mysql |
Description
To delete all the data in a MySQL table but preserve the structure:
# mysql -u root -p
mysql> delete from table_name;
OR
mysql> truncate table table_name; |
Example
truncate table table_name; |
Return to search results
 | | | |
Random coolcommands
coolcommand: how to find the process utilizing the most cpu
Example: top -b 1
[show me the details] |
coolcommand: metainit - how to create a stripe in Solaris Volume Manager
Example: metainit d0 1 3 c1t0d0s7 c2t0d0s7 c1t1d0s7 -i 32k
[show me the details] |
coolcommand: fw - how to export a log file to an ASCII file in Checkpoint Firewall-1
Example: fw logexport -i fw.log -o test.log -n
[show me the details] |
coolcommand: how to recover a failed MPIO paths from an IBM VIO server on an AIX LPAR
Example: chpath -l hdisk0 -p vscsi1 -s disable; chpath -l hdisk0 -p vscsi1 -s enable
[show me the details] |
|
|
coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts
| | | | |
|
|
|
|
 |
|
|
|
|
Top 5 Submitters
|
|---|
| lvo | 1160 |
| audet | 37 |
| kah00na | 32 |
| Mariom | 24 |
| lebjf000 | 14 |
Top 5 Searches
|
|---|
| Category Solaris | 51966 |
| Category AIX | 49058 |
| Category General UNIX | 47581 |
| solaris | 23554 |
| aix | 22739 |
|
|
|
|
Thursday May 23, 2013
