perl script help re: scope/structure for noob - Perl::
3 posts - 3 authors - Last post: Sep 30, 2005perl script help re: scope/structure for noob - Perl Community and Forum - Our Perl forum is #create "totalorder" copy of schedule hash
http://www.daniweb.com/forums/thread26696.htmlHOME |
Hello there, I am trying to create a table which worked alright in the beginning but after adding the on delete restrict on update cascade constraints it stopped working. Could someone please help me out and tell me whats wrong with the create statement.
create table branch
(
branchno varchar2(5) Constraint pk_branch_branchno Primary key,
HELP im a noob! - MSSQLTips::
HELP im a noob! Last post 05-24-2009 5:09 AM by ellis. 2 replies. Hey,I'm a noob webdesigner and im having trouble trying to create a *.bak from a
http://blogs.mssqltips.com/forums/t/1326.aspxHOME |
YouTube - the noob sheet: a strong statement toward WMG::
the noob sheet: racists, trolls, anit-gay arguements, and a blockbuster . YouTube, Programs, Help, Legal, Discover
http://www.youtube.com/watch?v=TuA1t62GmSYHOME |
name VARCHAR2(50) NOT NULL,
address VARCHAR2(256) not null,
town VARCHAR2(30) not null,
region VARCHAR2(150) not null,
phonenum number(11) not null
);
Please, I am a NooB and need Advice on creating the MySQL database ::
2 posts - 2 authors - Last post: Jan 4whatever, if it is there, you can easily create a database and grant The GRANT statement in the documentation is one way of creating a
http://drupal.org/node/354143HOME |
Linux noob needs help with dual boot partitioning - openSUSE Forums::
9 posts - 5 authors - Last post: Feb 7Hi to all, Linux noob here so take it nice and slow, Windows veteran so that create partition dev/sda7 (129.04GB) for /home with ext3
http://forums.opensuse.org/install-boot-login/406958-linux-noob-needs-help-dual-boot-partitioning.htmlHOME |
create table c
(
cID varchar2(5) constraint pk_c_cID PRIMARY KEY,
bID varchar2(5) constraint fk_c_bID references branch ON DELETE RESTRICT ON UPDATE CASCADE,
title varchar2(10) not null,
famname varchar2(50) not null,
firstname varchar2(50) not null,
address varchar2(256) not null,
town varchar2(30) not null,
county varchar2(50) not null,
postcode varchar2(7) not null,
homenum number(11) not null,
mobnum number(11),
worknum number(11),
email varchar2(30)
);
Please post the exact error message.
What MySQL version are you using?
Also the ON DELETE and ON UPDATE are only supported for InnoDB i think.
You also don't specify the column in your branch table to which the reference should point.
Thanks for the help. I am actually using oracle but i guess its pretty similar from what i understand. I will post the error message tomorrow when i am back at uni and can access the server.
Would you be able to post an example of what the reference in the branch table should look like?
I suggest you have a look in the Oracle Metalink and the Oracle documentation. You will not find much Oracle support on this forum i guess, and i am not at my own PC, so i also don't have any Oracle (documentation) at hand. If you can't find any examples at MetaLink (which i doubt) you could try searching for a more Oracle specific forum.
PS I am not so sure that the implementation of referencal integraty function is the same between Oracle and MySQL, for MySQL documentation see: http://dev.mysql.com/doc/refman/5.0/en/create-table.html
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
Noob create statement help.