Hello. MySQL CC is not supported now, and could have some problems with a fresh versions of MySQL. If error doesn't appear in latest MySQL Administrator then everything is ok.
> [local] ERROR 1146: Table 'llcopy.1' doesn't exist Have a look here: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html > The error was > ERROR 1054 (42S22): Unknown column 'C1' in 'field list' Check if the sql_mode has ANSI_QUOTES enabled. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html Kerry Frater wrote: > Can someone point me in the right direction. > I had 4.1 running and all was well with my little program. I decided to test > the code with the newer 5.0.18. I updated my DB and then tried to access it > using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha. > > The Administrator allows me to view table structure but not to add any > numerical columns. > > Using the Control centre, If I double click on the table I wish to view data > I get two lines in the message area > Empty set (0.00) sec > [local] ERROR 1146: Table 'llcopy.1' doesn't exist > > llcopy being my test database name. > These messages are got no matter what the table content is. I do note that > the error message on this app is different numerically to the previous > > Also my insert program now fails to insert data. So I extracted one of the > SQL insert commands that worked with 4.1 and manually run it using the > mysql.exe command interface. This is the manual command. > > INSERT INTO BanksC > (Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS) > VALUES ("C1","Client > Bank","NONE",000000000.00,000000000.00,000000000.00,"C"); > > The error was > ERROR 1054 (42S22): Unknown column 'C1' in 'field list' > > The settings of the table are char(2), char(20), char(12), > decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively. > > This is driving me crazy. I am obviously doing something stupid but I have > got so close to the problem I can't see the wood for the trees. > > Kerry > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
