From: dr_pompeii (dr_pompeiiyahoo.com)
Date: Sun Apr 06 2008 - 08:53:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Martijn
thanks so much for your reply

pls read this carefully

ok

for instance

i already know how use mysqldump,
so i can get A.sql , something like this

insert into person(id,name,age,sex ) VALUES (01, jesus, 33, male ),
insert into person(id,name,age,sex ) VALUES (02, michael, 17, male),
insert into person(id,name,age,sex ) VALUES (03, lucia, 18, female),
....

the point i need generate a B.sql (from A.sql or other way)
something like this

UPDATE person name='jesus', age='33' WHERE id='01',
UPDATE person name='michael', age='17' WHERE id='02',
UPDATE person name='lucia', age='18' WHERE id='03',
....

if you can see in my "desired" B.sql
for each row from A.sql (insert) i have a match row in B.sql (update)
see 2 importants things
1: one column is missing (sex)
   thats the reason that i need create this B.sql
   with my desired columns to update
2: the information in update statements are the same like to A.sql,
   but i am free to change some row to update

in other words i need something like a template (B.sql) to update
any "update statment" and the "desired columns"

i hope you see my point now

thanks in advanced

Martijn van den Burg wrote:
>
> Hi,
>
>> if i have for example
>> a simple table call person
>>
>> with 'id' and 'name' how columns
>>
>> i can do a backup and get some file (A.sql)
>> with all the inserts statements
>>
>> here, all fine
>>
>> but
>> how i can do this?
>
> Have a look at the 'mysqldump' command line utility.
> It goes something like 'mysqldump -u <user> -p <password> -h <host>
> <database> [<table>] > output.sql'.
> This will generate a text file with SQL statements that you can use to
> recreate the table.
>
> See http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html.
>
>> for each insert statement generated in A.sql
>> create a new B.sql, with update statements
>>
>> its possible do this?
>
> You could do this by editting the 'output.sql' file, changing the table
> name from A to B.
> Or you could execute the following SQL: 'CREATE TABLE B SELECT * FROM
> A'.
>
> See http://dev.mysql.com/doc/refman/5.0/en/create-table.html.
>
>> even worst, if a have a table with 20 columns
>> i need the way to generate the same B.sql
>> but with my desired columns to update
>
> I am not sure I understand your question, but you could make a database
> export using 'mysqldump', then alter the statements in the resulting
> output file to create the tables you need...
>
>
> HTH,
>
> Martijn
>
> --
> The information contained in this communication and any attachments is
> confidential and may be privileged, and is for the sole use of the
> intended recipient(s). Any unauthorized review, use, disclosure or
> distribution is prohibited. Unless explicitly stated otherwise in the
> body of this communication or the attachment thereto (if any), the
> information is provided on an AS-IS basis without any express or implied
> warranties or liabilities. To the extent you are relying on this
> information, you are doing so at your own risk. If you are not the
> intended recipient, please notify the sender immediately by replying to
> this message and destroy all copies of this message and any attachments.
> ASML is neither liable for the proper and complete transmission of the
> information contained in this communication, nor for any delay in its
> receipt.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=listsnabble.com
>
>
>

--
View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16524400.html
Sent from the MySQL - General mailing list archive at Nabble.com.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]