I have many tables like the table Person:below, in mysql database.
person_id, first_name,last_name, mi, gb_first_name, gb_last_name,
b5_first_name, b5_last_name, gender, dob
where different columns storing strings in different encodings. At anytime, a
web user can switch the language and the ap
Thanks a lot CJ. That's the cost of flexibility:-)
- Original Message -
From: Christian High
To: YL
Cc: mysql@lists.mysql.com
Sent: Sunday, April 22, 2007 12:45 PM
Subject: Re: Grouping Question
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
I have a co
I have a contact table looks like
id type owner_idowner_type value
11email21 person [EMAIL PROTECTED]
12phone 21 person 303-777-
13PO Box18 business 220
14cell
Dear List,
I have mysql server and php apps on the same machine, they worked very well.
The machine's OS is win2k pro
Mysql 5.0.15
Then I access the db from local network area 192.l68 And it worked fine
although I
have to reset my account privileges..
Then I tried to access it remotely by d
I'm setting up a mysql server on OS X Tiger powerbook for development.
I've also a mysql server on my win2k pro machine.
Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101
Both db servers work fine locally but I can connect from Tiger to Win2k
while not from win2k to Tiger.
The version of
I did nothing special to the mysql database for my english-chinese
multi-language web applications.
And it worded just fine.
column 'first_name' in this case is replaced by multiple columns according
to the number of languages:
first_name, b5_first_name, gb_first_name
Language is a session varia
x27;m wondering is that always doable or not and is there any guideling of doing
this?
Thanks a lot for any help/commends.
YL
Can you search Chinese with mysql client (shell)?
- Original Message -
From: "Carol Ku" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 01, 2005 10:56 AM
Subject: Chinese Characters
> Hi:
> I downloaded mysql 4.0 for a opensource library software called Koha. Now
I have trouble storin
at database level. Does this help the performance?
association_id is not refered very often, but address_id is. so I indexed
address_id in address_association.
Is it a good idea to index PKs for big table?
Thanks again,
YL
mysql> show create table address\G;
unsigned default NULL,
`status_code` tinyint(4) default NULL,
`gb_name` varchar(80) default NULL,
`b5_name` varchar(80) default NULL,
`path` varchar(80) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
ERROR:
No query specified
From: <[EMAIL PROTECTED]>
T
1444 | |
| 1 | SIMPLE | t0| ALL | NULL | NULL | NULL| NULL |
1456 | Using where |
++-+---+--+---+--+-+--+------+-+
3 rows in set (0.11 sec)
mysql>
- Original Message -
From: <[EMAIL PROTECTED]>
To: "YL" <[EMAIL PROTECT
Dear list, I need some inputs/help on my finding below:
5.0.15 make my view (below) almost useless compare with 5.0.1-alpha:
with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get
the result:
mysql>select count(1) from unit_address;
+--+
| count(1) |
+--+
| 143
1 | abc | (1,2,3) |
| 2 | bbc | (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
- Original Message -
From: Peter Brawley
To: YL
Cc: mysql@lists.mysql.com
Sent: Saturday, September 03, 2005 12:34 AM
Subject: Re: string->array question. ( 2 query questions)
ok at the values of options, they are like arrays. So my question
is how to fix query (4)? In other words, is there any function that
i can use to get the result illustrated in (4)?
- Original Message -
From: <[EMAIL PROTECTED]>
To: "YL" <[EMAIL PROTECTED]>
Cc:
Sent:
I've 2 basic questions. thanks for responses:
(1) Suppose i have a table with a varchar colum named options which stores
option id's in the form
"(id1, id2, , idk)", where id1,... are string representations of
positive integers. Given an integer i,
I want to fetch all ID's for the re
The following are the real tests but not the real logic i'll apply:-)
i have 4 very simple script files below and like to show you the performance differece
tst0.sql:
select t1.participation_id id, t1.owner_id from participation t1 where
(t1.participation_id in (24,469)) and
(t1.property_dic
16 matches
Mail list logo
