f
i've detected a table to see if its existed or not. If not, it will automatically create, but the problem is. Only UserData table created, VehicleData didnt create. need some help
f
Those "easy" sql scripts should just be burned in a fire. They make things slower and less straightforward and most of the time they don't even provide support for the things that make SQL powerful, such a grouping and joins. DDL statements (Data Definition Language, such as
CREATE
,
ALTER
) also shouldn't appear in code unless it is an update script that is specifically designed for that purpose and that is only run once. Your database creation script should be a separate
.sql
file that you can execute against your database once. Any updates to the model should also be placed into separate
.sql
so the entire model can be reconstructed by executing each file in order. All the SQL features that these "easy" scripts provide can be learned in a few hours so you might as well do that. Special mention for the fake scope resolution operator,
::
. If a library uses that, it's probably not good.
3 Views