mysqldump to regenerate the sql statement, you obtain:
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default ''
);
If you use default 0, 0 is an integer. But ENUM only accept strings,
so try to use default '0' when you create the table.
Have a nice day,
Thomas
, but I cannot find
anything in the manual. (I'm running version 3.23.38 which should be a
stable one.)
perhaps you have the auto_increment-field set as a smallint which can
only store values up to 127? Use mediumint or int instead ...
Bye,
Thomas Karcher
control ... *g*
Read the section 6 The MySQL Access Privilege System in the MySQL
manual, then you know what to do.
Thomas Karcher
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi,
I am just curious to know whether you have any GUI for mysql for Windows
NT/98? If so kindly send me the link where I could download it. I am curios
to work on MYSQL.
Look at http://www.mysql.com/downloads/index.html - you will find what
you are searching ...
Thomas Karcher
Hi,
once again *g*
$sql = insert into sitesats set areview='$areview', apositive='$apositive',
anegative='$anegative', arate='$arate' where id='$id';
Does it make sense to INSERT INTO . WHERE ... ? *GG*
Thomas
-
