CompareMySQL_PGSQL
 
  • Drivers :
    • PostgreSQL:
      String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
       String user = "postgres"; String pwd = "postgre_manas9";
    • MySQL :
      String dbURL = "jdbc:mysql://localhost/test?";
      String user = "Manas9"; String pwd = "Manas9237";
       
  • SQL :: Create and Drop Table  :
    • MYSQL ::Create
      String sqlCreate = "create table mysqlVisitor1A(" + "idV1A int(3) NOT NULL PRIMARY KEY,"
      + "fname varchar(30)," + "lname varchar(30),"
      + "age int(2)NOT NULL"
      +") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
    • PostgreSQL ::Create
      String sqlCreate = "create table pgsVisitor1A" + "(id NUMERIC(3) CONSTRAINT PK_v1A PRIMARY KEY,"
      + "fname varchar(30)," + "lname varchar(30),"
      + "age numeric(2)) ";

       
    • MySQL :: Drop Table
      String sqldrop= "drop table if exists mysqlVisitor1A";
      String sqlQuery ="Select * from mysqlVisitor1A";
       
    • PostgreSQL Drop :: Query ALL columns
      String sqldrop= "drop table if exists pgsVisitor1A;";
      String sqlQuery ="Select * from pgsVisitor1A";
       
  • INSERT Statement :: MYSQL and PostGreSQL
    • String strInsert0 ="INSERT INTO mysqlVisitor1A values (101,'John', 'Doe', 40)";
    • String strInsert1="INSERT INTO mysqlVisitor1A values(102,'Peter', 'Pan', 44)";
    • String strInsert2 ="INSERT INTO mysqlVisitor1A values(103,'Jean', 'Zenis', 29)";
    • String strInsert3 ="INSERT INTO mysqlVisitor1A values(104,'Savita', 'Jha', 34)";
    • String [] strInsert = new String[]{strInsert1, strInsert2, strInsert3, strInsert0};
    • ---------
    •