Query for generate increament Row Number Column
Sunday, 25 April 2010 12:38
Kategori : MySQL | 0 | 147 views

  try this query code :

select @rownum:=@rownum+1 'NO', p.barang_name from barang p, (SELECT @rownum:=0) r order by barang_name asc limit 5;

result :
NO | barang_name
---------------------
1 | Barang name 1
2 | Barang name 2
3 | Barang name 3
4 | Barang name 4
5 | Barang name 5
read more..

Import CVS File into MySQL database?
Friday, 24 October 2008 01:06
Kategori : MySQL | 0 | 1412 views

  I have more than 70.000 row data to execute and input to mySQL database..
hmm... Think fast.. CVS file is the solution for upload all the data to your database server.. don't think to do import SQL query... It cannot be done.. so slow.. and waste your time... maybe can be memory leak.. read more..

[ First ] [ Prev ] - 1/1 - [ Next ] [ Last ]

Visitor
There were 15482 user(s) here
Your IP : 38.107.191.92
Your Browser : Unknown
Country : UNITED STATES
~~~~~~~~
Latest Visitor
8thSep10 03:55| UNITED STATES
8thSep10 03:54| UNITED STATES
8thSep10 03:52| UNITED STATES
8thSep10 03:41| UNITED STATES
8thSep10 03:40| UNITED STATES
8thSep10 03:28| UNITED STATES
8thSep10 03:09| UNITED STATES
8thSep10 02:47| POLAND
8thSep10 02:46| UNITED STATES
8thSep10 02:43| BRAZIL
Search Subject |Auto Complete

Links