No, The column name should have been "Modified By" data type should have been "text"
Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -----Original Message----- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:20 AM To: 'Todd Williamsen'; '[EMAIL PROTECTED]' Subject: RE: Running Query "By" is not a legal data type. Did you mean "By text", without the word "Modified"? -----Original Message----- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:17 AM To: [EMAIL PROTECTED] Subject: Running Query I did a dump of a table from another database table and wanted to run the .sql file in another database. I used PHPadmin to do this and used phpadmin to run the .sql file against the other database I have this is the error from mysql: SQL-query : CREATE TABLE tblmembers ( ID int(11) default NULL, FirstName text, Initial text, LastName text, Address1 text, Address2 text, City text, State text, Zip text, HomePhone text, WorkPhone text, Fax text, Email text, Userid text, Password text, Registered datetime default NULL, Modified datetime default NULL, Modified By text ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'By text ) TYPE=MyISAM' at line 19 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
