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
blog version — similar 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
