Mysql insert query

Question

With Mysql tables like

table_main id firstname lastname table_type id table_main_id table_type_id table_type id typename

can a single sql insert query be contructed to run once with

fields: firstname, lastname, typename values: john,doe,mytypename

Siege898 · Accepted Answer · 2010-08-05 13:58:53Z

INSERT INTO table_name (firstname, lastname, typename) VALUES (john, doe, mytypename)

won't work because you're trying to insert into multiple tables at once.

My suggestion would be to make a stored procedure that takes arguments firstname, lastname, and typename and then does the proper inserts.

Flakron Bytyqi · Accepted Answer · 2010-08-05 13:54:48Z

1

Not that I'm aware of.

answered Aug 5, 2010 at 13:54

3,26422 silver badges20 bronze badges

Comments

Codler · Accepted Answer · 2010-08-05 13:58:51Z

Nope, but you can create a procedure and then call with it.