CREATE DATABASE cm_devices; USE cm_devices; CREATE TABLE devices (deviceID int, deviceName varchar(50), price decimal); SHOW tables;
SHOW columns FROM devices;