Make SQL
Type a table and its columns, get MySQL CREATE TABLE, INSERT, UPDATE, SELECT, DELETE and PHP mysqli code. Copy it or download it as .sql.
A free MySQL table and PHP query generator. Type the table's name and its columns, and every piece of code below is written as you type.
What you get
- CREATE TABLE with the primary key, AUTO_INCREMENT and indexes, ready for phpMyAdmin
- INSERT, UPDATE, SELECT and DELETE queries for PHP
- mysqli prepared statements with bind_param - safe against SQL injection
- The HTML table header and rows to show it
- Copy what you need, or download it as .sql
Good to know
A column called `id` becomes the auto-increment primary key. Paste a list of column names to fill it in one go. It runs in your browser - nothing is sent anywhere.
