Best groupmember,
I run version 3.23.58 and need to use something similar to DATEDIFF and
TIMEDIFF to calculate difference between two a timestamp and
current_timestamp().
Is there any other function that is working for version 3.23.58 that do the
same job?
Best regards,
Peter Lauri
--
MySQL
Peter Lauri schrieb:
Best groupmember,
I run version 3.23.58 and need to use something similar to DATEDIFF and
TIMEDIFF to calculate difference between two a timestamp and
current_timestamp().
Is there any other function that is working for version 3.23.58 that do the
same job?
Best regards,
Gabriel Mahiques schrieb:
My name is Gabriel, Saludos Cordiales is the same than Best Regard
in spanish.
The server explanin is the same. The table structure is the same, the
application is the same (redirect the data source only), the quantity
of record is the same. All is the same, I copy
Hi all,
I found something strange with calculate field query in MySQL 5.
My base table structure like this :
CREATE TABLE `BrgIn2` (
`PO` varchar(17) NOT NULL default '',
`BrgId` int(10) NOT NULL default '0',
`Qty`
Hi,
I need to add another value in an enum so ALTER TABLE table1 MODIFY
Status ENUM('a','b','c') where 'c' is the new value. My problem is
that the tables are VERY big and it would take days to alter them all.
So, i figure the values in enum:s are in the .frm file so why not change
it and
Jörgen Winqvist schrieb:
Hi,
I need to add another value in an enum so ALTER TABLE table1 MODIFY
Status ENUM('a','b','c') where 'c' is the new value. My problem is
that the tables are VERY big and it would take days to alter them all.
Tried it?
I also use big tables but adding a field
I get this error:
Fehler in
/home/virtual/site4/fst/var/www/html/adminheaven/artikel-vererben-save.php
in Zeile 36 mit Error:br
Query:INSERT INTO objektflyer_verknuepfung
(av_o_id_haupt,av_o_id_link,av_text,av_op_id) SELECT
418,av_o_id_link,av_text,av_op_id FROM objektflyer_verknuepfung WHERE
Barry wrote:
Jörgen Winqvist schrieb:
Hi,
I need to add another value in an enum so ALTER TABLE table1 MODIFY
Status ENUM('a','b','c') where 'c' is the new value. My problem is
that the tables are VERY big and it would take days to alter them all.
Tried it?
I also use big tables but
Hi Barry,
see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
you cannot insert into a table you're doing select on
(same goes for update).
Regards,
/Johan
Barry skrev:
I get this error:
Fehler in
/home/virtual/site4/fst/var/www/html/adminheaven/artikel-vererben-save.php
Johan Höök schrieb:
Hi Barry,
see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
you cannot insert into a table you're doing select on
(same goes for update).
But i am doing it on a test server version 5.x and it works like a charm :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for
Hi,
I'm trying to resolve why InnoDB is crashing. It happened twice for the last
month without obvoius reason
Any help will be appreciated.
Dobromir Velev
My Server is
Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp
Dual 3.2 GHz Intel Xeon
8 GB RAM
with 3 x 146GB
Thank you Dan,
I will try that.
Mikhail Berman
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 5:29 PM
To: Mikhail Berman
Cc: Chris White; mysql@lists.mysql.com
Subject: Re: Q2. Is there anything could be done to speed up this query
In the
Hi everybody, Please I need help on this.
I am beginning a new application. I am doing it with VB 6.0 - MySQL 5.0 -
MyODBC 3.51 on Windows
Is there any parameter i need to establish in order to be able to work with
RecordSets in the Client side , actually i can't because if i
Hi all,
I've got a database I recently inherited where there are a number of
records in the mysql.user table that have no user id. According to the
mysql docs, this is supposed to allow guest access, and there is mention
of how to turn it off.
How does one actually connect in guest mode? My
In the last episode (May 04), Hendro Suryawan said:
Hi all,
I found something strange with calculate field query in MySQL 5.
My base table structure like this :
CREATE TABLE `BrgIn2` (
`Qty` decimal(10,3) NOT NULL default '0.000',
`Price`
What is the best way to create a coded field? I want to do something
similar to enumeration but I don't want to have to define the values at
table creation time because sometimes the end-users need to add or remove
the codes.
I've been using char binary fields in my database to this point
Hi. im trying to add a second slave using load data from master ,and
it seems to me that when i run this command on the
new slave that its simply picking up from where the first slave is
replicating from. Does this make sense? Also interesting is that
when both the IO and SQL threads are No on
Hi,
MySQL 4.1.19, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not
I assume you are referring to this thread:
http://lists.mysql.com/mysql/197528
If so, a very important question still stands: What version of MySQL are
you using?
MySQL replication uses the binary log (binlog) to pass update queries
(INSERT, UPDATE, etc) to the slave; in other words it
Hi,
I have doubt on Mysql download and installation
1.Which mysql download is better to install on production server
rpm installation or binary installation or source installation
2.What are the difference between them.
Regards,
Shivaji.
(catching up on old mail) What version of MySQL are using? It
works in 5.0.19 and 5.1.9-beta. If you're trying on a version 5.0,
it won't work.
-Sheeri
On 4/9/06, Daevid Vincent [EMAIL PROTECTED] wrote:
I'm trying to follow the example in the manual to create a trigger:
Well I would not bother with the source distro as it can
take a while to compile, and possibly end up being slower
than a pre-compiled version.
Personally I would choose between the .tar.gz or the RPM
versions.
The RPM version is basically self-installing, and
also installs the scripts to
Coming to the table SOOO late. But this has special relevance as I'm
working on an application that stores event dates and therefore will
also need to solve this problem.
The biggest question I have is What will this be used for? My first
thought is to have at least 2 tables -- one table with
I don't think I noticed the original post for this discussion when it first
arrived - or maybe I did and mistook it for spam having to do with social
dating ;-) - but I just saw Sheeri's reply and want to jump in if I may.
Most professional databases in corporate environments that I have seen
(again, apologies for the lateness...)
MySQL has a cost-based optimizer. If it's deciding that a full-table
scan is appropriate, there's a reason. If more than 30% (approx) of
the table would be returned in a range query, the optimizer reasons
that it's LESS expensive to just do a full table
On 5/4/06, sheeri kritzer [EMAIL PROTECTED] wrote:
(again, apologies for the lateness...)
MySQL has a cost-based optimizer. If it's deciding that a full-table
scan is appropriate, there's a reason. If more than 30% (approx) of
the table would be returned in a range query, the optimizer
Not sure if you're still having this problem. But if MySQL can't open
the file orders_pay_methods.InnoDB I'd check the permissions in the
mysql datadir.
-Sheeri
On 4/18/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I'm trying to make an backup of a database and this is what I got:
I'd check to make sure you installed mysql-devel, which includes the
libraries and header files.
-Sheeri
On 4/18/06, tuxlinsecure [EMAIL PROTECTED] wrote:
Hi,
I uninstalled Mysql 3.23 (tar.gz )and installed Mysql 5.0 (rpm) on my server.
When I check shared lib dependencies using the
Can the program write to /var/lib/mysql/mysqlmanager.log? check permissions.
On 4/19/06, Duzenbury, Rich [EMAIL PROTECTED] wrote:
MySQL 5.0.20
I've got two instances running with mysqlmanager. I'm not getting any
logging of any sort.
mysqlmanager --help shows:
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from it, and you're able to update the view?
Yet when you SELECT with an ORDER BY clause, you're not allowed to
update the view?
I just do not understand how a read statement affects DML. I think
you're going to have to
Keith Roberts thanks for the input ,i have few doubts on your reply.
1.when i am installaing rpm based files, should my operating system contains
the necessary files that are build on rpm packagei.e compilers,gccversions etc.
2.if i want to create more than one instance on my server with same
The following are Cold Fusion code. It's interesting that previously
defined queries can be used as 'tables' to pull data from. In MySQL, does
the same functionality have to be implemented using join or subselect?
===
CFQUERY name=getprojects datasource=#dbname#
On Thu, 4 May 2006, Shivaji S wrote:
To: [EMAIL PROTECTED], mysql@lists.mysql.com
From: Shivaji S [EMAIL PROTECTED]
Subject: Re: Mysql on Production Servers
Keith Roberts thanks for the input ,i have few doubts on your reply.
1.when i am installaing rpm based files, should my
thanks keith...
Regards,
shivaji
On Thu, 4 May 2006, Shivaji S wrote:
To: [EMAIL PROTECTED], mysql@lists.mysql.com
From: Shivaji S [EMAIL PROTECTED]
Subject: Re: Mysql on Production Servers
Keith Roberts thanks for the input ,i have few doubts on your reply.
1.when i am installaing
I'm sorry if this is not the apropriate list, but I couldn't fined any
other list where this question would fit in. If someone know where to
post it, please suggest.
I have a question about collation and utf in mysql.
I'm using mysql on several of my websites, but the mysql database
doesn't
Bing Du wrote:
The following are Cold Fusion code. It's interesting that previously
defined queries can be used as 'tables' to pull data from.
===
CFQUERY name=getprojects datasource=#dbname#
SELECT db_entry_num, title
FROM
This query running fine on 4.0.25 but when trying
on
3.23 an error occurs.
can one help me to find correct command for 3.23?
Probably if you post the error message you get.
DELETE FROM A
USING A
RIGHT JOIN B ON B.id = A.sectionid
WHERE B.id is null
error message on 3.23 is:
You have an
Hello,
I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386)
using readline 4.3 on a Dual Xeon 2.4Ghz RHEL4 box with 4GB of RAM.
I have a query that takes anywhere from .25 - .85 seconds to run.
Following are the query and the related table structures I have
currently set
As it was already advised, check the dir/log file permissions.
Also, it might help if you post your my.cnf here.
Petr
On Wed, 2006-04-19 at 13:17 -0500, Duzenbury, Rich wrote:
MySQL 5.0.20
I've got two instances running with mysqlmanager. I'm not getting any
logging of any sort.
Hi.
I recently imported a dumpfile into mysql4.1.18
I did this using the 'source' syntax from inside the mysql client.
this is syntax I used:
mysqlcreate database dbname;
mysqluse dbname;
-unset the creation of bin-logs in my.cnf
mysql SET SQL_LOG_BIN = 0
then some tips to fast import dump
Hi,
Anybody know how can i safely and easily rename a database in MySQL 5.0.19.
Have tried some tips from google results (most of them are for MySQL 4.x)
but no luck till now.
Any help would be greatly appreciated.
Rgds/Hardi
Hey,
been trying to output a select statment to a file, all the books I have
only show how to input from a file, what is the correct way
I thought I could do select * from my_toy `/tmp/my_toys`
But I get an error.
Payne
--
MySQL General Mailing List
For list archives:
Payne wrote:
Hey,
been trying to output a select statment to a file, all the books I
have only show how to input from a file, what is the correct way
I thought I could do select * from my_toy `/tmp/my_toys`
But I get an error.
Payne
You can use the 'tee' command, eg:
tee
Hi Manuel,
I had a similar problem a few months ago and I found 'somewhere' in the
documentation
a post by Matthew van Os on May 27 2005, saying:
The CursorLocation should be of the type adUseClient instead of
adUseServer.
The adUseServer returns a -1 as recordcount.
The adUseClient returns
Hi Payne.
Payne wrote:
Hey,
been trying to output a select statment to a file, all the books I
have only show how to input from a file, what is the correct way
I thought I could do select * from my_toy `/tmp/my_toys`
You can do 'select * into outfile from table name;'
But I get
45 matches
Mail list logo