SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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'; SELECT students.NOME, students.COGNOME, FROM students INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear