mysql - insert random integers into table? -


i want update sql statement add randomly generate combination of letters , number , want 10 digits only

 update `transaction` set numberofuser=numberofuser+1 , referencenumber= randnum

try this:

update `transaction` set numberofuser=numberofuser+1 ,         referencenumber= left(md5(999999999*rand()),10)

Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

javascript - generate date range base on integers -

i have array [0,1,2,3 .. 23] , means hour in day. how use moment js convert them 12 hour date range? my desire output is ['12am-1am','1am-2am','2am-3am' .. 11pm-12am] my attempt failed coz thought don't need moment https://jsfiddle.net/s4l7hj1a you don't need moment.js var getformattedhour = function(hour) { return (hour % 12 ? hour % 12 : 12) + ':00 ' + ((hour < 12) || (hour >= 24) ? 'am' : 'pm'); } var gethourrange = function(hour) { return getformattedhour(hour) + ' - ' + getformattedhour(hour + 1); } var hours = []; for(var hour = 0; hour < 24; hour++) { hours.push(hour); } hours.map(function(hour) { console.log(gethourrange(hour)); });
Read more

javascript - Generate barcode from text and convert it to base64 -

does knows tool generate barcode image (preferably code 39) string , converts base64 string, use this: var text = "11220"; // text convert var base64str = texttobase64barcode(text); // function convert input // image formated in base64 string "data:image/jpeg;base64..." ? using jsbarcode function want. function texttobase64barcode(text){ var canvas = document.createelement("canvas"); jsbarcode(canvas, text, {format: "code39"}); return canvas.todataurl("image/png"); }
Read more