mysql> show processlist\G
*************************** 1. row *****************
     Id: 1
   User: root
   Host:
     db: test
Command: Query
   Time: 498
  State: rename result table
   Info: ALTER TABLE Commande AUTO_INCREMENT=0
*************************** 2. row *****************
     Id: 2
   User: root
   Host:
     db: test
Command: Query
   Time: 496
  State: rename result table
   Info: ALTER TABLE Commande AUTO_INCREMENT=0
   
   
mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.0.19-debug-log |
+------------------+
1 row in set (0.59 sec)


 	ntdll.dll!_ZwWaitForSingleObject@12()  + 0xb	
 	kernel32.dll!_WaitForSingleObjectEx@12()  + 0x71	
 	kernel32.dll!_WaitForSingleObject@8()  + 0xf	
>	mysqld-debug.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x009f97f0, _RTL_CRITICAL_SECTION * mutex=0x009f9a78, timespec * abstime=0x0493d144)  Line 67 + 0x11	C
 	mysqld-debug.exe!remove_table_from_cache(THD * thd=0x0154aea0, const char * db=0x0286c7c8, const char * table_name=0x02859200, unsigned int flags=2)  Line 5156 + 0x16	C++
 	mysqld-debug.exe!wait_while_table_is_used(THD * thd=0x0154aea0, st_table * table=0x0286bd30, ha_extra_function function=HA_EXTRA_PREPARE_FOR_DELETE)  Line 1929 + 0x23	C++
 	mysqld-debug.exe!close_cached_table(THD * thd=0x0154aea0, st_table * table=0x0286bd30)  Line 1954 + 0xf	C++
 	mysqld-debug.exe!mysql_alter_table(THD * thd=0x0154aea0, char * new_db=0x0154f778, char * new_name=0x02864c78, st_ha_create_information * create_info=0x0154b4a8, st_table_list * table_list=0x02864cb0, List<create_field> & fields={...}, List<Key> & keys={...}, unsigned int order_num=0, st_order * order=0x00000000, enum_duplicates handle_duplicates=DUP_ERROR, int ignore=0, st_alter_info * alter_info=0x0154b634, int do_send_ok=1)  Line 3820 + 0x10	C++
 	mysqld-debug.exe!mysql_execute_command(THD * thd=0x0154aea0)  Line 3041 + 0x6d	C++
 	mysqld-debug.exe!mysql_parse(THD * thd=0x0154aea0, char * inBuf=0x02864c18, unsigned int length=37)  Line 5641 + 0x9	C++
 	mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0154aea0, char * packet=0x02859911, unsigned int packet_length=38)  Line 1719 + 0x1d	C++
 	mysqld-debug.exe!do_command(THD * thd=0x0154aea0)  Line 1515 + 0x31	C++
 	mysqld-debug.exe!handle_one_connection(void * arg=0x0154aea0)  Line 1158 + 0x9	C++
 	mysqld-debug.exe!pthread_start(void * param=0x028498c0)  Line 63 + 0x7	C
 	mysqld-debug.exe!_threadstart(void * ptd=0x01549e48)  Line 196 + 0xd	C
 	kernel32.dll!_BaseThreadStart@8()  + 0x52	




 	ntdll.dll!_ZwWaitForSingleObject@12()  + 0xb	
 	kernel32.dll!_WaitForSingleObjectEx@12()  + 0x71	
 	kernel32.dll!_WaitForSingleObject@8()  + 0xf	
>	mysqld-debug.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x009f97f0, _RTL_CRITICAL_SECTION * mutex=0x009f9a78, timespec * abstime=0x0483d144)  Line 67 + 0x11	C
 	mysqld-debug.exe!remove_table_from_cache(THD * thd=0x01542830, const char * db=0x0154a2c8, const char * table_name=0x028548a0, unsigned int flags=2)  Line 5156 + 0x16	C++
 	mysqld-debug.exe!wait_while_table_is_used(THD * thd=0x01542830, st_table * table=0x0154f7d8, ha_extra_function function=HA_EXTRA_PREPARE_FOR_DELETE)  Line 1929 + 0x23	C++
 	mysqld-debug.exe!close_cached_table(THD * thd=0x01542830, st_table * table=0x0154f7d8)  Line 1954 + 0xf	C++
 	mysqld-debug.exe!mysql_alter_table(THD * thd=0x01542830, char * new_db=0x02859790, char * new_name=0x02862c10, st_ha_create_information * create_info=0x01542e38, st_table_list * table_list=0x02862c48, List<create_field> & fields={...}, List<Key> & keys={...}, unsigned int order_num=0, st_order * order=0x00000000, enum_duplicates handle_duplicates=DUP_ERROR, int ignore=0, st_alter_info * alter_info=0x01542fc4, int do_send_ok=1)  Line 3820 + 0x10	C++
 	mysqld-debug.exe!mysql_execute_command(THD * thd=0x01542830)  Line 3041 + 0x6d	C++
 	mysqld-debug.exe!mysql_parse(THD * thd=0x01542830, char * inBuf=0x02862bb0, unsigned int length=37)  Line 5641 + 0x9	C++
 	mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x01542830, char * packet=0x01545d49, unsigned int packet_length=38)  Line 1719 + 0x1d	C++
 	mysqld-debug.exe!do_command(THD * thd=0x01542830)  Line 1515 + 0x31	C++
 	mysqld-debug.exe!handle_one_connection(void * arg=0x01542830)  Line 1158 + 0x9	C++
 	mysqld-debug.exe!pthread_start(void * param=0x028498c0)  Line 63 + 0x7	C
 	mysqld-debug.exe!_threadstart(void * ptd=0x02854ed8)  Line 196 + 0xd	C
 	kernel32.dll!_BaseThreadStart@8()  + 0x52	



CREATE TABLE `commande` (
  `Numero` int(12) unsigned NOT NULL auto_increment,
  `RefTable` varchar(9) default NULL,
  `RefClient` int(10) unsigned default NULL,
  `RefClientLivraison` varchar(10) default NULL,
  `Reference` varchar(30) default '',
  `RefServeur` varchar(6) NOT NULL default '',
  `Date` datetime default NULL,
  `SousTotal` decimal(12,2) NOT NULL default '0.00',
  `FraisLivraison` decimal(12,2) unsigned NOT NULL default '0.00',
  `Promotion` decimal(12,2) NOT NULL default '0.00',
  `PromotionComptoir` decimal(12,2) NOT NULL default '0.00',
  `TPS` decimal(12,2) NOT NULL default '0.00',
  `TVQ` decimal(12,2) NOT NULL default '0.00',
  `Total` decimal(12,2) NOT NULL default '0.00',
  `Commentaire` varchar(30) default '',
  `Imprimee` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Numero`),
  KEY `IX_Commande_Serveur` (`RefServeur`),
  KEY `IX_Commande_Date` (`Date`),
  KEY `FK_Commande_ClientLivraison` (`RefClientLivraison`),
  KEY `IX_Commande_Table` (`RefTable`),
  KEY `IX_Commande_Client` (`RefClient`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;