Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
möp
#MySQL 5.7.12 #please drop objects you've created at the end of the script #or check for their existance before creating #'\\' is a delimiter CREATE TABLE Dummkopp(Personenid INTEGER PRIMARY KEY, name VARCHAR(255) ,strasse VARCHAR(255), hausnummer INTEGER, wohnort VARCHAR(255), geburtstag DATE); INSERT INTO Dummkopp VALUES('1', 'natascha', 'deutsche Strasse', '19', 'ludwigshafen', '1988.04.17'); INSERT INTO Dummkopp VALUES('2', 'sven', 'kirchen strasse', '16', 'mannheim', '1989.10.08'); INSERT INTO Dummkopp VALUES('3', 'Simone', 'schwanthaler Allee', '7', 'ludwigshafen', '1987.06.22'); INSERT INTO Dummkopp VALUES('4', 'Molla', 'Room strasse', '3', 'ludwigshafen', '1989.04.28'); INSERT INTO Dummkopp VALUES('5', 'trölf', 'Peter strasse', '16', 'mannheim', '2001.10.01'); INSERT INTO Dummkopp VALUES('6', 'Huan Son', 'corona strasse', '16', 'mannheim', '1989.10.08'); SELECT * FROM DUMMKOPP;
run
|
edit
|
history
|
help
0
order_history
gandu
test 2
Rakibul Haque
emp
Employee
calculate avareages for students and levels
test
MySQL JSON_SEARCH boolean Issue
ITM_14210069