MySQL Basics
Basic SQL (Standard Query Language) for use with MySQL[www.mysql.com].
MySQL:
MySQL is an open source Relational Database Management System (RDBMS).
MySQL Database Table Basics
Last updated at 01:22 AM on Monday 27th August, 2007 by Administrator
Inputting data with INSERT[dev.mysql.com].
INSERT INTO table (id, name)
VALUES (1, 'George'), (2, 'Fred')
Data retrieval with SELECT[dev.mysql.com].
SELECT id, name FROM table
ORDER BY id
Changing existing data with UPDATE[dev.mysql.com].
UPDATE table
SET name='Thomas'
WHERE id=2
Removing existing data with DELETE[dev.mysql.com].
DELETE FROM table
WHERE id=1
Comments (0)