Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: dr_pompeii (dr_pompeiiyahoo.com)
Date: Sun Apr 06 2008 - 08:53:00 CDT
thanks so much for your reply
pls read this carefully
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:
>> 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
>> 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
> 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...
> 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
> 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