Re: List archive?

On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson wrote: > On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: >> >> I have a question that this list solved a year ago, and I can't remember >> what the solution was. Does this list have an archive? >> >> (Sorry if it is on one of the links to t

Re: List archive?

On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) see it on the botto

Re: list rows with no recent updates

One option would be to add a column to the table with a last_updated timestamp. Everytime you update the row, update the last_updated field with the current timestamp. Therefore you could just query the timestamp column to get recently updated rows (or not so recently updated) as you please. -- A

RE: list rows with no recent updates

it. Plus it's stored internally as an integer (timestamp) *http://en.wikipedia.org/wiki/Long_and_short_scales > -Original Message- > From: MadTh [mailto:madan.feedb...@gmail.com] > Sent: Monday, June 14, 2010 2:23 PM > To: mysql@lists.mysql.com > Subject: Re: list ro

Re: list rows with no recent updates

Hi, Thank you all for your prompt response. Unfortunately timestamp file isn;t there, so I will find some other way to do it. Seems timestamp is a valuable field ( unless you want to save resource on generating timestamps on a very busy table). Thanks

Re: list rows with no recent updates

Do you have a timestamp field on this table? There's no way of seeing when a row was last updated unless you have a timestamp field that automatically updates for any change (that's *any* change - not necessarily the ones you want to keep track of) or creating your own and updating them either on

RE: list rows with no recent updates

The only way I could think of is to have a column that's an auto updated timestamp and then just query using that time. `updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP So for your mass update, I'd SET @updated_time = NOW(); and then you could use that in your

Re: List of Publicly Accessible MySQL Databases?

Hi! Check out db4free.net. :) Cheers, Jay Andrew J. Leer wrote: > Is there a listing of public MySQL Databases anywhere? > > Just if someone would be new to databases (not me...other people at my > office) and they would want to get a look at an existing working > database to learn SQL on? >

Re: List of ports which should be opened for IPTABLES

When it comes to clustering.. doesn't matter if it is MySQL, MS SQL Server, MS Exchange or a big bad Beowulf Cluster you need an independent switch for the cluster. Here is why, There is so much traffic to and from the nodes, and on the network that it will slow down your network, and the cluster.

Re: List of ports which should be opened for IPTABLES

On Tue, 2007-02-27 at 10:59 -0500, Agarwal, Abhishek wrote: > Hello All, > > Does anyone know a quick reference which details a list of ports which are > used my various machine in the MYSQL cluster environment. > > We just installed the MYSQL cluster and have the IPTABLES shutdown as we are > no

Re: list of cols that I need to index

Ahmad - It's not always a cut-and-dried thing; performance tuning involves a lot of factors, and with living databases should be an ongoing thing. Check out the section on optimization at http://dev.mysql.com/doc/refman/5.0/en/optimize-overview.html and/or Jeremy Zawodny's excellent book, "High

Re: list of words in fulltext key index

In the last episode (Aug 23), C.R.Vegelin said: > Hi List, > > I have a table with a FULLTEXT KEY column, > and I would like to get a list of all the FULLTEXT KEY words, eg: > acetic > acid > acidified > acrylic > ... > Any idea how to make such a list ? You can run the myisam_ftdump program to g

Re: List of tables.

Dear Peter, I need to name of each table,But mysql_list_tanles() creates a sql result. Can i make an array from those names?Each element of that is a name of table. Please guide me. regards > Mohsen, not sure what you mean here, to get a list of tables in a db you > have to issue an sql re

Re: List of tables.

Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql request, which is all mysql_list_tables() does (http://dev.mysql.com/doc/mysql/en/mysql-list-tables.html). PB Mohsen Pahlevanzadeh wrote: Dears,Problem of my Makefile is solved. But i have a new problem

RE: List of connection error

> Is there any documentation where I can find a list of > all connection related error/error codes returned by > MySQL? OS error codes : http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html Server error messages : http://dev.mysql.com/doc/mysql/en/error-handling.html --- Tom Crimm

Re: list of error codes

>Note that this error list is for the Linux version (parts differs for >another OS). More error descriptions can be found in the header files. >(forgot currently which ones). If you search the forum for error codes and >my name than you will find the info (roughly a year+ old) The typical pla

RE: list of error codes

[snip] I looked around and didn't see documentation of MySQL error codes. I did find a short list of INNODB codes but nothing comprehensive. Is there such a page? [/snip] OS error codes : http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html Server error messages : http://dev.mysql.c

RE: list of error codes

Hi Emmett, (B (BPlease try http://www.be-known-online.com/mysql/ (B (BNote that this error list is for the Linux version (parts differs for (Banother OS). More error descriptions can be found in the header files. (B(forgot currently which ones). If you search the forum for error codes and (B

RE: list of error codes

http://www.be-known-online.com/mysql/ (B (BBest regards (B (BNils Valentin (B (B (B> [snip] (B> I looked around and didn't see documentation of MySQL error codes. I did (B> find a short list of INNODB codes but nothing comprehensive. Is there such (B> a (B> page? (B> [/snip] (B> (B> Y

RE: list of error codes

[snip] I looked around and didn't see documentation of MySQL error codes. I did find a short list of INNODB codes but nothing comprehensive. Is there such a page? [/snip] You can use perror to find out want a mysql errno means. http://dev.mysql.com/doc/mysql/en/perror.html --- Tom Crimmins Inte

Re: List for newbie

At 3:56 PM +0100 1/3/05, Paun wrote: I am very new in mysql, and don't want to disturb users who have much more expirience with mysql. Is there any mysql list for newbies?? No, this is the appropriate list...just make sure you: (1) first try to search the manual: http://dev.mysql.com/doc/

RE: List for newbie

smime.p7m Description: S/MIME encrypted message

Re: List annoyance

Jochem van Dieten wrote: On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote: Why is this list reply to sender and not reply to list? Why don't you read the FAQ? Ah right. I see - a 2 year old article - http://www.unicom.com/pw/reply-to-harmful.html Completely disagree

Re: List annoyance

On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote: > Why is this list reply to sender and not reply to list? Why don't you read the FAQ? Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

Re: List of Dates Grouped by Week

Hi, You can use the WEEK function http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html and the query will look like select week(Date) as weekID,User_ID,sum(hours) from Timesheets group by weekID,User_ID order by weekID; You will have to do some additional math in your application to

Re: List of Questions

Hi, >I have some questions. I need urgent solutions for these. Could you spare some time for me for helping me. I hope you can. > > 1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give me the url please?. > > 2) What will be the equivalent of Pro*C API's in MySql?. Fo

Re: List of MySQL Keywords

- Original Message - From: "Tim Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 09, 2004 9:36 PM Subject: List of MySQL Keywords > Hello All: > I would like to make up a complete (if possible) > list of MySQL query keywords. I would appreciate > pointe

Re: List of MySQL Keywords

In the last episode (Sep 09), Tim Johnson said: > Hello All: > I would like to make up a complete (if possible) > list of MySQL query keywords. I would appreciate pointers to > documentation that might hold such a list, without too much > extraneous or extra text. > > In my current documentati

Re: List of associated records

Each member can have several interests, and each interest can be held by several members. The best way to do this is with a third table relating the two: CREATE TABLE member_interests (member_id INT, interest_id INT, UNIQUE INDEX mem_int_idx (member_id,interest_id); Each row in this

re: List of associated records

Create a seperate table called member_interests or something similar Store one member_id and one interest_id (or whatever you have your PKs named) in each row. This is similar to an order entry system, which typically has one table for order_headers and one for order_detail. The order_header tab

RE: LIST function?

This will do it... SELECT id, group_concat(distinct buddy_id) FROM buddies GROUP BY id Ed -Original Message- Hi, When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from all the values in your specific group from the GROUP BY. Is there any function to simply

Re: LIST function?

At 14:44 +0100 4/20/04, Andy Hall wrote: Hi, When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from all the values in your specific group from the GROUP BY. Is there any function to simply return a list of the values in the group? GROUP_CONCAT()? Supported in MySQL

Re: LIST function

Never mind, I found the GROUP_CONCAT function but I am still using v. 3.23.37 so thats that. Looks like I'll be using PHP, unless anyone has a workaround of some kind? Thanks

Re: list, order and limit data

Hi, For the query that you would need, see this page in the manual: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html Also see the comment from March 16, 2003 about the LEFT JOIN trick. However, in your case, why don't you just add another column in the tickets table? last_respon

Re: List-ID Header

It seems to be this way on all the lists -- the java.mysql.com List-ID header is missing, too. --jeff - Original Message - From: "Joseph Bueno" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "mysql-list" <[EMAIL PROTECTED]> Sent: Sunday, March 23, 2003 1:43 AM Subject: List-ID Header >

Re: List-ID Header

The mailing lists information on the MySQL website says that list headers can be idenitified with either "List-ID:" or "Delivered-To:". Though List-ID is missing at the moment, Delivered-To is still present. Every other majordomo listserver I see provides, List-ID; perhaps the change is an inadv

Re: List-ID Header

On Sun, Mar 23, 2003 at 10:43:28AM +0100, Joseph Bueno wrote: > It seems that emails coming from mysql mailing list > don't include 'List-ID: ' header anymore. > > Is this going to be fixed or should we change our email > filtering rules ? This List-ID header has been restored. Sorry for the ove

re: list current db

On Wednesday 12 March 2003 18:25, Jonathan Li wrote: > A few days ago I asked about how to know which database I am currently > in, I got an answer and I also replied to thank the send but the email > was returned. Any way I forgot to document it. I remember the answer > listed three methods to do

Re: list current db

select database(); Regards, Joseph Bueno Jonathan Li wrote: A few days ago I asked about how to know which database I am currently in, I got an answer and I also replied to thank the send but the email was returned. Any way I forgot to document it. I remember the answer listed three methods to do

Re: list current db

[filter fodder = sql,query,queries,smallint] mysql > select database(); David ** Jonathan said: ** A few days ago I asked about how to know which database I am currently in, I got an answer and I also replied to thank the send but the email was returned. Any w

Re: List of Tables

Hi, Have u thought of sending an sql query like "show tables" and then looking at what it returns? Eric On Thu, 20 Feb 2003, Jeff Pearson wrote: > I am writing a vb.net application to do some db management on MySQL. Ive > got it pretty far but am at a point where I am stuck. I know with php > th

Re: List of Tables

show tables; ? or do you mean specific to vb ? Jerry - Original Message - From: "Jeff Pearson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 10:31 PM Subject: List of Tables > I am writing a vb.net application to do some db management on MySQL. Ive > got

RE: List of Tables

SHOW TABLES; Then treat the output as a normal result set. see the manual for more about SHOW syntax http://www.mysql.com/doc/en/SHOW.html -Original Message- From: Jeff Pearson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 2:31 PM To: [EMAIL PROTECTED] Subject: List of Tabl

Re: List of Tables

Jeff Pearson wrote: I am writing a vb.net application to do some db management on MySQL. Ive got it pretty far but am at a point where I am stuck. I know with php there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would be G

Re: List

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jerry, et al -- ...and then Jerry said... % % Is it just me or is everyone on the list getting junk/spam from naver.com ? Haven't seen any, assuming you spelled it right. I just checked through my entire mysql folder and have only your and Stefan's

Re: List

Jerry, > Is it just me or is everyone on the list getting junk/spam from naver.com ? We all have this problem :/ Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fo

Re: List of Linked Libraries for 3.23.52

> I have been running MySQL in 32-bit mode on Solaris for about a year now. > I've been attempting to compile 3.23.52 in 64 bit mode using the Sun > Workshop 6 Update 2 compiler. Everything works/compiles great until it's Any reason to go 64-bit? I've compiled 64-bit myself and it seems to work

Re: List users?

select distinct User from mysql.user where User <> '' Mike Yrabedra wrote: > How would I list all users via the command line? > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

RE: List users?

Try: mysql -e "SELECT user FROM mysql.user" You may need to add the following as well mysql -h hostname -uyouruserid -pyourpassword -e "SELECT user FROM mysql.user" -Original Message- From: Mike Yrabedra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 6:55 AM To: [EMAIL PROTEC

Re: list of tables in a database

Show Tables; - VirtualChicagoLand.com Is Your Chicagoland Resource! Visit: http://VirtualChicagoLand.com On Wed, 16 Jan 2002, Bret Ewin wrote: > I need to know how to get a list of all the tables in a database. In Oracle > you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list

Re: list of tables in a database

show tables will get you a list of tables. To get the schema of tables type 'describe ' J Bret Ewin wrote: > I need to know how to get a list of all the tables in a database. In Oracle > you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all > tables and their schemas. How d

Feature (Was: Re: List BUG? Unsuscribe info appaears in replies)

David J Jackson wrote: > > database,mysql,sql > > ALL -- > > For reason unknown I seeing the unsubscribe information, for any > email I read or reply, here's what I'm talking about: > NOTE: I don't have this problem on the other list I subscribe to? > > Thanks, > David > David: This behavio

Re: List Info

On 16 Nov 2001, at 16:14, Bill Platt wrote: > I am wondering if there is any method available to switch this > Mysql list to digest mode? > > ...this list generates tons of > email everyday. You'd probably be better off to use the filtering/filing machinery of your mail client to stick all of

Re: List of aggregate functions? (aggregate "concat"?)

On Thu, Sep 06, 2001 at 12:40:16PM -0700, xris wrote: > I was just browsing through the searchable online MySQL manual, > trying to find a list of the aggregate functions (as I don't trust > the list in the O'Reilly book, considering the number of typos and > missing information in other sections

Re: List problems?

On Thu, Jul 19, 2001 at 09:06:19AM -0700, Bryan Coon wrote: > > Is there a mysql newsgroup somewhere? Or some other forum? I am > the kind of user that has one question every couple weeks or so, and > rather than fill up my mailbox, I prefer to subscribe, ask my > question and then unsubscribe.

Re: list of databases

You can also use mysql and query "show databases" as in this sample script I transcript: DBS=`mysql -e "show databases"` for db in $DBS ; do if [ "$db" != "Database" ] ; then # skip the title "Database" included in the output of command DBS. mysql -e "show tables from $db"

Re: list of databases

mysqlshow should work just fine. Tim Chambers wrote: > > Is there any way I can generate a list of the databases in mysql, perhaps > with the mysqlshow command and some fancy grep? > > I'm looking for a list separated by spaces, something that I could use in a > bash script. > > Thanks, > >

Re: list of databases

On Fri, Feb 16, 2001 at 06:46:58PM -0800, Tim Chambers wrote: > > Is there any way I can generate a list of the databases in mysql, > perhaps with the mysqlshow command and some fancy grep? SHOW DATABASES > I'm looking for a list separated by spaces, something that I could > use in a bash script