Using Delphi to with this query: SELECT TOTAL :=
PRICE * QTY FROM
INV_PRODUCT
will caused error Parameter object is improperly
defined. Inconsistent or
incomplete information was provided. because Delphi
look it as Parameter (a
parameter of query in Delphi using : at the
beginning).
Is it
Thanks, Roger
You pointed me to the right direction.
The only part I had to change, was using the SET term once, as below.
UPDATE Data INNER JOIN Updates ON ...
SET Data.Jan = IF(Updates.Month = 1,Updates.Cell,Data.Jan),
Data.Feb = IF(Updates.Month = 2,Updates.Cell,Data.Feb),
Data.Mar =
On 17/11/2005, Peter Brodersen wrote:
I would like to select top three from different parts in the same
table, e.g. for the following data set:
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
fid INT NOT NULL,
d INT NOT NULL
);
INSERT INTO foo VALUES
(1, 10), (1, 20),
Hi.
I want to backup one table from a database, where one of the columns saves
the passwords. If I use mysqldump I got the value in encrypted format, but I
need to backup the table to load the table in mysql 4.1. The original table
is a mysql 3.23 database.
Iago.
Hello,
Am I correct in thinking that if there are no dependencies
between the multiple statements then the various statements
are executed simultaneously by separate threads in the
server?
If so is there any way to turn this behaviour off and just
use multiple query execution
I try to run
./configure --with-ndbcluster --prefix=/STEFAN/mysql-5.1.2-binary
--with-partition --with-row-based-replication --with-innodb
--without-berkeley-db --enable-thread-safe-client --enable-shared
but it fails with
checking for termcap functions library... configure: error: No
Is there a way to list the privilidges that a user has in MySQL?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If I defined I stored procedure as root I can't be able to call this
procedure from a normal user.
I tried to grant it the execute method but the sintax seems wrong
For example suppose a simple store procedure like this:
CREATE PROCEDURE `test_root`()
BEGIN
declare a int default 0;
END
if I
Jesse Castleberry wrote:
Is there a way to list the privilidges that a user has in MySQL?
Thanks,
Jesse
http://dev.mysql.com/doc/refman/5.0/en/show-grants.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Jesse Castleberry wrote:
Is there a way to list the privilidges that a user has in MySQL?
Thanks,
Jesse
Yes.
SHOW GRANTS FOR [EMAIL PROTECTED];
Did you even try the manual
http://dev.mysql.com/doc/refman/5.0/en/show-grants.html?
Michael
--
MySQL General Mailing List
For list
Is there a way to list the privilidges that a user has in MySQL?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Jeremy,
Thank you for your help.
I do have an exact situation you have assume I have. Here is the output
of SHOW CREATE TABLE
+---+---
Thank you for your help, Shawn. I had to dig a little, but I found the
way to set the global variable to a larger size and was able to complete
my restore.
I may yet get the hang of this. :-)
Joseph Tito Kraer
Business Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
hi,
i just inherited a mysql server 4.1 and need to run mysql_fix_privileges on
it.
However one of the databases hosted on it is production and I'd rather avoid
it to be down.
I ran the script on an 4.0 server test that I had installed and which was
running when I ran the script. I had no
Hello.
If default-character-set can't set in [client]?
The comprehensive explanations you will find at:
http://bugs.mysql.com/bug.php?id=11673
wangxu [EMAIL PROTECTED] wrote:
Follow is a part of my my.ini.
I tried to investigate my previous problem with statements containing LIKE
clause on a specific table. The problem was basically the following:
mysql SELECT count(*) FROM user WHERE username LIKE 'o%';
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (0.00 sec)
Hi Mikhail,
Thank you for your help.
I do have an exact situation you have assume I have. Here is the output
of SHOW CREATE TABLE
`price_data_ticker` char(8) NOT NULL default '',
`price_data_date` date NOT NULL default '-00-00',
...
UNIQUE KEY `tidadx`
Is this something new with mysql 5, a bug, or something I'm missing? I'm
not able to switch databases.
[EMAIL PROTECTED] 5.0.15-0-es4]# rpm -ivh
MySQL-client-standard-5.0.15-0.rhel4.i386.rpm
MySQL-devel-standard-5.0.15-0.rhel4.i386.rpm
MySQL-server-standard-5.0.15-0.rhel4.i386.rpm
[EMAIL
I figured out a problem I was having, and just wanted to pass the solution
along to anyone who may run into the same problem in the future. I've got a
new problem now, but I'll deal with that in a separate message (if
necessary).
I was getting the error, #42000SELECT command denied to user
Hi Jeremy,
This is still work in progress but here are some samples of queries we
will be running, that involved this table and this date field:
==
#this fails -- join on is horrible
update COMPANY_NUMBERS left join TICKER_HISTORY_PRICE_DATA
on
I'm using the following code in my ASP.NET application to add a new record
to the database, and return the added ID:
Cmd=New MySqlCommand(sp_InsertNewCamper,Conn)
Cmd.CommandType = CommandType.StoredProcedure
paramReqID = Cmd.Parameters.Add(return,SqlDbType.Int)
paramReqID.Direction =
Mikhail Berman wrote:
Dear Jeremy,
Thank you for your help.
I do have an exact situation you have assume I have. Here is the output
of SHOW CREATE TABLE
CREATE TABLE `TICKER_HISTORY_PRICE_DATA` (
`price_data_ticker` char(8) NOT NULL default '',
`price_data_date` date NOT NULL default
Simon,
If your tables are too big, you want to archive/delete some
information. I certainly cannot guide you on what to delete.
What you describe below isn't going to do anything. From the
documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html):
Someone just asked this on the list, and another person answered --
MySQL recommends a 'gradual upgrade' --
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
It all depends on what code is running against your database, etc.
Read the upgrade section, it will help you devise a plan to figure
René Fournier wrote:
...that is the question.
I have some queries that would possibly benefit from subqueries, which
means upgrading my stock Mac OS X Server 10.3.9 installation of MySQL
(version 4.1.10a).
The question is, and I would appreciate any comments, should I go just
to 4.0.26
Mikhail Berman wrote:
Hi Jeremy,
This is still work in progress but here are some samples of queries we
will be running, that involved this table and this date field:
==
#this fails -- join on is horrible
What do you mean by fails? Takes too long?
Jesse,
I'm using the following code in my ASP.NET application to add a
new record
to the database, and return the added ID:
You may have persuaded dotNet that your sproc returns something, ie
that it is a function, but you apparently created it as a procedure. An
sproc returns nothing.
PB
Michael,
Thank you for your comments.
This give me a new ideas how to work with this issues.
And, no at this point we are not planning to work with price_data_ticker
field itself.
Regards,
Mikhail Berman
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent:
MySQL can use the index on one of the columns in a multi-column index,
with caveats.
If this is your index,
UNIQUE KEY `tidadx` (`price_data_ticker`,`price_data_date`)
and you plan to use price_data_date in all your queries, but never
price_data_ticker, then simply reverse the order of the
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established,
however, queries seem to
I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load
MySQL on boot? I don't see a script file that came with the installation.
Thank you.
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
If you´ve installed mysql from ports the startup sript is under
/usr/local/etc/rc.d/
Change its permissions to be extecutable
I hope that this help you
Regards!
++
| ISC Edwin Cruz García |
| IT Manager |
|
Andrew Kuebler wrote:
I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load
MySQL on boot? I don't see a script file that came with the installation.
Thank you.
Andrew
Place a script called mysql-server.sh in /usr/local/etc/rc.d
#!/bin/sh
case $1 in
start)
Hi,
0. stop the web server or avoid hitting the db !
1). Backup everything! :)
the mysqldump should suffice.
2). do the alter
The alter does already a create table with new data and then exchance
table. You need 2x the storage space though.
3. do the opposite of 0.
--
Pooly
Webzine Rock
Tripp Bishop wrote:
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established,
Michael, you hit the nail on the head. We added
--skip-name-resolve and changed our connnection string
to use the IP instead of FQDN and now things are
working fine. It must have been something with our
DNS/ISP since we changed nothing and that stuff is out
of our control.
The other thing was
sheeri kritzer wrote:
Simon,
If your tables are too big, you want to archive/delete some
information. I certainly cannot guide you on what to delete.
What you describe below isn't going to do anything. From the
documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html):
Andrew Kuebler wrote:
I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load
MySQL on boot? I don't see a script file that came with the installation.
Thank you.
Andrew
Hi Andrew,
You need edit your /etc/rc.conf file and add the following line:
mysql_enable=YES
Which
Hi,
I'm on Solaris 9 with mysql 4.1.
I've moved the datadir to a new location, and edited the mysql start script
directly so that it now has the line:
datadir=/export/www1/data
The server restarts no problem, and my phpBB web app can talk to it no
problem.
However when I try to connect to it
Hello.
It is strange for me that there isn't a stack trace. If you can
- switch to the debug version of MySQL and run it under gdb
to find out where it is crashing. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html
Thank you Heikki!
We had a problem where code in one of our program's EJB did not turn the
FK CHECK back to 1.
Another program that was started afterwards caused some bad data to be
inserted in the database - as though the FK CHECK was = 0. It wasn't
until we turned the FK CHECK back to 1 in the
Hi,
I'd ask some questions on MySQL cluster. Does anyone know if there is any
email alias for the cluster questions?
Thanks,
Jenny
On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote:
I'd ask some questions on MySQL cluster. Does anyone know if there is any
email alias for the cluster questions?
Yes, there is a mailing list for MySQL Cluster:
http://lists.mysql.com/cluster
Jim Winstead
MySQL Inc.
--
MySQL
Hi!
I have this code:
form method=post action=search.php
Search:
input type=Text name=SearchSalesperson size=35 value=?=
$_POST['SearchSalesperson'] ? maxlength=25
input type=Submit name=SubmitSearch value=Search
/form
and this
#searching for salesperson
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements contradict each other. Either you are getting case
insensitive search, meaning that it *is* the same if you enter afan,
Afan or AFAN, or you're getting
Hi,
I know select .. update could lock selected rows, if the connection not
release the lock, others always wait.
If I use get_lock() to get a logical lock by key xxxtable+xxxrow , but
others may not update other database on the same server .
What function could detect a row locked (by select ...
I know a lot more about DB2, my main database, than MySQL. However, MySQL
frequently does the same things in the same ways as DB2.
_If_ MySQL behaves the same way as DB2 in this regard - and I do not know if
it does - there is no function to determine if a given resource is locked.
Instead,
on 11/18/05 2:27 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Any ideas?
Set the field type to binary, or use your php to compare the result to the
entered result.
--
on 11/18/05 7:18 AM, Peczöli Zoltán at [EMAIL PROTECTED] wrote:
The result of the second query matches that of the corresponding LIKE
query, but the first seems to be correct.
Any ideas what the problem might be?
You are getting strange results. At this point I would suggest dumping the
Mysql increment backup technique is different from others.When a binlog file
be created after enable binlong?
thanks!
50 matches
Mail list logo