Hello ts. Tanaka,
I've tried your way and succeed. Thank you.
But I want to ask your help again what if the result will be like this:
A. Cat A
- Subcat A
- Subcat A
2. CatB
- Subcat B
possible by using br or div
which the previous result is
Cat A - SubcatA, SubcatA
Cat B -
and also id (either cat or subcat) can be called
- Original Message -
From: HaidarPesebe haidarpes...@gmail.com
To: MySQL Lists mysql@lists.mysql.com
Sent: Wednesday, May 30, 2012 2:31 PM
Subject: Re: category with parentid
Hello ts. Tanaka,
I've tried your way and succeed. Thank
Hello everyone,
There's only a few days left to get a massive discount of 70%
on all database development products at Upscene Productions.
www.upscene.com
Database tools for:
- Firebird
- MySQL
- Microsoft SQL Server
- Oracle
- InterBase
- NexusDB
- Advantage Database
- ADO ODBC
--
With
Welcome to Hopper!
Claudio
Thank you Claudio, we hope it will serve it's purpose and we get lots of
feedback on it.
2012/5/25 Martijn Tonies m.ton...@upscene.com
Dear ladies and gentlemen,
Upscene Productions is happy to announce the launch of a new
database-developer tool:
Hopper
On 05/07/2012 12:30 PM, Zhangzhigang wrote:
Thanks, i thought about this answer in the past, and i appreciate your reply.
How about the omelet?
What's your method?
--
RMA.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Pesebe-san,
I'm sorry to i'm not clear what do you want to do.
do you mean like this? (exampled by Perl)
#---
use DBI;
$cn = DBI-connect(DBI:mysql:test,root,);
$st = $cn-prepare(SELECT t1.name AS cat,GROUP_CONCAT(t2.name) AS
subcat FROM `table` AS t1 LEFT JOIN `table` AS t2 ON t1.id =
Dear MySQL users,
MySQL 5.5.25 is a new version of the 5.5 production release of the
world's most popular open source database. MySQL 5.5.25 is recommended
for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL
Check performance with script :
http://mysqltuner.pl/mysqltuner.pl - Variable tunning
http://hackmysql.com/mysqlidxchk - Unused Index
Thanks,
Prabhat
On Thu, May 24, 2012 at 4:32 PM, Rick James rja...@yahoo-inc.com wrote:
Thanks. I got tired of answering the same questions about buffer_pool
Hi Anupam,
You can achive this by circular replication, Circular replication between 4
nodes works fine. but not sure with 50 node server how practical it was.
Each database node will be a data center,
*Node 1 - data center 1* *-* *Node 2 - Data center 2* *-* *Node 3 - Data
Center 3* *-* *Node
I have mysql 5.1.62-0ubuntu0.11.10.1 installed, but the sort order for
utf8-unicode doesn't seem to be right. It is sorting some text like this
(order by title):
!
! *`-=[];',./~@#$%^()_+{}|:?\
!
![
!@
!a
!A
!t
!test
'Coal age'
[
\--\
100 years
when it should be (shouldn't it?):
!
!
Hi Wes, have you double checked you character set and collation ??
http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html
The collation is which determines the sorting order.
Carlos Proal
On Wed, May 30, 2012 at 4:02 PM, Wes James compte...@gmail.com wrote:
I have mysql
I'll double check and get back.
Thanks,
-wes
On Wed, May 30, 2012 at 3:43 PM, Carlos Proal carlos.pr...@gmail.comwrote:
Hi Wes, have you double checked you character set and collation ??
http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html
The collation is which determines the
In phpMyAdmin it says the database collation is utf8_unicode_ci and each of
the columns is utf8_unicode_ci except the ID primary key column.
If you create a simple table with ID and TITLE and put the data below (each
row in a record) and run 'select * from table order by title' what do you
get?
a and A are identical, according to utf8_unicode_ci and utf8_general_ci,
but not utf8_bin.
That is, I would not expect [ to slip in between them.
About 80% of the way down this page, there is a list of some of the
'equivalences' in selected collations:
http://mysql.rjweb.org/doc.php/charcoll
Caution!! If any one of them dies and cannot be recovered, you will have a
mess to fix.
From: Prabhat Kumar [mailto:aim.prab...@gmail.com]
Sent: Wednesday, May 30, 2012 1:43 PM
To: Rick James
Cc: Anupam Karmarkar; Nigel Wood; mysql@lists.mysql.com
Subject: Re: Architectural Help
Hi Anupam,
15 matches
Mail list logo