　

SQL文作成補助ツール

INSERT
SELECT
UPDATE
DELETE
CREATE DATABASE
CREATE TABLE
ADD COUMN

INSERT

データ投入サンプル - Node.js

const mysql = require('mysql2/promise'); const pool = mysql.createPool({ host: 'localhost', user: 'root', database: 'sample', password: 'password', }); (async () => { try { for(let i = 0; i < 30; i++){ await pool.query('INSERT INTO users (name, age) VALUES (?, ?);', ["taro" + i, i] ); } } catch (err) { console.log(err); } pool.end(); })();

SELECT

UPDATE

DELETE

CREATE DATABASE

CREATE TABLE

CREATE TABLE users ( id INT AUTO_INCREMENT, name VARCHAR(255) NOT NULL, age INT NULL, PRIMARY KEY (id) );

ADD COLUMNS

ALTER TABLE users ADD ( address text null, tell int null );