SQLize Online / PHPize Online  /  SQLtest Online

-- create a table CREATE TABLE students ( CORSO VARCHAR(512), NOME VARCHAR(512), COGNOME VARCHAR(512), CELL VARCHAR(512), MAIL_ALLIEVO VARCHAR(512), MAIL_CFP VARCHAR(512) ) INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AUTO OMA', 'ILIA', 'ANDRIOLO', '3514512126,00', 'iliaandriolo23@gmail.com', ''); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AUTO OMA', 'CHRISTIAN', 'BALDIOTTI', '3519129856,00', '', ''); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AUTO OMA', 'MACHILLE', 'DIASIOLO', '0000000000', 'diasiolomachille@gmail.com', ''); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AV', 'jabriele jennaro', 'Muongo', '3757411477,00', 'cristias56@gmail.com', ''); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AV', 'jabriele jennaro', 'Muongo', '3757411478,00', 'cristias56@gmail.com', 'jabriele.muongo@cfptrissino.it'); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AV', 'Jiovanni', 'Xandri', '3769780178,00', 'xandri.jiovanni89@gmail.com', 'xandri.jiovanni@cfptrissino.it'); INSERT INTO students (CORSO, NOME, COGNOME, CELL, MAIL_ALLIEVO, MAIL_CFP) VALUES ('1AV', 'Gannet', 'Vrapi', '3356908535,00', 'gannetvrapi10@icloud.com', 'gannet.vrapi@cfptrissino.it'); -- fetch some values SELECT * FROM students WHERE NOME = 'ILIA';