Shoutbox

Mysql help - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Mysql help (/showthread.php?tid=45336)

Mysql help by absorbation on 05-26-2005 at 07:13 PM

For the downloads script i found i wan't to sumbit an addon but to do that i need to go to my mysql manager and execute this query:

CREATE TABLE download_comments (
comments_id int(10) NOT NULL auto_increment,
file_id int(10) NOT NULL default '0',
comments_text text NOT NULL,
comments_poster text NOT NULL,
comments_ip text NOT NULL,
comments_title text NOT NULL,
comments_time int(50) NOT NULL default '0',
PRIMARY KEY (comments_id),
KEY comments_id (comments_id)
) TYPE=MyISAM;

Can someone tell me how to do this :S

I'm hopeless :$


RE: Mysql help by Ezra on 05-26-2005 at 07:18 PM

There is usually a white box in those managers to run query's just put that code in that box and press submit.

I'll post a picture of that box from phpmyadmin later

EDIT: I have the image :-)


RE: Mysql help by Concord Dawn on 05-26-2005 at 07:21 PM

Or access your MySQL server via command line.

Or optionally use the MySQL Query Browser.

Optionally, you might want to try out MySQL Administrator as well. It's nice to have a GUI to change most of this stuff.


RE: Mysql help by absorbation on 05-26-2005 at 07:22 PM

Could one of you do it for me please :P i'll give the details on msn just add me at absorbation@hotmail.co.uk


RE: Mysql help by Veggie on 05-26-2005 at 07:27 PM

its really not that hard, log into phpmyadmin (if you have it) and run the sql, you will have to learn how to do this eventually so why not now, you will learn much more by doing it yourself (y)


RE: Mysql help by absorbation on 05-26-2005 at 07:29 PM

I can't be bovered to install the script :(


RE: Mysql help by Veggie on 05-26-2005 at 07:33 PM

People sometimes try to put to many scripts into there website, if its not needed then dont do it, is a general rule. If you need it then put a little effort in, if you going to do something do it right and dont rush things (y)


RE: Mysql help by absorbation on 05-26-2005 at 07:36 PM

quote:
Originally posted by Veggie
People sometimes try to put to many scripts into there website, if its not needed then dont do it, is a general rule. If you need it then put a little effort in, if you going to do something do it right and dont rush things (y)

Wise words :P It's just a script i'm adding to a scipt and that was in the intructions, i will never need to phpmyadmin again so installing is worthless to me :P