RE: Rookie question
OR would not show dups. WHERE duespaid AND cat1 OR cat2 means WHERE (duespaid AND cat1) OR cat2 That is probably not what you wanted -- add parens like WHERE duespaid AND (cat1 OR cat2 ...) But... That is not a good way to build a schema. What will happen when you add category9? Plan A: Have another table that says which categories a user has. There would be 0-8 rows in this new table for each category. SELECT d.* FROM directory d JOIN categories c ON d.userid = c.userid WHERE c.category IN (1,2,3,4,5,6,7,8); Plan B: Use a SET as a single column for all the categories. Then AND (categories x'ff') != x'00' would check that at least one bit is on in the bottom 8 bits of that SET. (TINYINT UNSIGNED would work identically. Change to SMALLINT UNSIGNED for 9-16 categories; etc.) There is probably a Plan C. -Original Message- From: Gary Smith [mailto:li...@l33t-d00d.co.uk] Sent: Monday, April 29, 2013 10:43 AM To: mysql@lists.mysql.com Subject: Re: Rookie question On 29/04/2013 18:29, Patrice Olivier-Wilson wrote: Hi all: I have a membership directory where folks can belong to more than one category. But all folks do not qualify for a category. So I want to list folks who have qualified in a category but not have them repeat. So if member 1 is in cat 3 and cat 5, I want their name only to show up once. Here's what I have so far, but it shows a member listed more than once. select distinct ? Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Rookie question
On 29/04/2013 18:29, Patrice Olivier-Wilson wrote: Hi all: I have a membership directory where folks can belong to more than one category. But all folks do not qualify for a category. So I want to list folks who have qualified in a category but not have them repeat. So if member 1 is in cat 3 and cat 5, I want their name only to show up once. Here's what I have so far, but it shows a member listed more than once. select distinct ? Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: db/mysql rookie request
Hi, You can use this template. The idea is the same. All your line commands for certain task can be embedded in a single script : http://webxadmin.free.fr/article/mysql-use-shell-script-to-dump-all-databases-t-54.php Mathias Selon Jorgensen, Bill [EMAIL PROTECTED]: MySQL guys: I am new to databases, MySQL, and anything outside of my world of UNIX system administration. A former colleague of mine set up MySQL on our backup server and I would like to interface with the database to get reports. I have read a little and understand a few things. I have taken the time to develop some SQL to get the data I would like to get. However, I want to do this with a Korn shell script that emails the report to a list of internal customers. Any help you can provide would be greatly appreciated. Thanks in advance, Bill Bill Jorgensen CSG Systems, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
db/mysql rookie request
MySQL guys: I am new to databases, MySQL, and anything outside of my world of UNIX system administration. A former colleague of mine set up MySQL on our backup server and I would like to interface with the database to get reports. I have read a little and understand a few things. I have taken the time to develop some SQL to get the data I would like to get. However, I want to do this with a Korn shell script that emails the report to a list of internal customers. Any help you can provide would be greatly appreciated. Thanks in advance, Bill Bill Jorgensen CSG Systems, Inc.
MySQL Rookie having trouble with query containing several outer j oins
I'm new to MySQL and have tried many attempts myself and looked all over for this answer to no avail. How do I write MySQL joins to accomodate the Oracle equivalent listed belowany help would be appreciated. From iteration, story, person tracker, person customer, person developer, task, time_entry Where iteration.id=story.iteration_id and story.tracker_id=tracker.id(+) and story.id=task.story_id(+) and story.customer_id=customer.id(+) and task.acceptor_id=developer.id(+) and task.id=time_entry.task_id(+) I've got this so far, but it seems to be returning a cartesian product between iteration and story SELECT task.name, developer.name, time_entry.start_time, story.name, customer.name, tracker.name, iteration.name FROM ( ( (story left outer join (task left outer join time_entry on task.id=time_entry.task_id left outer join person as developer on task.acceptor_id=developer.id ) on story.id=task.story_id ) left outer join person as customer on story.customer_id=customer.id ) left outer join person as tracker on story.tracker_id=tracker.id ) join iteration on story.iteration_id=iteration.id
Re: MySQL Rookie having trouble with query containing several outer joins
* [EMAIL PROTECTED] I'm new to MySQL and have tried many attempts myself and looked all over for this answer to no avail. How do I write MySQL joins to accomodate the Oracle equivalent listed belowany help would be appreciated. From iteration, story, person tracker, person customer, person developer, task, time_entry Where iteration.id=story.iteration_id and story.tracker_id=tracker.id(+) and story.id=task.story_id(+) and story.customer_id=customer.id(+) and task.acceptor_id=developer.id(+) and task.id=time_entry.task_id(+) I've got this so far, but it seems to be returning a cartesian product between iteration and story [...] Ouch. I find this syntax easier: From iteration left join story on iteration.id=story.iteration_id left join person tracker on story.tracker_id=tracker.id left join person customer on story.customer_id=customer.id left join task on story.id=task.story_id left join person developer on task.acceptor_id=developer.id left time_entry on task.id=time_entry.task_id The WHERE clause is eliminated in this case. Had to move task before developer, the tables are read in the order you provide when using left joins. URL: http://www.mysql.com/doc/en/JOIN.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: A rookie question
--- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Paul Romanic [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 03:53 To: [EMAIL PROTECTED] Subject: A rookie question Hello, and apologies for such a novice question... we were all there once :) I have a need to find a method to allow a user to update information on members of our organization. The typical number of students' info that needs updated is 50-75. The info to be updated is grade change, and year of Latin change for each student. My initial thought (if I transfer the database to MySQL from FileMaker) is to set up the database as a relational database with students in one table, the schools in a second and the school name being the link. The real question is...if I use PHP to access MySQL, can I allow the user to edit the records (or portion of them) from one Web page with ONE submit button? Is this even possible? I want know I could do this with a submit button for each member, but that would not be too end user friendly! yes my usual approach is to have the form fields labelled so they return an array. You then work through the array in the script that you post to, updating one record at a time. You may find examples out there, http://www.phpbuilder.com is good source. If you need any more information email me offlist and I will send some sample code. HTH Peter Thanks for putting up with a novice question, and any help you can offer! Paul J. Paul Romanic, R.A. State Chair Ohio Junior Classical League - 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
A rookie question
Hello, and apologies for such a novice question... I have a need to find a method to allow a user to update information on members of our organization. The typical number of students' info that needs updated is 50-75. The info to be updated is grade change, and year of Latin change for each student. My initial thought (if I transfer the database to MySQL from FileMaker) is to set up the database as a relational database with students in one table, the schools in a second and the school name being the link. The real question is...if I use PHP to access MySQL, can I allow the user to edit the records (or portion of them) from one Web page with ONE submit button? Is this even possible? I want know I could do this with a submit button for each member, but that would not be too end user friendly! Thanks for putting up with a novice question, and any help you can offer! Paul J. Paul Romanic, R.A. State Chair Ohio Junior Classical League - 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: Rookie admin needs install help
Strange. I've never had any problems with the RPMs - Original Message - From: Duane Douglas [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 21:59 Subject: Re: Rookie admin needs install help At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote: Unix rookie as well? 0 | 0 \__/ Off the top of my head, rpm -i file_name should do it. I usually use redhat's gui. man rpm will give you more details. evidently, there's something wrong with the rpm package for linux. the binary at mysql.com installs fine. also, the binary at sourceforge doesn't install properly either. if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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: Rookie admin needs install help
At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote: I don't know whether slackware has the RPM software but if it does, use it. You won't have these problems then. Otherwise I can only suggest you try one of the other binaries instead. i'm also a mysql admin rookie. i couldn't get the rpm file to install and my linux distribution has the rpm software. however, i was able to install the tarball. hth if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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: Rookie admin needs install help
Unix rookie as well? 0 | 0 \__/ Off the top of my head, rpm -i file_name should do it. I usually use redhat's gui. man rpm will give you more details. - Original Message - From: Duane Douglas [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 13:20 Subject: Re: Rookie admin needs install help At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote: I don't know whether slackware has the RPM software but if it does, use it. You won't have these problems then. Otherwise I can only suggest you try one of the other binaries instead. i'm also a mysql admin rookie. i couldn't get the rpm file to install and my linux distribution has the rpm software. however, i was able to install the tarball. hth if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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: Rookie admin needs install help
At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote: Unix rookie as well? 0 | 0 \__/ Off the top of my head, rpm -i file_name should do it. I usually use redhat's gui. man rpm will give you more details. evidently, there's something wrong with the rpm package for linux. the binary at mysql.com installs fine. also, the binary at sourceforge doesn't install properly either. if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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
Rookie admin needs install help
This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - 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
Fw: Rookie admin needs install help
Well today just isn't my day. My mail forwarding was broken till just now. If you responded to this question earlier, could you please send the response to [EMAIL PROTECTED] again? Thank you, patrick - Original Message - From: Patrick Malone [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 12:22 PM Subject: Rookie admin needs install help This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - 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: Rookie admin needs install help
I don't know whether slackware has the RPM software but if it does, use it. You won't have these problems then. Otherwise I can only suggest you try one of the other binaries instead. - Original Message - From: Patrick Malone [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:22 Subject: Rookie admin needs install help This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - 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
Rookie...
Hi, I'm a total newbie to MySQL. I am creating an application in Java/JSP/Oracle. However, my client wants to move to MySQL because of the low costs, and I have no idea about MySQL. I just downloaded the API from MySQL.com I now need to know the following things : 1. Is there a graphical utility (like SQL Plus for oracle) that I can use to manage the database ? 2. I saw something about a MySQL GUI on the site. But it was full of classes and stuff. How do I install/use them? 3. I saw a tcFM JDBC driver on the web. Is that the best ? Are there any known bugs ? 4. What are the potential problems that could arise with using MySQL in the long run ? How easy is it to maintain from the backend ? Do I have to necessarily write 'raw code' like CREATE. to create a table ? I would really really appreciate any kind of information and/or insight into any of the stuff above, or even just URL's to good resources on the web. I've been searching the web, and the resources I've been seeing are pretty vague and are not answering my questions. I feel like the way I felt 5 years back when facing the web for the first time - totally LOST!! Thanks, Ravi http://BabyNamesIndia.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