Jump to content
Sigmahokies

Create new table will have relationship to prime table automatically

Recommended Posts

Hi everyone,

I know how to create new table by PHP, but I don't know how to have relationship to prime table such as account or register table once a new table is insert. Can you please show me how to do that? I know how to create new table, but my point is once table is insert in phpmyadmin, then have relationship connect to prime table. If you are not sure, I will explain more about this. 

Thanks,

Gary

Share this post


Link to post
Share on other sites

Actually, I am using MySQL (MariaDB), All right I will try this, I will come back to comment if I have something wrong or question.

Thanks,

Gary

Share this post


Link to post
Share on other sites

I'm talking about the storage engine used for the tables.  InnoDB supports foreign keys, MyISAM does not.  Your MySQL tables are probably using one of them, only InnoDB will enforce those constraints.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×