The intent is to have an auto_increment composite primary key on a InnoDB table which mimics the behavior as on a MyISAM table. The following assumes (3) InnoDB tables all with an auto_increment composite primary key (id incrementing and a_id not incrementing). Please comment positively or nega...

I have 2 tables one is passengers and second is driver but am confuse how to make one login page for both users, i can not write stored procedure of login for both tables. ALTER PROC [dbo].[SP_SELECT_Login1] @Email As varchar(50), @Password As varchar(50) As BEGIN SELECT Reg_id,Fname from reg wh...