curated news for friends & family™ ... because friends don't let friends go uninformed! ™    

Useful MySQL Queries

by bill - 2020-12-04 ( education / tech / computers / internet )

Common MySQL Queries. Extending Chapter 9 of Get it Done with MySQL 5&Up

Here's an example: Compute date from year, week number and weekday:

SET @yr=2012, @wk=26, @day=0;
SELECT Str_To_Date( Concat(@yr,'-',@wk,'-',If(@day=7,0,@day) ), '%Y-%U-%w' ) AS Date;

Go to artful software


Share this...

blog versionsimilar posts here... and elsewhere

Comments
We enjoy free speech. Try not to offend, but feel free to be offended.
Leave a new comment regarding "useful-mysql-queries":

post_ID = 1359

 
         

bill.friendsnews.com | computersavior.com | dievna.com | friendnews.com | friendsnews.com | friendsnews.blog | hepya.com | hepya on blogspot | homespun.news | lazypugcafe.com | myfriends.blog | nashvillecomputerhelp.com | newsletter on blogspot | pugfarm.org | tarasfaves.com | tarasfavorites.com | test.friendsnews.com | thebillholmes.com | thelazypugcafe.com | williamarthurholmes.com | workplayce.biz