Retrieving records (mysql)
Posted: Tue Feb 12, 2008 6:45 pm
My problem
INSERT INTO `blabla` (aaa,bbb,ccc etc...) VALUES('aaa','bbb','ccc' etc...);
Next I query the database for the record that was just added above
SELECT * FROM `blabla` WHERE aaa = 'aaa';
The record is not being returned (fields are all NULL)
I run the query again (sometimes 2 to 3 times) and finally I get my record.
Looks to me like the server is too busy to add the record fast enough or what.
How do I get my record?
INSERT INTO `blabla` (aaa,bbb,ccc etc...) VALUES('aaa','bbb','ccc' etc...);
Next I query the database for the record that was just added above
SELECT * FROM `blabla` WHERE aaa = 'aaa';
The record is not being returned (fields are all NULL)
I run the query again (sometimes 2 to 3 times) and finally I get my record.
Looks to me like the server is too busy to add the record fast enough or what.
How do I get my record?