DROP TABLE IF EXISTS studentTest;

    DROP TABLE IF EXISTS exercice1;

    CREATE TABLE studentTest (

      id int(10) DEFAULT '0' NOT NULL auto_increment,
      login char(40) DEFAULT '' NOT NULL,

      surname char(40) DEFAULT '' NOT NULL,

      first_name char(40) DEFAULT '' NOT NULL,
      password char(40) DEFAULT '' NOT NULL,

      PRIMARY KEY (id)

    );

    

    INSERT INTO studentTest VALUES (NULL,'Lihua','Li','Hua','hhuuaa');

    INSERT INTO studentTest VALUES (NULL,'Wangli','Wang','Lili','lili');

    INSERT INTO studentTest VALUES (NULL,'Liuso','Liu','Sophie','lulu');