Is it posisible that some of the infos in the database are empty before saving it ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Is it posisible that some of the infos in the database are empty before saving it ?

If its possible..How will I do that ? Someone help me. Please.

5th Nov 2016, 6:41 AM
JauJau
JauJau - avatar
3 Answers
+ 1
yes it can be. While creating your table you need to specify the default value for the fields or you can simply set it to null
5th Nov 2016, 9:23 AM
Haresh Suralkar
Haresh Suralkar - avatar
+ 1
you can use second form to insert data in table which specifies both the column names and the values to be inserted: INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...); provide only those columns which you want to save data & their values. remaining will be saved as per their default values as specified or set to null by default
5th Nov 2016, 9:58 AM
Haresh Suralkar
Haresh Suralkar - avatar
0
But is it possible to save a program with an incomplete data to mysql database. Specially from netbeans.
5th Nov 2016, 9:38 AM
JauJau
JauJau - avatar