|
|
 |
|
|
Thread Tools | Display Modes |
Aug 11th, 2007, 3:21 AM
|
#1 |
|
Hobbyist Programmer
Join Date: Feb 2006
Posts: 154
Rep Power: 3
 |
mysql - truncate command
what does it do?
I thought it deleted all the entries from the tables while preserving the column structure, right? well... when i type truncate tablename; and then i try to see the data of the set, it says "empty set", which I would expect.... but when I am using with c#, it would tell me the entry already exists....so how can an empty set have an entry? maybe I am doing something wrong with c#, but i doubt it! |
|
|
|
Aug 12th, 2007, 2:38 PM
|
#2 |
|
Hobbyist Programmer
Join Date: Apr 2004
Location: Texas
Posts: 106
Rep Power: 5
|
Try running mysqladmin flush-tables.
__________________
[ [ SykkN alloc ] initWithThePowerTo: destroyYouAll ]; /* Don't make me use it! */ |
|
|
|
|
Aug 12th, 2007, 6:20 PM
|
#3 | |
|
Hobbyist Programmer
Join Date: Feb 2006
Posts: 154
Rep Power: 3
|
Quote:
|
|
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Connecting MySQL and PHP | titaniumdecoy | PHP | 10 | Feb 25th, 2008 7:47 PM |
| MySQl simple problem | paulchwd | Other Web Development Languages | 7 | Feb 27th, 2007 10:31 AM |
| Command Prompt | SkyPioneer | Coder's Corner Lounge | 5 | May 3rd, 2006 10:07 PM |
| Tutorial - Using MySQL in C# | Darkhack | C# | 12 | Jan 17th, 2006 9:28 AM |
| system () command in Borland C++ Bldr. 4 | L7Sqr | C++ | 14 | Jun 18th, 2005 8:15 PM |
Linear Mode
