18 Nov
2013
18 Nov
'13
11:01 p.m.
magmatic schreef op ma 18-11-2013 om 08:17 [-0800]:
I'm playing around with importing books into a test site, and I want to wipe the database ("delete from TABLE"), to start over.
It depends on exactly what you want to delete, but if it's just biblios: items biblioitems biblio (in that order should be the fastest.) If you just do a delete, don't forget to reset the auto_increment back to 1, or new things will be numbered from where the previous data left off. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF