Table : user -------------- | Id | Name | -------------- | 1 | Test | | 2 | Test1 | | 3 | TEst2 | | 4 | Test3 | | 5 | Test4 | | 6 | Test5 | | 7 | Test6 | -------------- Query : selecr concat(id,":",name) as output from user Output: ------------ | output | ------------ | 1:Test | | 2:Test1 | | 3:TEst2 | | 4:Test3 | | 5:Test4 | | 6:Test5 | | 7:Test6 | ------------
Showing posts with label concat. Show all posts
Showing posts with label concat. Show all posts
Tuesday, 12 August 2014
Mysql get two column value in get single field
Mysql get multi row value in get single field
Table : user -------------- | Id | Name | -------------- | 1 | Test | | 2 | Test1 | | 3 | TEst2 | | 4 | Test3 | | 5 | Test4 | | 6 | Test5 | | 7 | Test6 | -------------- Query : select group_concat(concat(id) SEPARATOR ',') from user Output: 1,2,3,4,5,6,7
Subscribe to:
Posts (Atom)
-
<?php $to = "somebody@example.com, somebodyelse@example.com"; $subject = "HTML email"; $message = " <h...
-
.jpg)
ISAIMINI.COM Download -
document.onkeydown = myKeyDownHandler; function myKeyDownHandler(event){ alert(event.keyCode) }