+ 3

How am I supposed to leave a column while inserting mysql data?

I made a table and I want to skip entering data in one feild. How to do that?

12th Dec 2020, 12:57 PM
Allysia Morgenstern
Allysia Morgenstern - avatar
3 Respostas
+ 4
Insert into <table name> (column names ) values (values name);
12th Dec 2020, 1:05 PM
Sâñtôsh
Sâñtôsh - avatar
+ 3
specify column names in parentheses after table name in insert query. INSERT INTO tbl_name (col1,col2) VALUES(val1,val2); https://dev.mysql.com/doc/refman/8.0/en/insert.html
12th Dec 2020, 1:11 PM
🇮🇳Omkar🕉
🇮🇳Omkar🕉 - avatar
+ 2
It would also be nice if you add a default constraint for the column you want to skip on insertion; so system can give the column a default value when explicit value was not supplied on insert.
12th Dec 2020, 1:46 PM
Ipang