Laurent* Posted February 27, 2018 Share Posted February 27, 2018 Hey, I need to create a database and tables. I'm using phpmyadmin to do this. According to the professor's Power point slides the code below should create a table however it got me an error. I don't know how to think about this yet so go easy on me please. CREATE TABLE zodiacsigns (Sign VARIABLES(10), President VARIABLES(75)); Quote Error Static analysis: 2 errors were found during analysis. Unrecognized data type. (near "VARIABLES" at position 31) Unrecognized data type. (near "VARIABLES" at position 56) SQL query: CREATE TABLE zodiacsigns (Sign VARIABLES(10), President VARIABLES(75)) MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARIABLES(10), President VARIABLES(75))' at line 1 Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now