Mysql to test queries
Posted 07 November 2005 - 02:31 PM
Can anybody please give me some idea or point me in the direction of where to research how to setup a mysql table with this.
Its mysql server 5 and ive been told that i can create tables with it. I just need a bit of info about this as im ok with queries but not actualy setting up databases.
Ive also got mysql admin and the query tool.
Posted 07 November 2005 - 02:33 PM
Posted 07 November 2005 - 03:37 PM
Im making the tables using mysql command line.
Here are my tables although im not sure if they will work - can you check if the foreign key and primary key are set right.
Once ive got the tables working ill be fine.
Please anyone check if these are right:
create table emp
FOREIGN KEY (EMPNO)
create table dept
DEPTNO integer(2) NOT NULL PRIMARY KEY,
Posted 07 November 2005 - 05:46 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users