MySQL

Question

MySQL

ben.brugman

SSChampion

Points: 13369
More actions
February 5, 2019 at 1:49 am

#409485

Hello Community,
It is my opinion that I have some SQL and SQLserver skills. Apart from the SQL, I have no experience with MySQL.
For a Historical Society I plan to do some volunteer work. I have been asked to use my SQL skills on a project. At the moment I do not know what/how/when/where/who *) etc. But I know that MySQL is one of the tools to be used.
Could somebody give me some hints and links where to get started with MySQL?
(Websites etc.).
Thanks for your time and attention,
Ben
*)
This is a sleight exageration.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 1

There are a bunch of articles right here on SQL Server Central that can help to get you started. This one right here seems perfect. Do a search in the box up above for a bunch more (filter the search to just Articles after the first result). Also, go and get mysql. Download it. Install it. Start working with it. Or, spin up a mysql database in Azure. However you do it, get your hands on the bits and start mucking about.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 2

ben.brugman - Tuesday, February 5, 2019 1:49 AM
Hello Community,
It is my opinion that I have some SQL and SQLserver skills. Apart from the SQL, I have no experience with MySQL.
For a Historical Society I plan to do some volunteer work. I have been asked to use my SQL skills on a project. At the moment I do not know what/how/when/where/who *) etc. But I know that MySQL is one of the tools to be used.
Could somebody give me some hints and links where to get started with MySQL?
(Websites etc.).
Thanks for your time and attention,
Ben
*)
This is a sleight exageration.

Why not just use SQL Express?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ben.brugman SSChampion Points: 13369 More actions · Answer 3

Jeff Moden - Tuesday, February 5, 2019 8:48 AM
Why not just use SQL Express?

It's not my choice.

So I have to guess why.
Maybe because SQL Express is limited in database size.
Maybe because SQL Express is not future proof or future free. (Is MYSQL ???).
Maybe because SQL Express is limited in number of users.

In the end the database is probably going on line, serving a larger community. (???).

It's a long term project, data from centuries ago is digitized and made future proof.

As said not my choice,
Ben

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 4

ben.brugman - Tuesday, February 5, 2019 1:49 AM
Hello Community,
It is my opinion that I have some SQL and SQLserver skills. Apart from the SQL, I have no experience with MySQL.
For a Historical Society I plan to do some volunteer work. I have been asked to use my SQL skills on a project. At the moment I do not know what/how/when/where/who *) etc. But I know that MySQL is one of the tools to be used.
Could somebody give me some hints and links where to get started with MySQL?
(Websites etc.).
Thanks for your time and attention,
Ben
*)
This is a sleight exageration.

MySQL and MariaDB are in fact two sides of the same coin, fairly good ISAM engines. Both are quite ANSI compliant and not too different from other RDBMSs.
😎
If you want to practice unflavored SQL, I'd suggest SQLite, you can run that of the phone (and it's probably running there already) if you like. PHP 5 MySQLi would be your first stop, works with the formers, SQLite Studio for the latter.

cmullican SSC-Addicted Points: 465 More actions · Answer 5

MySQL is more ANSI-compliant than it used to be...if you don't accidentally do something to break that, but I wouldn't use it for anything serious if I could possibly avoid it. Here's one of my least-favorite potential gotchas:
Back in the day, MySQL did not require group by clauses to list all non-grouped columns. For any not listed, it just pick a value. There's a start-up flag you can use to enable strict grouping, and eventually, they included it in the default flag...UNLESS you specify another flag or flags at start-up, in which case all defaults are replaced with what you specified. Congrats, you wanted to specify something about date handling, and you just turned off strict group-by because you didn't realize it was a flag!

MySQL is riddled with similar traps, bits of legacy design lurking in the shadows, waiting to snare the unwary.

If you must use it, proceed with extreme caution, and never, never, never assume the system will do the right thing.