CREATE TABLE users( id SMALLINT UNSIGNED...-慕课网

                        课程
                    
                        /数据库
                        
                            /MySQL
                        
                        /与MySQL的零距离接触

CREATE TABLE users( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, username VARCHAR(10) NOT NULL, pid SMALLINT UNSIGNED, FOREIGN (pid) REFERENCES provinces (id) ON DELETE CASCADE );