Quite possibly THE COOLEST SITE ON THE INTERNET because you can come and go as you please without being bombarded with pop-ups asking you to join any lists, and our pages are not full of ads, just a few! curated news for friends & family™
... because friends don't let friends go uninformed! ™    

Useful Mysql Queries

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

Read the rest of the article at artful software

"
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; "


Share this...

blog versionsimilar posts here... and elsewhere

Comments (we believe in free speech, but not necessarily these comments)
Leave a new comment regarding "useful-mysql-queries":

post_ID = 1328

 
The Lazy Pug Cafe -- The Lazy Pug Cafe was a dilapidated old two-story farmhouse abandoned years ago, lately serving as a sad but charming reminder of days gone by. With its beautiful old weeping willow in front and a massive ancient oak tree, Ol' Lightnin', out back, locals were grateful someone was finally bringing the