create table foo select * from bar does not copy keys??

2001-04-07 Thread Marc Swanson
NOT NULL default '0', field1 char(55) default NULL ) TYPE=MyISAM; ** The manual doesn't say anything about this. Is this a bug or just something I missed in the manual? Thanks -Marc- #/\/\/\/\/\/\/

usage of "distinct" in a table join query?

2001-02-04 Thread Marc Swanson
a list of each item encountered and skip over the next element if it has already been encountered but that seems like a lot of extra unneccessary code. Thanks -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | \|||/ # #MSwanson Consulting | /o o\

RE: Backup?

2001-01-30 Thread Marc Swanson
l that dumps databases into a nice directory tree... http://www.mswanson.com/mybackup or under the contributed section of the mysql website. -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | \|||/ # #MSwanson Consulting | /o o\ # #Phone: (6

bug in 3.23.22-beta

2001-01-19 Thread Marc Swanson
). Can somebody let me know if this bug exists in the newer 3.23 servers? Thanks -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | \|||/ # #MSwanson Consulting | /o o\ # #Phone: (603)868-1721|-oooOooo-# #Fax:(603)868-1730