Hi,
I need it some info to help a client defend against a legal challenge.
Is there a MySQL function that will allow me to ascertain the date and
time that a particular field's value was last updated. I can't find
anything in the MySQL documentation.
Thanks very much.
Mark
--
Fast,
--- Kishore Jalleda [EMAIL PROTECTED] wrote:
check the permissions on the mysql data dir, may be
the user mysql or
who ever runs mysql does not have sufficient
privileges
Kishore Jalleda
I agree with Kishore, to elaborate his answer a little
longer I would ask the following.
- is
ps, I meant to delete the note from my draft
folder... sorry
Enrique Sanchez.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's ||We live in the outer space
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of records.
And I want to list them only last 12 months (that mean last 1 year) records
exactly.
For that I tried using the following query, but it list sometimes 13 months
when the current
Hi Green,
Thanks for guiding me to the manul, i some how missed this section of the
manual.I was more keen on adding and removing log files url.
Thanks once again.
regards
anandkl
On 10/18/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Ananda Kumar [EMAIL PROTECTED] wrote on 10/17/2005
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of records.
And I want to list them only last 12 months (that mean last 1 year) records
exactly.
For that I tried using the following query, but it list sometimes 13 months
when the current
I made backup of database issuing 'mysqldump --opt
--skip-extended-insert' from command line on 4.1.5-gamma-log, FreeBSD.
When I try to restore data from backup into same server, data is
corrupted! How is this possible? What is the purpose of this program if
it cannot restore the very same
Unfortunately that would have to be designed into the system into a field.
When updated, the instructions would be to instruct that field to update.
Cheers
Mark:
I need it some info to help a client defend against a legal challenge.
Is there a MySQL function that will allow me to ascertain
news [EMAIL PROTECTED] wrote on 17/10/2005 15:45:15:
I need it some info to help a client defend against a legal challenge.
Is there a MySQL function that will allow me to ascertain the date and
time that a particular field's value was last updated. I can't find
anything in the MySQL
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Hiu Yen Onn wrote:
hi all,
i have a mysql which only localhost can be logged in. if i have created
an account [EMAIL PROTECTED], then, i cant login in as that host.
mysql -u user -h
Hello.
I don't think that it is possible to recover the data from the new
table, because ALTER operation creates a new table and fills it with
data (and truncates the data). But why did the system backup not help
you? Could you describe the situation more in detail. If you haven't
flushed
Hello.
I strongly recommend you to upgrade to the latest release (4.1.14 now).
If you still want the manual for you version, perhaps you could get it
from the appropriate distribution from:
http://downloads.mysql.com/archives.php
Luke Vanderfluit wrote:
Hi.
Where can I
Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Hello.
It is a bit strange, usually MySQL should be able allocate up to 2G
of memory. Check that summary memory usage of MySQL is less than 2G.
You may be interested in PAE extention. But to be able to use it
you should compile MySQL yourself. See:
Hello.
Very often InnoDB provides a better performance in
environment where a lot of concurrent SELECTs and
UPDATEs. Check if the problem still exists if you change
the engine of you tables from MyISAM to InnoDB.
M.E. Koch wrote:
Hello:
After haveing a look at the `show
Hello.
It is a bit confusing for me. Really, MySQL has all permissions for
reading those files. Do you have SELinux enabled? Sometimes it is
the source of the problems, you should have it properly configured.
Israel Fern$ndez Cabrera [EMAIL PROTECTED] wrote:
List: MySQL General
(response interspersed)
Jasper Bryant-Greene [EMAIL PROTECTED] wrote on 10/17/2005 07:49:36 PM:
Just recently (possibly since upgrading to MySQL 5.0.13 RC), I've been
getting the following error with queries like the one below.
Unknown column 'photos.id' in 'on clause' (1054)
SELECT
I need it some info to help a client defend against a legal challenge.
Is there a MySQL function that will allow me to ascertain the date and
time that a particular field's value was last updated. I can't find
anything in the MySQL documentation.
MySQL doesn't store change histories. That's
Is there a way I can create a table on MySQL using Access and
establish a link remotely?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[EMAIL PROTECTED] wrote on 10/18/2005 06:28:03 AM:
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of
records.
And I want to list them only last 12 months (that mean last 1 year)
records
exactly.
For that I tried using the
Scott Hamm [EMAIL PROTECTED] wrote on 10/18/2005 09:46:20 AM:
Is there a way I can create a table on MySQL using Access and
establish a link remotely?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
You can write some
Gleb,
I don't think that it is possible to recover the data from the new
table, because ALTER operation creates a new table and fills it with
data (and truncates the data). But why did the system backup not help
you? Could you describe the situation more in detail. If you haven't
flushed you
R,
I tried using the following query, but it list sometimes 13 months
when the current date is in the middle of the month.
SELECT * FROM t WHERE DATE_ADD(dt, INTERVAL 1 YEAR) = NOW();
Try...
DATE_ADD( dt, INTERVAL
IF(YEAR(NOW())%40 AND YEAR(NOW())%100=0,366,365)
DAY ) = NOW()
Possible solutions. Has not tried all of it myself.
1. Create ODBC connection to your MySQL database, using MySQL
Connector/ODBC - this works, sometimes gives problems
2. Try to use MS-Access Pass-Through query to create tables - never
tried this way.
3. Do search for link tables in MS Visual
Hello list
I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all
connections with MySQL through MyODBC 3.51.11 have problems
I install the Access on a pc without updating and the driver works fine.
This version of Access is 10.25... something.
I download again MyODBC
grKumaran wrote:
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of
records. And I want to list them only last 12 months (that mean last 1
year) records exactly.
For that I tried using the following query, but it list sometimes 13
Jon,
using a 4 GB buffer pool is safe in a 64-bit computer, and allocating
50 % - 80 % of memory to the buffer pool is recommended in an
InnoDB-only server.
Regards,
Heikki
Oracle/Innobase
- Alkuperäinen viesti -
Lähettäjä: Jon Frisby [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
- Original Message -
From: grKumaran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 16:08
Subject: query help
: Hello,
:
: CREATE TABLE t (
: dt datetime
: )
:
: Please assume this is the table structure and contains thousands of
records.
: And I want to list
First of all thanks for you answer...
would you like to give me some hinst about what should me condifured in SELinux?
best regards
Israel
On 10/17/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
It is a bit confusing for me. Really, MySQL has all permissions for
reading those files.
The attachment was stripped by the list manager: forwarded to list for
general information
Shawn
- Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM -
Shawn Green/Unimin
10/18/2005 11:48 AM
To
nikos [EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Access 2002 hangs with
[EMAIL PROTECTED] wrote on 10/18/2005 12:01:50 PM:
- Original Message -
From: grKumaran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 16:08
Subject: query help
: Hello,
:
: CREATE TABLE t (
: dt datetime
: )
:
: Please assume this is the table
Hi,
The following query will probably work but I think it will be easier to pass
the minimum date from your application.
SELECT * FROM t WHERE (year(dt)=year(Now()) and dtNow()) or
(year(dt)=year(Now())-1 and month(dt)month(Now()))
Also you might want to check the other Date and Time functions
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.2
The FIRST LASSO TIPS FOR MYSQL
- http://www.listsearch.com/lassotalk.lasso?id=143312
The LAST LASSO TIPS FOR MYSQL
- http://www.listsearch.com/lassotalk.lasso?id=154176
10
: : Hello,
: :
: : CREATE TABLE t (
: : dt datetime
: : )
: :
: : Please assume this is the table structure and contains thousands of
: records.
: : And I want to list them only last 12 months (that mean last 1 year)
: records
: : exactly.
: :
: : For that I tried using the following
Hi to all!
I have tables products and categories
CREATE TABLE categories (
cat_id INT(6) NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED NULL,
cat_status ENUM(0,1) NULL DEFAULT 0,
PRIMARY KEY(cat_id),
INDEX
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/18/2005 01:50:20 PM:
Hi to all!
I have tables products and categories
CREATE TABLE categories (
cat_id INT(6) NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED NULL,
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 10/18/2005 12:01:50 PM:
- Original Message -
From: grKumaran [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 16:08
Subject: query help
: Hello,
:
: CREATE TABLE t (
: dt datetime
: )
:
: Please assume
Oops! My bad! :)
original name for categories and products are ac_categories and
ac_products. but I wanted to simplify and deleted ac_ part - but not
on all places. And my simplified query become mess query. Sorry.
But, you got a point. And I got the answer.
And ac_products_categories
Dobromir Velev wrote:
Hi,
The following query will probably work but I think it will be easier to pass
the minimum date from your application.
SELECT * FROM t WHERE (year(dt)=year(Now()) and dtNow()) or
(year(dt)=year(Now())-1 and month(dt)month(Now()))
Also you might want to check the
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 1:50 PM
Subject: one product in more categories
Hi to all!
I have tables products and categories
CREATE TABLE categories (
cat_id INT(6) NOT NULL AUTO_INCREMENT,
cat_name
grKumaran wrote:
Hello Folks,
It is great help. Thank you all and specially for Michael and Shawn. It
does work properly in 4.1.9-max. But I think, LAST_DAY function does not
availble in old MySQL version 4.0.??, so there I have problem, actually our
webserver is still in that version. So
Hello.
First check the contents of /var/log/messages. SELinux usually puts
there some notes about what it is doing. I'm not a SELinux expert, but
quick search at fedora.redhat.com has shown me that I should use
system-config-securitylevel utility for configuring SELinux.
Israel
Hello.
This is the same problem that Delyan Toshev reported on
September 18 2005 4:27pm but that post is still unanswered:
Are you sure that you have the same problem (the same character set
settings, same broken cyrillic characters and so on)? If not, please,
provide as much info as
Hello.
As a sidenote - shouldn't MySQL raise an error when data gets truncated?
MySQL raises a warning after such ALTER operation. See:
mysql create table dt(a decimal(4,1));
Query OK, 0 rows affected (0.01 sec)
mysql insert into dt set a=999.1;
Query OK, 1 row affected (0.00 sec)
For the same project (below) I have problem with building table for
product prices.
In regular online store, price is usually part of the products table.
But, I need a solution for multiple prices. E.g.
QTY -2550 100 200
Price - $1.59 $1.39 $1.19 $0.99
Also, if
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 18, 2005 4:26 PM
Subject: Re: one product in more categories
For the same project (below) I have problem with building table for
product prices.
In regular online store, price is usually
afan,
For the same project (below) I have problem with building table for
product prices.
In regular online store, price is usually part of the products table.
But, I need a solution for multiple prices. E.g.
QTY -2550 100 200
Price - $1.59 $1.39 $1.19 $0.99
nikos wrote:
Hello list
I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all
connections with MySQL through MyODBC 3.51.11 have problems
I install the Access on a pc without updating and the driver works fine.
This version of Access is 10.25... something.
I download
Are there any difference between max_connection and max_user_connection?
thanks!
_
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
My kernel version is 5.0.12.
When i learn the manual,i didn't find any variables in the manul when i
used show variables.Weither there is a lack of manual updating?
thanks
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
liulian,
In mysql,server system variables's function like server option function.
How do i choosing between the server opiton and the system variables.
thanks!
MySQL has more than 300 system variables that can be set in the option
file my.cnf/ini, on the server command line, and/or with SELECT
At 10:13 +0800 10/19/05, ⧠àÆ wrote:
Are there any difference between max_connection and max_user_connection?
thanks!
The difference is explained here:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL
In mysql,server system variables's function like server option function.
How do i choosing between the server opiton and the system variables.
thanks!
_
与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL
At 10:11 +0800 10/19/05, ⧠àÆ wrote:
My kernel version is 5.0.12.
When i learn the manual,i didn't find any
variables in the manul when i used show
variables.Weither there is a lack of manual
updating?
Did you look here?
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
I want to know when i need using the server option and when i need the
server system variables.In other words,can i using server system variables
replace all server options.
thanks.
From: Peter Brawley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: 王 旭 [EMAIL PROTECTED]
CC:
My kernel version is 5.0.12.
When i learn the manual,i didn't find any variables in the manul
when i used "show variables".Weither there is a lack of manual
updating?
Some system variables can be read by running mysqld --help or mysqladmin
variables from a command line. Some can be SET
Hi all,
We are a group of three students in Professor Ric. Holt's Software
Architecture class at the University of Waterloo. As our project, we
would like to examine the MySQL source to determine the best way to
implement materlialized views.
What we would like to know is:
1. How feasible
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named bdb_..,but i can't find these
variables used show variables.
From: Paul DuBois [EMAIL PROTECTED]
To: 猝 嗥 [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: I can't find any variables used show variables
At 13:49 +0800 10/19/05, ⧠àÆ wrote:
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named
bdb_..,but i can't find these variables
used show variables.
Your server probably doesn't have BDB support compiled in.
From: Paul DuBois [EMAIL PROTECTED]
To: ý
59 matches
Mail list logo