MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.6.51


CREATE TABLE bus
(
  busno VARCHAR (10) PRIMARY KEY
);
create table reservation
(
  PNRno int(9) primary key, 
  journey_date DATE, no_of_seats int(8), 
  address varchar2 (50), 
  contact_no int, 
  busno varchar (10), 
  seat_no int(25)
);
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar2 (50), 
  contact_no int, 
  busno varchar (10), 
  seat_no int(25)
)' at line 5

  busno varchar (10) references bus(busno), 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'busno varchar (10) references bus(busno),' at line 1