Howdy all!
I have changed my my.ini but my problem remains... details below.
Any further assistance would be greatly appreciated!
I apolagise to all if it seems I am flooding.. :(
Rob
:)
:->
:-}
====== my.ini
[mysqld]
basedir=C:/mySql/
datadir=C:/mySql/data
[WinMySQLAdmin]
Server=C:/mySql/bin/mysqld-MAX-nt.exe
innodb_data_home_dir = C:\mySql\ibdata
innodb_data_file_path=ibdata1:30M:autoextend
====== Creating tables with referential integrity?
C:\mySql\bin>mysql --local-infile -h localhost -u rob -prob
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.55-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE menagerie;
Query OK, 1 row affected (0.01 sec)
mysql> USE menagerie;
Database changed
mysql> CREATE TABLE owner (
-> name VARCHAR(20) NOT NULL,
-> PRIMARY KEY (name)
-> INDEX owner_name_idx (name))
-> TYPE = InnoDB;
ERROR 1064: You have an error in your SQL syntax near 'INDEX owner_name_idx
(name))
TYPE = InnoDB' at line 4
mysql> CREATE TABLE pet (
-> name VARCHAR(20) NOT NULL,
-> species VARCHAR(20) NOT NULL,
-> sex CHAR(1) NOT NULL,
-> birth DATE,
-> death DATE,
-> name1 VARCHAR(20) NOT NULL,
-> PRIMARY KEY (name),
-> INDEX owner_name (name1),
-> FOREIGN KEY (name1) REFERENCES owner (name)
-> ON DELETE SET NULL
-> ON UPDATE CASCADE)
-> TYPE = InnoDB;
Query OK, 0 rows affected (0.05 sec)
mysql> drop database menagerie;
Query OK, 3 rows affected (0.01 sec)
mysql> CREATE DATABASE menagerie;
Query OK, 1 row affected (0.00 sec)
mysql> USE menagerie;
Database changed
mysql> CREATE TABLE owner (
-> name VARCHAR(20) NOT NULL,
-> PRIMARY KEY (name),
-> INDEX owner_name_idx (name))
-> TYPE = InnoDB;
Query OK, 0 rows affected (0.05 sec)
mysql> CREATE TABLE pet (
-> name VARCHAR(20) NOT NULL,
-> species VARCHAR(20) NOT NULL,
-> sex CHAR(1) NOT NULL,
-> birth DATE,
-> death DATE,
-> name1 VARCHAR(20) NOT NULL,
-> PRIMARY KEY (name),
-> INDEX owner_name (name1),
-> FOREIGN KEY (name1) REFERENCES owner (name)
-> ON DELETE SET NULL
-> ON UPDATE CASCADE)
-> TYPE = InnoDB;
Query OK, 0 rows affected (0.06 sec)
mysql> insert into PET (name,species,sex,birth,death,name1) values
('Chicko2','Dog','m',2001/11/04,\N,'Robsdf');
Query OK, 1 row affected (0.01 sec)
mysql> quit
Bye
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
