14.04.2015, 16:32
Confirmed, I just tried to create an empty table and it wouldn't let me (Navicat).
Also, if there isn't any record in your table (even if all your fields are present and have the proper data like int or float or varchar), update won't do anything and your update query will fail as well.
You can't update a line that doesn't exist.
You'll have to add all the proper columns (fields) to your table first, then add at least one row of data into your table.
After that, your update query should work.
But since your query doesn't have a WHERE clause, having more than one row in your table will update ALL rows at once because the WHERE clause is used to state which row to update.
No WHERE clause = all rows at once.
If you only plan to have one row, it won't matter.
Also, if there isn't any record in your table (even if all your fields are present and have the proper data like int or float or varchar), update won't do anything and your update query will fail as well.
You can't update a line that doesn't exist.
You'll have to add all the proper columns (fields) to your table first, then add at least one row of data into your table.
After that, your update query should work.
But since your query doesn't have a WHERE clause, having more than one row in your table will update ALL rows at once because the WHERE clause is used to state which row to update.
No WHERE clause = all rows at once.
If you only plan to have one row, it won't matter.