auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

(2) unsigned zerofill NOT NULL auto_increment, -> PRIMARY KEY(name, id) -> ) TYPE=INNODB; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql> mysql> create table test ( -> name CHAR(20) NOT NULL, -> id INT(2

ON DELETE CASCADE ON UPDATE CASCADE

--+--+--+---+ | softwareID | softwareName | softwareVers | installedDate | ++--+--+---+ | test-1.6 | test | 1.1 | NULL | +----+------+--+---+ 1 row in set (0.00

[Fwd: Foreign key ... ON UPDATE CASEADE]

Original Message Subject: Foreign key ... ON UPDATE CASEADE Date: Thu, 27 Mar 2003 12:08:34 +1100 From: vinita Vigine Murugiah <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Hello I have been use mysql ver 3.23.53, also I'm using on DELETE CASECADE. It s

Foreign key ... ON UPDATE CASEADE

Hello I have been use mysql ver 3.23.53, also I'm using on DELETE CASECADE. It seems working fine. I believe UPDATE CASECADE is working from version 4.0.8. - I have following problem (purchaseOrder_items::ord

exist

HI Does mysql support function EXIST I got the following error mysql> select * from arcdata d -> WHERE year='2003' AND semester='1' -> AND EXIST (SELECT * FROM arcdata_unitCodes u -> WHERE u.idnum = d.idnum AND u.semester=d.semester AND u.year=d.year -> AND unitcode LIKE '433%')

Re: Foreign key in INNODB

vinita Vigine Murugiah wrote: Egor Egorov wrote: On Thursday 16 January 2003 00:12, vinita Vigine Murugiah wrote: Rafal Jank wrote: On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: HI I'm not sure what is wrong with my CREATE T

Re: Foreign key in INNODB

Rafal Jank wrote: On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: HI I'm not sure what is wrong with my CREATE TABLE syntax, Please advice There is no index on ifname in table equipment_interfaces. Well.. Then how come Foreign key

Foreign key in INNODB

Y (equipID, ifName, ifIPv4alias) -> ) TYPE=INNODB; ERROR 1005: Can't create table './test/equipment_interfaces_IPv4alias.frm' (errno: 150) mysql> ********

Re: auto increment

ncrement. I can't use address as part of the primary keys, it doesn't have the Characteristic to use as part of the primary key(blob). Well. If mysql doesn't support this, then i need to change the design a bit. Thanks Matt - Original Message - From: "Paul

Re: auto increment

nt the ID to be incremented automatically!! regards - Original Message - From: "vinita Vigine Murugiah" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 11:35 AM Subject: Re: auto increment HI ALL I couldn't have an auto-inc

Re: auto increment

(roomNum, id) Any idea??? -- warm regards Vinita Vigine Murugiah Email : [EMAIL PROTECTED] Ph : (03) 8344 1273 -- warm regards Vinita Vigine Murugiah Email : [EMAIL PROTECTED] Ph : (03) 8344 1273 - Before posting, pl

Left Join more than one table

HI I'm using ver 3:23:49 & 3:23:53, I thought "A LEFT JOIN B USING (c)" is Identical to "A LEFT JOIN B ON A.c = B.c" It seems it is NOT the case if you are joining more that ONE table & one of them is EMPTY. Please see the following Example mysql> select * from room; +-+-

Re: using explicit locking

HI I have a similar question. I'm using InnoDb table type (ver 3.23.53), according to the web side, it does a row level locking. Does this mean that I don't need to do any table locking during the Update/Delete/Insert queries?? How do I test it that It really doing the locking (other than ta

Re: Creating foreign key

HI Victoria, Harald, Dyego you all were right, the database is not supporting the InnoDb tables; I configure it with "--with --innodb" option & add innodb_data_file_path to the my.cnf. Now it's working!! Thank you so much Vinita sql Dyego Souza do Carmo wrote: vvM> HI vvM> still not workin

cmd load is not allowed in ver3.23.53???

HI Does any one encounter the same problem?? If load cmd in not working in ver3.23.53, is there any alternative cmd for loading table??? Thanks vinita # mysql> select version(); +---+ | version() | +---+ | 3.23.33 | +

Re: Creating foreign key

("433222", "2000", "1"); Query OK, 1 row affected (0.00 sec) Silmara wrote: Change room to unit FOREIGN KEY (unitCode) REFERENCES room (unitCode) ON DELETE CASCADE FOREIGN KEY (unitCode) REFERENCES unit(unitCode) ON DELETE CASCADE Hope this helps, Sil - Orig

Creating foreign key

HI I'm not sure what I'm doing wrong in the following example, the foreign key is NOT working. I'm using ver3.23.53. - mysql> CREATE TABLE unit ( -> unitCode CHAR(20) NOT NULL, -> uni

Re: problem

HI You may NOT have create privileges. check your privileges by doing show grants for @; You can give CREATE privileges for databases & tables GRANT CREATE ON *.* To IDENTIFIED BY '' Refer to http://www.mysql.com/doc/en/GRANT.html Phung Huu Phu wrote: >Dear Sir or Madam: >I have install

SubSelect Query

HI all' mysql> select userGroup from machineGroup_userGroups where hostname="mulga"; +---+ | userGroup | +---+ | staff | | tech | +---+ 2 rows in set (0.01 sec) mysql> select username from account where loginGroup="staff" OR loginGroup="tech"; +--+ | use

Re: Select Query

Chris Kay wrote: >Query ( that gets past the anti spam ) > >Question is.. > >I have a select where I want to get ID 15 && id 25 > >Can I do something like WHERE ID = 15,25 > I don't think this will work, In SQL you can do WHERE id IN (15, 25) This IN() function doesn't seems working in

Perl with Mysql :

HI all I'm trying to do the following --- # want to select (just preparing) every thing from the table PERSON where i don't know the deptID yet. $per = $

Re: mysqlimport

Paul DuBois wrote: > At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote: > >> Hi paul >> >> Paul DuBois wrote: >> >>> At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote: >>> >>>> HI Egor >>>>OK, I want to

Re: mysqlimport

Hi paul Paul DuBois wrote: > At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote: > >> HI Egor >>OK, I want to create new databases, to do that I need database >> create privilege. >> >> Grant CREATE ON ## >> to ddb@localhost IDENTIFIED BY &#

Re: mysqlimport

HI Egor OK, I want to create new databases, to do that I need database create privilege. Grant CREATE ON ## to ddb@localhost IDENTIFIED BY 'passwd' What should go into #, is it a *? but I should NOT given permission to access other databases. Thanks Egor Egorov wrote: >vinita, >M

mysqlimport

Hi I can create a database called test, mysql> create database test; Query OK, 1 row affected (0.03 sec) BUT I can't create any other databases??? mysql> create database tem; ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem' mysql> create database proj; ERROR 1044: Access d

Re: auto Incerment

HI Paul Thank you very much!!! yes it works when I have PRIMARY KEY (SoftwareId, id) but didn't work for KEY(SoftwareId, id), since this allows to have multiple entries on the keys, I think vinita Paul DuBois wrote: > At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote:

Re: auto Incerment

atement > > > > > > vinita vigine > >Murugiah

Re: auto Incerment

> HI > > I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 > > This is the definition of table software_machineOSs > ++--+--++-++ > | Field | Type | Null | Key | Default | > Extra

auto Incerment

HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra | +

Re: problem with AUOT_INCREMENT

vinita vigine Murugiah wrote: > HI > > I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 > > This is the definition of table software_machineOSs > ++--+--++-++ > | Field | Type