Re: Question of a Beginner

2001-12-26 Thread Bob Hall
On Wed, Dec 26, 2001 at 05:34:34PM -0500, Jose Villanueva wrote: I'm a beginner in MYSQL, please can anyone tell me the right command in ORACLE equivalent to the EXEC SP of SQL Server, i'm working with ORACLE SP, i will apreciate any hepl, thanks. Sir, I'm confused. If you want the ORACLE

Question of a beginner

2001-09-24 Thread Jacques Le Tallec
I'm working with a table that includes a field id INTEGER AUTO-INCREMENT NOT NULL . When I create a new record with the query INSERT, I don't give any value for the id field, the value is automatically given by mySQL. As the database is supposed to be used on the WEB, several queries INSERT

Re: Question of a beginner

2001-09-24 Thread jim barchuk
Hi Jacques! I'm working with a table that includes a field id INTEGER AUTO-INCREMENT NOT NULL . When I create a new record with the query INSERT, I don't give any value for the id field, the value is automatically given by mySQL. As the database is supposed to be used on the WEB, several

Re: Syntax question for a beginner..

2001-07-06 Thread Rolf Hopkins
that are in B but not in A. - Original Message - From: { randy } [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Friday, July 06, 2001 14:05 Subject: Re: Syntax question for a beginner.. Well, I think I got it figured out. I am using PHP, and thought I could lick it with just one

Re: Syntax question for a beginner..

2001-07-06 Thread { randy }
You are the man...thanks a bunch! that's what I needed. = r a n d y / sesser at mac.com From: Rolf Hopkins [EMAIL PROTECTED] Date: Fri, 6 Jul 2001 14:39:59 +0800 To: { randy } [EMAIL PROTECTED], MySQL [EMAIL PROTECTED] Subject: Re: Syntax question for a beginner

Syntax question for a beginner..

2001-07-05 Thread { randy }
Alright, I am about to pull my hair out. I have 2 tables. Each have a column 'email' that are unique. Some of the records in both tables are duplicates and I want to combine the two tables into one with out bringing in the duplicates. So... I have this statement: Mysql SELECT email FROM tableA

RE: Syntax question for a beginner..

2001-07-05 Thread Shania Qiu
I remember somewhere has mentioned that MySQL does not copy with nested SELECT query. Properly it is the reason. Shania Qiu -Original Message- From: { randy } [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 July 2001 4:29 p.m. To: MySQL Subject: Syntax question for a beginner.. Alright

RE: Syntax question for a beginner..

2001-07-05 Thread Siomara Pantarotto
I had never seen WHERE NOT before. Does this exist in mysql siomara From: Shania Qiu [EMAIL PROTECTED] To: '{ randy }' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: Syntax question for a beginner.. Date: Fri, 6 Jul 2001 16:39:47 +1200 I remember somewhere has mentioned that MySQL

RE: Syntax question for a beginner..

2001-07-05 Thread Bomber Steel
. Black Holes The End of The Universe? John G. Taylor PG 11. Line 1 -Original Message- From: { randy } [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 10:29 PM To: MySQL Subject: Syntax question for a beginner.. Alright, I am about to pull my hair out. I have 2 tables. Each have

Re: Syntax question for a beginner..

2001-07-05 Thread Rolf Hopkins
tableA and tableB, without the duplicates. - Original Message - From: { randy } [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Friday, July 06, 2001 12:28 Subject: Syntax question for a beginner.. Alright, I am about to pull my hair out. I have 2 tables. Each have a column 'email