Treehouse | Community | Creating a Table

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

Join the Treehouse affiliate program and earn 25% recurring commission!

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Miguel Nunez
3,266 Points
What situations are temporary Tables are used in SQL?

Posted November 14, 2016 2:34am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
Miguel Nunez
3,266 Points
Just curious can Unicode be used with other systems similar to UTF-8?

Posted November 13, 2016 5:33am by Miguel Nunez

Miguel Nunez
3,266 Points
0 Answers
Judy Mosley
11,910 Points
IF NOT EXISTS - Not working

Posted February 8, 2016 3:40pm by Judy Mosley

Judy Mosley
11,910 Points
3 Answers
Kent Drummond
8,309 Points
Help creating db

Posted February 2, 2016 7:34pm by Kent Drummond

Kent Drummond
8,309 Points
2 Answers
PLUS

Mayur Pande
Courses Plus Student 11,711 Points
How do I go about changing a column from NULL to NOT NULL?

Posted January 26, 2016 7:08pm by Mayur Pande

Mayur Pande
Courses Plus Student 11,711 Points
1 Answer
PLUS

Mayur Pande
Courses Plus Student 11,711 Points
Andrew says in this video that DDL modifies the schema.

Posted January 21, 2016 8:12pm by Mayur Pande

Mayur Pande
Courses Plus Student 11,711 Points
1 Answer
Alexander Nortung
6,930 Points
diffrence on schema and database?

Posted January 10, 2016 9:17pm by Alexander Nortung

Alexander Nortung
6,930 Points
2 Answers
Seth Warner
5,348 Points
@ 8:00 he says you can use the WHERE Claus or the ???? clause or LIMIT Claus to choose what you delete..what is after

Posted October 14, 2015 3:34am by Seth Warner

Seth Warner
5,348 Points
1 Answer
Seth Warner
5,348 Points
who determines what "engines" are available in that D.B.? The server? Work bench? Can you download more engines?

Posted October 13, 2015 6:38pm by Seth Warner

Seth Warner
5,348 Points
1 Answer
Anders Lund
3,061 Points
how to add column?

Posted September 27, 2015 3:23pm by Anders Lund

Anders Lund
3,061 Points
1 Answer
Alex Martino
367 Points
Problem with null and a column in SQL

Posted September 19, 2015 8:31pm by Alex Martino

Alex Martino
367 Points
2 Answers
pi R
12,720 Points
MySQL UPDATE and Wildcard doesn't works?

Posted September 16, 2015 5:28pm by pi R

pi R
12,720 Points
1 Answer
MUZ140886 Mandava
4,675 Points
task 1 no longer passing

Posted July 29, 2015 8:23am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
1 Answer
Daniel Sibanda
4,803 Points
Oops! It looks like Task 1 is no longer passing.

Posted July 27, 2015 8:53am by Daniel Sibanda

Daniel Sibanda
4,803 Points
1 Answer
MUZ140886 Mandava
4,675 Points
JUST CANT PASS

Posted July 24, 2015 10:34am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
0 Answers
MUZ140886 Mandava
4,675 Points
I THINK ITS A BUG

Posted July 24, 2015 9:11am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
1 Answer
MUZ140886 Mandava
4,675 Points
WHAT About this one

Posted July 24, 2015 8:32am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
2 Answers
MUZ140886 Mandava
4,675 Points
it looks like task 1 is no longer passing

Posted July 24, 2015 8:19am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
0 Answers
Zinaldo Park
15,469 Points
not working

Posted July 22, 2015 10:40pm by Zinaldo Park

Zinaldo Park
15,469 Points
0 Answers
MUZ140683 Viniel Munjeri
3,448 Points
Create a table called "products" with a VARCHAR column named "name", a TEXT column named "description" and a INTEGER "st

Posted July 16, 2015 1:53am by MUZ140683 Viniel Munjeri

MUZ140683 Viniel Munjeri
3,448 Points
1 Answer
MUZ141058 Loice Kajawu
3,364 Points
database foundations Update the SQL statement to include the keywords to make sure the server doesn't error if it alrea

Posted July 15, 2015 8:14am by MUZ141058 Loice Kajawu

MUZ141058 Loice Kajawu
3,364 Points
1 Answer
Pavle Lucic
10,801 Points
Read XML and creating columns

Posted July 7, 2015 9:53am by Pavle Lucic

Pavle Lucic
10,801 Points
1 Answer
muz141018susanmusonza
3,695 Points
I don't know where am lost

Posted July 2, 2015 10:59am by muz141018susanmusonza

muz141018susanmusonza
3,695 Points
1 Answer
PLUS

Ted Sumner
Courses Plus Student 17,967 Points
Table created but returns an error.

Posted June 29, 2015 3:30am by Ted Sumner

Ted Sumner
Courses Plus Student 17,967 Points
1 Answer
Tyler Brewer
1,871 Points
SQL Create Database Issue

Posted June 28, 2015 10:49pm by Tyler Brewer

Tyler Brewer
1,871 Points
1 Answer
Aaron Munoz
11,177 Points
Difference between a query and sql file.

Posted June 11, 2015 6:26pm by Aaron Munoz

Aaron Munoz
11,177 Points
2 Answers
jason chan
31,009 Points
So I found out I can do all lowercase with mysql workbench? is there benefits to write in all caps?

Posted June 6, 2015 5:13am by jason chan

jason chan
31,009 Points
6 Answers
sayedshahidi
9,158 Points
Why use if not exists ?

Posted May 31, 2015 2:16pm by sayedshahidi

sayedshahidi
9,158 Points
2 Answers
David Axelrod
36,073 Points
Creating a database code challenge, task#1

Posted May 24, 2015 10:05pm by David Axelrod

David Axelrod
36,073 Points
1 Answer
Igors Smirnovs
10,441 Points
Delete duplicates in MySQL

Posted April 7, 2015 1:27pm by Igors Smirnovs

Igors Smirnovs
10,441 Points
2 Answers

Prev Page 1 of 2 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.