-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
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 primary),comp
or more 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
You DO NOT need to specify table field names when INSERTing records. For
instance, if the table were defined thus:
CREATE TABLE mytable (
valueA varchar(10) NOT NULL,
valueB varchar(25),
valueC varchar(30) );
This statement will insert one record:
INSERT INTO mytable VALUES("some text",
asamy Palaniappan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 9:46 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: help on mysql tables
Sir,
please tell me how to stop mysql from accepting empty string values.
it accepts empty string values even when i enclosed in single q
; <[EMAIL 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,
On Tue, Mar 27, 2001 at 11:53:22AM -, Ramasamy Palaniappan wrote:
> 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 T
- 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 following table:
>
> create table test(name varchar(10) NOT NULL);
> query is ok
Yes, but notice that yo
