[PHP] Re: Command Line

2002-08-27 Thread Gerald R. Jensen
Trevor ... Do you want to drop the tables, or simply delete the data in them and retain the table structure? To delete data ... USE databasename; DELETE * FROM tablename; To drop tables ... DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT | CASCADE] If you drop a tabl

[PHP] Re: Storing images in MySQL bad idea, performance-wise?

2002-07-08 Thread Gerald R. Jensen
Rene: I think a good deal depends on the size of the image files themselves. There are a number of apps that store small files (i.e.: icons, small gif's, etc.), which seems to make sense. Larger files may be problematic. There was quite a discussion on this issue here just last week ... do a sea