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

1

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.

answered Aug 5, 2010 at 13:58

Siege898

4634 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

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

1

Not that I'm aware of.

answered Aug 5, 2010 at 13:54

Flakron Bytyqi

3,26422 silver badges20 bronze badges

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

0

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

answered Aug 5, 2010 at 13:58

Codler

11.3k6 gold badges55 silver badges66 bronze badges