so to work around that i have to put either "insert" or "into" in underline or bold so that the 2 strings are not together.
Here's what i wanted to say.
Code: Select all
create table t(id int auto_increment primary key);
To my surprise it lets me do it...inserting empty set into table which is awesome.
This is used for when for example you want to have multi tables that are classified as the same object, for example company, business, and person all can be taxpayer, but if company, business and person have completely different information details (not sharing any fields, obviously if they shared things like name, then name could be put in taxpayer table...but as an example when taxpayer has no columns other than the fact that it's a taxpayer with taxpayerid referenced in company,business and person then you can just add taxpayerid as primary key auto_increment in taxpayer table and make the other tables reference taxpayer(taxpayerid), then you can make it so that if you ever update or delete taxpayer it deletes company,business, or person entities automatically.
I thought that was cool to find out (adding empty set just adds an auto_increment id to table).
I still want an opportunity to implement this in real life situations however i think it's rare because usually you have some common information that you put in taxpayer table (ie. phonenumber, address since company, business and person most likely will have these information).