Well, the easy way to chunk the inserts is by use of limit. Here is what I
used for one of my projects:
Insert ignore into t1 (f1, f2, f3)
Select f1, f2, f3 from t2 limit 100, 100
Inserts 1M records at a time starting from 1M th record in t2 and you can keep
incrementing this offset as
of my
queries, tables, views and stored procedures to my sql from ms sql.
Best Regards,
Arjun
**
This email and any files transmitted with it are confidential and
intended solely for the use
a clue on what might be happening?
3. Is there any way other than downloading some shareware third party
programs to transfer my databases from access to MySQL ?
I would appreciate any help at all. Thanks to everyone in advance !
Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell
Hi bob ! thanks for your quick reply. I did do a search on google. I
bumped into a bunch of stuff that really lead nowhere. Do you have any
specific sites or utilities in mind ?
Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
I'm MySQL certified. Are you
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privileges for root connecting from any remote
host. Hence the %. It implies [EMAIL PROTECTED]
Hope this helps.
Arjun Subramanian
Georgia Tech
I took the MySQL core certification exam on the 2nd of January and
Passed. I was just wondering when MySQL actually sends out the
Certificate and other stuff they said they would send out? Does anyone
here have any experience with this ?
Thanks in advance.
Arjun Subramanian
Georgia Tech Station
worry too much. Head to sitepoint.com and
go to the php section and start learning. It is an excellent resource. PHP.net
is a good place too although you might want to go to sitepoint first.
Best of luck,
Arjun
Quoting Troy T. Hall [EMAIL PROTECTED]:
I know this sounds stupid but I'm
Hello everybody ! I have question regarding the MySQL core certification. Does
anybody have any general insights on taking the exam ? I am studying from the
manual, but I am pretty nervous about the exam as I don't know how much in
depth the questions will be or even if studying from the manual