Revoking Privileges

2007-04-11 Thread Al Sparks
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

Re: Creating a Table With a Default

2007-03-28 Thread Al Sparks
> 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

Creating a Table With a Default

2007-03-28 Thread Al Sparks
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)

Newbie wants to load a couple of tables and join them

2006-02-13 Thread Al Sparks
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