Re: Duplicate Entry, But Table Empty!

2009-12-13 Thread Pinter Tibor
Victor Subervi wrote: Hi; mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2"); mysql> select * from *tem126072385457*; t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: find records with only numbers

2009-04-13 Thread Pinter Tibor
Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number. For example, Select Field1 as f from table1 as t where lcase(t.f) not like in ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p',

Re: Cannot start mysqld

2005-08-10 Thread Pinter Tibor (tibyke)
check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t >050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table >'mysql.host' doesn't exist >050810 20:26:52 mysqld ended -- MySQL General Maili