Mega Code Archive

 

Categories / MySQL / Join

 

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;