Just starting in MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
southeastweb
Forum Newbie
Posts: 14
Joined: Sun Mar 21, 2004 3:28 am
Location: Florida

Just starting in MySQL

Post 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 :?
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Install phpMyAdmin, it is a web based client to MySQL Server.
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

I second that, phpmyadmin is Cpanel for MySQL databaes =]
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post by Steveo31 »

malcolmboston wrote:use MySQL-Front, i stopped using PHPmyAdmin because of it
Because of what?
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

personally i think its better

sorry for the lack of clarity
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post 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 ...
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post 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?
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Just found this mysql query builder, haven't tried it yet though.

http://www.myqry-generator.com/?page=0
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
ptesone
Forum Newbie
Posts: 7
Joined: Mon Dec 15, 2003 11:32 am

Post 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,
Post Reply