add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.14
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
-- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `files` -- CREATE TABLE files ( idf int(11) NOT NULL, id_dir int(11) NOT NULL, id_type int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `files` -- INSERT INTO files (idf, id_dir, id_type) VALUES (3, 1, 2), (4, 1, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `files` -- ALTER TABLE files ADD PRIMARY KEY (idf), ADD KEY id_dir (id_dir), ADD KEY id_type (id_type); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `files` -- ALTER TABLE files MODIFY idf int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Constraints for dumped tables -- -- -- Constraints for table `files` -- ALTER TABLE files ADD CONSTRAINT files_ibfk_1 FOREIGN KEY (id_dir) REFERENCES directory (iddir), ADD CONSTRAINT files_ibfk_2 FOREIGN KEY (id_type) REFERENCES typef (idtype); COMMIT; SELECT * FROM directory AS d LEFT JOIN customers AS c ON d.idcust = c.id_cust LEFT JOIN files AS f ON d.idfile = f.idf LEFT JOIN typef AS t ON f.id_type = t.idtype