Keeping track of db structure changes

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 t

RE: Scheduling with MySQL

> 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 i

MySQL, mm.MySQL, and SQL Problems

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 s

Re: What next

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

Re: Stuck Some More

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 p

RE: Uppercase first letter of each word

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; A

Re: Limits of mySQL

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

Why does MAX(this_col) when this_col has index?

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'; +---+--+-++---

Re: Uppercase first letter of each word

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 al

Newbie: Help with count

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

Install problem!

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 don’t install MySQL. I’m using windowsxp pro

SV: WHERE ignored

> -Oprindelig meddelelse- > Fra: Mike Hall [mailto:[EMAIL PROTECTED]] > Sendt: 27. april 2002 00:04 > 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 ign

Re: WHERE ignored

> 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 write('Mailer is locked - terminating'); exit; } // Create a lock file $log->write('Locking mailer'); @touch($lock); @chmod($lock, 0666); // Internal mai

Dynamic $table in SELECT?

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 ---

Help with mysql installation

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

read only

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) h

Problem with User Account - access denied

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 "somepass

Compressed MASTER-SLAVE replication

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 time,

Re: Help with mysql installation

> 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 o

Re: Compressed MASTER-SLAVE replication

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 > replicati

Re: Newbie: Help with count

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 hav

Re: Keeping track of db structure changes

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 importan

Re: Limits of mySQL

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

Re: Why does MAX(this_col) when this_col has index?

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 =

Determining character set from table data

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 dat

Re: Re[2]: Cross querying databases

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.* > fro

Re: How to optimize this sql ?

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 |

Re: Sql SELECT statement to get all dates between 7:00am yesterday an d 7:00am today

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

Re: Which would be a faster query:

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.

Re: Help with mysql installation

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 > > Howev

Re: MySQL & PervasiveSQL

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 > acco

Re: How does DISTINCT really work ?

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 o

Multiple Sum Queries

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 loo

Re: Multiple Sum Queries

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

Re: Compressed MASTER-SLAVE replication

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 t

Re: a graph theory problem

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

Re: mysqldump generates "create table" commands with wrong table name case.

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) > > my

Re: Potential bug

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. S

Re: WHERE ignored

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

Re: Table corrupted after myisampack

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

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.

RE: MySQL, mm.MySQL, and SQL Problems

> 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

Re: Compressed MASTER-SLAVE replication

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 tha

Which Index is better ?

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

ANNOUNCE: mytop 1.0 is released...

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

Re: FW: Does MySQL provide an access to system tables ? Are thereany ?

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

FW: Does MySQL provide an access to system tables ? Are there any ?

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 inform

GUI managers for Linux

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.

I need an example on DELETE /UPDATE with JOIN syntax

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 update

Re: MySQL, mm.MySQL, and SQL Problems

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 ve

Re: What next

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 PROTECT

Re: Stuck Some More

In reply to Egor's request... Egor> > Ian, show me the contents of your .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 connections /nfs/

Re: mysql read only ? sql,query

[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 te

Re: Blobs+ASP+MySQL

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: Blobs+ASP+

FW: I need an example on DELETE /UPDATE with JOIN syntax

-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 Adaptiv

Example UDF for anyone interested

If anyone's looking for another nice user-defined function example, I've just set one up at work and am happy to share the wealth :). They're really quite cool, and this one is a good deal simpler than udf_example.cc. The function is at: http://www.adamhooper.com:4242/ccode/project_view.php?pro