-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What are the results you expect. There are always workarounds
Adrian
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary :
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary : partycode(references to primary),companyname
select partycode,companyname from secondary where partycode=(select
partycode from primary where partyname="");
as per mysql -
mysql doesn't support subselects.
Jeff Levy
Software Design
Meta-Craft Creations
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary : partycode(references to
Dear Sir,
I have created the following table:
create table test(name varchar(10) NOT NULL);
query is ok
I HAVE TRIED THE FOLLOWING QUERY :
insert into test values("");
MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL
CONSTRAINTS.
PLEASE CHECK THE ABOVE QUERY
KINDLY
PROTECTED],
[EMAIL PROTECTED]
Subject: Re: help on mysql tables
Date: Tue, 27 Mar 2001 07:08:29 -0500
- Original Message -
From: "Ramasamy Palaniappan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 6:53 AM
Subject: help on mysql tables
I have created the fol
of the
fields you are inserting into.)
Cal
http://www.calevans.com
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 1:25 PM
To: [EMAIL PROTECTED]
Subject: RE: help on mysql tables
You DO NOT need to specify table field names when INSERTing