$ip = "your IP-adress"; |
$user = "your username (loginname)"; |
$password = "your password"; |
$dataname = "the name of your database"; |
$tablename = "the name of your table"; |
mysql> CREATE TABLE test ( ->name VARCHAR(50), ->email VARCHAR(25), ->project VARCHAR(30), ->ID INT NOT NULL AUTO_INCREMENT, ->PRIMARY KEY(ID)); |