> -----Original Message----- > From: Jon Miller [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 20, 2003 1:49 PM > To: [EMAIL PROTECTED] > Subject: query problem > > > I ran a query as follows: > Insert Into db_test.tbl_dbaddr (Client, Contact, Addr, > OfcPhone) SELECT Client AS Client, Business AS Contact, Addr > AS Addr, OfcPhone AS OfcPhone From AddressBook.tbl_addr; > > I got the following Records: 8989 Duplicates: 16 Warnings:394 > > Where can I look to see the Warnings? > Also the information in the Contact and Addr field is wrong. > How do I delete the entire table. I believe I cannot use > Drop. Using Select * delete from tbl_dbaddr yields a syntax error. >
correct syntax for delete is: delete from <table> --------------------------------------------------------------------- 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