Hi everyone:
I have the next question
I have php script that does a lot of inserts to my tables, the first time I executed the script worked fine and I could see the results and when I did a select the command showed me the right info, but now when I try running again the script all seems is inserting data, I typed the command show processlist and displayed the following:
mysql> show processlist;
+----+-----------+-----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------+-----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+
| 91 | developer | localhost:33629 | servicios | Query | 0 | update | INSERT INTO Cliente VALUES ('14626' , '1','7087','1','1','21','6','FRANCISCO','HERNANDEZ','GARCIA',' |
| 92 | mysql | localhost | servicios | Query | 0 | NULL | show processlist |
+----+-----------+-----------------+-----------+---------+------+--------+------------------------------------------------------------------------------------------------------+
But when I do a "select * from Cliente" or "select * from Pedido" simply displayed nothing, then I run the command show innodb status and displayed the following:
--
TRANSACTION 0 23285999, COMMITTED IN MEMORY, process no 4776, OS thread id 405515 committing
MySQL thread id 91, query id 7996081 10.50.21.246 developer update
INSERT INTO Pedido VALUES ('260893','1','7126','103373' ,'1' ,'2','2000-07-28','4')
---
I don't know what happened, the question is Where is the data that my php script inserted before?.
Greetings and thnx in advanced.
System info: Red Hat 7.3 mysql version 4.0.12 500MB Ram
_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
