7 Simple tips for being successful with MySQL

When it comes to MySQL, there's a few things you can do to use the tool more effectively and make your life easier. Here's 7 tips to that end.

Try Linode one-click applications today and get a $20 credit:

Hope you enjoyed the video!

Check out this code here:

Join my Discord server to chat with me:

Check out some code on my GitHub:

Come visit us on Reddit:

Other Social:

[rish]

Wow, this isn't just smart for MySQL, it is smart for any relational database. Good video!

[Chache]

This channel is a real treasure. I look forward for the next videos.

[TooLazyToFail]

I met some of the Linode folks at their booth at a job fair recently. They were super warm and gracious. It stood out among some of the other booths. Good people!

[PhG]

Nice and usefull video. Somethings I had almost completely forgotten are now freshend up and back in my memory !

[MaartenVanDamme]

short but effective; great video, thanks!

[AnatolSommer]

I would also recommend using the "slow query log" functionality.

[Raaampage]

I learned not so long ago about transactions, that's a really great feature, because if something fails you can revert it since no actual data was inserted/modified :)

[poetranoegraha]

In my notification, this video's title shown as "7 Simple tips for being succ...".

[mikesveganlife]

Good tips for relational databases, not just mysql in general. Be wary of other types of databases though if you happen to run into them.

[RobertWildling]

Thanks a ton! Any chance to get a video from you about using nosql in MySQL?

[jobspoint]

Everyone should watch this video before starting his fist project

[philpeko]

I am sorry, you say that by indexing/optimizing/etc some local DB, you are gonna be their heroe, but I am afraid this a vision from the past. Nowadays, I do not know any business that "runs its own SQL database schema for its in-house-developed application" . Every administration or Company I know, from Big Corp down to Medical/dentist/Veterinary clinics, car garages, small law firms (a few Laywers associated), they all have been running for ages some specific applications, I mean related to their business, which are available off-the-shelf, and now, available on cloud. So, I don't mean that SQL are not needed, but it is only on a small scale, mostly working for software editors.

[victomeyezr]

Tip # 8. Never use a remote database...

[sanjaykindo]

Hello! I'm unable to make the snake game which you made in one of your video, it's showing ModuleNotFoundError please help me to make that game. Please reply Thank you..

[fuzzydk]

is that really how mysql is pronounced?

[benben]

This is the first advertisement that I've seen on this otherwise great channel. It was quite off putting (but no more than other great channels I guess).

[JNET_Reloaded]

I need a working python3 irc bot that can do !say and !CMD#: commands! anyone help? also it must know ping pong!