MySQL Column wise Insert

Question

I am trying to create a calculation logic using MySQL tables. Data from two table is processed using a stored procedure and a set of values is generated. These values are part of a column of output table. I have to run different procedure to generate output for each column in output table

Now if I create insert query for each row it will have large number of inserts for each column. Can I insert a set of values into a table column in one go? assuming other columns can be NULL.

yes e.g. insert into tabA (name,roll) values ('aaa',12) ; and assuming that tabA has one more column school , school will have the value as NULL — Satya
– Satya, Commented May 3, 2012 at 12:44

Community · Accepted Answer · 2017-05-23 11:56:28Z

2

INSERT INTO tableName(columnName)
VALUES ('baz'),('foo'),('bar'),('baz'),('baz'),('baz'),('baz');

etc as u like..

See this: Bulk insert into table with one single query

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered May 3, 2012 at 12:51

nawfal

73.8k59 gold badges342 silver badges379 bronze badges

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

Comments

Shaikh Farooque · Accepted Answer · 2012-05-03 12:54:37Z

0

The insert can be done for one column rest can be NULL if remaining columns are nullable.

But next time for the remaining columns the Insert will not work for the existing rows. If You want to update the existing rows then you need to fire the update query.

Assuming col1 and col2 are nullable

If you want to insert in col1 keeping col2 null insert will work If you want to insert in col2 keeping col1 null insert will work

answered May 3, 2012 at 12:54

Shaikh Farooque

2,6402 gold badges22 silver badges36 bronze badges

Collectives™ on Stack Overflow

MySQL Column wise Insert

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related