Hi,
I am having problem migrating a arabic vbulletin database from a remote
server to my server, as it shows strange characters , or what we call
charset or encoding issue and I have not been able to get past and fix it.
On my server
mysql> show variables like 'char%' ;
+---
Hi,
Thanks for the prompt reply. I have tested yours and it seems to be
working. What about to group the result by week? TIA.
Willy
Your life would be very empty if you had nothing to regret.
-Original Message-
From: Daevid Vincent <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Cc: sangp
On Thu, 2008-12-04 at 08:27 +0700, sangprabv wrote:
> Hi,
> I get stuck to build a query to select records between curdate() and the
> last 4 weeks and groupped by week. I tested with:
>
> "SELECT *
> FROM momtbak
> WHERE insertdate
> BETWEEN curdate( )
> AND curdate( ) - INTERVAL 4 week"
>
>
Hi,
I get stuck to build a query to select records between curdate() and the
last 4 weeks and groupped by week. I tested with:
"SELECT *
FROM momtbak
WHERE insertdate
BETWEEN curdate( )
AND curdate( ) - INTERVAL 4 week"
It doesn't work. Please help, TIA.
Willy
Every why hath a wherefore. --
Hi All,I need tom combine two ndb cluster db and one MyISAM db and one
InnoDB db together using one mysqld demon,
can anyone help me to build the my.cnf?
ndb cluster details
ndb node1 = 172.18.18.1
ndb node2 = 172.18.18.2
ndb_mdmd1 = 172.18.18.3
ndb_mdmd2 = 172.18.18.4
myisam db details
mysqld
If this is a web app, then it should be making a new connection every
time a page is loaded (where applicable). At least that's how every PHP
site I've ever made works...
If this is a stand alone app, if your language has threads you could
(hackily) have a thread that does some "NO-OP" every hour
I am trying to develop an db app w/ OO base as the front end to mysql
db that is running on the web in a shared hosting environment using
jdbc as the connector.
The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get it to
recon
For embedded server do I need to configure
--with-embedded-privilege-control?
It looks like stored procedure is looking for mysql.proc table.
Thanks.
On Wednesday 03 December 2008 08:39:54 Paul Nowosielski wrote:
> Hi,
>
> Please, can anyone lend a hand in helping pullout
> phone numbers from the DB that only match
> the format (nnn) nnn- ?
"("[0-9]{3}") "[0-9]{3}-[0-9]{4}
I think
HTH
W
> SELECT phone_work FROM leads WHERE phone_work REGEX
The reason ur getting empty result set is becuase both tables have
raw_mat_id (1,2).
Insert a new record into raw_materials and not into raw_materials_product,
then you would get the missing record.
On 12/3/08, Nigel Peck <[EMAIL PROTECTED]> wrote:
>
> Nigel Peck wrote:
>
>> Ananda Kumar wrote:
>
>Description:
running mysql_install_db does not correctly fill grant tables
>How-To-Repeat:
run mysql_install_db; attempt to connect, fail.
>Fix:
Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL**
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Adam Thompson
>Organization:
Nigel Peck wrote:
Sorry, make that:
SELECT `Raw_materials`.`raw_mat_id`, `Raw_materials`.`name`
FROM
`Raw_materials`
LEFT JOIN
`Raw_materials__Products`
ON
`Raw_materials`.`raw_mat_id` =
`Raw_materials__Products`.`raw_mat_id`
WHERE
Nigel Peck wrote:
Ananda Kumar wrote:
did u try this
select * from raw_materials where raw_mat_id not in (select
raw_mat_id from
raw_materials__Products);
Hi Ananda,
Thanks for this, I'm really looking to do this in a single SELECT, for
efficiency. I'm sure it's possible with a join but j
Ananda Kumar wrote:
did u try this
select * from raw_materials where raw_mat_id not in (select raw_mat_id from
raw_materials__Products);
Hi Ananda,
Thanks for this, I'm really looking to do this in a single SELECT, for
efficiency. I'm sure it's possible with a join but just not sure how.
I'
did u try this
select * from raw_materials where raw_mat_id not in (select raw_mat_id from
raw_materials__Products);
On 12/3/08, Nigel Peck <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I'm having trouble figuring out how to construct a query and am hoping
> someone can help...
>
> I have three ta
Hi all,
I'm having trouble figuring out how to construct a query and am hoping someone
can help...
I have three tables:
Raw_materials
+++---+
| raw_mat_id | name | count |
+++---+
| 1 |
when I start mysql 5.1.30 up it fails to startup,the error info is:
*[ERROR] Error message file '/usr/local/mysql/share/english/errmsg.sys' had
only 617 error messages,
but it should contain at least 619 error messages.
Check that the above file is the right version for this program!*
I setup mys
This seems to do it:
SELECT phone_work FROM leads WHERE phone_work REGEXP '[(]{1}([0-9]){3}[)]{1}[
]?([^0-1]){1}([0-9]){2}[ ]?[-]?[ ]?([0-9]){4}'
- Original Message
From: Paul Nowosielski <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, December 3, 2008 2:39:54 PM
Subjec
18 matches
Mail list logo
