I did that as a convenience. Basically it provided me two ways of uniquely
identifying any row in a table(an auto_inc integer, and some unique text
column). The autoincremented values should never repeat. HOWEVER because I
did not put a UNIQUE constraint on them, it is possible for someone to
c
Too funny! I'm slowly coming to grips on the M2M. I
decided not to opt for it in this situation as I still
believe it would not address my issues.
My problem, or a better to phrase it , my solution is
that I am not supplying titles. They are, to the user
, blank fields , left to them to supply t
Stuart,
You need to begin to divorce these two processes from each other: STORAGE
and INPUT/OUTPUT. What your user's see on a web page doesn't need to look
anything at all like your database structure. A user interface (UI) is
designed for ease of use. The other is designed for query and stora
Never mind, finally figured it out on my own.
Sorry , i think out loud sometimes!
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Trying to figure out how this gets done. Let me
> explain first. By the way I hope this is not off
> topic
> as perhaps it is more towards application the
Trying to figure out how this gets done. Let me
explain first. By the way I hope this is not off topic
as perhaps it is more towards application then core db
.
I have a table:
Count[int][auto-increment], MemberID[int],
Title[varchar], TitleYear[int]
In my organization members can have or have he
At 14:32 -0700 7/22/04, Scott Haneda wrote:
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
Scott,
Perhaps you could ask "someone" to provide a
Scott Haneda <[EMAIL PROTECTED]> wrote:
> I was just reading a forum post on mysql, someone said it was possible in
> mysql 4 to insert data into more than one table at once. Is this possible,
> if so, where in the docs can I see a example of this?
Not possible. What is possible is inserting sev
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
--
-
Scott Haneda
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
--
-
Scott Haneda
gt;>Values (("56-56", 5), ("27-01", 1), ("15-02", 2));
>>
>>I've tried it with and without the outer parens.
>>
>>Thanks
>>
>>
>>
>>>>>"Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >
Table1 (Product, Qty)
>>Values (("56-56", 5), ("27-01", 1), ("15-02", 2));
>>
>>I've tried it with and without the outer parens.
>>
>>Thanks
>>
>>
>>
>>>>>"Adolfo Bello" <[EMAIL PROTECT
L PROTECTED]> 12/1/2002 5:42:34 AM >>>
>
> INSERT INTO your_table(fields_list) VALUES
> (record_1),(record_2),...,(record_n);
>
>
>>-Original Message-
>>From: Ed Reed [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, November 30, 2002 3:47 PM
>&g
ot;, 1), ("15-02", 2));
>
> I've tried it with and without the outer parens.
>
> Thanks
>
>
>>>>"Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>>
>
> INSERT INTO your_table(fields_list) VALUES
> (record_1
;
> INSERT INTO your_table(fields_list) VALUES
> (record_1),(record_2),...,(record_n);
>
>
>>-Original Message-
>>From: Ed Reed [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, November 30, 2002 3:47 PM
>>To: [EMAIL PROTECTED]
>>Subject: Multiple Ins
ens.
Thanks
>>> "Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>>
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
> -Original Message-
> From: Ed Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturda
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
> -Original Message-
> From: Ed Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 30, 2002 3:47 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple Inserts and updates
>
>
&g
Can anyone give me an example of how to insert and/or update multiple
records in the same table simultaneously?
I have a table with three fields; ID, PartNum, Qty. The user enters
PartNum and Qty data in an unbound grid UI. When the user hits "Save"
I'd like to build a single SQL statement from th
Hi all
Thanks for your replies to my question about multiple updates in one query. I think
Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do
what I wanted, so I reverted to single update queries.
cheers
Mark
---
Summary of replies
-- from Paul Wilso
Mark
> Does anyone know if it's possible to insert mutilple records into 1
table
> in one query?
yes
> Something like -
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15')
>
> insert into mytable (id,name,job_number,job_date) values
> ('2','Mark','AA2'
Hi.
Just use
INSERT INTO mytable (id,name,job_number,job_date)
VALUES ('1','Mark','AA1','2002-04-15'), ('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17') [and so on...]
Also see http://www.mysql.com/doc/I/N/INSERT.html
Bye,
Benjamin.
On Sun, Apr 14, 2002 at 11:10:22PM
Many thanks for that.
cheers
Mark
On Mon, 15 Apr 2002, Kittiphum Worachat wrote:
> Hi.
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
> 'AA3','2002-04-17'),
>
> Kittiphum Worachat,M.T.
> www.ha
Hi.
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
'AA3','2002-04-17'),
Kittiphum Worachat,M.T.
www.hatyailab.com
>
> Does anyone know if it's possible to insert mutilple records into 1 table
> in one q
Does anyone know if it's possible to insert mutilple records into 1 table
in one query?
Something like -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15')
insert into mytable (id,name,job_number,job_date) values
('2','Mark','AA2','2002-04-16')
insert int
* Egor Egorov
> AC> REALFROM: "Anton Chalbaud" <[EMAIL PROTECTED]>
> AC> HOUR: 2002033122
>
> AC> Hi, if I need to do multiple INSERTS (I mean into different
> tables) which is
I think he asked about inserting int
Anton,
Sunday, March 31, 2002, 10:53:45 PM, you wrote:
AC> REALFROM: "Anton Chalbaud" <[EMAIL PROTECTED]>
AC> HOUR: 2002033122
AC> Hi, if I need to do multiple INSERTS (I mean into different tables) which is
AC> the best way to manage this? Do I have to run a
Hi, if I need to do multiple INSERTS (I mean into different tables) which is
the best way to manage this? Do I have to run a different Query for each
INSERT ? Or is there a faster & better way to do it.
Thanks.
-
Be
- Original Message -
From: "Philippe L. Houze" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 8:09 AM
Subject: MySQL: Multiple INSERTS syntax ...
> When running: INSERT INTO customers3 (firstname) select TRIM(trailing
> char(10) FR
Hi,
I found syntax for INSERT command in both Paul DuBois excellent book and
online manual but for single insert. And it works... which for a newbie like
me is thrilling. But, I am stuck for multiple inserts.
I am trying to remove from a database trailing characters (ascii 10) that
have shown
I would think an UPDATE would suit you just fine.
UPDATE mytable SET price=price*1.21 WHERE ...
- Original Message -
From: "fano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 23:01
Subject: multiple inserts
> Hello mysql,
>
>
Hello mysql,
Hi, I have a table "Invoices", and i want to do something like
this..
every 15 of every month, i need to open every registry of invoices..
take the price of each record and crete a new record with that price
* 1.21 (I'm from argentina, and we pay some taxez :)
How can i
30 matches
Mail list logo
