Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialPhyo Min Htun
Courses Plus Student 3,657 PointsDatabase Foundations Creating a Table
CREATE TABLE products (name VARCHAR(100), stock_count INTEGER, TEXT description);
Bummer! The column names were typed in incorrectly.
Can someone tell me pls what im doing wrong ?
5 Answers
John Paul Ashenfelter
1,118 PointsCREATE TABLE products (name VARCHAR(100), stock_count INTEGER, description TEXT);
You reversed the column name and data type in the last column definition.
Mobarak Hamdan
1,660 PointsI wrote
CREATE TABLE products (name VARCHAR(100), stock_count INTEGER, description TEXT);
it says: SQL Error: table products already exists
Emeka Onodugo
1,888 Pointsmobarakhamdan I get the same error do you know why that happened?
Emeka Onodugo
1,888 Pointsmobarakhamdan I get the same error do you know why that happened?
Ben Serviss
1,315 PointsI'm getting the same error - even when I copy in your code, CREATE TABLE products (name VARCHAR(100), stock_count INTEGER, description TEXT);, it still gives the same error:
SQL Error: table products already exists
Phyo Min Htun
Courses Plus Student 3,657 PointsPhyo Min Htun
Courses Plus Student 3,657 Pointsthanks ! i was confuse. now i got it thanks again (: