Hi Guys, am currently studying Kevin Yank's Book; "Build Your Own DataBase Driven Website using PHP. My question is; how do I type vertical ellipsis while creating databases in MYSQL? Please help!
It's not actual syntax, it's just the author's way to say "do the same with all the other columns"... the same as it's used in natural language
mysql> CREATE TABLE table_name (
-> column1Name column1Type column1Details,
-> column2Name column2Type column2Details,
-> ) DEFAULT CHARACTER SET charset;
This is just an example showing you the general syntax for a CREATE TABLE statement. The syntax isn't valid, because you need to replace column1Type and column1Details with actual SQL definitions. Look on the next page and you'll see an actual example:
mysql> CREATE TABLE joke (
-> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> joketext TEXT,
-> jokedate DATE NOT NULL
-> ) DEFAULT CHARACTER SET utf8;
The vertical ellipsis are on page 61 (under the Topic: Creating A Table) of Kevin Yank's Book: "how to build your own database driven website using php and mysql. I don't even know what to replace the vertical ellipsis with!
can you give the query where you saw the vertical ellipsis?
what you have to do is replace the vertical ellipsis with something else
the reason i asked you to show the query is because i don't have the book, but i'm pretty good with queries once i see what's going on...