Hi,
I have some logging data from a webserver in a table and want to do some
analysis.
I infact want to see how many files are requested at one time.
To do this I
SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC
This gives me the number of requests at any time. I now want to see
Hi,
I want to CREATE a TABLE an specify a collation.
If I do
CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
If I omit the keyword DEFAULT the requested collation latin1_german1_ci
is shown by SHOW TABLE STATUS.
So
Hello 'mysql',
I found your address on http://lists.mysql.com.
I'm a freelance programmer from British Columbia, Canada,
with a college degree (well, almost) in computer science,
and four years experience. I'm currently looking for
programming contracts that I can fulfi
SELECT t2.`col1`, t3.`title`, t3.`col3`, t4.`published` FROM t1 LEFT JOIN
t2 ON (t2.`catid`=t1.`id`) LEFT JOIN t3 ON (t3.`id`=t2.`sid`) CROSS JOIN
`main_data` t4 ON (t4.`id`=t2.`sid`) WHERE t2.`catid`='7' AND
t4.`published`=1 GROUP BY `sid` ORDER BY t3.`title`;
What this does is to show all the
I copy the 3 MYD MYI frm of a database to another directory as a way of backup.
Is this the right way to do it. It appears to be not function correctly.
Any help appreciate.
Thanks.
