MySQL

MySQL v Access

[Andrew Thomas]

Hi, im looking into a new host to develop websites (www.webfusion.co.uk) and they use MySQL as their database.

All I have ever used before is MS Access with ASP,

Can i intergrate MySQL with asp, if so is it similiar techniques to using Access (eg connections/ SQL queries etc)?

Or is it a big learning curve?

thanks

[rpking]

Very similar and a whole lot better. The connection strings will be slightly different, and some of the SQL statements may have slightly different syntax but you'll have no problems getting going.

[Andrew Thomas]

OK, thanks

Ive just installed it on my computer to get used to it....

Can I import data/tables from Access or do i have to type it in again??

[Woz]

Is mySQL a relational database with inbuilt queries or does it simply store table data? I am not sure as I have never used mySQL but I do seem to remember reading this somewhere.

If the latter, then, Andrew, you may need to consider whether your data uses any of these functionalities within Access.

Onya
Woz

[Andrew Thomas]

To be honest, I know nothing about MySQL, but need to learn it, as it is much more powerfull than Access, and my future host, uses only this?

Besides I dont think access will be man enough the amount of records/users i expect (hope) to use it...

[Josk]

Check out [mysql.com...] ...its a fully relational database, commonly used in web applications. Its open source (free), easy to integrate, and reliable... It scales quite well, but if get above the 000,000 records you may want something like Oracle...

<Link fixed ~Marcia>

(edited by: Marcia at 12:10 pm (utc) on Feb. 21, 2002)

[Andrew Thomas]

OK, ive actaully started to create and insert records into MySQL, this may seem a dumb question, but is there a user interface i can use - or do i have to type statements like :-

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

each time??

[wataru]

MySQL is a good choice for web sites since its VERY fast at doing its thing.

If you are looking for a GUI, the authors of MySQL didnt make any (that i know of) themselves, but they link to several 3rd party ones, I found this the most useful.

[anse.de...]

[Andrew Thomas]

thanks wataru, the front end looks much easier - i just nedd some data to put in it now - ha ha

[Josk]

If you look at [webmasterworld.com...] you might find a way of generating data for that death DATE bit...

[Tapolyai]

Just a side note for Josk, I run MySQL with well over 10,000,000 records/rows (actually 11,881,376) and it is a many-to-many DB.

I am not running into MySQL limit

I am running up against an OS 4G max size limit.

This baby humms... and at the right price!

[txbakers]

This sounds great. I'm getting ready to convert my Access DB to something. I was thinking SQLServer, but it's expensive. MySQL looks good, but I wasn't aware of a GUI until now.

I also have the Oracle Personal Edition. Has anyone used that?

One more question: Will MySQL work with IIS and Windows?

[rsteele]

I just started working with MySQL, IIS, an Win2K and it works great. Especially since I had never worked with MySQL (mainly Access), I had no problems setting it up and had my database up and running in about 30 minutes. (I had to learn all the SQL syntax). It's pretty much an install just like most of Win32 installs.
Oh yea, I found out about the MySQL GUI's after a week of pulling my hair out learning MySQL via command line AND on a deadline. Whooopie!!! Stress?
Good luck!!

[Chameleon]

If you need a decent frontend to MySql , you should use PhpMyadmin. You can get it at
[phpwizard.net...]

Alternatively you can setup an MyODBC connection in Access 2000 and link to the existing databases.

[circuitjump]

Chameleon is right,

PHPMyAdmin is an awesome tool to use. It's not hard to configure either.