Sorry Joseph, you must've missed my next post minutes later. I had the
limit option accidentally set in MySQL-Front and the newly inserted
records weren't appearing.
Another question though, I continued testing this and found that if I
use MSAccess as the front end to the MySQLserver the command fails.
Access produces an error that claims it's expecting the statement to end
after the first records data. Is there anyway to get around this
apparent limitation?
- Thanks
>>> Joseph Bueno <[EMAIL PROTECTED]> 12/1/2002 1:48:05 PM >>>
If you don't have any error message, what make you think it doesn't
work?
FYI, I have run the following commands from mysql client:
mysql> use test
Database changed
mysql> create table Table1 (Id int not null auto_increment primary
key,
Product varchar(80), Qty int);
Query OK, 0 rows affected (0.00 sec)
mysql> Insert Into Table1 (Product, Qty) Values ("56-56", 5),
("27-01", 1), ("15-02", 2);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from Table1;
+----+---------+------+
| Id | Product | Qty |
+----+---------+------+
| 1 | 56-56 | 5 |
| 2 | 27-01 | 1 |
| 3 | 15-02 | 2 |
+----+---------+------+
3 rows in set (0.00 sec)
It really seems to work ;)
Regards,
Joseph Bueno
Ed Reed wrote:
> I created a new table called Table1 and did a test with that command.
My
> test table does have all three fields that I mentioned. The ID field
is
> an autoincrement. The other fieldnames match what's in my command.
>
> I'm running the command from MySQL-Front and it doesn't return any
> error message it just doesn't insert the new records. If I include
the
> outer parens then it tells me there's an error in my syntax.
>
> - Thanks
>
>
>>>>Joseph Bueno <[EMAIL PROTECTED]> 12/1/2002 12:00:21 PM >>>
>
> According to your first post, your fields are named ID, PartNum,
Qty.
> May be replacing 'Product' with 'PartNum' will help.
> You should only remove outer parens:
>
> Insert Into Table1 (Product, Qty)
> Values ("56-56", 5), ("27-01", 1), ("15-02", 2);
>
> If it does not work, you should also post the error message you
> are getting from mysql.
>
> Regards,
> Joseph Bueno
>
> Ed Reed wrote:
>
>>Thanks for the response. I tried your example but it doesn't work,
>>Here's my SQL, can you tell what I'm doing wrong?
>>
>>Insert Into 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 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
>>>To: [EMAIL PROTECTED]
>>>Subject: Multiple Inserts and updates
>>>
>>>
>>>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 the data in the grid and have that one statement update
>>
>>>or insert the rows in the table as necessary. I don't wanna
>>>have to build a separate SQL statement for each row of the
>>>grid (which is the only way I know how at this moment).
>>>
>>>Any help would be appreciated.
>>>
>>>
>>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
