The version I'm using is:
Your MySQL connection id is 6 to server version: 4.1.22
I log on as root. I then:
mysql> show grants for 'WP_INT_BASEBALL'@'localhost';
++
| Grants
> It makes no sense to use a default value with an auto_increment
> attribute, which means, the default value is the auto-incremented
> value.
>
> Carlos
Hmmm... I see your point. I sort of figured that the default was an
initial value, and from there, it incremented when accessed.
Sort of weir
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created in MySQL, and
I've culled it down to this:
mysql> CREATE TABLE zones (
-> id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY (id)
Basically, I'm new to mysql (or to any database for that matter).
I have an old version installed on my linux machine. I thought, as a
learning exercise I'd take 2 files (tab separated tables) load them
into mysql and then merge or join them.
So what are the steps? The first thing I tried was t