NathanFriend.co.uk

Developers notebook

Month: October 2009

Computer music, geeks only

MYSQL note book

Login to MYSQL client: mysql -uusername -p

Select datebase: use database name;

View all records in a  table: SELECT * FROM table name;

Delete a record: DELETE FROM table name WHERE field name=’value‘;

Add a record: INSERT INTO table name (field name 1, field name 2) VALUES (‘value 1‘, ‘value 2‘);

Update records where condition is met: UPDATE table name SET field name = ‘new value‘ WHERE condition field name = ‘condition value

© 2017 NathanFriend.co.uk

Theme by Anders NorenUp ↑