MYSQL : Create table

mysql>use <database>;
-- Selecting database

mysql>create table expenseinfo(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
item VARCHAR(100),
amount DECIMAL(5,2)
);

-- table creation script