Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE products ( Id INTEGER PRIMARY KEY AUTO_INCREMENT, name TEXT NOT NULL, description TEXT NOT NULL, price REAL NOT NULL ); Create table users ( id INTEGER PRIMARY KEY AUTO_INCREMENT, username TEXT NOT NULL, password TEXT NOT NULL, email TEXT NOT NULL, admin INTEGER NOT NULL DEFAULT 0 ); insert into users (username, password, email, admin) values ('admin', 'admin', 'admin@localhost', 1); INSERT INTO products (name, description, price) VALUES ('Prueba','Prueba',1000); SELECT CONCAT("hola", "Adios"); SELECT conv(hex((select username from users limit 1)), 16, 10); SELECT unhex(conv(418296719726, 10, 16)); SELECT CONCAT(SELECT length(username) FROM users LIMIT 1, SELECT length(password) FROM users LIMIT 1))

Stuck with a problem? Got Error? Ask AI support!

Copy Clear