Letting MySQL Workbench create an insert statement for you

creating-insert-staement.PNG

<div>
Hi Guy Hengel,<br />
<br />
Can you provide the syntax to generate a insert statement.<br />
from the above mysql link i didn't get the point.how to generate insert statement.<br />
I dont know how to take a dump from the table as well.
</div>


<div>
The suggestions are not about code, but about to manually generate the statement.<br />
Please provide the background why you would want that be done from code?
</div>


<div>
By using my sql work bench we are getting sql insert statements From the existing records.<br />
if I have this insert statement I can change few of the values from that record I will inser New record.<br />
<br />
here problem is<br />
I am not using my sql work bench.<br />
I am connecting to my sql sever from the cmd prompt.<br />
<br />
is it possible to get the insert statement from the existing table or not?
</div>


<div>
No, not from the MySQL command line, this is a feature of the Workbench, not of MySQL itself.<br />
The workbench makes use of SHOW COLUMNS to know what to build up as insert command. I heard of no database or any language capable writing out the code leading to some data. It's executing code, not generating it. That's always done by toolings around a database or language.<br />
<br />
MySQLDump is indeed specialised on this, as it rather writes out the DDL and DML code to recreate a MySQL database and its data than export CSV, pure data, like other ETL tools do.<br />
<br />
Bye, Olaf.
</div>


<div>
and i think all you need to know is how to do this<br />
<br />
insert into yourtable ( colA, colB, colC, colD )<br />
select colA, colB, 456, 'abc'<br />
from yourtable<br />
where id = 987<br />
<br />
colA and colB would be copied, colC and ColD with different data
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a tabel called text,having 50 columns<br />
I have inserted one record to this table long back.<br />
if i want to see the same insert query how do i get from the table.
</div>
</div>


Hi Experts,

I have a tabel called text,having 50 columns
I have inserted one record to this table long back.
if i want to see the same insert query how do i get from the table.

How to get the insertquery from the table for a specific id in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.