why use MySql?

vahidi

Hi,
I have this answer:
php is almost used by mysql database,
althogh myslq has a difficult Interface and work with that, is hard.
why very people use that?????????😕

junkie_doodle

PHP has support of various databases. For example now i'm writing this post at a break time of coding for an Oracle-PHP software.

Databases are choosen by analysing the requirements of the project. It might be MySql or a simple CSV file. Or there are people using PHP with DB2, PgSql and more. The choice depends on the pluses and minuses of the databases.

For example, MySql is a database, which is responding select queries really fast. And that's one of the reasons why MySql is picked up from those bunch of DBs while developing web applications.

And about the interface of the mysql.. Mysql doesnt have an interface in the distubution package, except a command line tool. But there are alot of programmers who develop interfaces to mysql. You can try a different tool to access your MySql database.

the_Igel

Yeah. MySQL is fast, free, widely used light-weight db. And for most web-sites it's far enough: the power of high-end databases is rarely needed.
As for interface, you may use phpMyAdmin, if you like. Or there are GUI interfaces in the world. And since mysql is mostly used for site-running, there's not much need in any interfaces anyway, as a site itself is an interface.

_SuperString

I think the main reasons are the costs (free) and the platform support. But I have to say that it does lack some of the power available on high-end expensive RDBMS like: entitly relationship and transaction processing support. - But Yeah - weres theres a will theres a way.

p.s. did I mention that people like it because its free ?

vahidi

hi,
very thanks for your answering,
your answer is very good,and I use this.

have a good day,
by.
🙂

_SuperString

I would like to add that its free. 🙂 🙂 🙂 😃 😃 🙂 🙂 🙂

Stinger51

MySqlFront is a free MySQL interface that isn't too bad (altho it's a resource hog). And the .exe is < 2 megs.

I don't have the URL handy, but a quick search on Google should give it to you.

HTH

the_Igel

MySqlFront [...] isn't too bad
Yes, it isn't too bad, but it's a bit buggy and it works in a strange manner sometimes. All that tab switchers on the top come & go without any reason.......

Stinger51

One of the things that I have not gotten this interface to do successfully is updates between databases -- without writting both the table structure and data.

For example, I keep both a local and an on-line copy of a particular DB I have. If I want to sync them up, just importing the data from one table to another doesn't work. Nothing gets copied unless I tell the program to use both data and table structure. This is silly, but it's the only way I can get it to work.

= = =

Hey, would you happen to know why I cannot select more than one database locally? I use the latest version of MySQL and PHP 4.0. I can see the other databases from both MySQL Front and the Monitor. But, via my PHP scripts, I can only select the original one I created when I first set everthing up. If I try to select a different DB, I get a "Cannot select database error."

Weird problem, and I've been looking months for a solution to this.

The_Chancer

I had a problem with connectin to a different database, only way I got round it was to not use an include file which held my connection data, and connect in the PHP file itself, and use mssql_select_db('dbname',$connectioninfo) but trying to do it when I had specified an include file didn't work... odd but it was a feasible workaround for me..

If only my employers had done as I said and used a FREE DATABASE like MySQL !!! Would have saved us so much time, effort and bother...

Stinger51

I made connection calls straight to the DB from the script, but it still refuses to see anything other than my original DB.

Personally, with all these nagging issues like this, plus the lack of a decent interface, I think MySQL is fucked. Unfortunately, I'm stuck with it.

rebelo

With regards to interfaces. I used to only use the command line mysqld to work with my database. I have recently started doing work at my employers office, however, where I am working in a Windows environment. I know phpMyAdmin is a decent interface, but I was wondering if anyone has any advice on a windows graphical app for interfacing with a mysql database that is as featured as phpMyAdmin. For the time being I am still just using mysql> but if anyone has suggestions for this question, I would appreciate it.

Cheers

Justin Rebelo

tha_mink

I can't see how any gui could be easier than the command line. I mean...how much easier can it get?

rebelo

I don't believe I stated that I wanted something easier. I am just interested in seeing what sort of things are available.