the output look like this..
mysql> desc policy;
+----------------+--------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------+------+-----+---------+-------+
| service_charge | int(2) | | | 0 | |
+----------------+--------+------+-----+---------+-------+
1 row in set (0.01 sec)
-----Original Message-----
From: "Chris Bolt" <[EMAIL PROTECTED]>
Date: Wed, 25 Jul 2001 05:07:02 -0600
To: <[EMAIL PROTECTED]>
Subject: RE: Invalid SQL..?
Re: > hi all..
Re: >
Re: > this error came out after i make backup for my database using mysqldump
Re: > what this error say is wrong... maybe my database is corrupt or
Re: > crash or something like that.. any command can fix this error..?.
Re: > any idea what i should do.
Re:
Re: Please paste the output of typing "DESCRIBE policy;" into the mysql client.
Re:
Re: > Database error: Invalid SQL: select id, subid from policy where
Re: > id='2' and subid='0'
Re: > MySQL Error: 1054 (Unknown column 'id' in 'field list')
Re: > Session halted.
Re:
Re: Now there's a pointless SQL query... heh
Re:
Re:
Re: ---------------------------------------------------------------------
Re: Before posting, please check:
Re: <A HREF="http://www.mysql.com/manual.php" TARGET="_new"><FONT
COLOR="BLUE">http://www.mysql.com/manual.php</FONT></A> (the manual)
Re: <A HREF="http://lists.mysql.com/" TARGET="_new"><FONT
COLOR="BLUE">http://lists.mysql.com/</FONT></A> (the list archive)
Re:
Re: To request this thread, e-mail <[EMAIL PROTECTED]>
Re: To unsubscribe, e-mail <[EMAIL PROTECTED]>
Re: Trouble unsubscribing? Try: <A HREF="http://lists.mysql.com/php/unsubscribe.php"
TARGET="_new"><FONT COLOR="BLUE">http://lists.mysql.com/php/unsubscribe.php</FONT></A>
Re:
Re:
--
Get your free email from www.linuxmail.org
Powered by Outblaze
---------------------------------------------------------------------
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