Back

MySQL Basics

CREATE TABLE name (
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	first CHAR( 25 ),
	last CHAR( 25 )
);

INSERT INTO name ( first , last ) VALUES ( 'Syd' , 'Lawrence' );

SELECT * FROM name WHERE id = 1;

UPDATE name SET first = 'Syd' WHERE id = 1;

DELETE FROM name WHERE id = 1;

Back