Hello.
I have a question to ask.
First of all
There is a function to take a test in the program I'm making.
You can take the test several times.
And I'd like to save the test scores in the database with the date of the test.
(I want to use these data to generate statistics and graph them.)
But I don't know much about the DVD
The date is datetime, string, or the score should be saved using int!
When you save this, don't overwrite it and save it.
|Date | Score|
|0401 | 60| --------------------------- The way I did... Only one date and score are saved.
I'm not sure which technology(?) will be saved next time. (I'm embarrassed.))
|Date | Score|
|0401 | 60 |
|0402 | 70 | ----------------- This is how it goes...
I thought it would be a nuisance to ask you how to do it.
I just want to know if it's dusty to do that.
Please!
Oh, for your information, membership information, date and score are saved in one table.
(By any chance...) Should we make a separate table and go to the form where the table is biting the table?)
mysql
Are you talking about the query INSERT syntax?
insert into [table name] ([column name 1], [column name 2], ...) values ([column name 1 data], [column name 2 data], ...);
I think you mean the phrase UPDATE.
If you are not sure about the above answer, you can easily find the answer by searching mysqlinsert.
I think the questioner used an update statement in the query.Like this...
update [table name] set [Properties] = [Properties]
You must use the insert statement to add data.
insert into [table name] ([column],[column]...) values ([value to put],[value to put]...)
Note that the column name must match the order of the values to be inserted. The first column you enter contains the first value you enter.
© 2024 OneMinuteCode. All rights reserved.