i have got a table "table1":
CREATE TABLE table1
id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
refer varchar(255) NOT NULL,
aantal int(9) DEFAULT '1' NOT NULL,
time int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id)
now i insert about 200 rows in it.
After that i do i select (using phpMyAdmin):
SELECT table1 FROM table1
it seems this never stops sending data:
Id User Host db Command Time State Info
171807 _ _ Query 300 Sending data SELECT * FROM
also a delete like "DELETE FROM table1 WHERE time<........." will take (too)
All this give problems cause the table is locked when 'Sending data' and the
row of new inserts is growing.
Is there something wrong with my table-design?
Thanks for reading.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]