مای‌اسکیول

Webhook (فرم ارسال شد) → MySQL (Insert)
  - Table: contacts
  - Columns: name, email, phone, message
  - Values:
    name = {{$json.name}}
    email = {{$json.email}}
    phone = {{$json.phone}}
    message = {{$json.message}}

Schedule (هر 10 دقیقه)
  → MySQL (Execute Query)
    SELECT o.*, c.name as customer_name
    FROM orders o
    JOIN customers c ON o.customer_id = c.id
    WHERE o.status = 'new'
    ORDER BY o.created_at DESC
    LIMIT 10
  → IF (تعداد > 0)
    → Telegram (ارسال لیست سفارشات)

Webhook (فروش جدید)
  → MySQL (Execute Query)
    UPDATE products
    SET stock = stock - {{$json.quantity}}
    WHERE id = {{$json.product_id}}
    AND stock >= {{$json.quantity}}
  → IF (affectedRows > 0)
    → True: تایید فروش
    → False: پیام "موجودی کافی نیست"

Schedule (هر روز ساعت 23:00)
  → MySQL (Execute Query)
    SELECT
      COUNT(*) as total_orders,
      SUM(amount) as total_sales,
      AVG(amount) as avg_order,
      MAX(amount) as max_order
    FROM orders
    WHERE DATE(created_at) = CURDATE()
  → Set (فرمت فارسی)
  → Telegram (ارسال گزارش)

Schedule (هر ساعت)
  → MySQL (Execute Query)
    SELECT * FROM users
    WHERE synced_to_crm = 0
    LIMIT 50
  → Loop
    → HTTP Request (POST به CRM API)
    → MySQL (Update)
      SET synced_to_crm = 1
      WHERE id = {{$json.id}}

Schedule (هر هفته)
  → MySQL (Execute Query)
    DELETE FROM activity_logs
    WHERE created_at < DATE_SUB(NOW(), INTERVAL 90 DAY)
  → Telegram (گزارش حذف)

Webhook (درخواست جستجو)
  → MySQL (Execute Query)
    SELECT * FROM products
    WHERE name LIKE '%{{$json.keyword}}%'
    AND category = '{{$json.category}}'
    AND price BETWEEN {{$json.min_price}} AND {{$json.max_price}}
    ORDER BY {{$json.sort}} {{$json.order}}
    LIMIT {{$json.limit}} OFFSET {{$json.offset}}
  → Respond to Webhook (نتایج JSON)

Schedule (هر روز ساعت 2 شب)
  → MySQL (Execute Query)
    SELECT * FROM customers
  → Google Sheets (Append)
    - Spreadsheet: Backup_Customers
    - Sheet: {{$now.toFormat('yyyy-MM-dd')}}

Schedule (هر 6 ساعت)
  → MySQL (Execute Query)
    SELECT name, stock, min_stock
    FROM products
    WHERE stock <= min_stock
    AND stock > 0
  → IF (نتایج > 0)
    → Telegram (هشدار به ادمین)
    → Gmail (ایمیل به انبار)

MySQL-Old (Select All)
  → Set (تبدیل فرمت)
  → MySQL-New (Insert)

-- اشتباه (خطرناک):
   SELECT * FROM users WHERE email = '{{$json.email}}'

   -- صحیح (امن):
   -- از پارامتر ? استفاده کنید (n8n خودکار escape می‌کند)
   SELECT * FROM users WHERE email = ?

SELECT * FROM logs ORDER BY id DESC LIMIT 100

START TRANSACTION;
   UPDATE accounts SET balance = balance - 50000 WHERE id = 1;
   UPDATE accounts SET balance = balance + 50000 WHERE id = 2;
   COMMIT;

INSERT INTO products (name, price) VALUES
   ('محصول 1', 10000),
   ('محصول 2', 20000),
   ('محصول 3', 30000);

-- امروز
   WHERE DATE(created_at) = CURDATE()

   -- 7 روز اخیر
   WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)

   -- این ماه
   WHERE MONTH(created_at) = MONTH(NOW())
   AND YEAR(created_at) = YEAR(NOW())

SELECT
     category,
     COUNT(*) as count,
     SUM(amount) as total,
     AVG(amount) as average,
     MIN(amount) as minimum,
     MAX(amount) as maximum
   FROM orders
   GROUP BY category
   HAVING total > 1000000
   ORDER BY total DESC

SELECT o.id, o.amount, c.name, c.email
   FROM orders o
   INNER JOIN customers c ON o.customer_id = c.id
   LEFT JOIN products p ON o.product_id = p.id
   WHERE o.status = 'completed'

CREATE INDEX idx_email ON users(email);
   CREATE INDEX idx_status_date ON orders(status, created_at);

INSERT INTO stats (date, visits)
   VALUES (CURDATE(), 1)
   ON DUPLICATE KEY UPDATE visits = visits + 1;

SELECT * FROM products
    WHERE category_id IN (
      SELECT id FROM categories WHERE active = 1
    )

SELECT name,
      CASE
        WHEN stock > 100 THEN 'فراوان'
        WHEN stock > 10 THEN 'محدود'
        ELSE 'تمام شده'
      END as status
    FROM products

SELECT
      name,
      FORMAT(price / 10, 0) as price_toman
    FROM products

SELECT * FROM orders
    INTO OUTFILE '/tmp/orders_backup.csv'
    FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n'

// تعداد رکوردهای تغییر یافته
    {{$json.affectedRows}}

    // آخرین ID درج شده
    {{$json.insertId}}

    // فیلد خاص از نتیجه
    {{$json.name}}

# /etc/mysql/mysql.conf.d/mysqld.cnf
  bind-address = 0.0.0.0  # اجازه اتصال از همه IPها

SHOW GRANTS FOR 'n8n_user'@'%';

CREATE USER 'n8n_user'@'%' IDENTIFIED BY 'password';

SHOW DATABASES;

SHOW TABLES;

ALTER TABLE my_table MODIFY COLUMN description TEXT;

INSERT INTO users (email, name) VALUES ('ali@test.com', 'Ali')
  ON DUPLICATE KEY UPDATE name = VALUES(name);

CREATE INDEX idx_created_at ON orders(created_at);

EXPLAIN SELECT * FROM orders WHERE status = 'new';