Join Bill Weinman for an in-depth discussion in this video Installing time zone support in MySQL on Windows, part of MySQL Essential Training (2014).
…In this movie I'll show you how to install time zone support on MySQL on Windows.…My SQL supports time zones by using the…extensive time zone database maintained by the IANA.…That's the internet assigned numbers authority.…This database is a standard set of…international time zone rules, names and locations.…If you're using a Mac or a Unix based…My SQL installation, you probably already have this database installed.…If you're using Windows, it's probably not installed by default.…
In this movie, I'll show you how to install it.…This is necessary if you want to learn about the time zone capabilities of MySQL.…I'll be using this in the lessons on date and time types and functions.…First, let's find out if this machine has time zone support installed.…So I'm here in SID.…And, I don't need a database selected for this.…I'm just going to type in a couple of commands.…First is, SHOW VARIABLES, and the word LIKE.…And you'll learn, a lot of this SQL syntax later in this, course.…
Show variables is a MySQL specific.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.