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
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:
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)
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
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
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
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;
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
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
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
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
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 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
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 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
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
