question on whether mysql cab be made more user friendly

[poolboi]

hi,

i need some advice on something
from what i know mysql store our data in the form of databases
and we have sql statements that helps define our query results
but this is mostly for developer's use
however i'm searching for a final interface where users who uses access the database can use it without much knowledge of mysql language
so say for example:

if a employer needs the users and specific dates and times, there should be an interface prompting the employer to key in what she/he wants to know and the results will be printed for her/him to see

is there any methods of ways where this can be done?

[r035198x]

hi,

i need some advice on something
from what i know mysql store our data in the form of databases
and we have sql statements that helps define our query results
but this is mostly for developer's use
however i'm searching for a final interface where users who uses access the database can use it without much knowledge of mysql language
so say for example:

if a employer needs the users and specific dates and times, there should be an interface prompting the employer to key in what she/he wants to know and the results will be printed for her/him to see

is there any methods of ways where this can be done?

You can create either a web application or a desktop application which has the friendly interface. This forum is one example of a web application.

[arggg]

You can use phpMyAdmin which is pretty user friendly or even use the MySQL Administrator Application that comes with MySQL.

[poolboi]

ok thanks :)
i'm gonna check both these 2 out now

[poolboi]

hi,
i've checked both out..
it seems mySQL administration has tools like migration, administration, query browser
but i guess this part still requires u to know about SQL statements

and phpmyadmin..i'm trying not to use it
'cos we need to download PHP, and i have no knowledge of this language
hm..

basically i aim to let a user access a database without any prior knowledge of SQL statements...me aning u can insert delete and get information out from fields u need with just a click
basically it would be good if there a GUI to allow u to connect to yr database, delete and insert, filter out information and u woon't touch any SQL statements at all
u think it's possible?

[poolboi]

hm..i've found a couple of handful GUI for sql
things like navicat mysql admin, and sqlyog
actually these are like support softwares for mysql right?

end of the day we still have to purchase the server from sql right? cos i'm exploring on sql enterprise version

[arggg]

you can download mysql for free. Enterprise edition i'm not sure about but it all depends on what you are wanting to use the database for.