Hi list,
I have some problems with INSERT INTO and UPDATE queries on a big table.
Let me put the code and explain it ...
I have copied the create code of the table. This table has more than
1500 rows.
Create Table: CREATE TABLE `radacct` (
`RadAcctId` bigint(21) NOT NULL AUTO_INCREMENT
2012/06/15 18:14 +0900, Tsubasa Tanaka
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.html
"Try" is the operative word: MySQL s character format is _like_ CSV, but not
the same. The treatment of NULL is doubtless the bigg
Database when lot of insert / update queries to execute
>
> hi,
> I am biased on mysql, and hence i am asking this on mysql forum first.
> I am designing a solution which will need me to import from CSV, i am
> using my JAVA code to parse. CSV file has 500K rows, and i need to do
>
Hello,
> I am designing a solution which will need me to import from CSV, i am using
> my JAVA code to parse. CSV file has 500K rows, and i need to do it thrice
> an hour, for 10 hours a day.
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.
hi,
I am biased on mysql, and hence i am asking this on mysql forum first.
I am designing a solution which will need me to import from CSV, i am using
my JAVA code to parse. CSV file has 500K rows, and i need to do it thrice
an hour, for 10 hours a day.
The Queries will mainly be update but select
Try using CONCAT() ;
mysql> update inventory_items set
image_location=concat(item_number,'-1.jpg');
Thanks
ViSolve DB Team.
- Original Message -
From: "Jerry Jones" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 03, 2007 12:00 PM
Subject: Update que
I need to run a query that will take the data from item_number field,
add "-1.jpg" to the end of it, and store it in image_location
I have tried update inventory_items set image_location = item_number + "-1.jpg";
but that just places the item number into the field, without the text
in quotes.
How
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
> I set up replication on my servers since the version 3.23.43. Recently I
> upgrade all my servers to version 4.0.3.
> The replication work fine for insert and delete queries (also alter table)
> but doesn't take care
Hello,
I set up replication on my servers since the version 3.23.43. Recently I
upgrade all my servers to version 4.0.3.
The replication work fine for insert and delete queries (also alter table)
but doesn't take care of update queries.
When I make an update on an existant row in a table o
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE `systemdefault`
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE `systemdefault`
I am hoping this reaches the right place, I was sure I had sent it but
didn't see it come to list...
I have two problems I am hoping to solve.
1) Is it possiblt to "combine" two update queries into one. So something
like UPDATE table SET field=value WHERE field=value2 whi
On Sun, Mar 03, 2002 at 07:51:36PM -0800, Son Nguyen wrote:
> Dear all,
> If my site has two users try to update the same piece of data in
> mySQL at the same time.
>
> * I wonder if I have to create a lock to handle the race condition in
> my script or not?
>
> * Or mySQL already pro
Dear all,
If my site has two users try to update the same piece of data in
mySQL at the same time.
* I wonder if I have to create a lock to handle the race condition in
my script or not?
* Or mySQL already provided a method, which is when the first user
update the data in mySQL, mySQL
14 matches
Mail list logo
