On Tue, 7 Oct 2003 16:48:55 -0400, Jim wrote
Hi,
I need to be able to 'delete' records from table(s) but still
maintain their information for an audit trail.
I'd rather not have a field for a deleted flag and have to condition
all the queries on the table on the state of this flag.
I use 4.0.14 and 4.1.0-Alpha
Thanks
Emery
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 16:45
Subject: Re: error messages in different languages
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
Yup, there is a
Some are free, others are commercial.
But, note that most of these are mainly for administration purposes.
For example phpMyAdmin is a free PHP based client.
Do you know some programming language? Like Visual Basic, C, C++, Java, PHP,
...
You said that you are able to run queries, ...
How do you
Well, it seems to me, that he is looking for some replacement of oracle
reports ... Which is ... As far as i know ... Something like MS
Access-Report-Wizard where you can say: Take this table, this field,
link it to this field in the second table, show me all records which
have date = TODAY and
So Ken Menzel says:
Hi Jacco,
Perhaps the manual needs to be enhanced, but it is only a guide,
perhaps the language should be softened or 'error 136' modified that
it could be either problem. Either way I hope this fixes you problem,
my guess would be you have very large rows of data,
Unfortunately, they have not implemented a reporting tool in that client.
that's the problem, as I was trying to find some sql commands to edit the
report, such as report titles.
Do you know some programming language? Like Visual Basic, C, C++, Java,
PHP,
i know them, but as I mentioned
thanks for your nice advice. *dummy users* --- let's see.
- Original Message -
From: Michael Haunzwickl [EMAIL PROTECTED]
To: 'Director General: NEFACOMP' [EMAIL PROTECTED]; 'Wang Feng'
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 6:03 PM
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they
What is the correct syntax for using a Exponentiation operator in MySQL?
BTW is this even posible?
bye, Bob
http://www.beheervisie.nl/disclaimer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote:
What is the correct syntax for using a Exponentiation operator in MySQL?
It's not an operator but a function. Look at EXP and POW in the docs:
http://www.mysql.com/doc/en/Mathematical_functions.html
Regards,
Fred.
--
Fred van
Michael,
Couldn't help myself to read your words again, and I have to say you r so
stupid and annoying, at least today (i'm in a bad temper today).
Although I don't use Access often, I don't say Access is for dummy users.
In my opinion, every programming language and any tool has its own depth.
So listen guy, this is a big miss understanding:
What i wanted to say, and what i did say was:
1.) If you want to have an easy way tool for creating your reports -
use MS Access
2.) All this things do not have anything to do with the base of your
datas (either you use Oracle, MySQL, Access or
Paul
How about
select FIRST_NAME, count(*)
from a table
group by FIRSTNAME
having count(FIRST_NAME) 1
Mike
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person
So listen guy, this is a big miss understanding:
NO
1.) If you want to have an easy way tool for creating your reports -
use MS Access
Hey, man, inserting a record is also ealier in Access. = You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy users,
So listen guy, this is a big miss understanding:
NO
1.) If you want to have an easy way tool for creating your reports -
use MS Access
Hey, man, inserting a record is also ealier in Access. = You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy users,
Access is not a Database, its a kiddies toy.
You can just as easlily make your reports using crystal reports or any thing
else like that if you really want to, or PHP/ASP
Now, please, for suggesting there is any use what so ever in the world for
access, please take your self out back and
I have 2 tables: currencies and quotes
currencies
==
id currency
-
quotes
==
id date id_currency value
---
Index (date, id_currency - UNIQUE)
In order to find the most recent value for a currency I use the following
logic:
1. SELECT
On Wed, 2003-10-08 at 09:52, shaun thornburgh wrote:
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00
Add LIMIT x,y (x is first row and y the number of rows 1.e. 1,1 for
first row) at the end of the SQL and order the SQL. Not sure if this
helps, just initial thoughts.
On Wed, 2003-10-08 at 13:04, Ciprian Trofin wrote:
I have 2 tables: currencies and quotes
currencies
==
id
Please take this flame war off list.
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: 08 October 2003 11:31
To: Michael Haunzwickl; 'Director General: NEFACOMP';
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: printing reports
Importance: Low
So listen guy,
Sorry about that, those were jokes to entertain you experts. I know you guys
work hard everyday, so just made some funs.
Now Stop! :-)
cheers,
feng
- Original Message -
From: Andy Eastham [EMAIL PROTECTED]
To: Mysql List [EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 9:29 PM
1.) If you want to have an easy way tool for creating your reports -
use MS Access
Yep if you know Access
WF -- Tools are for dummy users, Clever users create tools. --
Clever users select the best way they can do things for themselves
What is best depends on user knowledge and objectives (
One of the best things is to listen from diffrent opinions from different
people who have different backgrounds. :-)
cheers,
feng
- Original Message -
From: DeBug [EMAIL PROTECTED]
To: Wang Feng [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 9:42 PM
Subject:
I'd hardly call it a war, more of a skirmish, if that. perhaps at best
it should be considered a Terrorist action, don't think it even gets up to
an Act of Terror which is good, because I don't want the American Jack
Boot of Opression on my back, thank you very much.
- Original
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.9, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
It is now available in source and binary form from the Connector/J
download pages at http://www.mysql.com/downloads/api-jdbc-stable.html
and
I have a slave that has been running for a long time without any problems,
but now its not replicating any more. So I tried to do a LOAD DATA MASTER;
which always gives me this error now:
Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port:
3306
031008 15:07:59 Slave I/O
you are not using Debian testing by any chance? If so last time I did
an apt-get upgrade it broke mysql and I fixed it by doing a reinstall.
On Wed, 2003-10-08 at 14:13, Søren Neigaard wrote:
I have a slave that has been running for a long time without any problems,
but now its not replicating
Pada Wed, 8 Oct 2003 15:13:00 +0200
Søren Neigaard [EMAIL PROTECTED] menulis:
what was the show slave status output ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No its Redhat, and i have made absolutly no updates :(
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:23
To: Søren Neigaard
Cc: '[EMAIL PROTECTED]'
Subject: Re: Sudden error when replicationg - please help
you are not using Debian testing by any
I attached the output from show slave status.
/Søren
-Original Message-
From: Dicky 'Mas Saint' [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:28
To: [EMAIL PROTECTED]
Subject: Re: Sudden error when replicationg - please help
Pada Wed, 8 Oct 2003 15:13:00 +0200
Søren Neigaard
* Ciprian Trofin
I have 2 tables: currencies and quotes
currencies
==
id currency
-
quotes
==
id date id_currency value
---
Index (date, id_currency - UNIQUE)
In order to find the most recent value for a currency I use
I have an app for which people can submit plans.
Each plan relates to a particular product.
A new plan can be submitted for the same product, so each plan has its own
submission number. (1,2,3...)
Each plan is composed of artifacts.
The (artifacts) table looks like this:
artifact_id INT
product_id
Arthur Maloney [EMAIL PROTECTED] wrote:
I have recently reformatted my hard disk and done
a clean install of 4.0.15 on Win 2k Pro SP4.
I used C:\ C:\mysql\bin\ mysqld --install
This created a mySQL service and it works ok.
I happened look at a log in the data folder
and noticed
) In MySQL we don't have subselect. this is not valid:
SELECT article, dealer, price
FROM shop s1
WHERE price=(SELECT MAX(s2.price)
FROM shop s2
WHERE s1.article = s2.article);
instead of this, in MySQL we can write:
CREATE TEMPORARY TABLE tmp (
BTW, I tested the SELECT(MAX) part of this separately, and discovered that MySQL
doesn't like the single quotes around the table name, so I took them out.
Now THIS query works:
SELECT MAX( plan_submission_number )
FROM artifacts
WHERE product_id = '1'
-- (returns '2')
But this one still
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
I use 4.0.14 and 4.1.0-Alpha
Hmm .. I have comp-err.exe in 4.0.14, but it's absent in 4.1.0.
Thanks
Emery
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 16:45
Er, I _used_ a basic SQL tutorial, which specifically said that should work.
The problem seems to be a limitation of MySQL, not general SQL operation.
That being said, are there any clever one-query options (using JOINs, etc?) or
is this basically a 2-step process in MySQL?
--
Mark Wilson,
On Wed, 2003-10-08 at 15:06, Mark Wilson wrote:
Er, I _used_ a basic SQL tutorial, which specifically said that this should
work. The problem seems to be a limitation of MySQL, not general SQL operation.
That being said, are there any clever one-query options (using JOINs, etc?) or
is this
Michael Stassen wrote:
Cal Evans wrote:
or '' (empty string). You can change this behavior by building your own
mysql from source with the -DDONT_USE_DEFAULT_FIELDS compile option.
Thanks, I'm off to recompile my development server.
you should be able to define a field as NOT NULL without a
Problem 1 : Your query contains a subquery :
SELECT MAX( plan_submission_number )
FROM 'artifacts'
WHERE product_id = '1' )
subqueries are (AFAIK) not supported in the latest production version of
MySQL (4.0.15) but are coming soon...might already be in a beta ver
Two possible solutions -
I think exp(number, number) will do the job.
Check the manual for the correct syntax.
Thanks
Emery
- Original Message -
From: Bob Brands [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 11:16
Subject: Exponentiation operator
What is the correct syntax for
Hi list,
I have the following problem and here is the message that displays the
console when I try to connect
Warning: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
I'm using linux, Red Hat 7.3 Linux version
any idea, how to export data to a file on the remote machine?
thanx for the help anyway
Nitin
- Original Message -
From: Andy Eastham [EMAIL PROTECTED]
To: Mysql List [EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 9:49 PM
Subject: RE: how to export data from multiple tables
Nitin,
Subqueries don't show up until v4.1 which I have running on one of my servers. Runs
great and I have it into production.
--ja
On Wed, 8 Oct 2003, Rory McKinley wrote:
Problem 1 : Your query contains a subquery :
SELECT MAX( plan_submission_number )
FROM 'artifacts'
WHERE product_id =
it seems that time gives the hour, minutes, seconds.
is there a way to get tenths and hundreths?
how about without hours?
basically, i'm wanting to store lap times for racing.
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
What machines are you working with at each end? Internal network?
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 10:19 AM
To: Andy Eastham; Mysql List
Subject: Re: how to export data from multiple tables
any idea, how to export data to a
* [EMAIL PROTECTED]
it seems that time gives the hour, minutes, seconds.
is there a way to get tenths and hundreths?
how about without hours?
Not as a data type, but see the DATE_FORMAT() function:
URL: http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333
basically, i'm wanting
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run mysql.server stop then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but I also know there are times I need to work on
At 10:45 -0700 10/8/03, Bruce Dembecki wrote:
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run mysql.server stop then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but
I am learning the DBA ropes on a MySQL 4.0.14 database. I am working on
a backup strategy and I have a few questions. But first, a bit about the
database: we are collecting messages from a customer, storing them in
a table, then pushing the data to a master database. The messages are
inserts into
We have a script that deletes records from a database that are over then
a certain date. We had no problem running the delete on 3.x, but on
4.0.14, we are having a problem.
Here is the command that does the delete:
$EXECPATH/mysql --host=hostname --user=blah --password=blah --execute=delete
Here is the script that creates the database.
create table object_attrib (obj_record_id INTEGER(7) AUTO_INCREMENT NOT
NULL,
PRIMARY KEY (obj_record_id),
INDEX (rel_obj_int_id),
FOREIGN KEY (rel_obj_int_id)
REFERENCES obj_id_internals (obj_int_id)
ON DELETE RESTRICT ON
At 18:22 + 10/8/03, Croniser Brian Contr AFRL/IFGB wrote:
Here is the script that creates the database.
create table object_attrib (obj_record_id INTEGER(7) AUTO_INCREMENT NOT
NULL,
PRIMARY KEY (obj_record_id),
INDEX (rel_obj_int_id),
FOREIGN KEY (rel_obj_int_id)
I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use
--force (or is it --nodeps, I can never remember) because MySQL wants
libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question
(coming from that other world) why aren't these dependencies 0.9.6,
or
greater, instead of being
Hi all. I am needing to do a backup of two smalldatabases, both live on
the same server and under the same Mysql binary installation...
I would like to back them up, dump them into a file(s), make my move,
install the same database, and then restore/load this dumped
information
back into the new
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for
select purposes from within an application script. They are normally imported in the
early morning.
I now have a need to Insert into a table from an application script. The insert works
when submitted through
I'm under the impression that your over thinking the problem.
LOOK-UP the functions DATE_SUB / INTERVAL / TIME_TO_SEC / TO_DAYS and
the arithmetic should be easy.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
Let's say I have the following table (t1):
++--++
| id | c1 | c2 |
++--++
| 1 | NULL | 1 |
| 2 | a| 1 |
| 3 | NULL | 2 |
| 4 | b| 2 |
| 5 | NULL | 3 |
| 6 | c| 3 |
| 7 | NULL | 4 |
++--++
I would like to delete all rows that c1 =
I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the
next messages in the ../var/*.err file:
mysqld started
/home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13)
031008 15:18:16 Could not use dns1-bin for logging (error 13)
031008 15:18:16
The query optimizer will not recognize an index on an innodb table. tranfer_logs is an
innodb
table, auth_user is not. As demonstrated below, trans_team is not even recognized as
a possible
key when EXPLAIN SELECT is used. (my apologies for the extra wide message). I am not
sure if this
is an
Try the following:
SELECT a.*
FROM artifacts a left join artifacts higher
on a.product_id = higher.product_id
and higher.plan_submission_number a.plan_submission_number
WHERE a.product_id = '1'
AND higher.product_id is null;
For anyone following this, I'm using some sample code,
Now that I listen to you Michael, you must probably know how MySQL
refers to NULL values on a logical sentence, e.g. If(something=NULL...)
How do I get TRUE on a logical sentence if I want to refer to it as If
it is NULL do...?
Thanks on advance,
Miguel Ernesto
-Mensaje original-
De:
I have imported 1000s of records into a table and even spent some time
cleaning up characters which I messed up as I imported them (not the
fault of the DB layer, but the result of bringing things into a text
editor), but now I have the following problem.
I have a whole series of author and
You cant have subqueries (select from where) in the where clause.
On Wed, 2003-10-08 at 15:00, Mark Wilson wrote:
BTW, I tested the SELECT(MAX) part of this separately, and discovered that MySQL
doesn't like the single quotes around the table name, so I took them out.
Now THIS query works:
Hi Heath,
MySQL cannot use the trans_team query because you're using !=, for which
an index is never used (currently anyway). Do you think that trans_team
is the best index that will find the least rows and produce the fastest
result? If so, you can try using the following, which can be
Hi all:
There is a question:
Two tables:
table_out: ( fields ) product_name,out_count , out_date
table_in: ( fields ) product_name,in_count , in_date
I want to create a table that show the remain of product.
Can you help me??
thanks in advance!
--
MySQL
Hello,
I've searched the manuals and any websites I can find but am still at a loss
on how to calculate what I thought was going to be an easy 'Average' of Call
Times.
Situation. Have a table which is updated daily for users metrics and have
configured one column as TIME which should have
I have a table let's call it (old) containing items of interest
index field (id)
another field (data)
I want the data colum to move to a normalized table (normal) that
uses id as part of a multifield primary key. So I created a data
column in the normalized table. How can I now
Matt,
Thank you for the help and you are correct the index can't be utilized when using !=.
I will try
your hack/work around.
Thanks again.
sql,query
Hi Heath,
MySQL cannot use the trans_team query because you're using !=, for which
an index is never used (currently anyway). Do you think
Bruce Dembecki wrote:
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run mysql.server stop then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but I also know there are
My first thought would be to create an empty table call it new_table set it
up like you want.
then
INSERT INTO new_table
SELECT n.*,a.data FROM normal n LEFT JOIN another a ON o.id=a.id
ORDER BY (n.id)
and then verify it got there, and drop the other tables and rename the
new_table to
normal
To test for NULL, you use the IS NULL comparison operator.
SELECT * FROM table_name WHERE col_name IS NULL;
See http://www.mysql.com/doc/en/Comparison_Operators.html in the manual
for more.
Michael
Miguel Ernesto wrote:
Now that I listen to you Michael, you must probably know how MySQL
I am running PHP/MySQL for a program that I am writing. We will have
100's or 1000's of databases that will be duplicates in structure. The
problem is when I make a change to the database, I have to go to every
database manually and make the change. All of the databases start with
a_ and
Check out sqlyog. (www.sqlyog.com) It has a structure sync tool. After
making the first change, you could generate a script to make the change
to the next database and then take that script and parameterize it so
that a PHP script could use it to update all of your database.
HOWEVER,
A
74 matches
Mail list logo