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 bottom of my post... thanks and sorry for noise -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: List archive?
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson b...@biz-comm.com 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 the list, but I don't have any on hand at the moment.) see it on the bottom of my post... thanks and sorry for noise It's also archived in many other places, such as GMANE[1] and MARC[2]. ^1: http://gmane.org/ ^2: http://marc.info/ -- /Daniel P. Brown Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting (866-) 725-4321 http://www.parasane.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 16:02, MadTh madan.feedb...@gmail.com wrote: Hi, I ran a update command on around 2700 rows inside a mysql database table which has around 3000 table rows to change the ( say) price of each item ( with unique ID. unique product code). like: mysql UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and prod_code='a0071'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 How can I list rows with no recent updates ( or the once where the above updates were not done) or say with no updates in last 2 hours? Thank you.
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 future query where @updated_time +/- some fuzzy amount of seconds. -Original Message- From: MadTh [mailto:madan.feedb...@gmail.com] Sent: Monday, June 14, 2010 2:02 PM To: mysql@lists.mysql.com Subject: list rows with no recent updates Hi, I ran a update command on around 2700 rows inside a mysql database table which has around 3000 table rows to change the ( say) price of each item ( with unique ID. unique product code). like: mysql UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and prod_code='a0071'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 How can I list rows with no recent updates ( or the once where the above updates were not done) or say with no updates in last 2 hours? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 the update statement itself or in a trigger. You can pretty much tell when the last time an entire table was updated by the date on the MYD or ibd file. I'm assuming you don't want to constantly parse the binlog or general log. On Mon, Jun 14, 2010 at 4:02 PM, MadTh madan.feedb...@gmail.com wrote: Hi, I ran a update command on around 2700 rows inside a mysql database table which has around 3000 table rows to change the ( say) price of each item ( with unique ID. unique product code). like: mysql UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and prod_code='a0071'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 How can I list rows with no recent updates ( or the once where the above updates were not done) or say with no updates in last 2 hours? Thank you. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
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
Easy enough to rectify http://dev.mysql.com/doc/refman/5.0/en/alter-table.html ALTER TABLE `tbl_xyz` ADD COLUMN `updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `prod_id`; Personally I put a 'created_on' and an 'updated_on' column for mostly every table I create. 3000 rows is nothing. A mere blink of an eye to mySQL. The database I'm using is almost a Billion (yes, with a B, and I mean a good ol' USA 10^9 Billion, not that goofy long scale 10^12 Billion*) rows and 90GB. So don't worry about 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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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? I've found one such database: Genome Bioinformatics db.host=genome-mysql.cse.ucsc.edu db.user=genomep db.password=password But I really don't think the people I'm trying to teach here know much about Genome Bioinformatics (and ah consequently I don't know anything about that either...) Thank you, Andrew J. Leer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. A cluster has more communication on it than just serving your data, it has management information as well. Our typical setup for a cluster (OS and Job independent) is usually a 10/100/1000 switch, noting fancy like a managed switch but quality (not putting in a $40 switch). We also do not allow switches to be over 75% used, if a 12 port switch has more than 9 ports used we replace it with a 24 port. Typically we also use a rack to house all the clustered boxes with nothing else not required for the cluster in there. The exception is when it is only 2 boxes in the cluster then we just rack them next to each other and instead of a switch we use a fiber connection between the two boxes. We set up a lot of clusters for various Operating systems and servers and these are our general rules of set up. These simple rules have never let us down when it comes to clustering. When cluster traffic is running outside the cluster you are asking for network performance issues.
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 not sure which ports are being used by each of these machines. We want to keep the firewall on with a certain list of open ports. Any advice? Don't use a firewall for Cluster traffic. It just slows things down with added latency (really not what you want). We (ndb) gets the operating system to assign free ports to work on - so it's not predictable. The protocols that MySQL Cluster uses between the nodes are NOT secure and if you swamp that network with other traffic, performance will suffer (including the possibility of missing heartbeats). i.e. a whole world of bad. Run the cluster traffic on its own private network with no firewalls getting in the way. easiest and fastest way. -- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: [EMAIL PROTECTED] Mobile: +61 4 3 8844 332 Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html signature.asc Description: This is a digitally signed message part
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 Performance MySQL what may be of specific interest to you right away is the EXPLAIN function, showing you how MySQL will execute your queries: http://dev.mysql.com/doc/refman/5.0/en/explain.html Dan On 10/16/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote: Hi is there anyway or command to run it against a production table to see if there is any column that I should think about indexing it remember this is a production database, so I can't run it in debug mode and I don't have a root access to the database (I'm just a developer). Thanks -- Ahmad Fahad AlTwaijiry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 get this info. There's no way to get it from a client connection. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 place for the error codes is usually /usr/include/errno.h But that tends to be references to OS specific places. On Linux the actual numbers/mappings for i386 are in /usr/include/asm/errno.h Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 You can use perror to find out want a mysql errno means. (B (B http://dev.mysql.com/doc/mysql/en/perror.html (B (B --- (B Tom Crimmins (B Interface Specialist (B Pottawattamie County, Iowa (B (B (B -- (B MySQL General Mailing List (B For list archives: http://lists.mysql.com/mysql (B To unsubscribe: (B http://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 (Bmy name than you will find the info (roughly a year+ old) (B (Bperror (the way I remember it) will only cover a limited scope of the (Berrors (ca.10%) (B (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 You can use perror to find out want a mysql errno means. (B (B http://dev.mysql.com/doc/mysql/en/perror.html (B (B --- (B Tom Crimmins (B Interface Specialist (B Pottawattamie County, Iowa (B (B (B -- (B MySQL General Mailing List (B For list archives: http://lists.mysql.com/mysql (B To unsubscribe: (B http://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.com/doc/mysql/en/error-handling.html (this page also tells what files to find these in) --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: List for newbie
smime.p7m Description: S/MIME encrypted message
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/ (2) search the mailing list archives: http://lists.mysql.com/ http://marc.theaimsgroup.com/?l=mysqlr=1w=2 (3) Then, if you still need to post a message to the mailing list: * Explain your problem as clearly as possible * Describe what you've tried already *If appropriate, post table structures, example queries, and/or example output Here's a *comprehensive* reference on good ways to ask questions: http://www.catb.org/~esr/faqs/smart-questions.html ...and, finally, welcome to the MySQL world! steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center[EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his fork + -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED]
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 with this in terms of mail list management, especially when you read through the interesting summary, but I'll bow to mysql.com feelings on this. Still it : It is really bl annoying Does mean that the list archive is incomplete and therefore less useful. Does mean that I have to waste time cleaning up after this one list when I have quite enough email to handle as it is. But as I say I'll bow to mysql.com's beliefs and drop it. Stephen -- Registration for MX Europe 2005 is now open. http://www.mxeurope.org/go/registration Early bird discounts available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 retrieve the dates when a week starts/ends but this should nto be a problem HTH -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ On Tuesday 26 October 2004 16:28, shaun thornburgh wrote: Hi, I am creating an online timesheet application. Most parts are done, however I have a problem displaying a list of unapproved timesheets. Here is my timesheet table: mysql DESCRIBE Timesheets; +---+-+--+-++-- --+ | Field | Type| Null | Key | Default| Extra +---+-+--+-++-- --+ | Timesheet_ID | int(11) | | PRI | NULL | | auto_increment | | Type | varchar(40) | YES | | NULL | | | Project_ID| int(11) | YES | | NULL | | | User_ID | int(11) | | | 0 | | | Hours | float | | | 0 | | | Date | date| | | -00-00 | | | Status| varchar(40) | YES | | Open | +---+-+--+-++-- --+ When a timesheet is submitted for approval the manager logs in and approves / rejects the timesheets. How can I display a list of unapproved timesheets grouped by week and user? i.e. Week 1 - Bill - 45 Hours Week 1 - Fred - 40 Hours Week 2 - Bill - 45 Hours Week 2 - Fred - 40 Hours Week 2 - Sam - 12 Hours Thanks for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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?. For this what API's i have to use?. Could you give me the reference links/documentation?. 3) What are the equivalent alternatives for using Stored procedures of Oracle 7.3 in MySQL 4.0 classic version?. There isn't any. 4) What are the equivalent alternatives for using Triggers of Oracle 7.3 in MySQL 4.0 classic version?. There isn't any. 5) What are the equivalent alternatives for using Views of Oracle 7.3 in MySQL 4.0 classic version?. There isn't any. 6) What are the equivalent alternatives for using Transaction locks of Oracle 7.3 in MySQL 4.0 classic version?. There isn't any. 7) What are the equivalent alternatives for using primary/foriegn keys of Oracle 7.3 in MySQL 4.0 classic version?. There is no alternative for Foreign Keys in Classic. Primary keys are available in other table types as well. Only InnoDB tables have transactions and foreign keys, but not CHECK constraints. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 documentation, the Manual Function Index is a good source, but if I could find something with less extra text, that would be great. Take a look at sql/lex.h in the source. There are two arays: symbols[] and sql_functions[]. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 pointers to documentation that might hold such a list, without too much extraneous or extra text. In my current documentation, the Manual Function Index is a good source, but if I could find something with less extra text, that would be great. How about the table on this page? http://dev.mysql.com/doc/mysql/en/Reserved_words.html Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 table contains things like an order_id, the order_number, the customer, the selected address, etc.. The order_detail table contains the items that are on the order. On Sun, 25 Jul 2004 12:40:09 -0500, Robb Kerr [EMAIL PROTECTED] wrote: I have come across this problem a few times and wondered how other people solved the problem. Let's say I have a table containing Members. Each Member can choose several items in which they are interested. Each of these items represent records in a separate table - Interests. How do you store which records from Interests the member has checked in their record of the Members table? Do you create a TEXT field in the Members table and save a comma-delimited string of InterestsIDs? Thanx. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 table represents one interest for one member. If the table held these rows: member_id interest_id 1 1 1 5 1 17 2 5 2 13 then the member with ID=1 holds interests with IDs 1, 5, and 17, while the member with ID=2 holds interests with IDS 5 and 13. Michael Robb Kerr wrote: I have come across this problem a few times and wondered how other people solved the problem. Let's say I have a table containing Members. Each Member can choose several items in which they are interested. Each of these items represent records in a separate table - Interests. How do you store which records from Interests the member has checked in their record of the Members table? Do you create a TEXT field in the Members table and save a comma-delimited string of InterestsIDs? Thanx. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 4.1 and up. e.g. SELECT id, LIST(buddy_id) FROM buddies GROUP BY id which would return: idbuddy_id 1 1,3,5 2 2,3 I cant see why this wouldnt be possible but I havent found anything yet. Thanks for any help Andy Hall. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 return a list of the values in the group? e.g. SELECT id, LIST(buddy_id) FROM buddies GROUP BY id which would return: idbuddy_id 1 1,3,5 2 2,3 I cant see why this wouldnt be possible but I havent found anything yet. Thanks for any help Andy Hall. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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_response or whatever. Then you have everything you need right in 1 table and just have to UPDATE the last_response when a response is made. Hope that helps. Matt - Original Message - From: brfg3 at yahoo Sent: Thursday, November 27, 2003 1:00 PM Subject: list, order and limit data MySQL version: 3.23.49 OS: Debian3 Scripting Language: PHP I'm working on a trouble ticket system. There are several tables involved, but for this query only two tables are involved: tickets and comments. They are related by the ticketnumber field. This client cannot afford a high end database, and their host does not support MySQL 4 yet. I want to display the last 50 trouble tickets and the last response from support for each ticket. I can pull the last fifty with this query: SELECT * FROM tickets LIMIT 50; and I can select the latest date of response from the comments table for a given trouble ticket with this query: SELECT dtg FROM comments WHERE ticketnumber =540856 ORDER BY dtg DESC LIMIT 1; My question is, how can I pull 50 rows from the tickets table and then grab the last resonse date of each ticket from the comments table?. The queries can be run individually easily, but I need them to run together or I need some way of relating the comment table results and the ticket table results. I plan to stick each row in an html table so the user is presented with 50 ticket items, and a link to each item (that part is easy, I just need to know how to pull that query). The reason for the last resonse date is for informational purposes. Just to help you visualize (this is in an HTML table): | username | submit date | problem class | ticket status | last response | the first four fields come from the tickets table, the last comes from the comments table. There might be 20 commenst for each ticket, or there may be none, but I only want to show the date of the last comment. Hopefully I've been clear in what I'm trying to acomplish. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: mysql.mysql.com' 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 oversight. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 inadvertant omission. I've made the following change in my procmailrc file, and waiting to see which additional mail get swept up by the use of Delivered-To:. :0 * ^(List-ID|Delivered-To):.*\/.* * MATCH ?? ()\/[^\]+ * MATCH ?? ()\/[^\.]+ ${LISTDIR}/${MATCH}/ Hopefully they'll fix the List-ID header. On Sun, Mar 23, 2003 at 10:43:28AM +0100, Joseph Bueno wrote: Hello, It seems that emails coming from mysql mailing list don't include 'List-ID: mysql.mysql.com' header anymore. Is this going to be fixed or should we change our email filtering rules ? Thank you Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Hello, It seems that emails coming from mysql mailing list don't include 'List-ID: mysql.mysql.com' header anymore. Is this going to be fixed or should we change our email filtering rules ? Thank you Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 way I forgot to document it. I remember the answer listed three methods to do it, they are mysql \s, mysql status. Could you (or someone) point me the third method? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 it, they are mysql \s, mysql status. Could you (or someone) point me the third method? Thanks in advance Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 it, they are mysql \s, mysql status. Could you (or someone) point me the third method? SELECT DATABASE() ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 GREATLY appreciated. Jeff Pearson I use: use DATABASE_NAME show tables -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Tables 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 GREATLY appreciated. Jeff Pearson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 GREATLY appreciated. Jeff Pearson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 GREATLY appreciated. Jeff Pearson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 messages mentioning it. HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+USGFGb7uCXufRwARAhv0AKCFf/t0TxdOHnN7bEaPJIJRqCCICQCfVeju yDoNRzqOm/dCDaUgrNc7i5I= =bAig -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 for the rudimentary stuff I was doing .. FWIW, the MySQL docs state that 64-bit compilations aren't supported ... There may be bugs/corruption that you'll run into ... link time. I think the libtool or /usr/ccs/bin/ld thinks either: - my system cannot run 64 bit apps - there's a 32-bit library out there that cannot mate with a 64-bit library Based on the messages below, it's a 32/64 mismatch. Is there a way to get libtool to tell me what libraries it is using and where it is looking? I think if I had that list I could audit it for 32-bit libs. (I suspect it may be curses, but I cannot tell where it is looking) Here's the barf from the shell: /bin/sh ../libtool --mode=link /opt/SUNWspro/bin/CC -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/opt/src/mysql-3.23.52/include -DHAVE_RWLOCK_T -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses ../libmysql/libmysqlclient.la -lz -lgen -lsocket -lnsl -lm /opt/SUNWspro/bin/CC -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/opt/src/mysql-3.23.52/include -DHAVE_RWLOCK_T -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses ../libmysql/.libs/libmysqlclient.so -lz -lgen -lsocket -lnsl -lm -lz -lgen -lsocket -lnsl -lm -R/opt/local/lib/mysql ld: warning: file ../readline/libreadline.a(readline.o): wrong ELF class: ELFCLASS64 From the ld man page: No command-line option is required to distinguish 32-bit or 64-bit objects. The link-editor uses the ELF class of the first input relocatable file it sees to govern the mode in which it will operate. The error message, combined with the above knowledge, means ld is in 32 bit mode and the 64-bit class of libreadline is a mismatch. I don't know what the first relocatable file is in your CC line is, so one way to determine what's going on is to set the LD_OPTIONS environment variable to the proper switch ('-64' I believe) that forces 64-bit mode and retry the compile. Then you'll see complaints about the 'offending' 32-bit libraries which will help you narrow down the problem. You may need to do things like make /usr/lib/sparcv9 come AHEAD of /usr/lib so that the linker attempts the system's 64-bit libs first. Offhand I'm not sure if setting your LDFLAGS will do the trick as I'm not sure if that's used before the default /usr/lib or not. It's been a while since I did this and I no longer have access to the machine to test... Perhaps toying with LD_LIBRARY_PATH (and make LD_RUN_PATH match) environment variables will work .. IE setting them to '/usr/lib/sparcv9:/usr/lib' [snip] HTH, -=| Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 PROTECTED] Subject: List users? How would I list all users via the command line? sql,query -- Mike Yrabedra President 323 Enterprises Home of The MacDock and The MacSurfshop [http://macdock.com] : [http://macsurfshop.com] VOICE: 770.382.1195 ___ in all your ways acknowledge Him and He will direct your paths. Proverbs 3:6 NIV {{{ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: list of tables in a database
show tables will get you a list of tables. To get the schema of tables type 'describe tablename' 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 does one do this in MySQL? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 of all tables and their schemas. How does one do this in MySQL? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 behavior is by design. Once upon a time in a land very far away (okay, many lands; it's the Internet), people would instantly post to the list when they got stuck without checking the online documentation, which even then was quite extensive and thorough. The administrivia that shows up at the end of each message is by design to give people the hint to check the manual before posting; and a quick unsubscribe reference for the occasional list member who has a nervous breakdown during the departure-from-the-list process. Van (Look, it will be right after this line {unless you use lookOut mailer}) -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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), and couldn't find anything.. Yeah, that book is pretty bad. And the folks at O'Reilly know it. They're finally working on a book to replace it. (Amusingly, they weren't interested a year or so ago when I talked to them about it.) Is there a list in the manual? If not, someone should really think of adding a section to the Functions area to list out all of the aggregate ones. Probably a good idea if they aren't already clearly labeled in the manual. On that note, I'm curious if there is an aggregate version of CONCAT or CONCAT_WS (and if there isn't, make a suggestion for the creation of them). Something like join() in Perl, maybe? I'm not sure quite what you're looking for. Can you give an example of where/how you'd use it? It might also be nice for whoever writes the manual to include the minimum MySQL version supporting the function (my ISP is still using 3.22 and it's annoying to learn of a cool function only to find out that it doesn't work when I try it)... That's in the manual sometimes, and sometimes not. What you really need is the manual that comes with the 3.22 distribution. Then you won't have that problem. What you really need to do is get your ISP to jump into the year 2001 and upgrade. But you already knew that. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 1 days, processed 18,181,878 queries (186/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. This works well with other services, but it takes me (no exaggeration) 2 hours to subscribe to the mysql list. It usually takes over an hour for my post to appear. This list is the only one I have problems with, so I have 3 questions: 1. Is it something at my end? i.e. subscribe/unsubscribe is blazing fast for everyone else? 2. Is it something at the mysql list end? If so, why is it so slow? 3. Are there alternatives with the same quality of information for questions? (I havent found any) You could send in your question and then watch the archives on http://lists.mysql.com/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 259,872,258 queries (90/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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" fi done Regards, Rosana "Gerald L. Clark" wrote: 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, Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php