Sql Guide Development Tutorials, Guides & Insights

• START TRANSACTION: Begins a new transaction.
• COMMIT: Saves the changes made in the transaction permanently.
• ROLLBACK: Reverts the changes made in the transaction.

START TRANSACTION;

INSERT INTO accounts (user_id, balance) VALUES (1, 100);

UPDATE accounts SET balance = balance - 50 WHERE user_id = 1;

COMMIT;

To identify the largest table in terms of size within a specific database, use a similar query but without the grouping. Instead, order by size and limit the result to find the largest table:

SELECT table_name AS "Table",
       ROUND((data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY (data_length + index_length) DESC
LIMIT 1;