[wdvltalk] MySql front won't select - 2nd time

2004-01-22 Thread Joseph, Smile Poet
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

[wdvltalk] MySql front won't select

2004-01-21 Thread Joseph, Smile Poet
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