Jesse wrote:
I worked with the query for a while, trying equi-joins instead of JOINs,
and variuos other things. I found that the queries that I was using to
represent the TotMem & TotAdv columns was what was closing things down.
I finally ended up using a sub-query to solve the problem. I ga
> If this is so, IMNSHO it was a wrong decision:
> Zip codes are character strings, even though they may (in some / many
> countries) consist of digits only.
> Use a "char (n)" column for them, with "n" varying by country.
So did I, as in the char(n) however, the import script I wrote, in the
lang
Hi Dan,
Thanks for the clue!
Putting `Title` = 'var_a' (or combinations of \' or ` or \` or " ) was
putting var_a as the text in the table.
Resolution is:
begin
set @Populate = CONCAT('insert into ', tableName,' set OwnerID=0, Type=1,
State=0, Title=\'', var_a ,'\';');
PREPARE populate1 from @
MySQL has provided support for CJK languages (Chinese, Japanese, Korean)
for a long time. There's a chapter in the MySQL Reference Manual that
extensively covers MySQL character set support. Managing CJK data can be
particularly tricky, though. Therefore we've just added a FAQ section
that answers
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
> @cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
MySQL Gen
I have the following stored procedure that I'm using:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo VarChar(7))
BEGIN
Declare cPrefix VarChar(1);
Declare cNextInv VarChar(7);
Set cInvNo = '';
IF nChapterID > 0 THEN
Well that's good to know. This is a InnoDB engine db. I did try specifying
the how the fields and lines in the file are terminated to the LOAD DATA
INFILE program but I still get the same error message.
Still have no idea what I'm doing wrong. I was getting errors where the
program was complainin
I have skimmed through several pages of instructions on creating stored
procedures, and I can't seem to find when I should and should not use the
"@" symbol before a variable name? I have seen a lot of procedures where
it's always used, and I've written a procedure or two that doesn't use it at
Yes they're all right ! Database is the last thing on your problem list...
I don't know how you thought the system... if it's WEB based... more
problems arrise...
In a potential scenario... I miself would power up the database server
with an UPS... because it contains DATA... the application...
Hi all,
Running MySQL 5.0.22 Community on Win 2003 Server.
Can anyone give me some guidance as to what is wrong with the following SP?
It continually errors with "1054 Unknown column 'Individual' in 'field
list'. "
The SP is completing the drop table and the create table, but it is when it
comes
Chris White wrote:
On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote:
ALL I am asking is how strong you think MySQL stands up in such a
business scenario. I have even created the manual business procedures
for power-failure scenarios. I DO need to know HOW gracefully MySQL
will recover aft
I'm guessing that the way MySQL handles foreign language full text
indexing is through parser plug-ins and custom stop word lists. Am I
right? And If so, these must have been already created for the common
western languages such as German, French etc. Where can I find these
plug-ins? Is there an
Jesse wrote:
I need to delete some records based on a JOIN relation. The following
works in Microsoft SQL Server, and the syntax appears to be correct
for MySQL, but it reports "syntax..near 'DELETE FROM ConvInvDet FROM
ConvInvDet H...". What's the proper way to format this for MySQL?
DELETE
I need to delete some records based on a JOIN relation. The following works
in Microsoft SQL Server, and the syntax appears to be correct for MySQL, but
it reports "syntax..near 'DELETE FROM ConvInvDet FROM ConvInvDet H...".
What's the proper way to format this for MySQL?
DELETE FROM ConfInvD
Sounds like you have more potential problems than is typical. It also sounds like you may want to setup replication, even if the
data is replicated to an old, old computer that you were going to throw out. It's not a big deal if it falls behind in the
replication at times. And if you could get a
On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote:
> ALL I am asking is how strong you think MySQL stands up in such a
> business scenario. I have even created the manual business procedures
> for power-failure scenarios. I DO need to know HOW gracefully MySQL
> will recover after each power fai
Hi,
I have created 4, 5 and 8 column unique indexes ( I had to - the
application requirements dictated me to do so) on some tables in an
InnoDB only database on a 5.0.22 MySQL server running on XP-SP2
machine. The 4-col indexes are on order, invoice and receipt tables;
the 5-col indexes are on d
I worked with the query for a while, trying equi-joins instead of JOINs, and
variuos other things. I found that the queries that I was using to
represent the TotMem & TotAdv columns was what was closing things down. I
finally ended up using a sub-query to solve the problem. I gathered the
ba
Good point, should have included in my post. We were already using
mysqlhotcopy to make snapshots of our data in another directory, which
were then subsequently backed up to tape by the backup agent. We set
the backup agent to specifically exclude the live data directory,
/usr/local/mysql/dat
(My comments are at the bottom)
Greg Lehey wrote:
On Monday, 26 June 2006 at 10:41:16 -0400, [EMAIL PROTECTED] wrote:
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared o
The NAS does make snapshots periodically (every few hours), but it
doesn't look like the timestamps of the records match up with when the
backup would have run (the records are written each minute) so I
don't think that that is the cause.
What did you do to resolve the issue?
--
Mark P. Hennes
how about something like this, which finds one row (if any) with the
lowest in-stock price, UNIONs it with the highest out-of-stock price (if
any), and then returns just one row, including whether that was an
in-stock or out-of-stock price:
(SELECT col1, price, quantityOnHand, 1 as inStock
FR
Hi John,
On 6/24/06, John Hicks <[EMAIL PROTECTED]> wrote:
Karl Larsen wrote:
> ..I was glancing through
the mamouth
> MySQL reference manual ...
I worked on an Oracle-9i development project around two years back.
If I recall correct
Hi all,
We have an implementation of mysql servers, and are looking for a decent
SNMP monitoring package for them. We are looking to monitor replication,
queries per second, throughput, and slow queries.
Are there any decent packages that easily integrate?
Regards,
Matthew Juszczak
--
MyS
Wim, see http://dev.mysql.com/doc/refman/5.0/en/grant.html
When granting access to a user, you can do like
GRANT SELECT on db.* to 'user'@'%.domain.com'
which gives 'user' access to select from any table within 'db', provided
they are coming from a host in 'domain.com'. ('%' is a wildcard.)
Y
Yup... For now the problem stopped...
These humongos values were because they were initialized at MAX_INT on
that 64bit machine...
In the my.cnf file they were not mentioned at all !
2^64 - 1 == 18446744073709551615
Now look at the values below !
--
Gabriel PREDA
Senior Web Developer
On 6/22
Hey list;
I have a case where I need to fetch a product row from a table
containing price information about some products, and where every
product can have multiple rows but from different suppliers (thus with
different prices and stock information).
However, I'm trying to create a query which f
Hello
I would like to grant select access to a certain
mysql database from all computers in my local lan
without having to add every specific computer to the
user database , is this possible and how is this
done?
The purpose is to give all users the possibility to
access the addresslist table in
Hi all
I found the problem:
It was not related to the '*' what-so-ever, but to the way I started my console
client.
If I load it with --default-character-set=utf8 - the problem is solved (as my
table is set to have utf8 charset).
Thanks.
-Original Message-
From: Eitan Gur [mailto:[EMAI
On Tuesday 27 June 2006 08:11 am, Jesse wrote:
> How do I output messages to the screen during the execution of a Stored
> Procedure? In other words, what command in a stored procedure will allow
> me to sent output to the screen to indicate progress?
Well, you can use SELECT "message", but you'
How do I output messages to the screen during the execution of a Stored
Procedure? In other words, what command in a stored procedure will allow me
to sent output to the screen to indicate progress?
I'm using MySQL 5.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://l
Hallo
On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote:
> Christian, I hope raising the open_files_limit helps (I think it
> should). I second Brent's suggestion to enable the thread_cache.
>
> Please do report back and let us know how you fare.
The effect that lots of tables are i
On Tuesday 27 June 2006 03:35 am, 战芳 wrote:
> Hello everyone:
> I wanna connect to mysql server using PHP. My operating system is
> Redhat Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started
> the server using a statement like this: #>/usr/local/mysql/bin/mysqld
> -uroot& -S/va
Hi J.R.
Thanks for your response, but this did not help. If I try the same syntax on
other values (not '*') I have no problem...
-Original Message-
From: J.R. Bullington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 3:22 PM
To: mysql@lists.mysql.com
Subject: RE: Using replace
null values were not the problems. It was a bug in version 3.51.11 of the
ODBC driver, which I was using. I downloaded and installed version 3.51.12,
and the problem seems to have been resolved.
Thanks,
Jesse
- Original Message -
From: "J.R. Bullington" <[EMAIL PROTECTED]>
To: "'My
Found the problem. I upgraded to version 3.51.12 of the ODBC driver, and the
problem was solved.
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, June 26, 2006 4:58 PM
Subject: ASP Reporting EOF?
When I run the following query in my ASP A
I used to have this problem, but I solved it by using 'IS NOT NULL' in my
queries v. using
if rs(fld.value) <> ""
Here's something else from the MySQL manual... Don't know if this will help
or not...
***
ASP users: if you're getting empty recordset
returned when using COALESCE, add "OPTION=1638
I have found a bug report, #11541 which appears to be reporting the same
thing that I am reporting. However, it doesn't indicate that it has been
fixed. If it has not been, this is a serious flaw, and I will not be able
to convert this particular application over to MySQL as it's critical that
Yes, some of the fields have null values, but not the main key values. I've
also got another report I run in ASP which has null values in it as well,
but it doesn't report EOF. But how could a null value in one of the fields
make it appear EOF?
Thanks,
Jesse
- Original Message -
Fr
Peter, SHOW PROCESSLIST is a moment-in-time snapshot of connections and
their activities. It shows you what all is going on at the instant you
issue the command; it does not show you "recent" commands (even those
that happened a second ago).
Many of your queries are very likely so fast that y
I did read in the manual that the field level REFERENCES constraints
on InnoDB tables do not work as expected and one has to first define a
table level index and then create a table-level FOREIGN KEY constraint
for the field to make it work.
I believe this is just a hack to keep things faster...
Part of the problem is that you have a ' ' in between your REPLACE and your
(). The REPLACE function needs to have that space removed.
SELECT REPLACE(deviceID,'*','.*') FROM MY_TABLE;
Try that and see if it helps.
J.R.
-Original Message-
From: Eitan Gur [mailto:[EMAIL PROTECTED]
Sent:
Eko, you're not JOINing the two tables together - your database is
taking the time to produce a huge result set known as a cartesian
product, which is probably not what you want. You need to introduce an
additional WHERE clause specifying how the two tables should be JOINed, like
WHERE hiart0
Hi,
I want to get a full list of all queries being run at a specific moment...
If I look at mytop output, I'm hitting 500 queries per second.
If I do "show full processlist" though, I only see 1 query as output -
it's 'show full processlist' itself! And a few sleeping queries
sometimes.
How doe
Kim, if this is still going, can you post the output of SHOW FULL
PROCESSLIST; please?
40 MB doesn't sound like a lot of data but could be a fair number of
rows, and a complete table analysis and repair and index rebuild could
take a few hours.
Dan
Kim Kohen wrote:
Folks,
please forgive
Mark, any chance that a process on the NAS is accessing your data files
for some reason? Backups?
We had some severe crashing problems with MySQL years ago we eventually
traced to a backup process accessing the live data directory.
Dan
[EMAIL PROTECTED] wrote:
*** This happens for me using
Use a transaction and an InnoDB table.
http://dev.mysql.com/doc/refman/5.0/en/transactional-commands.html
Or, use the LOCK TABLES command:
http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html
An ideal solution (in my mind) is to use a stored procedure to read the
table, increment the current
Hi,
is is possible to show a list of all named locks (obtained by GET_LOCK)?
Best regards
Achim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In addition to Ben's answer...
> Hi All,
>
> I have been repeatedly trying to create the following table - without
> __ANY__ success. Looks like there is REALLY something wrong with the
> MySQL engine or something! Here is the script:
Posting the error itself would help.
Martijn Tonies
Databas
Andreas, if you are only using MyISAM tables, the included mysqlhotcopy
script may work for you. We used it at my previous employer with good
results. We would run it to create a snapshot of our data files every
day, then run a network backup utility that backed up the snapshot (but
did not a
Asif, I note 3 problems:
1 - your table is named 'order', which is a reserved word in MySQL and
most other db engines. I'd suggest using a different name. If you must
use 'order' for the name, enclose it in backticks, a la `order`, in the
create statement.
2 - you have IDNEX instead of IND
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the REPLACE command on this column:
SELECT REPLACE (deviceId, '*', '.*') FROM MY_TABLE;
But I get the following error:
ERROR 1270 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT),
(latin
Hi All,
I have been repeatedly trying to create the following table - without
__ANY__ success. Looks like there is REALLY something wrong with the
MySQL engine or something! Here is the script:
CREATE TABLE Order (
DID int not null,
DeskNo int
On Tuesday 27 June 2006 13:43, Veerabhadra rao Narra wrote:
> Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
> www.venadsolutions.com
> its
> not spam
> -Rao
I consider this as spam. I would suggest that this person is removed from the
list.
--
Jørn Dahl-Stamnes
homepa
On Tue, Jun 27, 2006 at 08:19:41AM -0300, Daniel da Veiga wrote:
> On 6/27/06, Andreas Widerøe Andersen <[EMAIL PROTECTED]> wrote:
> >Hi,
> >I have a few FreeBSD servers running various web/database things and I'm
> >looking for a good a reliable backup script that I can run through a
> >cronjob. I
Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
www.venadsolutions.com
its
not spam
-Rao
On 6/27/06, Andreas Widerøe Andersen <[EMAIL PROTECTED]> wrote:
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm currently running the latest version of mysql323, but will
upgrade to vers
Hi,
I did read in the manual that the field level REFERENCES constraints
on InnoDB tables do not work as expected and one has to first define a
table level index and then create a table-level FOREIGN KEY constraint
for the field to make it work.
I just would like to know if that's the case with
Hello Denis,
>
> I have a question related to the two MySQL data types mentioned in the
> subject. Are they totally identical or not?
>
>
> I am asking this question due to the problem I am facing right now. The
> thing is that yesterday I downloaded a tool named Advanced Data Generator
> for MySQ
Hello everyone:
I wanna connect to mysql server using PHP. My operating system is Redhat
Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started the server
using a statement like this:
#>/usr/local/mysql/bin/mysqld -uroot& -S/var/lib/mysql/mysql.sock
But when I call mysql_pconne
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm currently running the latest version of mysql323, but will
upgrade to version 4.1 soon aswell as upgrade most of the servers to the
latest
Hello list,
I have a question related to the two MySQL data types mentioned in the
subject. Are they totally identical or not?
I am asking this question due to the problem I am facing right now. The
thing is that yesterday I downloaded a tool named Advanced Data Generator
for MySQL (by Upsc
I have a query statement like this
select hiart01a.cust, hiarf01.nama, hiarf01.al2, hiart01a.tgl, hiart01a.netto,
hiart01a.muka
from hiart01a, hiarf01
where hiart01a.tgl>=from_days(to_days(now()) - 180) and
hiart01a.tgl<=from_days(to_days(now()) - 30)
order by hiart01a.cust;
when I run
You have at least 2 options (witch came instantly in my mind):
CONCAT_WS - concatenation with separator
SELECT CONCAT_WS('/', firstname, lastname) AS name FROM tablename
CONCAT - concatenation of arguments
SELECT CONCAT(firstname, SPACE(1), lastname) AS name FROM tablename
ATTN: SPACE(n) - gene
Hi Scott, all!
Scott Haneda wrote:
I need to update a column, if the string length is less than 5, I want to
add leading zeros to it until it has 5. These are zip codes, I think there
are no 00 leading zips, so most should all be four chars long.
This sounds like the columns were of a numeri
65 matches
Mail list logo
