MySQL Bulk Insert Generator (Datetime & Boolean Fixes)

Why MySQL Developers Choose MockBlast

MySQL has specific datetime and boolean requirements that can break imports if your mock data isn't formatted correctly. MockBlast handles these automatically:

MySQL-Specific Features

MockBlast understands MySQL's unique data types and constraints:

• •DATETIME & TIMESTAMP: Generates valid MySQL datetime values with proper formatting.
• •TINYINT(1) Booleans: Correct boolean representation (0/1) for MySQL.
• •AUTO_INCREMENT: Sequential ID generation that matches MySQL behavior.
• •VARCHAR & TEXT: Proper string escaping for MySQL INSERT statements.
• •ENUM Types: Support for MySQL ENUM columns with predefined values.
• •Foreign Keys: Maintains referential integrity across InnoDB tables.

Example: MySQL Schema with Datetime and Booleans

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(100) UNIQUE NOT NULL,
  is_active TINYINT(1) DEFAULT 1,
  email_verified TINYINT(1) DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB;

CREATE TABLE orders (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT,
  total DECIMAL(10, 2),
  is_paid TINYINT(1) DEFAULT 0,
  order_date DATETIME,
  FOREIGN KEY (user_id) REFERENCES users(id)
) ENGINE=InnoDB;

INSERT INTO users (id, name, email, is_active, email_verified, created_at, updated_at) VALUES
  (1, 'John Doe', 'john@example.com', 1, 1, '2024-01-15 10:30:00', '2024-01-15 10:30:00'),
  (2, 'Jane Smith', 'jane@example.com', 1, 0, '2024-01-16 14:20:00', '2024-01-16 14:20:00'),
  (3, 'Bob Johnson', 'bob@example.com', 0, 1, '2024-01-17 08:15:00', '2024-01-17 08:15:00');

INSERT INTO orders (id, user_id, total, is_paid, order_date) VALUES
  (1, 1, 149.99, 1, '2024-01-18 09:30:00'),
  (2, 1, 299.99, 0, '2024-01-19 15:45:00'),
  (3, 2, 79.99, 1, '2024-01-20 11:20:00');

Common MySQL Use Cases

How to Generate MySQL Mock Data

1. 1.
   Import Your Schema: Paste your MySQL CREATE TABLE statement into MockBlast. We'll parse all MySQL-specific types automatically.
2. 2.
   Configure Data Types: MockBlast automatically infers types from column names and SQL types. Adjust as needed for datetime, boolean, or enum columns.
3. 3.
   Set Row Count: Choose how many rows to generate. MockBlast handles everything from 10 rows to 1 million+.
4. 4.
   Download SQL: Get MySQL-compatible bulk INSERT statements ready to run. Copy and paste directly into MySQL Workbench or your migration scripts.