Showing posts with label MySQL 8. Show all posts
Showing posts with label MySQL 8. Show all posts
Tuesday, September 22, 2020

MySQL + WePay MeetUp

›
Description Join this virtual meetup featuring WePay and Oracle MySQL! They will review three great talks on MySQL Compatibility Check, Runn...
Wednesday, August 26, 2020

Better VIEWs with the WITH CHECK OPTION

›
      VIEWs have been a handy feature of MySQL for many years but do you know about the WITH CHECK OPTION clause?  The WITH CHECK OPTION cla...
Wednesday, August 12, 2020

Two MySQL 8.0 Talks this week - DevOps and Features, an upcoming Podcast, and an article on JSON Document Validation

›
 I have two talks this week on MySQL 8.0 that you can attend virtually. And another session that is one line also plus an article.  Busy wee...
Wednesday, April 4, 2018

Array Ranges in MySQL JSON

›
Pretend you have a JSON array of data that looks roughly like the following. mysql> insert into x(y) values('["a","b...
Monday, January 8, 2018

Common Table Expressions (CTEs) Part 1

›
Occasionally at conference or a Meetup, someone will approach me and ask me for help with a MySQL problem.  Eight out of ten times their dif...
Tuesday, November 7, 2017

MySQL Queries No Waiting

›
Last time  we looked at SKIP LOCKED  where rows locked by another process were skipped. NOWAIT informs the server to return immediately IF t...
Monday, November 6, 2017

SKIP LOCKED

›
SKIP LOCKED is a new feature in MySQL 8 that many will find valuable.  If allows you to not wait about for locked records and work on what i...
Tuesday, October 3, 2017

MySQL Shell with Command Completion

›
MySQL Shell CLI Interfaces are usually boring, ASCII-ish functional interfaces that are as about as exciting as paint drying or end user li...
Sunday, September 24, 2017

MySQL 8's Windowing Function Part 1

›
MySQL will have Windowing functions and CTEs which will mean it will be easier to do data analysis with MySQL. You can now make calculations...