Table to SQL Insert Statement Generator
Generate realistic mock/dummy data INSERT statements directly from a SQL CREATE TABLE schema query. Auto-parse column names, detect SQL types, and configure bulk outputs client-side.
Generator Options
SQL CREATE TABLE Schema Query
Define table structureParsed Database Schema Fields
-- SQL INSERT Statements Generated by ToolKH
-- Source: Mock Data generated from CREATE TABLE schema
-- Dialect: MYSQL
-- Generated Date: 2026-09-17
-- CREATE TABLE Schema Script
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
full_name VARCHAR(100) NOT NULL,
email VARCHAR(150),
salary DECIMAL(10, 2),
is_active BOOLEAN DEFAULT TRUE,
joined_date DATE
);
START TRANSACTION;
INSERT INTO `employees` (`emp_id`, `full_name`, `email`, `salary`, `is_active`, `joined_date`) VALUES
(101, 'Sok Dara', 'sok.dara@example.com', 875.5, true, '2026-01-15'),
(102, 'Chan Sophea', 'chan.sophea@example.kh', 1025.5, false, '2026-01-20'),
(103, 'Keo Nary', 'keo.nary@company.com', 1175.5, true, '2026-01-25'),
(104, 'Lim Bunna', 'lim.bunna@toolkh.org', 1325.5, false, '2026-01-30'),
(105, 'Mary Smith', 'mary.smith@db.net', 1475.5, true, '2026-02-04'),
(106, 'John Doe', 'john.doe@example.com', 1625.5, false, '2026-02-09'),
(107, 'Jane Smith', 'jane.smith@example.kh', 1775.5, true, '2026-02-14'),
(108, 'David Miller', 'david.miller@company.com', 1925.5, false, '2026-02-19'),
(109, 'Michael Brown', 'michael.brown@toolkh.org', 2075.5, true, '2026-02-24'),
(110, 'Emily Davis', 'emily.davis@db.net', 2225.5, false, '2026-03-01');
COMMIT;Related ToolsData
Discover other free online tools to boost your productivity
SQL to Table Diagram Visualizer
Instantly convert raw CREATE TABLE SQL scripts into interactive, draggable database schema diagrams. Visualize foreign key relations, inspect data types, and export as JPG or PDF.
Data Formatter
Format and convert CSV, TSV, TXT, or Excel tabular spreadsheet copy-pastes into other clean data layouts. Output structure-mapped SQL INSERT statements, beautified JSON arrays, Markdown documentation tables, or clean CSV sheets.
Date Time Splitter
Free online Date & Time Splitter. Instantly separate combined date-time values into individual Date and Time columns. Supports ISO 8601, ordinal dates (1st, 2nd, 3rd), MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, 12-hour AM/PM, 24-hour formats, bulk list processing up to 50 rows, and CSV export. 100% client-side, no login required.
Khmer Font Converter (Limon โ Unicode)
Convert legacy Khmer fonts (Limon S1/S2/F1/F2, ABC Khmer, Kbach) to standard Khmer Unicode and back in real time. Features automatic pre-vowel reordering, subscript coeng alignment, Khmer digits to Arabic numerals converter, live font preview options (Kantumruy Pro, Battambang, Moul), keystroke mapping reference, and bilingual UI (English & Khmer).
Save this tool to your Favorites
Sign in with Google to bookmark tools and access them quickly from your Favorites tab.
Help us improve Table to SQL Insert Converter!
Found a bug, want a new option, or have suggestions for Khmer Unicode formatting? Share your comments and help us improve.
Discussion
0Join the discussion
Sign in to leave feedback, ask questions, or report bugs. Your input helps improve this tool!
No comments yet. Be the first to share your thoughts!
