Page 1 of 1

Just starting in MySQL

Posted: Tue Mar 23, 2004 1:31 am
by southeastweb
Hello!

So I am just getting started with MySQL, I am having some serious beginner trouble and was wondering if anyone could give me some info.

I am running an Apache server, and I code in PHP. This is the first time I am starting to do some work w/ my sql.

I was a dbase user for quite some time, but as easily seen, MySQL is no relation whatsoever, besides basic functionality.

I would like to build a table, but havn't been successful (possible have, but was unable to loacate, ad data, and use it for anything).

Is there any basic guidlines to follow here, maybe some tips, I am up for anything anyone has to offer at this point.

My classes won't be digging into MySQL for a while and I would like to get ahead of he game.

If anyone has some info! Thanks D :?

Posted: Tue Mar 23, 2004 2:03 am
by Pyrite
Install phpMyAdmin, it is a web based client to MySQL Server.

Posted: Tue Mar 23, 2004 5:02 pm
by tim
I second that, phpmyadmin is Cpanel for MySQL databaes =]

Posted: Wed Mar 24, 2004 2:17 pm
by malcolmboston
use MySQL-Front, i stopped using PHPmyAdmin because of it

also it can help you in creating queries for PHP, as it lists hte actual query you have just used, copy and paste into PHP and 99% of the time, the correct syntax is there, this is what i did for the first few days of working with mysql

Posted: Wed Mar 24, 2004 2:23 pm
by Steveo31
malcolmboston wrote:use MySQL-Front, i stopped using PHPmyAdmin because of it
Because of what?

Posted: Wed Mar 24, 2004 2:55 pm
by malcolmboston
personally i think its better

sorry for the lack of clarity

Posted: Fri Mar 26, 2004 12:07 am
by Pyrite
phpMyAdmin does that too dude. It creates queries for you, lets you bookmarkqueries you have used in the past, you can copy them into php scripts too. What is so different about MySQL-Front ? Just wondering ...

Posted: Fri Mar 26, 2004 12:16 am
by Pyrite
I read through MySQL-Front's website. Reading their list of features, I didn't see anything that phpMyAdmin can't do. Main differences appears to be that phpMyAdmin is webbased and mysqlfront is a windows application (sorry linux/mac people). And MySQL-Front is not freeware, but only offers a 30 day evaluation while phpmyadmin is FREE.

Seriously though, as someone who uses both, are there any features that you know phpmyadmin doesn't have?

Posted: Fri Mar 26, 2004 12:30 am
by Pyrite
Just found this mysql query builder, haven't tried it yet though.

http://www.myqry-generator.com/?page=0

Posted: Sun Mar 28, 2004 5:40 am
by malcolmboston
sorry for not getting back to you sooner

well i have several problems with PHPmyAdmin which is why i switched and from what i understand MySQL Front is Freeware, i havent payed for it and ive had it around 6 monts now, and all the features are still enabled

anyway with PHPmyAdmin has got a nasty habit of not 'refreshing' its database list, i dont know why, but ive read this problem all over the net and still cant fix it, also i think MySQL Front has a better designed interface, however, when your inserting data straight through 'Front it has a nasty habit of automatically selecting it as 3 digit TINY INT and defult to 0 i have no idea, but this is just plain stupid

PHPmyAdmin is good, just has some issues in my opinion

try them both and decide for yourself

Posted: Mon Mar 29, 2004 2:58 pm
by ptesone
Hi

I recommend MySQL Turbo Manager , the product is good and integrated PHP features , this product not is free but the price is right.

http://www.mentattech.com

Regards,