Qualify the table name with database name : Database Join « Join « SQL / MySQL






  1. SQL / MySQL
  2. Join
  3. Database 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;








Related examples in the same category

1.If the current database is database1 or database2, you can dispense with some of the qualifiers.
2.if the current database is database2, no database2 qualifiers are necessary
3.Qualify the column name with table name and database name