Hi !!!
> -Original Message-
> From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 1:24 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Insert records in a VB5 recordset
>
>
>
> Dear members,
>
> I'm new to MySQL and I'm using MyODBC. I
Hi !
)-Original Message-
)From: rsaras [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 15, 2001 10:23 PM
)To: [EMAIL PROTECTED]
)Subject: insert records
)
)
)hai
)
) can anybody help me?
)
)Table A
)---
)name date
)a2000/12/12
)b2000/12/12
)c2000/
On Thu, Aug 16, 2001 at 01:23:15PM +0800, rsaras wrote:
>
> now i want to take first 2 records from Table A and insert back to
> Table A with different date.
What language are you programming in? Do you know how to query MySQL
using it? If yes, what's the specific problem? If no, then you'll
Yeah, this is why some people like the idea of having transaction supports
in the tables, to make sure both the inserts to the two tables succeed, or
none of them do. Currently MyISAM does not support this, only the newly
introduced Berkeley DB tables support this feature although it is assumed
qu
you can't. You have to do 2 seperate inserts. (Sorry)
Cal
http://www.calevans.com
-Original Message-
From: Bryan Wheelock [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:47 PM
To: [EMAIL PROTECTED]
Subject: INSERT records into multiple tables
I'm just learning how to use MyS
Well, there's a few things. First, I think you need to do a few things to
better normalize your data. You need a table to join a person with a job.
It would look like this:
create table peoplejob (people_id int not null, job_id not null)
Then remove the job column from people.
Then when you c
