There is no icon. The best way to run MySQL is as a service. If you have
Windows NT, 2000 or XP you can install MySQL as a service as follows:
1. Open a command prompt.
2. change to the mysql bin directory (cd \mysql\bin).
3. type mysqld-nt --install. You should see a message saying service
Does anybody have any feedback, particularly problems, using CAST to
strip the trailing alpha characters from a string in order to convert
the string to an integer? Is there a better way to do it with MySQL?
(MySQL 4.0.20, Mac OS X 10.3)
Here's my situation:
TABLE_1
id CHAR( 8 )
TABLE_2
id
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs out a little
past 8.3 million.
It
At 19:02 -0700 on 06/18/2004, Paul Chu wrote about Re: Full Text
Index on Large Tables - Not Answered:
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Full Text Index
Hi all
how to do this in MySQL? Returning only records with COUNT 5?
SELECT
`groups`.`groupsDescr`,
`roles`.`roles_Agroup`,
`roles`.`rolesDescr`,
COUNT(`roles`.`rolesDescr`) AS TOTAL
FROM
`roles`
INNER JOIN `groups_roles` ON (`roles`.`rolesID` =
`groups_roles`.`fkrolesID`)
INNER
Robert A. Rosenberg wrote:
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million
inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs out a
You cannot do that in the WHERE clause. The WHERE clause determines which
rows to look at. That is, in this case, it determines which rows to count.
How can it choose which rows to count based on the result of the count?
See the problem?
Instead, you need to use the HAVING clause, which
Greetings:
Does anyone know of a standalone string function in MySQL that can return the
number of occurrences of a string within field? I need this for a CREATE TABLE
/ INSERT FROM exising_table implementation and am trying to keep the number of
parsing functions to a minimum.
Is FIND_IN_SET
Hi everyone,
ok, so I know how to use RLIKE to match regular expressions. However,
let's say I have an isbn number of:
0-06-430022-6
saved in the database but someone wants to search for it by entering:
0064300226
or even
006-430-0226
So the search query needs to have its dashes removed
Oh, I think I know this one.
Copied from my console:
mysql select * from test;
++-+
| id | myvalue |
++-+
| 1 | 12 |
| 2 | 15 |
| 3 | 3 |
| 4 | 10 |
| 5 | 10 |
| 6 | 10 |
++-+
6 rows in set (0.04 sec)
mysql select * from test
Hey, All:
I'm getting:
ERROR 1114: The table '#sql-3612_4' is full when trying to convert a MyISAM
table to HEAP with:
ALTER TABLE ns_sum_cats TYPE=HEAP;
mysql describe ns_sum_cats;
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default |
Hi Bob,
I think this might be in the wrong direction - my isbn is saved with the
dashes, so I would need it to look like:
select * from test where REPLACE('myvalue','-','') = '12';
which I'm not sure will work. When I get on my machine I'll give some
variations of this a try, thanks for the
Never Mind:
I set in /etc/my.cnf
max_heap_table_size = 256M
and, all is good.
Van
--
=
http://www.dedserius.com/-Linux rocks!!!
=
Van wrote:
Whoops. I was thinking about how I have my isbn table stored. ;) I
prefer to remove all formatting from numbers like this(isbn, phone
numbers, social security numbers, etc) before storing them. Anyway,
here's something that should work. I'm not sure if it is the most
efficient way to do
Greetings,
Last night I upgraded from 3.23 to 4.0.20 and when I try to start mysqld
it fails. The only entries I have in my error log are:
040620 23:44:19 mysqld started
040620 23:44:19 mysqld ended
I know this isnt' enough info to troubleshoot the problem. How can I
set the log level to
At 09:10 -0500 on 06/17/2004, gerald_clark wrote about Re: How to
monitor that slave is not working because of use:
The master will be trying to serve binlogs to the old address, but
the slave won't know this.
You could monitor the IP address, and stop and start the slave when
it changes,
but
I have a Sun Netra T1 with 512MB of ram and 2 x 9G drives. (One is
exclusively the MySQL 3.23.56 files, and the other is OS, Apache, etc.)
I am also using the default medium (I think) my.cnf.
Currently, the complaints are coming from a php Forum and a php picture
Gallery. From the OS side, I
17 matches
Mail list logo