Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
double insert (MySQL)
DROP TABLE IF EXISTS TableA; DROP TABLE IF EXISTS TableB; CREATE TABLE TableA ( Row1 int, Row2 int ); CREATE TABLE TableB ( id serial NOT NULL, Row1 text, Row2 text, Row3 int, PRIMARY KEY (ID) ); INSERT INTO TableA (Row1, Row2) VALUES (10, 12); INSERT INTO TableB (Row1, Row2, Row3) VALUES ('Test', 'Second test', 12); SELECT * FROM TableA; SELECT * FROM TableB;
run
|
edit
|
history
|
help
0
ITM_14210069
barbato
mysql - having
How to run query to keep maximum 3 rows with the same name
Srinivas
sree..
rutujafulari
Adding a number
calculate avareages for students and levels
saikatd