/* create table */
CREATE TABLE myTable (
    id TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, /* unsigned allows only positive integers */
    col1 VARCHAR(20) not null,
    col2 VARCHAR(35) null default '', /* set the default value to an empty string */
    col3 INT NOT NULL
    FOREIGN KEY(col3) REFERENCES myOtherTable(id)
) ENGINE=innodb, DEFAULT CHARSET=utf8;

/* drop table */
DROP TABLE IF EXISTS myTable;

/* reset auto increment */
ALTER TABLE myTable AUTO_INCREMENT = 1

/* delete  from table */
DELETE FROM myTable / TRUNCATE myTable
DELETE FROM myTable WHERE id = 1

/* modify foreign key */
ALTER TABLE myTable
DROP FOREIGN KEY fkName;  

ALTER TABLE myTable
ADD CONSTRAINT fkName
    FOREIGN KEY (myTableField) REFERENCES anotherTable(anotherTablePrimaryKeyField) ON DELETE CASCADE ON UPDATE CASCADE;