Hi Comunity,
I am facing concurrency problem. The scenario is, I have a table, the
primary key of that table say 'uid' is a unique number, which is used by my
application. So every time i fire a query, i get max(uid) i read this
ResultSet from my Java application. I increament this uid to +1.
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
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) -
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
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
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 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
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 MySQL (by
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
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
Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
www.venadsolutions.com
its
not spam
-Rao
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'm
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
homepage:
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
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),
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
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
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
Database
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]
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
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
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
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 does
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
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:
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
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
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 -
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
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=16384
to
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 mysql@lists.mysql.com
Sent: Monday, June 26, 2006 4:58 PM
Subject: ASP Reporting EOF?
When I run the following
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: 'MySQL
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
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
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 in
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:
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
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're
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
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
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
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.)
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
--
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 correctly,
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
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.
(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
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,
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
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
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
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
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
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'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
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
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
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...
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
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
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
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
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
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
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
language I
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
66 matches
Mail list logo