Database walk through
Best Answer
-
peregrine MVP
In PhpMyadmin to view the column format in the
GDN_Discussion
click on the vanilla database.
then click on GDN_Discussion
then click on browse.
it will show you the whole table.you could go in to sql (top center button) click it and enter your command.
e.g. view a single column for the firs 500 entries.SELECT
Format
FROMGDN_Discussion
Limit 500;I believe there is a phpmyadmin
looked like a video and a bunch of sites.
the best way to learn is create a databases and play with the command.
The update command would change things.
But you better back up your database before you play with the live vanilla (there is an export button).I suggest you read the tutorial
http://www.w3schools.com/sql/default.asphttp://vanillawiki.homebrewforums.net/index.php/Database_&_Query_Building
http://vanillawiki.homebrewforums.net/index.php/Database_Objects
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
1
Answers
what do you want to know? That's a pretty broad question.
http://www.w3schools.com/sql/default.asp
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Todd states something about changing the values in GDN_Discussion and GDN_Comments to "BBCode", I was wondering how to do that with phpMyAdmin, because I can't find the values. (It's Todd's 2nd comment, part 2)
Lol, I'm still working on being more descriptive
In PhpMyadmin to view the column format in the
GDN_Discussion
click on the vanilla database.
then click on GDN_Discussion
then click on browse.
it will show you the whole table.
you could go in to sql (top center button) click it and enter your command.
e.g. view a single column for the firs 500 entries.
SELECT
Format
FROMGDN_Discussion
Limit 500;I believe there is a phpmyadmin
tutorial
looked like a video and a bunch of sites.
the best way to learn is create a databases and play with the command.
The update command would change things.
But you better back up your database before you play with the live vanilla (there is an export button).
I suggest you read the tutorial
http://www.w3schools.com/sql/default.asp
http://vanillawiki.homebrewforums.net/index.php/Database_&_Query_Building
http://vanillawiki.homebrewforums.net/index.php/Database_Objects
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.