UK Sales: 0800 035 6364 | sales@2020media.com | We'll Call You

Introduction to MySQL

This guide is intended to jog the memory about syntax of the basic commands, and not to act as a comprehensive reference.

The full documentation and information about MySQL can be found at http://dev.mysql.com/doc/, Alternatively, MySQL by Paul DuBois is a good reference (ISBN 0-7357-0921-1)

Connecting

Log into the server using SSH and then enter the command

mysql -u 'username' -p -h 'hostname'

where username and hostname are as provided on your account details letter. This will start a basic client that allows you to enter commands to manulipulate the database. To execute each command, type in the command and a terminating ';', for example'select * from test;'

Creating Tables

Basic Form

CREATE TABLE
(
Item 1,
Item 2,
Item 3
)

 

Example Items would be

an unsignednumber INT UNSIGNED NOT NULL,
a date DATE NOT NULL,
a string VARCHAR(200) NOT NULL,
an enumeration ENUM('T','F') NOT NULL,
an index INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY

Adding Values

Basic Form

INSERT INTO tablename VALUES (
columsitems
);

Example

INSERT INTO tablename VALUES ( 
'string', 345, 'T'
);

Selection

Basic Form:

SELECT * FROM tablename 
SELECT col1, col2,col3 FROM tablename
SELECT * FROM tablename WHERE expression
SELECT * FROM tablename ORDER BY col1 DESC;
SELECT * FROM tablename WHERE col2 LIKE 'W%'

Updating

UPDATE tablename SET col1='string'
UPDATE tablename SET col1 ='string' WHERE expression

Deleting Items (Rows)

Basic Form:

DELETE FROM tablename WHERE col1=expression

Adding Columns

ALTER TABLE tablename ADD col INT NOT NULL,

 

2020Media is a leading provider of small business Wi-Fi hotspots. If you want to offer free Wi-Fi to your customers or users, our service could be exactly what you are looking for. Our Hotspots are managed in the cloud, ultra-reliable and give you loads of information about behaviour patterns of your users. Read More   Read more...
2020Media introduces Moodle Hosting - UK servers and UK Moodle experts setup your site ready to use. Read more...
Special Offer for Longer Registration Periods Register or renew a .com, .net or .org domain name for 5 years we'll include 1 year free*. Read more...
2020Media is now offering zero-click installation of the popular TYPO3 content management system. Read more...

Our blog is regularly updated with news, tips and industry opinion.

Clients

  • AggieWestons
  • baker-and-mckenzie
  • arts-council-england
  • Big Finish
  • barratt-developments-logo
  • City-of-Lincoln-council-logo
  • brora-logo
  • DenisMacShane
  • Construction-Industry-Council
  • colchester