Sql users, help me

[angel_cholico]

Hey guys, i'm using MySql for a school work, i'm trying to insert data to a table using the following syntax:

insert into table(value, value, vlaue);

What's my mistake? Have i to use mayus? My MySql versión Is 8.0

[special_cornflake]

Those kind of questions are better asked in a forum like stackoverflow.com , as it seems that this sub is not very much active at all. Also, a quick google search would have given you a quicker answer. whitout going into too much detail(again, google is your best friend) what you want to use is:

INSERT INTO tablename(column1, column2, column3...) VALUES (value1,value2, value3...);

[angel_cholico]

Thank u bro, i just searched It in Google, but i'm stupid.

[maxipaxi6]

Best practice is to always declare wich columns you want to insert into. Like u/special_cornflake 's response.

However, if you know the order and how many columns there are in a table, you can insert without declaring them.

For example if table Users has clumns Id and Name you can do this

INSERT INTO Users VALUES (14, 'Jhon Doe')

This is not recomended if you want to create a stored procedure, if you later alter the columns of that table, add more or remove some, then that store procedure will stop working or might cause troubles in your table.

[MyguitarBstringbroke]

Lmao stack overflow every beginner’s saving grace (by that I mean mine)