Join MySQL

  1. Home
  2. MySQL
  3. Join
  4. Qualify the table name with database name
CREATE TABLE CITIES(
       CITYNO      INTEGER NOT NULL PRIMARY KEY,
       CITYNAME    CHAR(20) NOT NULL);
INSERT INTO CITIES VALUES(1, 'Stratford');
INSERT INTO CITIES VALUES(2, 'Inglewood');
SELECT   *
FROM     EXTRA.CITIES;
drop table cities;