Idiots Guide to mySQL

Not sure if where to put this so might aswell pop it in here, decided to have a look at mySQL and i have no idea where to start apart from fnd the download on the site.

Im coming from a asp access background using ODBC to connect to my database.

Does anyone know of a fool proof guide to mySQL for the life of me i cant find any instrctions on the site maybe its me and its late in the day but there just not there.

Anyhew any advice on this would be great

Cheers ME

What do you need, help installing it? Or help with syntax? Or something
else...?

i use phpMyAdmin to manage my mysql databases, that might be of use to you. As for anything else ya better answer Chief first

Help with installing it it and how to use it etc, i have heard of PhpMyAdmin im gusiing it is just an interface allowing you to manage your Database's.

Is it anything like Access where u just create your database fileds and bobs your uncle we have a database.

Any yes the install part (im on windows xp, locally) and going to be writing the cms in asp.


any advice would be great cheers me

Ok, this is a guide to installing WAMP [Windows/Apache/MySQL/PHP],
it's not quite what you want, but it's an excellent article, and it shows
how to install/set up MySQL nicely...

http://www.devarticles.com/c/a/Apac...P-under-Windows

As for ASP - I'd strongly recommend doing it in PHP rather than ASP,
as it is far more powerful, and very easy to get to grips with...

phpMyAdmin is probly the best tool for managing your MySQL DBs.
You can get other stuff like MySQL Front, but I find phpMyAdmin the
easiest to use. It does do what you are asking - you just create a
DB, type in the field names/types, fill in the data and your done.

HTH,

--Jon.

Cheers Mate.. asp is the only programme i kinda know atm can i still use MySql with asp? hopefully i will be getting into .NET soon can i use it with that aswel? if so do i treat it like i did with Access ie using ODBC etc?

one more question im still quite new in asp i have built 2 cms's and my IT guy wants me to get away from Access, if i was togo to mySQL would u recomend going down the PHP route as i tried to look into .NET and as im more a designer then a coder feel ill never pick it up.. any thoughts

Hi Sluap,

you can use mySQL with ASP and ASP.Net, you are correct,
you will just use another provider/driver with your ODBC connection.

I wont suggest to change programming lanuages just because of
a database change, but that is just my opinion

Cheers
Jako

Cheers for the feed back NF, i do not belive ill ever get into .NET that kinda programming is not my thing, and if asp is slowly being taken over by .NET then php would be the logic as i know a little of it.

Thanks for your thoughts guys i realy apreciated it

ps so if i created a dataBase with phpmyAdmin i could still connect to it via the ODBC just using a diferent driver

phpmyadmin is just a way to create the db so yeah you can connect to it using php or using asp with a driver, as i understand it.

cheers mate.

and for learning about mysql syntax, this site might help u!!
http://dev.mysql.com/