/    Sign up×
Community /Pin to ProfileBookmark

MySQL

Copy linkTweet thisAlerts:
May 10.2005

Hi

As I’m still learning ASP at work, I’d really like to spend sometime on it at home, however I’m using Microsoft SQL Server at work and clearly can’t afford to have that at home!

I believe that MySQL is free to use, can anyone give me any advice on how easy it is to use? As a beginner would I struggle too much? Any tutorials etc..

Thanks in advance!

to post a comment
Full-stack Developer

9 Comments(s) ↴

Copy linkTweet thisAlerts:
@BleedMay 10.2005 — I was wondering this same thing...I'm interested in learning it, but have little information on how. If possible, please answer the following questions.

1)what are the exact features of MySQL databases or databases in general? user accounts, newsletters?

2)would you recommend using this feature?

3)how hard is it to learn, and do you have any resources to offer? (as asked above). Tutorials, free classes, etc.
Copy linkTweet thisAlerts:
@Stephen_PhilbinMay 10.2005 — As far as I know, MS SQL server and the MySQL server are very different. MySQL is completely free and very easy to set up on a Linux/Unix machine, but I'm not sure about setup on windows. I'm assuming you use windows? There weren't too many "installation on Windows" notes in the manual so I can't imagine it'll be [i]too[/i] difficult to install, but I'm not sure about getting it to work with ASP on a home machine, let alone how it might compare to MS SQL.

If you want to go ahead and give it a swing then you can download it from http://dev.mysql.com/downloads/mysql/4.1.html Have a look about half way down the page to find the Windows downloads. The manual for setup, installation and usage comes with it so you don't need to wander the web for help. ? Like I said, I'm not sure how it'll compare, but it's there if ya wanna give it a swing.
Copy linkTweet thisAlerts:
@ray326May 10.2005 — MS has a free version of SQL Server called MSDE that you could use at home if your OS can support it.
Copy linkTweet thisAlerts:
@Stephen_PhilbinMay 10.2005 — I was wondering this same thing...I'm interested in learning it, but have little information on how. If possible, please answer the following questions.

1)what are the exact features of MySQL databases or databases in general? user accounts, newsletters?[/QUOTE]

As far as I know it know (the version 4.1. type and version 5.0 type and above) supports most of the SQL standard plus some proprietary features. It supports the MyISAM engine (which is non-relational but is slowly being tweaked to emulate features of a relational database and is apparently the fastest stable production-ready database around) and the InnoDB engine (which is relational and has quite a bit of speed and space optimisations to it and also has some synonyms added to increase oracle compatability).

2)would you recommend using this feature?[/QUOTE]
What feature?

3)how hard is it to learn, and do you have any resources to offer? (as asked above). Tutorials, free classes, etc.[/QUOTE]

It's very easy to learn. Just use the manual that comes with the download. I can't imagine you'll need any tutorials, the manual is complete.
Copy linkTweet thisAlerts:
@screaming_banjoauthorMay 11.2005 — Thanks! I'll look into MSDE as well, I have XP Pro.

I also have Access 2000, but thought that MySQL would enable me to build a database that would be faster to access.

Thanks for all your posts
Copy linkTweet thisAlerts:
@buntineMay 11.2005 — Access 2000 will work fine. MSDE will be even better.
Copy linkTweet thisAlerts:
@ATBSMay 11.2005 — You could use Access as the front end to MSDE.

I use MySQL and I think it's great. I am running it on a development machine running Win2k. MySQL doesn't support triggers or stored procedures. There are two nice front ends built for MySQL too. One is GUI, the other is Web based.
Copy linkTweet thisAlerts:
@ray326May 12.2005 — Access is a query tool. The database bundled with Access is Jet.
Copy linkTweet thisAlerts:
@Stephen_PhilbinMay 12.2005 — You could use Access as the front end to MSDE.

I use MySQL and I think it's great. I am running it on a development machine running Win2k. MySQL doesn't support triggers or stored procedures. There are two nice front ends built for MySQL too. One is GUI, the other is Web based.[/QUOTE]


I don't really know what you mean by "triggers" but if you want stored procedures, then MySQL 5 has them. Last I looked MySQL 5 had not yet been declared as a stable product and given GA status, but if that doesn't bother you then it's there for anyone that wants it.

Additionally, if you're on a Windows machine and you're using asp and the machine you're going to be running your work on is using a MS database, then I'd definitely go for using a MS database on the home machine where possible too, rather than MySQL.
×

Success!

Help @screaming_banjo spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.24,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...