Hi,
Thanks for the reply. Now I also manipulate it using PHP script to loop
every 1000 of records.
Regards,
Willy
On Tue, 2008-05-20 at 11:48 +0800, Moon's Father wrote:
> To make the parameter max_allowed_packet larger.
>
> On Mon, May 19, 2008 at 12:17 PM, sangprabv <[EMAIL PROTECTED]>
> wrot
To make the parameter max_allowed_packet larger.
On Mon, May 19, 2008 at 12:17 PM, sangprabv <[EMAIL PROTECTED]> wrote:
> Hi,
> Currently in my production environment, mysql only allow max 50.000
> records per insert. Is it possible to increase the number of records
> inserted during insert into
Hi,
Currently in my production environment, mysql only allow max 50.000
records per insert. Is it possible to increase the number of records
inserted during insert into query? How to do it? TIA
Regards,
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
At 18:56 +0100 10/5/02, Greg Conway wrote:
>Hi all,
>
>I've got a MySQL Db on a Server, and I want to export and re-import the data
>into another Server.
>
>This is fairly straight-forward using phpMyAdmin, but there is one
>problem
>
>After creating the tables in the Db, I've gone back and ad
Hi all,
I've got a MySQL Db on a Server, and I want to export and re-import the data
into another Server.
This is fairly straight-forward using phpMyAdmin, but there is one
problem
After creating the tables in the Db, I've gone back and added record ID 0 in
each table as a record with value
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
Dear members,
I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost
from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I
try to add a new record I got the following error msg:
Run-time error 40069
Client Cursor: 40 - Assigned data exceeds defined column
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
hai
can anybody help me?
Table A
---
name date
a2000/12/12
b2000/12/12
c2000/12/12
d2000/12/12
now i want to take first 2 records from Table A and insert back to Table A with
different date.
The result should be:-
Table A
---
n
ED]]
> Sent: Friday, March 16, 2001 3:47 PM
> To: [EMAIL PROTECTED]
> Subject: INSERT records into multiple tables
>
>
> I'm just learning how to use MySQL and I am searching for a more simple
way
> of doing an INSERT query into multiple tables simultaneously.
> I have
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
t;,$link_id)
or die(mysql_error());// assumes auto_increment
I just typed this in without trying it in any way, so don't tryo to run it
as is -- but it should give you an idea.
- Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&
I'm just learning how to use MySQL and I am searching for a more simple way
of doing an INSERT query into multiple tables simultaneously.
I have done my best to nominalize my DB but that creates but I'm confused as
to how to insert data into the DB and have all the related table be updated.
I thin
14 matches
Mail list logo
