-- create a table
CREATE TABLE Reservation (
      ID INT,
    Name VARCHAR(30),
    ReserveDate DATE,
    RoomNum INT
);

ALTER TABLE Reservation
MODIFY COLUMN RoomNum FLOAT;

INSERT INTO Reservation(ID, Name, ReserveDate, RoomNum)
VALUES(5, '이순신', '2016-02-16', 1108);

SELECT * FROM Reservation;

DESCRIBE Reservation;