In infinite wisdom Adarsh Sharma wrote:
> Dear all,
>
> I have million of sites stored in url column of a mysql table.
>
> Some few examples are :-
>
> www.facebook.com/home
> I want to take the output in a tsv file the sites url in the below forms :
>
> com.faebook.com/home
> com.yourguide.a
- Original Message -
From:
To: "shawn wilson"
Sent: Thursday, July 14, 2011 1:28 AM
Subject: Re: How to Shuffle data
You could parse the URLs into different fields and save these to specific
fields (TLD, subdomain etc) in the database
which will then allow you to do an order by sel
On Jul 13, 2011 6:41 AM, "Adarsh Sharma" wrote:
>
> Dear all,
>
> I have million of sites stored in url column of a mysql table.
>
> I need to shuffle the . words . Is there any in built function in mysql to
achieve this.
>
Why would you want to do this in mysql? What's your programming language
2011/07/13 16:10 +0530, Adarsh Sharma
www.facebook.com/home
adelaide.yourguide.com/news/local/news/entertainment/cd-review-day-and-age-the-killers/1401702.aspx
abclive.in/abclive_business/2393.html
abclive.in/abclive_business/assocham_manufacturing_companies.html
abclive.in/abclive_busine
> How about:
>
> select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
> t1.oid<100 order by t2.pv
>
> Mike
Very nice and simple. Thanks Mike!
Also Thanks Singer X.J. Wang and shawn wilson.
best regards,
Elim
--
MySQL General Mailing List
For list archives: http://lists.mysql
At 01:26 PM 7/13/2011, you wrote:
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
| .|
+-+-
On Jul 13, 2011 2:26 PM, "Elim Qiu" wrote:
>
> I have a prime table
> +-+--+-+
> | oid | pv | descipt |
> +-+--+-+
> | 1 |2 | NULL|
> | 2 |3 | NULL|
> | 3 |5 | NULL|
> | 4 |7 | NULL|
> | 5 | 11 | NULL|
> | .
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
| .|
+-+--+-+
what the query will be
Do i need to move output to a CSV file & then write a Java or C code for it.
I think a procedure can do it easily , If I know the proper function for
that.
Thanks
wal...@waltertross.com wrote:
What you want to do is not shuffle, but reverse the domain order, starting
from the TLD (top level
What you want to do is not shuffle, but reverse the domain order, starting
from the TLD (top level domain). You may pick the string functions you
need from the string functions page of the manual, but the problem is that
there may be any number of subdomains, so that in principle you would need
a l
Hi!
SQL Maestro Group announces the release of AnySQL Maestro 11.7, a
powerful tool for managing any database engine accessible via ODBC
driver or OLE DB provider (MySQL, SQLite, PostgreSQL, SQL Server,
Oracle, Access, etc). The new version is immediately available at
http://www.sqlmaestro.com/pro
Am 13.07.2011 12:40, schrieb Adarsh Sharma:
> I need to shuffle the . words . Is there any in built function in mysql to
> achieve this.
>
> Thanks
do not use any random-functions of mysql even if they exists
http://bugs.mysql.com/bug.php?id=59253
signature.asc
Description: OpenPGP digital
Dear all,
I have million of sites stored in url column of a mysql table.
Some few examples are :-
www.facebook.com/home
adelaide.yourguide.com/news/local/news/entertainment/cd-review-day-and-age-the-killers/1401702.aspx
abclive.in/abclive_business/2393.html
abclive.in/abclive_business/assocham_
13 matches
Mail list logo
