Hi,
I am trying to do something like this in MySQL 5.0
create function myfunc(param_name varchar(100)) returns int
begin
..
if exists(select 1
from my_table
where name = param_name) then
return -1;
end if;
.
I have three(3) instances of an application inserting data into a MYSQL (4.X)
database. I have to change the password.
I would like to know, if I can change the password of the application on the
server without disrupting existing
connections then modify the password in the startup file for the
Hi Dan,
It would be a pretty large table of changes, but this solution would work,
if as you say, I don't mind making those sacrifices. Something to think
about. Thanks.
Ian
At 03:59 PM 1/20/2006 -0600, Dan Buettner wrote:
Perhaps you could use database triggers to keep track of these chan
Perhaps you could use database triggers to keep
track of these changes. I also think there's a
way you could make the change tracking a little
neater if you don't mind sacrificing some SQL
functionality and storing everything as text.
If you create a table "product_changes", with 4
columns
Rhino,
I appreciate your comments. This wasn't meant to be a real world
example. My actual application keeps track of changing data in a gas
network. I wanted to simplify the problem to help in finding an answer to
my dilemmas.
Ian
At 04:45 PM 1/20/2006 -0500, Rhino wrote:
Ian,
If I'm
Ian,
If I'm not mistaken, you started this conversation yesterday. I've been
watching the back-and-forth haphazardly and not really absorbing the full
details so forgive me if someone has already asked this and you've answered
it.
My concern, in hearing you state your problem, is that some o
sheeri kritzer wrote:
Hi folks,
I'm attempting to optimize a query -- it's quite a simple one, actually.
SELECT uid from Bill_Sales WHERE startDate > '[some date]';
mysql> show create table Bill_Sales\G
*** 1. row ***
Table: Bill_Sales
Cre
Marco,
Thanks for your help. I created this example to try to simplify my real
world problem. Clearly I didn't provide enough detail. Keeping with my
example, essentially I'm looking at product details that change over
time. Let's say I'm keeping track of boxes. Over time, the color or si
I am importing records from a text file into my DB. Each record in the text
file corresponds to six tables in the DB due to normalization.
So for example, an inventory record containing a part, vendor,
contactPerson, mpn etc...in ONE line of a text file, requires 6 inserts into
the DB.
Further m
Realized I should probably show the Bill_Sales table. . .
ls -lh Bill_Sales.*
-rw-rw 1 mysql mysql 104M Jan 20 15:11 Bill_Sales.MYD
-rw-rw 1 mysql mysql 97M Jan 20 15:11 Bill_Sales.MYI
-rw-rw 1 mysql mysql 9.2K Jan 3 13:43 Bill_Sales.frm
mysql> show table status like "Bill_Sales"
Hi folks,
I'm attempting to optimize a query -- it's quite a simple one, actually.
SELECT uid from Bill_Sales WHERE startDate > '[some date]';
mysql> show create table Bill_Sales\G
*** 1. row ***
Table: Bill_Sales
Create Table: CREATE TABLE
Martins wrote:
Hi!
I'm trying to figure out which platform to use on my new server.
Server's primary and almost only role is mysql, huge databases (can
grow up to terabyte or so), so I'm considering enough big ammount of
RAM which probably allso will grow over 4GB, so at this point I think
x86
Given two MySQL database on two separate boxes in the same rack, one is
a master and the other is a slave.
Is corruption on either db possible in the case of a power outage that
affects both boxes? What is the best way to avoid this? Is it possible
to "roll back" the last N transactions to a known
Hi all,
Having a bit of mysqldump trouble again. I've looked over the documentation
(again) and can't
seem to find the flag to make 'mysqldump' output "CREATE TABLE IF NOT
EXISTS". Any ideas?
Keep in mind, I never want to 'DROP IF EXISTS'. . .I simply want to CREATE if
it doesn't exist s
Hi!
I'm trying to figure out which platform to use on my new server.
Server's primary and almost only role is mysql, huge databases (can
grow up to terabyte or so), so I'm considering enough big ammount of
RAM which probably allso will grow over 4GB, so at this point I think
x86 32bit becomes pr
I installed MySQL, which runs an initialize script everytime I launch
the terminal, and it automaticlly logs me out, so I cant use the
terminal locally. I uninstalled MySQL, now I need to get rid of the
script and what calls it. I get the following when I launch the
terminal:
Last login: Fri Jan
Thank you. I tried this outside of the procedure and it works. However In
MYSQL 5 I get:
ERROR 1314 (0A000): PREPARE is not allowed in stored procedures
Is there a way without needing to use prepare?
Any idea why CAST(fdata AS UNSIGNED) doesn't work?
David Godsey
> Hello.
>
> You can use this
"Subscriptions" <[EMAIL PROTECTED]> wrote on 01/19/2006
06:13:06 PM:
> I'm not sure if this falls under a PHP topic or a MySQL topic, but I
have a
> table that contains a field that stores serialized data. Is there a way
to
> order a recordset by a piece of the serialized data? For example,
Giandomenico Sica wrote:
Hi,
I've a little problem with mysqldump.
I'm using wordpress in localhost.
Now I'd like to put online my wordpress website, including the related
mysql database.
In order to make this operation, I've used the command:
"mysqldump database name"
This will dump to the
Hello.
MySQL doesn't support this yet. The CHECK clause is parsed but ignored
by all storage engines.
Ferindo Middleton Jr wrote:
> I have the following table where I have a CHECK CONSTRAINT to check for
> logical data values but for some reason it's not working on INSERTs to
> the table. MySQL
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "wangxu" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about "CONTAINS SQL"
At 8:29 -0500 1/19/06, Rhino wrote:
I am copying the rest of the l
I posted this earlier, however it has a nasty SPAM tag attached to it, so
I thought I would resend it.
My end goal is to select arbitrarily large data from a BLOB column use
SUBSTR to pull out certain pieces of data and do some bit shifting and
masking on that data. I believe you can only do bit s
Hello.
You can use this technique:
drop procedure if exists test20;
DELIMITER $$
create procedure test20()
BEGIN
DECLARE fdata BLOB;
DECLARE foffset INT UNSIGNED;
DECLARE flength INT UNSIGNED;
DECLARE tmp_int BIGINT UNSIGNED;
SELECT 0xAB
Hello.
If you switch to the debug binary of the mysqldump, you will be able to
find the query which causes 1064 error. See:
http://dev.mysql.com/doc/refman/5.0/en/debugging-client.html
Rhino wrote:
> Just as a followup to my own remarks, I've tried running my backup
> script with the new synta
Hello.
A lot of depends on the type of your queries. Find out which of them
make the maximum load on the server and then tune your configuration.
ESV Media GmbH wrote:
> Hey,
>
> what do you think is the best configuration ( my.cnf ) for running a
> database,
> which many users access at the s
Hello.
In case it is an 'Access denied error' see:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
ESV Media GmbH wrote:
> Hi everyone,
>
> how can i import a database export from another database.
> I´ve got alway a permission error...
> I used mysqlimport & mysqldump...
>
>
Hello.
What data type are you using to store the result of AES_DECRYPT? Please,
send the CREATE statement for your table.
sharif islam wrote:
> On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
>>Hello.
>>
>>What doesn't work? In case you want more help please, provide the
>>results you wa
Hello.
Just a possible workaround - you can parse the output of mysqlbinlog and
replace the buggy statement with the correct one.
wangxu wrote:
> My mysql version is 5.0.16.
>
> My problem is similar to the bug.
>
> My sql mode is ANSI and TRADITIONAL
>
> If mysql can't do recovery with mysql
Hi, im hoping to solve a problem that is bugging me!
I just moved a database from a development server to production (test),
several of the fields have auto-increment ticked but as it is mainly a
data warehouse i thought nothing of it. I then found that a lot of my
queries were running slow
Hi Gents
Is it possible to sort char/varchars that only contains integers as integers
and not as characters. I can't use integer because the standard says it may
contain characters aswell. Currently I do this outside mysql in a
perl-procedure.
Whatever I try I get this order:
| 2000651
morten bjoernsvik <[EMAIL PROTECTED]> skrev: Hi Gents
Is it possible to sort char/varchars that only contains integers as integers
and not as characters. I can't use integer because the standard says it may
contain characters aswell. Currently I do this outside mysql in a
perl-procedure.
On Friday 20 January 2006 11:19, Giandomenico Sica wrote:
> Hi,
>
> I've a little problem with mysqldump.
> I'm using wordpress in localhost.
> Now I'd like to put online my wordpress website, including the related
> mysql database.
> In order to make this operation, I've used the command:
> "mysql
Hi,
I've a little problem with mysqldump.
I'm using wordpress in localhost.
Now I'd like to put online my wordpress website, including the related
mysql database.
In order to make this operation, I've used the command:
"mysqldump database name"
The work seems correct, but the problem is that I'm n
Hello Paul,
If it like your mean,these parameters aren't beneficial to help user to ensure
the correctness with their code.
On the contrary,mysql depend on these parameters to ensure the integrality and
security.
If it like this,these parameters increase use difficulty about user.
Should mysq
34 matches
Mail list logo