Hi,
is there any way to have MySQL automatically keep track of any changes
I do with ALTER TABLE and later spit out the changes again?
I use one database (well, actually several, but that's not important
here) for development and one database for the production system. Now,
whenever I change
However, I would suggest, if you have control of the search
tools, that you simply put in an extra timestamp field called
hideuntil into your database, and add conditions into your
searches that drop rows for which hideuntil is not null and is
after the current time.
This is a great idea
So I'm jumping back into database stuff after a long absence.
(I guess you could say that I was never really *in* databases
to begin with. Anyway...) I'm working with various databases
and have settled on MySQL but am encountering a variety of
problems that I hope the MySQL community can help me
Ian,
Saturday, April 27, 2002, 1:42:46 AM, you wrote:
IP I was able to start the mysql server using this suugested by Egor
Egor safe_mysqld
IP [1] 15476
IP user_obscured:/# Starting mysqld demon with databases from /usr/local/var
IP nohup
IP /nfs/usr/libexec/mysqld --basedir=/usr/local
Ian,
Saturday, April 27, 2002, 2:31:28 AM, you wrote:
IP Mysql has not been used on my server before, and I am the only user who has
IP ssh access to the system, (any mysqld processes are mine) and have been
IP trying to get mysql set up and working properly.
IP Currenlty I have two mysqld
Hi,
A function like initcap in other databases and programming languages in
mysql would be
much desired in such situations.
You may try this ugly code.
select ltrim(replace(replace(replace...(concat(' ',lower(strcolumn)),' a','
A'),' b',' B' ),' c',' C'), ...,' z',' Z')) from tablename;
On Sat, 27 Apr 2002, Sam Minnee wrote:
I've been asked to put together a very large (well, it's large to me)
database, and while mySQL is great for my current uses, I haven't had
experience with stuff of this scale.
The database will have about 88 tables, with up to 100 fields per table.
Hello,
Perhaps I don't understand indexes but I was wondering how to improve teh
performance of a query on an indexed column that uses MAX().
mysql explain select max(master_mtime) from redirects where uri_scheme =
'http';
If you are using PHP, just use the ucwords function.
From the PHP manual
ucwords(PHP 3= 3.0.3, PHP 4 = 4.0.0)
Uppercase the first character of each word in a string
string ucwords (string str)
Returns a string with the first character of each word in str capitalized,
if that character is
Hi all,
I have a table that has data that looks something like this (fixed font on):
UserID MessageID MessageState
1 1 PENDING
1 2 PENDING
2 3 FAILED
3 4 DELIVERED
2
Hello there.
Some time ago I have installed MySQL and after a
short period of time I uninstalled it.
Now when I try to install it again the installshield
makes a sound (like a warning) show a message box to
quickly (it disappears right after) and dont install
MySQL.
Im using windowsxp
-Oprindelig meddelelse-
Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
Sendt: 27. april 2002 00:04
snip
No other scripts perform UPDATEs on that table, only INSERTs. But MySQL
returned the correct data at 8:55 and again at 9:05. It was only
when it ran
at 9am that it appeared to
I think you better show us the script. This might help to figure out the
problem.
Okay, here it is:
-- Start
#!/usr/local/bin/php -q
?php
// Include library files
include 'config.php';
include 'feedlib.php';
// Init log
$log = new ParserLog;
// Define location of mailer lock file
$lock =
Here is another question;-)
Is there any ability to put tables dynamic in a query?
I have to do a select * for many tables and it would be cool if I just do
something like this
select * from (select t from mytables).
Thanks a lot,
Jan
Hello,
I am trying to install mysql from RPMs. My installation guide requires:
-Mysql server
-Mysql shared
-Mysql client
However those files are not present on mysql's website. Where do I find
them??
Is the file available at Mysql.com sufficient for a server + client
installation?
Thanks
sql,query
How to enable the table for read write again ?
Thanks.
--
Best regards,
Ridwan
Goldbase Technology
http://www.pembukuan.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I created and user, like below, using mysql on my
Linux machine (Linux-Mandrake 8.1) to access a
database called college:
GRANT ALL ON college.* TO someuser BY somepassword;
But I'm denied access even from localhost. I tried the
following too:
GRANT ALL ON college.* TO someuser@% BY
Hi there,
I am wondering if there's a way of estabilishing a compressed link between
a master and slave mysql servers.
I know that a compressed client-server protocol exists.
Do we have anything similar for replication?
When replicated data is mostly text, such an option would save a lot of
Hello,
I am trying to install mysql from RPMs. My installation guide requires:
-Mysql server
-Mysql shared
-Mysql client
However those files are not present on mysql's website. Where do I find
them??
Where do you want to install .. on 1) Unix like OS or 2) windows or 3) any
other?
For
On Sat, Apr 27, 2002 at 04:28:27PM -, [EMAIL PROTECTED] wrote:
Hi there,
I am wondering if there's a way of estabilishing a compressed link
between a master and slave mysql servers. I know that a compressed
client-server protocol exists. Do we have anything similar for
replication?
you can use:
select messagestate, count(*) from table where uid=1 group by messagestate;
for uid=1, if you want to do the same for all users with one query you
can use:
select uid, messagestate, count(*) from table group by uid, messagestate;
Regards,
Ben Holness wrote:
Hi all,
I have
On Sat, Apr 27, 2002 at 10:42:47AM +0200, Jens Vonderheide wrote:
Hi,
is there any way to have MySQL automatically keep track of any changes
I do with ALTER TABLE and later spit out the changes again?
Not really, no.
I use one database (well, actually several, but that's not important
On Sat, Apr 27, 2002 at 05:15:10PM +1200, Sam Minnee wrote:
I've been asked to put together a very large (well, it's large to
me) database, and while mySQL is great for my current uses, I
haven't had experience with stuff of this scale.
The database will have about 88 tables, with up to
On Sat, Apr 27, 2002 at 08:25:26AM -0400, Richard F. Rebel wrote:
Hello,
Perhaps I don't understand indexes but I was wondering how to improve teh
performance of a query on an indexed column that uses MAX().
mysql explain select max(master_mtime) from redirects where uri_scheme =
Hello,
I am wondering if there is any way to determine the character set used for
data in a table.
For example, a single database has 10 tables, six with 'latin1' characters,
two with 'cp1251' characters, and two with 'greek' characters. The
character_set variable is set to 'latin1' on this
Hello
On Thu, Apr 25, 2002 at 03:29:34AM +0100, [EMAIL PROTECTED] wrote:
Guten Tag Donna Robinson,
Hi 2u2 sir!
and god bless your cotton socks.
i hope this will help you..
...
it didn't but it gave me enough of a clue so that this did:
select dancedetails.coupletypes.*
from
Hello.
On Thu, Apr 25, 2002 at 01:49:39PM +0200, [EMAIL PROTECTED] wrote:
[...]
mysql show index from cpu;
+---++--+--+-+---+-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Hello.
You have given to few information to give a specific answer. Please
include the output of DESC your_table in your mail next time.
Most people probably solve that by determining the date in the
application part and just inserting it in the SQL query. The following
is an SQL-only solution
Hi.
Unfortunately you posted only one of the queries, so one cannot weight
in their complexity.
First, normally forums get at least about 10 times more read requests
than new posts. In my experience posting speed is not a limiting
factor. That said, I am going to answer your original question.
Should be able to find the right rpm's from your Linux distribution's
website. Just a guess here but www.redhat.com.
Mike
sqp,mysql
Balteo wrote:
Hello,
I am trying to install mysql from RPMs. My installation guide requires:
-Mysql server
-Mysql shared
-Mysql client
However those
Hello.
On Thu, Apr 25, 2002 at 04:09:57PM -0400, [EMAIL PROTECTED] wrote:
Hi,
Looking for advice on integrating database applications.
We are building a web app in php. Generally I use MySQL for everything.
But this app needs to integrate with, or at least exchange data with an
Hi!
Fournier == Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] writes:
Fournier Hi,
Fournier So I assume in this case the only way to have distinct results is to use
Fournier GROUP BY topic clause ?
If you do this, you can't still use 'ORDER BY date' as 'date' is not
part of the GROUP BY
I have a table full of cell phone data with three important columns:
ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a
query grouped by serviceNumber that gives me the sum of minutes per
rating period for each of the numbers in the other cloumns. So the query
result will
At 14:24 -0500 4/27/02, [EMAIL PROTECTED] wrote:
I have a table full of cell phone data with three important columns:
ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a
query grouped by serviceNumber that gives me the sum of minutes per
rating period for each of the numbers in
Hi Jeremy,
you wrote:
If you send the traffic thru an ecnrypted tunnel, such as with SSH,
you'll get decent compression and security to boot! :-)
Yep, that's a bright idea in fact... I wanted to make sure that we didn't
already have that feature built-in.
Now I am just curious to know if
Hello.
On Fri, Apr 26, 2002 at 01:43:21AM +0200, [EMAIL PROTECTED] wrote:
Hello folks,
here is a pretty original (I think) problem for your minds! :-)
Well, to be true, not really. :-)
I'd like to store a graph in a MySQL database. By graph, I mean the
graph theory meaning (i.e., a set
Hello.
To answer only a part:
On Fri, Apr 26, 2002 at 03:26:15PM -0400, [EMAIL PROTECTED] wrote:
[...]
Having loaded these tables, the mysql
monitor appears not to care about case:
mysql select ID from Maps;
++
| ID |
++
| 1 |
++
1 row in set (0.00 sec)
mysql select
Hi.
On Fri, Apr 26, 2002 at 04:19:37PM -0400, [EMAIL PROTECTED] wrote:
I'm writing to you about a potential bug.
Not that this is a public list for users help users.
I am using (trying) the gui for managing the dbs, and it freezes if i
hit a keystroke while looking at a query result.
Hi.
First a praticial hint to prevent further harm: I presume you can set
an upper limit for how many rows should be returned (say 1000?). If
there are more, complain and refuse to do anything in your script.
Or also select the sent value and compare in your script that it is
0 before sending
Hi.
It sounds as if you run myisampack/myisamchk while the server was
running. This is not supported and has a high probability to corrupt
tables (http://www.mysql.com/doc/R/e/Repair.html)
Bye,
Benjamin.
On Fri, Apr 26, 2002 at 09:50:18PM -0400, [EMAIL PROTECTED] wrote:
Hi,
I am
Character ² 2 m² meter to square hangs odbc insert into varchar VB 6 SP5
and access 2000/2002 XP
Myodbc 2.50.37 hangs insert into varchar(16) values ('m²'):
Access 2002 SR1 myodbc (MYSQL 2.50.37)
Mysql on SuSE-linux 3.23.41
But m3 dosn't make any prob.
Message-ID: [EMAIL PROTECTED]
Date: Sat, 27 Apr 2002 18:28:57 +0900
From: Andy Clark [EMAIL PROTECTED]
MIME-Version: 1.0
To: MySQL [EMAIL PROTECTED]
Subject: MySQL, mm.MySQL, and SQL Problems
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
So I'm jumping back
On Sat, Apr 27, 2002 at 07:40:51PM -, [EMAIL PROTECTED] wrote:
Hi Jeremy,
you wrote:
If you send the traffic thru an ecnrypted tunnel, such as with SSH,
you'll get decent compression and security to boot! :-)
Yep, that's a bright idea in fact... I wanted to make sure that we
Hi,
I wonder which index will be the most efficient for this query :
SELECT numreponse FROM searchhardwarefr7 WHERE pseudo='joce' AND
date'2001-01-01 00:00:00';
I tested a compound index on (pseudo,date,numreponse), and explain return :
mysql EXPLAIN SELECT numreponse FROM searchhardwarefr7
I have just released version 1.0 of mytop, a top-like command for
monitoring your MySQL server.
The mytop home page (with screenshot, docs, mailing list) is now here:
http://jeremy.zawodny.com/mysql/mytop/
which is different than the old location, which also points to that
URL now.
Changes
At 16:19 -0700 4/27/02, Vadim wrote:
Greetings:
I'm a SYBASE DBA and very familiar with Sybase implementation of system
catalog. (systables; syscolumns, etc) There is a lot of information that
can be derived from these tables. MySQL, however, doesn't appear to have
any system tables.
Right,
Greetings:
I'm a SYBASE DBA and very familiar with Sybase implementation of system
catalog. (systables; syscolumns, etc) There is a lot of information that
can be derived from these tables. MySQL, however, doesn't appear to have
any system tables. When use command describe it shows the
Ive downloaded and sucessfully installed both mysqlgui, and mycc from the
mysql.com site
for some wierd reason I cant connect to the database with either of them
I can with the text mysql client, and the text mysqladmin
I have created a database, and granted rights to that database to a user.
Greetings:
My company migrated to MySQL a few months ago from Sybase Adaptive
Server Anywhere. Where I'm very impressed with the performance and the
simplicity of management I find its very difficult, however, to run
regular updates or deletes because joins are not supported on delete and
Mark Matthews wrote:
First off, let me say Thanks for the work you've done with the XML Parser.
I used it heavily on a project last year and it performed admirably.
Cool. :)
Hmm. MM.MySQL will do this for you. Seeing your next comment leads me to
believe that you've found yourself a very
In reply to Egor's question:
Execute:
ps ax | grep mysql
Is there MySQL in the process list?
Only mysqld (2 of them)
5404 p2- I 0:00.00 (mysqld)
15488 p4- I 0:00.00 (mysqld)
Ian
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
In reply to Egor's request...
Egor Ian, show me the contents of your host_name.err file (the last
20-40 rows)
This is the total contents of this file.
/nfs/usr/libexec/mysqld: ready for connections
/nfs/usr/libexec/mysqld: ready for connections
/nfs/usr/libexec/mysqld: ready for
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of
Why store the pic in the DB?
I know there is an ASP upload utility avaliable.
Try www.asp101.com or www.hotscripts.com
HTH
Mark
-Original Message-
From: Zill-e-Hassan [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, April 25, 2002 1:48 PM
Subject:
-Original Message-
From: Vadim [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 27, 2002 4:49 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: I need an example on DELETE /UPDATE with JOIN syntax
Greetings:
My company migrated to MySQL a few months ago from Sybase
55 matches
Mail list logo