This month, in honor of the start of the school year, we’ll be going over some of the basics of MySQL:
- Concepts and Terms
- Basic usage
I hope to see you at the meetup this Wednesday, Sept 23rd at 7pm at the 404:
If you know anyone that is interested in MySQL, this would be the meetup to attend!
This month, we’ll talk about Triggers and Stored Procedures per some suggestions for last month. MySQL has support for both and we’ll talk about some of the caveats and real world experiences.
As usual, we’ll provide food and drink. Hope to see you there!
I’ll be out of town for work, but #okcmysql member Josh Walcher (http://www.bigboardroom.com/) will be driving a discussion about scaling applications using various automation, APIs, and other techniques.
The goal is to hopefully introduce folks to some new ideas while having an interactive discussion to see what others are doing to manage similar issues.
Pizza will be provided as usual and if it works out, I’ll hopefully be able to join remotely for some of the talk as well. And please RSVP here so we can get a good head count for food: http://www.meetup.com/Oklahoma-City-MySQL-Meetup/events/222840388/
Hope to see you there and thanks Josh for offering to drive the discussion while I’m out of town!
As a continuation of Part 1 in this tutorial, we’ll work through some basic interaction with our test database using MySQL Workbench. Some things we’ll cover include:
- Setting our current database
- Creating a new table
- Inserting rows into a table
- Selecting rows from a table
- Basic UI review of Workbench
Without further adieu, lets get started using MySQL!
At long last… the first real post of the intro series on getting started with MySQL! (Better late than never, right?)
There are a few ways you can go about setting up a test instance that are generally shared across Operating Systems:
- Install locally on your machine (Windows, OSX, Linux)
- Set up a local Virtual Machine, then install MySQL on the VM
- This is my preference as it also allows me to get familiar with the OS (preferably Linux)
- Set up a quick Amazon EC2 Instance
- This is easiest if you are comfortable with EC2, but can also be costly if you forget to turn off an instance or want to spend lots of time testing and experimenting
For the sake of folks getting their feet wet, I’ve setup a Virtual Appliance that you can import and start using right away:
The rest of this post and Part 2 will be a step-by-step guide on getting starting with the above appliance. So lets get started!