I have a table 'test' in database 'test' with two columns and 20 rows.
I have used both DBManager and MySql Front to select with this
SELECT*FROM test WHERE 1=orange; (after much sweat) this appears
to be acceptable syntax.
However, while the two fields are acknowledged both programs tell me
and simply
typing in SQL commands to try out. For instance,
CREATE TABLE test (col1, col2) [enter]
then
INSERT INTO test (col1, col2)
VALUES ('fruit', 'orange') [enter]
INSERT INTO test (col1, col2)
VALUES ('colour', 'orange') [enter]
Okay I have 19 rows