Definitions
Sorry, no definitions found. Check out and contribute to the discussion of this word!
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word lpad.
Examples
-
WiTH this code, I take some columns from my database table, put one after the other with lpad function.
ASP.NET Forums 2009
-
WiTH this code, I take some columns from my database table, put one after the other with lpad function.
ASP.NET Forums Baranboz 2009
-
VIEW ball. x12_grp AS SELECT cid, avg (o1) as o1_avg, avg (ox) as ox_avg, avg (o2) as o2_avg, concat (DATE (srcstamp), '-', lpad (time_to_sec (srcstamp) DIV 600, 4, '0')) AS grp from ball. x12 group by cid, grp;
unknown title veritas z. 2008
-
Selecting directly from the underlying table is much faster. mysql > explain SELECT cid, avg (o1) as o1_avg, avg (ox) as ox_avg, avg (o2) as o2_avg, concat (DATE (srcstamp), '-', lpad (time_to_sec (srcstamp) DIV 600, 4, '0')) AS grp from ball. x12 where cid = 9691 group by cid, grp;
unknown title veritas z. 2008
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.