Re: MySQL Searchable Mailing List Archive now up.
This is a very very good search engine for the mailing list!!! Great work Two things: 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne Robert Alexander wrote: Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive It's still in BETA, so this is a test release to see how it holds up. It's fully searchable on Subject or Body, on the From address, and by date range. It's running on a reasonably decent box (a Sun Ultra 1), but on a fairly slow connection (for now). The pages are quite compact, though, so as long as not everybody hits it at once, it should give pretty decent performance. : Written in Perl with MySQL as the backend, of course. : The archive is updated in real-time as the mails arrive, so it should always be up-to-the-minute. Take a minute and let me know what you think -- it's a work in progress, and feedback is appreciated. Thanks, all! /Rob - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySQL Searchable Mailing List Archive now up.
Netscrap 4.78 oops sorry mispelled that one.. Netscape :) I do loads of html and I hate Netscape with a passion, I think 6.2 renders pages like IE4, but I'm not even sure, and only .2% of websurfer use it. www.technodium.net/kira/kira.htm check this out with IE = perfect.. chek it out with NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) Etienne Robert Alexander wrote: At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: This is a very very good search engine for the mailing list!!! Great work Thank you! Two things: 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields Second one first: Any Date is already checked by default. What browser/OS are you using? 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me in describing how much I detest spam -- well, at least polite ones do. :-/ I believe our information is safe in this case, though. Let me explain why: To the best of my knowledge, Email harvesting 'bots (spambots) use technology similar to that used by the big web search engines. Those companies, like Google, Yahoo, etc., run two main pieces of software; one (a 'spider') that continually accesses all the sites on the web -- well, they hope it's all of them -- and stores information about, or a complete copy of, each page they find. These pages are stored in their database on their big, fire-breathing computers (it's a staggering amount of data) and that's what the _other_ piece of software, the search engine, looks through when you do a search. The spambots do basically the same thing -- they gather up web pages. They, however, simply extract anything that looks like an email address. These lower-than-pond-scum then add that to their database (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that you 'opted-in' or 'expressed an interest.' Fortunately, search engine page gatherers and spambots can access only 'static' html pages that exist on a server and can be searched. The pages you see when you search the email archive are safe from 'bots because they don't even _exist_ until you ask for them -- they're generated on-the-fly, on demand, and they're sent directly to your computer. The content of the archive is visible only to the person doing the search. So, it's a 99% solution. There's still the chance that an unscrupulous person could go to the effort of doing an archive search in the hopes of getting some email addresses to spam, but that's simply not their style; that's too much like legitimate work. Pirating email addresses is 'profitable' (I guess) if they let a computer do all the work; it's not if a person has to write them down or type them in. There are places that DO put the contents of mailing lists up on the web on static, searchable pages. You should be aware of them so you can make better-informed decisions, and thereby have more control over where your address appears. One site with the MySQL list is http://dbforums.com/f114/. Or try, for example, http://www.mail-archive.com/dbi-users@perl.org/msg06361.html For an interesting exercise, you should try going to www.google.com, or your favourite search engine, and doing a web search on your email address and/or your phone number. The hits you get on that search are the prime places where spambots are getting your email address from. I truly believe we're safe, though I'd love to hear more comments. All the best, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySql forum or newsgroup
If benjamin and all other gurus read/post on the webforum, sure I'd like it, since it's not easy to manage hundreds of emails a day... Etienne Jason Rowski wrote: Hi, I willing to build and host a free mySQL discussion forum/newsgroup for the mySQL community. I have web space available and can easily build a discussion forum using vbulletin and mySQL in a couple of days. Does the mySQL community think that we need a discussion forum where all the mysql messages are archived and offer superor search options ? Any comments and feedback is appreciated. Thanks Jason [EMAIL PROTECTED] --- John Meyer [EMAIL PROTECTED] wrote: Would it be too much to suggest that mysql.com host its own news server or is that too pricey? __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: possible bug?
anti spam words: database,sql,query,table you can first put it here to be sure it's a bug be specific, showing table definitions, query that is not working please provide OS, mySQL version, any relevant information Etienne Karl J. Stubsjoen wrote: database,sql,query,table Hello, Where is the correct place/procedure to report a possible bug? I think I found one. Karl Karl Stubsjoen excelbus.com/info-m - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySql forum or newsgroup
Sorry but I've never seen a mailing list archive really working.. No good search feature, hard to follow a thread (next by thread, next by date, etc) Plus to post you need to be member of the mailing list, therefore receive 400 emails a day... On a forum you register, you post only when you have question, you have separate areas (installation, query problem, design problems, innoDB problem, let's say) and you can do specific searches. You can also have email notice when a reply is made to a thread you started asking a question. my 2 cents... Etienne Philip Molter wrote: On Fri, Dec 14, 2001 at 07:16:40AM -0800, Jason Rowski wrote: : Hi, : : I willing to build and host a free mySQL discussion : forum/newsgroup for the mySQL community. I have web : space available and can easily build a discussion : forum using vbulletin and mySQL in a couple of days. : : Does the mySQL community think that we need a : discussion forum where all the mysql messages are : archived and offer superor search options ? Any : comments and feedback is appreciated. Why not just stick a web-frontend on to the mailing list? That way, there aren't two separate areas of MySQL support. There's already archives of the mailing list, and it sounds like what people want is the functionality of the mailing list without the inbox clutter. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: sub selects
no, but you can acheive the same results please consult the manual http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Etienne Joel Wickard wrote: can you perform sub selects in mysql? - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Best Free Web Panel for mySQL
http://www.gossamer-threads.com/scripts/mysqlman/index.htm I think they have what you are looking for Etienne David Jourard wrote: Hi, Could someone recommend the best perl web panel to maintain the databases and tables for mysql. Something similar to phpMyAdmin but in perl. Thank-you David - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
[OT] When to un-normalize
Ok let's say I have a table for artists informations. Some artists have two names, let's use know ones, Prince and The Artist I made a table artists that host different info for that artist, then made a table with artistnames where i have artistID and artistName. SELECT artistCity from artists,artistnames WHERE artists.artistID = artistnames.artistID AND artistName = foo; But, since there are maybe less than 1% of artists with many names, I tought maybe i could de-normalize my artists table to put artistName and artistAKA BUT, ever search would have SELECT artistCity FROM artists WHERE artistNAME = foo OR artistAKA = foo Which would disable the index searching because of the OR right? Please give some advises!!! Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
[OT] mod_perl and last_insert_id() (Was: sequence and nextval)
If running mod_perl does this stay true??? Isn't mod_perl using an already opened connection to do subsequent manipulations? Or when one perl script is using a connection is creates a new connection for each perl script that starts running and if a perl script finishes, it keeps that same db handle for the next perl script asking a connection? If this is the case than I magine last_insert_id will always return the good value.. sorry if this is mod_perl related Etienne Carsten H. Pedersen wrote: Thanks, but how secure is this. Is it possible for two computers to do the select at the same time, i.e. get the new incremented value? Computer one insert, computer two insert, computer one select, computer two select? If this is possible how can I solve this? To make the column that insert the new nextval unique and then check for errors (non-unique insert) and if error then re-ask for a new nextval? Is this the best solution? It's not possible to mix up the values. The value returned last_insert_id() is conncection specific, so each computer will receive only the value that it generated. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq Thanks / Henrik --- create table MySequence ( nextval int(10) not null default '0' auto_increment ) ; insert into MySequence values (''); select LAST_INSERT_ID(); is what I use M -Original Message- From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] Sent: 13 December 2001 15:41 To: [EMAIL PROTECTED] Subject: sequence and nextval Does the above functions exist in MySQL? If not, when do you think it's going to be implemented and how can I simulate nextval the easiest way? / Thanks Henrik - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySQL on Win2000
use the mysql.exe file in c:/mysql/bin double click it and it opens a dos shell where youcan do all commands! mysql use test; Database changed mysql create table firsttable( - ID int unsigned auto_increment, - primary key(ID)); Query OK, # rows affected (0.00 sec) mysql so on.. when you press enter it gives a new line, when you put a ; and press enter it sends the query! Etienne Alex Shi wrote: Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: SELECT'ing only 1st matching row
If you are using perl/DBI you can usee my @row = $dbh-fetchrow_array() instead of the usual while()... it will only take the first row returned. Etienne Ron Jamison wrote: Tack on a LIMIT 1 on the end of your query to limit the returned rows to 1. Reference: http://www.mysql.com/doc/S/E/SELECT.html -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:47 PM To: MySQL (E-mail) Subject: SELECT'ing only 1st matching row Is there a way to SELECT only the first matching row of a query? I would like to allow the registration of identical products (unique serial numbers / owned by one user), without the user having to re-enter all their data. I've set up a page that allows them to just enter their login info (username and password) and the serial number of the product they want to register. What I need to do is grab their product preferences to be duplicated in the new record, however is they have more than one registered product, it throws off my plan. I only need one record to get the values that I need. (I know that duplicating values is not proper database form, however I need to allow the user to change their preferences on each owned product.) Any advice, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySQL on Win2000
I never used any kind of ODBC and can connect to mySQL with the mysql.exe from c:/mysql/bin/ also with perl/apache locally installed I can make perl script to play intop the DB without even thinking about ODBC my 2 cents Etienne Miguel Angel Solórzano wrote: At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like Perl, PHP, Python, any one which uses ODBC driver (you need to download MyODBC driver from our site), C/C++, Delphi, VB. Regards, Miguel Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: [PHP] Performance
what?? that is a joke? I mean disconnectiong at every single little block ending? I just can't beleive it, probably you can put that in an inc file for connection, call the connect at the beginning of the script, and call disconnection at the end. It's impossible that you have to reconnect each time you want to prepare/execute something! I'm only coding perl so I don't know php at all, but I'm sure you can stay connected for at least all the time the same script is running... so many websites uses mysql/php... Etienne markus|lervik wrote: On Thu, 2001-12-13 at 22:16, Ron Jamison wrote: I'm fairly sure there's no difference in performance when using PHP tags mixed with HTML blocks as you are doing. Think of it as PHP knowing that it should send everything not in ? ? tags directly to the browser. Like an echo or a print, but without needing to specify calls to those functions. HTML ? echo $PHP_SELF ? /HTML HTML ?=$PHP_SELF? /HTML I'm not -that- worried about performance loss for switching between, php and html, what annoys me (and would probably slow down performance quite a bit), is that every time I have to do a database query, I have to use mysql_connect again, because as Prottoss pointed out, PHP drops the connection every time a PHP-block ends. Not that it is that a big issue for my particular application, but knowing a workaround to this problem would be quite useful in the future. Cheers, Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Public Library - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Performance
Bon apràs-midi René, Well keeping a connection alive is way better on performance.. that is why, under mod_perl, it keeps the connections alive. You should connect at the beginning of the script, and always use that same database handle for the script run. Then close it. Etienne René Fournier wrote: Is it true that mixing HTML and PHP--switching back and forth with ?php ? tags--slows down performance? (I'm using PHP4.) Is it better to echo output than to drop out of PHP mode? And concerning database connections, my ISP asks that I always close a MySQL connection with a mysql_close()--which I can understand. But I'm curious, if I have to make, say, 10 SELECTs throughout a page (in the header, body, and footer), is it perhaps faster to use the mysql_close() at the very end of the page (in the bottom of the footer.inc)? In other words, is there any disadvantage performance-wise (or stability reason) to open and immediately thereafter close mysql connections? Can anyone recommend an article or two on coding techniques for improving PHP and MySQL performance? I don't wan to spend the rest of my life optimizing my php code, but if I knew a few basic rules about its performance characteristics, I might be able to make better decisions when coding. Thanks. ...Rene --- René Fournier, [EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: [OT] A News Group Perhaps.
also screen what you don't need. I delete everything regarding installation. I don't have solaris and I don't have red hat so 80% of the install questions I can't help. You can set up pretty complex sorting rules. It might take a couple of weeks to set up, but once it's done you should receive only wanted informations. My 2 cents Etienne Tony Buckley wrote: Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: ADV: Dear Future Millionaire:
. = '' It really is a great opportunity to make relatively easy money with little cost to you. I followed the simple instructions carefully and within 10 days the money started to come in. My first month I made $20,560.00 and by the end of third month my total cash count was $ 362,840.00. Life is beautiful, Thanx to internet''. Fred Dellaca, Westport, New Zealand = ORDER YOUR REPORTS TODAY AND GET STARTED ON YOUR ROAD TO FINANCIAL FREEDOM ! If you have any questions regarding this great deal please write me at [EMAIL PROTECTED] If you wish to be removed from the mailing list please send an email to [EMAIL PROTECTED] with the word REMOVE in the subject line. = If you have any questions of the legality of this program, contact the Office of Associate Director for Marketing Practices, Federal Trade Commission, Bureau of Consumer Protection, Washington, D.C. GOOD LUCK TO ALL = ONE TIME MAILING, NO NEED TO REMOVE = This message is sent in compliance of the proposed bill SECTION 301, paragraph (a)(2)(C) of S. 1618. Further transmission to you by the sender of this email may be stopped at no cost to you by sending a reply to:[EMAIL PROTECTED] with the word REMOVE in the subject line.This message is not intended for residents in the State of Washington, screening of addresses has been done to the best of our technical ability. - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: find_in_set syntax
mysql create table gd_records( - id int unsigned auto_increment, - res_skills set(skills1,skills2,skills3,skills4,skills5,skills6), - res_skills_ma set(skills_ma1,skills_ma2,skills_ma3,skills_ma4,skills_ma5,skills_ma6), - primary key(id)); Query OK, 0 rows affected (0.00 sec) [Enter some values] mysql select * from gd_records; ++-++ | id | res_skills | res_skills_ma | ++-++ | 1 | skills1,skills2 | skills_ma4,skills_ma5 | | 2 | skills2,skills4 | skills_ma2,skills_ma3 | | 3 | skills1,skills3 | skills_ma3,skills_ma6 | | 4 | skills4,skills5 | skills_ma2,skills_ma6 | | 5 | skills1,skills4 | skills_ma2,skills_ma3 | | 6 | skills1,skills2,skills3 | skills_ma1,skills_ma3,skills_ma5 | | 7 | skills3,skills4,skills5,skills6 | skills_ma1,skills_ma2,skills_ma3,skills_ma5,skills_ma6 | | 8 | skills1,skills3,skills4,skills6 | skills_ma2,skills_ma4,skills_ma5,skills_ma6| ++-++ 8 rows in set (0.00 sec) mysql SELECT FROM gd_records WHERE FIND_IN_SET(skills3,res_skills) AND FIND_IN_SET(skills_ma3,res_skills_ma); ++-++ | id | res_skills | res_skills_ma | ++-++ | 3 | skills1,skills3 | skills_ma3,skills_ma6 | | 6 | skills1,skills2,skills3 | skills_ma1,skills_ma3,skills_ma5 | | 7 | skills3,skills4,skills5,skills6 | skills_ma1,skills_ma2,skills_ma3,skills_ma5,skills_ma6 | ++-++ 3 rows in set (0.00 sec) Tadam you can't use the WHERE col_name value ehrne you have more than one SET afaik HTH, Etienne Wiliam Stephens wrote: At 17:40 11/12/01, you wrote: Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Yeah, Both are SET columns. Wil -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: [OT] A News Group Perhaps.
Well that's called a forum and it's not at all like a mailing list :-) But yes there could be a forum, but there are already some on the net www.devshed.com have a mySQL part and a Perl part and a PHP part. Plus a forum requires servers, space, web hosting, DNS, maintenance, moderation, programming.. the mailing list is al up and running. I don't like vbulletin, well I don't like the fact that you get the header and wait, wait and wait for the body to display, it's getting the messages out of the DB everytime a user loads a page and the little 3-4 seconds it takes to get the info is annoying :) my 2 cents Etienne Kelly Firkins wrote: I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it because I have set up this program and know how well it works. It's a great example of PHP and MySQL working together. Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Kelly Firkins [EMAIL PROTECTED] _ Chat with friends online, try MSN Messenger: http://messenger.msn.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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: find_in_set syntax
Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Etienne Wiliam Stephens wrote: Hi Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, I'm using the following: ELECT * FROM gd_records WHERE res_skills 3 AND res_skills_ma 3; And it returns the most weird results. It completely ignores the AND statement, and returns results even if the second statement is true or not? Why is this? Is this a major bug or is there a problem with my query? Thanks Wiliam Stephens Web Developer http://www.fbagroup.co.uk - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: efficient DELETE query - 2 tables
mySQL can't do subselects afaik Etienne Harlan Feinstein wrote: Rory I want to write an efficient query that will delete all records Rory from one table when they show up in another table (pending Rory shipments -- shipped shipments). I can't do it with this: mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno; Rory because you can only refer to columns of one table in a delete Rory query. Does anybody have an effiecnt way for me to do this with Rory Perl DBI? This isn't really a Perl question, is it? Isn't the most efficient way to have the DB handle all of it? Something like: DELETE FROM pending_2 WHERE ordno IN (SELECT ordno FROM ordersearch_2) --Harlan - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Annoying article about MySql
http://www.phpbuilder.com/columns/tim2705.php3 especially: http://www.phpbuilder.com/columns/tim2705-res.php3 those aren't from the latest releases of both DB, but gives a good idea. Someone in replies said that the mysql that dies is not normal and some config was probably not done right. Etienne Admin wrote: I was just reading an annoying article from a user who was moving from MySql to Postgres because of stability problems and because of problems restoring large MySql data-dumps. I checked his site and it does not have the appearance of a very heavy loaded site so I am not sure what he means by large. This is the article: http://webmasterbase.com/article/529 I was wondering what size of MySqldump file creates problems when importing the datadumps (is it equipment dependent - size of memory, speed of processor etc ??), also under what circumstances does MySql become unstable (how many concurrent users? what kind of queries etc) or is the stability question something that has changed alot with version 3.23 and is just not relevant any more? I used Oracle8i before (under very heavy load) and did not have any problems there. I am now using MySql under not so heavy load and have not yet had any problems with it, but just want to be prepared when and if they come along. I would be grateful to hear your opions and experiences, good or bad. Regards, Ingvar G. us.logiledger.com Web accounting CRM - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Newbie!
Please use a more descriptive subject, you have better chances to have replies (a lot filter out subjects having only question newbie, etc Etienne Angel Gabriel wrote: Thanks for reading this. I'm new to the whole world of linux, and MySql, but I decided to get my hands dirty, and learn the whole thing. I have just installed corel linux, and I'm quite happy that the whole thing is working, and is visable on my network. Next I'm trying to get apache up and running! (Well, it's running, but I have no idea how to update the default web page!!! lol !) I've had limited experiance with MySQL, I've only ever been a user, and even then it was a remote host. My questions are as follows: Do I need to create users for the database, or does every user on the system have the right to create a table? Also, is it possible to connect to a MySQL database using Access as a front end? Thanks in advance! - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Problem
Please use a more descriptive subject... I don't use Solaris and therefore cannot help you at all with your problem. Plus a lot of users filter out subjects problem newbie question since they are usually a lost of time to read and often not related to one of their strong subject. Etienne Phillip B. Bruce wrote: Hi, I've downloaded mysql 3.23.46 version and currenlty runnig solaris 2.8 relase 10/00 on intel platform. I'm getting the following error during the ./configure stage in creating my makefile. checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! # libm.a is in /usr/lib and my LD_LIBRARY_PATH is set as followed: # echo $LD_LIBRARY_PATH /opt/orca/lib:/usr/lib:/usr/local/lib:/opt/sfw/lib:/opt/sfw/gnome/lib:/opt/orca/lib/perl:/usr/local/rrdtool-1.0.33/lib:/usr/local/lib/glib:/usr/local/lib/mysql config.log has the following: # tail -20 config.log configure:6468: checking for off_t configure:6501: checking for st_rdev in struct stat configure:6514: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6535: checking whether time.h and sys/time.h may both be included configure:6549: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6570: checking whether struct tm is in sys/time.h or time.h configure:6583: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6606: checking size of char configure:6625: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 configure: failed program was: #line 6614 configure #include confdefs.h #include stdio.h main() { FILE *f=fopen(conftestval, w); if (!f) exit(1); fprintf(f, %d\n, sizeof(char)); exit(0); } I would appreciate any ideas on this. I have compiled mysql 3.20 version in the past with no problem but wondered if this is a bug? -- *** Phillip B. Bruce *** *** http://pbbruce.home.mindspring.com *** *** [EMAIL PROTECTED] *** *** *** *** Have you ever noticed? Anybody going slower than*** *** you is an idiot, and anyone going faster than you*** *** is a maniac. - George Carlin*** - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
[OT] Undescriptive subjects.
PLEASE can everybody use a descriptive subject? Especially on a monday morning, I have over 250 messages, I really appreciate to read and learn from other's problems, but when it talks about solaris install I can't care less, I do filter subjects, but too often they are totally unhelpful. Is there a way to block Question Newbie Please help Problem and subjects alike? Or can the mailer daemon send a message similar to the one when we don't use mysql, or other database related words, that sends warning. I'm sure I'm not the only one that have a little trouble handling those. Etienne p.s. this message is in no way intended to be harsh, maybe it because we are monday morning. -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: [OT] Undescriptive subjects.
Thanks, I will definitively look for that But the blocking should be done by the mailing list, making a reply like the one for omitting mysql or database in the message. the message could just ask to put a more descriptive subject. because if every user filters out topics, then the person seeking help would have an hard time finding some. I know there are already a lot of gurus on other mailing lists that are filtering all undescriptive topics.. so I hope my message will convince users to always use a good subject so that every possible help can be gathered! Etienne Doug Thompson wrote: On Mon, 10 Dec 2001 09:08:25 -0500, Etienne Marcotte wrote: Is there a way to block Question Newbie Please help Problem and subjects alike? I use PMMail2000 which includes an impressive filtering capability to do what you're seeking. There are Windoze and OS/2 versions. http://www.pmmail2000.com hth Doug -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Index of SET Field
I think you are missing something. From the Manual: FIND_IN_SET(str,strlist) Returns a value 1 to N if the string str is in the list strlist consisting of N substrings. A string list is a string composed of substrings separated by `,' characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimised to use bit arithmetic! Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function will not work properly if the first argument contains a `,': mysql SELECT FIND_IN_SET('b','a,b,c,d'); - 2 = I don't know what exactly you're trying to acheive, but I'm pretty sure FIND_IN_SET is not what you are looking for. Can you give table descriptions and what is the data you want at the end of your query? Etienne Wiliam Stephens wrote: Hi How can I create an index of a SET field so that a FIND_IN_SET can search for a column number rather than name? Is this even possible in MySQL? It might seem like a bug? Thanks. Wiliam Stephens Web Developer http://www.fbagroup.co.uk - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Index of SET Field
read http://www.mysql.com/doc/S/E/SET.html for the set, how it works internally... humm.. is that what you want? : mysql CREATE TABLE test( - id INT UNSIGNED AUTO_INCREMENT, - place SET(Whales,North,South); - PRIMARY KEY (id)); Query OK, 0 rows affected (0.00 sec) [insert some values] mysql SELECT * FROM test; ++--+ | id | place| ++--+ | 1 | Whales,North | | 2 | Whales,South | | 3 | North,South | ++--+ 3 rows in set (0.00 sec) mysql SELECT * FROM test WHERE place LIKE %Whales%; ++--+ | id | place| ++--+ | 1 | Whales,North | | 2 | Whales,South | ++--+ 2 rows in set (0.00 sec) mysql SELECT * FROM TEST WHERE FIND_IN_SET('Whales',place)0; ++--+ | id | place| ++--+ | 1 | Whales,North | | 2 | Whales,South | ++--+ 2 rows in set (0.00 sec) mysql SELECT * FROM TEST WHERE place 1; ++--+ | id | place| ++--+ | 1 | Whales,North | | 2 | Whales,South | ++--+ 2 rows in set (0.00 sec) [This one is the best one IMO] or even if you wanna be specific: mysql SELECT * FROM TEST WHERE place = Whales,North OR place = Whales,South; ++--+ | id | place| ++--+ | 1 | Whales,North | | 2 | Whales,South | ++--+ 2 rows in set (0.00 sec) But i don't suggest this one! HTH Etienne Wiliam Stephens wrote: Hi Thanks for your reply. I've got the field res_places_sl. It's a SET field that consists of the following options: 'Wales','North','South' I was using FIND_IN_SET('Wales',res_places_sl); to access all records that were categorised under 'Wales' which worked great. Now, I want to be able to access them from their numerical position. i.e. if I wanted to access 'Wales' I would ideally want to use something like FIND_IN_SET('1',res_places_sl); But that doesn't seem to want to work. The reason I want this is that I don't want to pass the category name in the URL, but passing a numerical reference would be ideal. Is there a way to do this? Thanks for your help. Wil At 16:54 10/12/01, you wrote: I think you are missing something. From the Manual: FIND_IN_SET(str,strlist) Returns a value 1 to N if the string str is in the list strlist consisting of N substrings. A string list is a string composed of substrings separated by `,' characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimised to use bit arithmetic! Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function will not work properly if the first argument contains a `,': mysql SELECT FIND_IN_SET('b','a,b,c,d'); - 2 = I don't know what exactly you're trying to acheive, but I'm pretty sure FIND_IN_SET is not what you are looking for. Can you give table descriptions and what is the data you want at the end of your query? Etienne Wiliam Stephens wrote: Hi How can I create an index of a SET field so that a FIND_IN_SET can search for a column number rather than name? Is this even possible in MySQL? It might seem like a bug? Thanks. Wiliam Stephens Web Developer http://www.fbagroup.co.uk - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: mysql round problem
That rule is usually to try and get at the end the most accurate value, if your numbers are evenly distributed your final value will be closer to the good one. So if your values will never have the rounding digit odd so you'll always be discarting half the smallest digit.. at the end of multiple calculations you generate bigger errors. Sometimes one can say, you alternate when having middle values, once you go up, once down... Sometimes it's better to go up, for money calculations, etc This is getting off topic anyways Etienne Dibo Chen wrote: The rounding rule I learnt many years ago said, rounding in 1 if previous digit is odd but discarding it if even. so 9.065 - 9.06, 9.055 - 9,06, ... Attila Soki wrote: hi, is this bug already in buglist, maybe in newer verisons of mysql is already corrected? if yes then please let me know please from what version. the probmlem: select round(9.065,2) ++ | round(9.065,2) | ++ | 9,06 | ++ why not 9,07 ?? cheers, Attila Soki - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: mysql round problem
maybe you can add a small value to be sure it rounds up. select round(9.065+.001,2); Always add 1 at the digit after the one you want to keep:) so 9.065 can also be a variable... Etienne Shankar Unni wrote: Attila Soki wrote: select round(9.065,2) ++ | round(9.065,2) | ++ | 9,06 | ++ why not 9,07 ?? Most C compilers today defer things like round() to the floating-point unit on the CPU. Most CPUs these days implement IEEE754 as their FP standard, and IEEE 754 defines several rounding modes that the processor can be set to to define the behavior of the round operation. The default (usually) is round to nearest even (which is what the others have pointed out). You can also set it to round towards zero, round away from zero, or round towards minus infinity. The application is supposed to know what behavior it prefers, and set the default rounding behavior on the FPU by using a specific control instruction. The operating systems are supposed to cooperate by saving and restoring the process' FP rounding preference when restarting the process after an interrupt. Needless to say, there's a fair amount of confusion on this front, and certainly no portable solution, though I believe the latest C standard (C99) has some APIs to control this. The only other choice is to never depend on the FPU rounding, but always call a software FP round routine to perform your rounding, if it's that important. MySQL hasn't done this (and neither have any of the other DB packages I've used recently). -- Shankar. - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: mysql round problem
[EMAIL PROTECTED] wrote: [blabla because there is no sql in my text] You have written the following: Good point well then the best is two smaller than the highest resolution you have. if all your data has 4 digits after the . you'll be ok with a epsilon 2 digits smaller since you're sure that it won't affect the 4th digit after the . Etienne Shankar Unni wrote: Etienne Marcotte wrote: maybe you can add a small value to be sure it rounds up. select round(9.065+.001,2); Always add 1 at the digit after the one you want to keep:) so 9.065 can also be a variable... Etienne Shankar Unni wrote: [Long-winded IEEE float explanation :-)] That's a reasonable solution, though you have to be sure to add a *really* small epsilon (as small as you can reasonably represent in source code). The danger with a large epsilon like 0.001 is that 9.4995 will round as 10 instead of 9, even though it's clearly smaller than 9.5. Some people may care :-). -- Shankar. -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Query and join problem with null values
mysql create table users( - usrID smallint unsigned auto_increment, - usrZip char(5), - primary key(usrID)); Query OK, 0 rows affected (0.00 sec) mysql create table cities( - ctyZip char(5) not null, - ctyName varchar(30) not null, - primary key(ctyZip)); Query OK, 0 rows affected (0.00 sec) [Insert some values] mysql select * from users; +---++ | usrID | usrZip | +---++ | 1 | 90210 | | 2 | 12345 | | 3 | 30300 | | 4 | NULL | +---++ 4 rows in set (0.00 sec) mysql select * from cities; ++---+ | ctyZip | ctyName | ++---+ | 90210 | Beverly Hills | | 12345 | Fubar Town| | 30300 | Rowland City | ++---+ 3 rows in set (0.00 sec) mysql select usrID, usrZip, ctyName from users left join cities on usrZip=ctyZip; +---++---+ | usrID | usrZip | ctyName +---++---+ | 1 | 90210 | Beverly Hills | | 2 | 12345 | Fubar Town| | 3 | 30300 | Rowland City | | 4 | NULL | NULL | +---++---+ 4 rows in set (0.00 sec) mysql select usrID, usrZip, ctyName from users left join cities on usrZip=ctyZip where usrID=4; +---++---+ | usrID | usrZip | ctyName +---++---+ | 4 | NULL | NULL | +---++---+ 1 row in set (0.00 sec) Is that what you are looking for? sorry I redone your table definitions, but you should have the same type of data for the linked keys (in thsi case you had varchar255 for zip in the peoples table and a tinyint for the zip in the city table. HTH Etienne Michaël Delorme wrote: Hi guys I have a problem on a SQL query : I got no records selected. Below is a sample of my 2 tables : A table identifying people, containing their adress therefore a ZIP code. However for some people I don't have their adress, so no ZIP code : Table People +--+--+ | PeopleID | zip | ... +--+--+ | 1| 1| | 2| Null | | 3| Null | | 4| 3| | ... | +--+--+ Another table describe ZIP codes and cities : Table City +-+--+ | zip | city | ... +-+--+ | 1 | aaa | | 2 | bbb | | 3 | ccc | | 4 | ddd | | 5 | eee | |... | +-+--+ Here is my query : SELECT people.peopleId, people.zip, city.city FROM people, city WHERE people.zip = city.zip and people.peopleId = 2; I don't get any selection... wheras I expect : +--+--+--+ | PeopleID | zip | city | +--+--+--+ | 2| Null | Null | +--+--+--+ Where am I wrong ? Thanks in advance Michael Here are the table definitions : CREATE TABLE `people` ( `peopleId` tinyint(1) unsigned NOT NULL auto_increment, `zip` varchar(255) default NULL, PRIMARY KEY (`peopleId`) ) CREATE TABLE `city` ( `zip` tinyint(1) unsigned NOT NULL auto_increment, `city` varchar(255) default NULL, PRIMARY KEY (`zip`) ) __ Michael Delorme GIS Manager French Mediterranean Botanical Conservancy mailto:[EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Creating MySQL table w/2 primary keys
that doesn't create two primay keys it uses both colums to form the primary key, which is A LOT different. if you use primary key (a,b) be sure to put a and b not null AND unique. otherwise you could have duplicates in either of these rows. also, if you are fetching rows based on b, it WILL NOT use the index, which is not the intended result. so primary key (a,b) is ok but you need to add either unique key(b) or unique key(b,a) Etienne A. Clausen wrote: I do it all the time, just go primary key c (a,b) A. Clausen [EMAIL PROTECTED] - Original Message - From: sherzodR [EMAIL PROTECTED] To: Demirchyan Oganes-AOD098 [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 06, 2001 11:58 Subject: Re: Creating MySQL table w/2 primary keys As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Query question
I don't get the question.. you just have to compare the values out from the database with the values from the user input. my $sth = $dbh-prepare(SELECT usremail, usrStatus from users where usrName = ?); $sth-execute(param{'name'}); my ($email,$status) = ($sth-fetchrow_array); print invalid login if (param{email} ne $email || $active ne 'Y'); Something like that, not tested at all. HTH Etienne Steve Osborne wrote: I am trying to validate a user in a login form. There are 3 things that must be true. User login name = email_login (from User table) User password = password (from User Table) User must be active: activeuser (from Owner table) = 'Y' I don't know why I'm having so much difficulty with this SQL statement, but can anyone help? Steve - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: ANN: EMS MySQL Manager 1.22 released
I think you are overreacting with your spam thing. Quoted from the link he gave: === This trial version is FULLY functional! An unregistered copy of the EMS MySQL Manager may be used for evaluation purposes for a period of 30 (thirty) days following the initial installation. At the end of the TRIAL PERIOD, the user must either register the EMS MySQL Manager or remove it from his system. === I mean, It's *directly* related to mySQL. Put a filter on OT, Off-topic, Ann and you won't see them. My 2 cents, Etienne Raymond Abel wrote: At 20:25 2001-12-06 +0500, Igor Brynskich wrote: allo Is this product free like MYSQLfront? If it is not free, Can I considere it as a SPAM (SPAM is a no sollocited commercial email) on a Mailling List? Ray Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.22) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.22? 1. Export Data: data export as INSERT statement now works in compliance with order of selected fields. (*) 2. DB Explorer: Fixed bug with host name editing in the registered database. Now edited database will be added to corresponding host node properly. 3. BLOB Viewer/Editor: Fixed bug with changes loss after current record is changed. Now the question dialogue will appear on record or field changing. (*) 4. Edit Field dialogue: 'Multiple primary key defined' error now doesn't occur after field is renamed and setted as primary key at the same time. 5. Fixed bug with data extracting with apostrophe within field value. Now each apostrophe within value will be duplicated after data extraction. 6. Fixed bug with exporting fields of type ENUM('N','Y') as INSERT statement. (*) 7. Fixed bug with ENUM('Y','N') field type. Now default values for this type will be displayed properly in the data view. 8. Import Data Wizard: Design of Import Data Wizard form was changed. (*) 9. Some minor bugfixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: NULL Strings
SELECT * FROM classification WHERE level1 = FOO AND level2 IS NULL; IS NULL instead of = NULL null is not a value, it's the abscence of value Etienne Ward, Mark wrote: I don't know how this affects anything, but, I'm running the most recent version of mySQL for win98. Why is it that an SQL statement like this (or any variation)... SELECT * FROM classification WHERE level1 = FOO AND level2 = NULL; will return an empty set. I know that there should be results. The NULL value is screwing me up. Am I even referencing it properly? Mark Ward - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: dos prompt help
hum maybe you can cut/paste with the right button of your mouse. this does not work under winNT4, but on my win2k it does, and you could try it on your machine. right click in the screen replaces the ctrl-v used for paste and it automatically cuts any highlighted text (as in mIRC) HTH Etienne Ward, Mark wrote: Okay, got through that NULL problem. Thanks. My next question is regarding using the DOS prompt. At work, I'm using Win2000. When I'm using mySQL, if I want to repeat commands, I can just press the up key without retyping the whole thing. But at home I use Win98. I can't do the same thing, even though I've got doskey running. Is there anyway to get this working under win98? I'm sure there is, but I can't really figure it out. Mark Ward - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Creating MySQL table w/2 primary keys
using primary key (col1, col2) makes no index on col2... which is not good if you lookup only in col2 primary key (col1), unique index (col2) don't forget to add not null beside your col2 definition. Etienne rc wrote: why not use a concatenated Primary key? create table tname col_name1 int, col_name2 int, PRIMARY KEY (col_name1,col_name2) you get the drift On Thu, 6 Dec 2001, sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: just moved from windows to linux mysql
http://www.linux-mag.com/2001-03/mysql_01.html There ya go, you can't have it better explained, as for the user access part. For the data transfer, that I don't know Etienne Curtis Gordon wrote: Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I am gearing up to move my databases from a windows box to the linux box. There are a couple of things I would like to be clear on before I start. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? 2) can somebody, anybody offer up some links to a quicky tutorial on loading a database with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. Thank you in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Creating MySQL table w/2 primary keys
I found a way to have two primary key, if those keys relate on many columns. mysql create table keytest( - col1 int not null, - col2 int not null, - unique index (id1,id2), - unique index (id2,id1) Query OK, 0 rows affected (0.01 sec) mysql describe keytest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id1 | int(11) | | PRI | 0 | | | id2 | int(11) | | PRI | 0 | | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) here ya go, two primary key. in my app, it's very useful for the tables linking two other tables (two tables are N:N so the middle one links) +-+ +---+ +--+ | users | | userdepts | | depts| +-+ +---+ +--+ | usrID || usrID || deptID | | usrDept | | deptID| | deptName | | usrName | +---+ +--+ +-+ (do you like my relational DB ascii figure? Then when selecting all linked entried, it uses only the index! Since it's only numbers and the indexes for search in each directions are there.. HTH Etienne sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: more than one possible column value
hum I have an hard time understanding, but if I'm right: CREATE TABLE files( fileID smallint unsigned auto_increment, filename varchar(36) not null, primary key (fileID) ) CREATE TABLE types( typeID smallint unsigned auto_increment, typename varchar(36) not null, typeext char(4) not null unique, primary key (typeID) ) You'll need a third table linking the two (because it will be a N:N relationship) A file may have many extensions and an extension may have many files. CREATE TABLE filetypes ( fileID smallint unsigned not null, typeID smallint unsigned not null, unique index (fileID,typeID), unique index (typeID,fileID) ) Now insert some dummies mysql select * from files; ++--+ | fileID | filename | ++--+ | 1 | foo | | 2 | bar | | 3 | baz | ++--+ 3 rows in set (0.00 sec) mysql select * from types; ++-+ | typeID | typename| ++-+ | 1 | photoshop image | | 2 | word document | | 3 | excel sheet | | 4 | jpeg image | | 5 | jpeg image | ++-+ 5 rows in set (0.00 sec) Now let's say you have an image that can have either jpeg or jpg: mysql select * from filetypes; +++ | fileID | typeID | +++ | 3 | 1 | | 1 | 2 | | 2 | 4 | | 2 | 5 | +++ 5 rows in set (0.00 sec) mysql SELECT filename, typename, typeext FROM files, types, filetypes WHERE filetypes.fileID = files.fileID AND filetypes.typeID = types.typeID AND filename LIKE bar; +--++-+ | filename | typename | typeext | +--++-+ | bar | jpeg image | jpg | | bar | jpeg image | jpeg| +--++-+ 5 rows in set (0.00 sec) I hope it's what you wanted Etienne btw, if you find any mailing list ont he web for general relational DB design issues, let me know. I searched and could not find any:( Erik Price wrote: Hello, I was looking for some advice on building my database. If this is an offtopic question, I apologize in advance! I'm building a database with several tables. Only two of them pertain to my question. Also, as I have not yet built my tables (I'm planning them), I can't include contents of a dump. One of the tables is called files, the other is called types. Here is a quick sketch of what files looks like (there is more but this is really all that matters): +-+---+-+ | file_id | file_name | type_id | +-+---+-+ | | | | | | | | | | | | | | | | +-+---+-+ here is types: +-+---+-+ | type_id | type_name | ext | +-+---+-+ | | | | | | | | | | | | | | | | +-+---+-+ You can probably figure out what I'm doing here. file_id and type_id are INTEGER-based primary keys which simply give me a nice reference number to give each row. file_name and type_name are VARCHAR(36) columns. files.type_id is really the same as types.type_id, and types.ext is a VARCHAR(5) column. Queries will look like this: SELECT files.file_name FROM files, types WHERE types.ext LIKE txt AND files.type_id = types.type_id ; So that a user can enter txt as a file's extension and all the files that are .txt files will be returned. First of all, I hope I'm doing this right. Second of all -- some files types (file formats) have more than one extension. For instance, I write HTML files and use JPEGs. But sometimes I'll use a graphics program that automatically renames the file .JPG and I won't change it because it's too much of a pain. Or someone I work with might have use Windows, and instead of writing a .html file, they may have their extension as .htm (the l is missing). What is the best way to accommodate all of this? I would like to make the types table a comprehensive list of all file formats with their associate extensions so that when a filename comes up, the user can easily see what format that file is in (and there would be other columns, such as open_in with the name of an application to open that file with; e.g.: Photoshop for .psd or Illustrator for .ai). Any advice? Thank you, Erik Price - 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 -- Etienne Marcotte Specifications
Re: more than one possible column value
well I index both because it enables to pull data without even reading on the table.It reads only in the B-Tree index since it's both numeric. There is a section on mySQl optimization in the mySQL guide on the webpage. If you want to find all files that have this or that extension, mySQL will use the (typeID,fileID) index if you are looking for the index of a particular file, it will use the index (fileID, typeID). this is for speed! HTH Etienne Erik Price wrote: On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote: CREATE TABLE filetypes ( fileID smallint unsigned not null, typeID smallint unsigned not null, unique index (fileID,typeID), unique index (typeID,fileID) ) One question, though. Do I have to construct indexes in both directions? I haven't used the UNIQUE INDEX command. I still have much to learn -- I'm only partway through the DuBois book that I am using to learn MySQL. The chapter on optimizing databases and indexing is next. Well, no need to respond to that. I will study further before asking any more questions. Erik -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Graphical Database Information
I use visio professional... But it's home made, not auto made like with an access DB. Plus since there are not a lot of types from visio, I prefered to make my own drawing, using cool functions like the snapping (so when I move tables they stay linked). Plus the relationship from visio are pretty neat, you can choose One, one (optional), many, many (optional) so ti draws the correct ends: ---||- or ---o|- or ---| or ---o But if you already have a complex DB in mySQl and want to have the graphical equivalent from a click, then I don't know and I'm curious if there is such app. Etienne Steve Osborne wrote: Is there a utility that will allow me to view a mysql database that is similar to an Access 2000 relationship diagram? Steve Osborne Database Programmer Chinook Multimedia Inc. - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySQL 3.23 Manual - PDF
start paste message From: Thomas Spahni [EMAIL PROTECTED] 6:24 AM Subject: Re: MySQL 3.23 Manual - PDF To: A. Clausen [EMAIL PROTECTED] CC: MySQL Mailing List [EMAIL PROTECTED] On Wed, 28 Nov 2001, A. Clausen wrote: [deleted] ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas end paste message it's all there! Etienne A. Clausen wrote: Well there is a 4.x manual, and I know from a few months ago that there was a 3.23 manual on the site which I foolishly decided I didn't need. Do the developers of MySQL just delete all copies of manuals for previous version when they move to new software? I mean, what is a 3 or 4mb file nowadays? A. Clausen [EMAIL PROTECTED] - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 03:24 Subject: Re: MySQL 3.23 Manual - PDF On Wed, 28 Nov 2001, A. Clausen wrote: That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted manual. The HTML and text versions supplied with the 3.23 distributions are way too unwieldly, and I'm not going to upgrade my mission critical app to what is apparently alpha software, just so I can have an up-to-date manual. The very fine manual is not distributed in PDF format, because it's much too big in this format. However, you may get your copy without upgrading your software. Just get the latest mysql-3.23.45.tar.gz, unzip, untar, go to the mysql-3.23.45 directory and type: me@host:~/mysql-3.23.45 ./configure to create the Makefiles. Then go to the Docs/ directory and me@host:~/mysql-3.23.45/Docs make manual.pdf ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: conceptual question.
I store links instead of the data. I don't know I seem to prefer a light database and the retreival of images/others from the server itself instead of pulling it from the database. There are a lot of debates on this, I'm only telling you what I prefer to use:) Etienne Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: LIMIT by column return
hum, I think it won't acheive his goal:) Let's say you have this as data: | id |date| whatever | || | 1 | 2001-11-26 | | | 2 | 2001-11-27 | | | 3 | 2001-11-25 | | | 4 | 2001-11-27 | | | 5 | 2001-11-26 | | | 6 | 2001-11-26 | | | 7 | 2001-11-25 | | | 8 | 2001-11-26 | | | 9 | 2001-11-27 | | he wants to have the data for the two last dates. so it would be in that case: | id |date| whatever | || | 2 | 2001-11-27 | | | 4 | 2001-11-27 | | | 9 | 2001-11-27 | | | 1 | 2001-11-26 | | | 5 | 2001-11-26 | | | 6 | 2001-11-26 | | | 8 | 2001-11-26 | | means all invoices from the two last days where there are incvoices. I don't think he want's to use date sub from NOW() sine the two last invoice dates might be variable.. Etienne Michael Stassen wrote: Tom, Restating the problem, you want the last two from the set ordered by invoice date. So, add ORDER BY site_service.invoice_date DESC LIMIT 2; Probably just a typo, but I note your statement selects site_service.id and site.site_id but has site_service.site_id = site.id in the WHERE clause. Michael On Thu, 29 Nov 2001, Tom Beidler wrote: I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last two invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displaying a table of invoice dates ordered by job name and LIMIT the invoice dates to the last two invoice dates for each job. Here's my query so far; SELECT site_service.id, site_service.service_date, site_service.invoice_date, site.site_id, site.name, site.state, site.status FROM site_service, site WHERE site_service.site_id = site.id AND site.company = 'Nextel' If I add LIMIT 2, I only get two invoices. I'm trying to get the last to invoices for each site. Is this possible or is there another direction I should go? I checked out the MySQL site without any luck. Thanks, Tom Michael Stassen University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
General database design
1- What should I index? Index is for speed.. Should I mainly index the columns where I do often searches on them? Should I index all not null columns event if I rarely search using them? Should I index enum columns even if there is a lot of identical data. Will a search using only indexed columns be faster, or it will still go into the table itself to get the data? I read some about it in the guide, but still not clear. 2- Do you think it's better to have 4 small queries or one huge one that returns tons of lines? Let me explain. I have let's say, a main table events with fields evtID, evtName, etc. I have 3 smaller tables outlets, promoters and artists. Those are n:n relations with the events table. An event may have multiple artists, and an artist may be in multiple events. So I created 3 link tables eventoutlets with columns eoEvtID and eoOutID eventpromoters with columns epEvtID and epProID eventartists with columns eaEvtID and eaArtID So, if you still follow me, I want to get the list of artists playing at an event, plus the outlets for tickets and the promoters throwing the event. I can do a HUGE select statement, or make a couple of small ones. select epProID from eventpromoters where epEvtID = '3' select eoProID from eventpromoters where epEvtID = '3' select eaProID from eventpromoters where epEvtID = '3' (some script to store those results) select proName, proInfo from promoters where promoterID = '5' or promoterID = '6' or promoterID = '12' (etc) same for the artists, outlets.. ideally, something like select proName, proInfo from promoters where promoterID = (select eaProID from eventpromoters where epEvtID = '3') would be perfect, assuming it selects for all the occurences where epEvtID is 3 and not just the first one. Anyways, I'm pretty sure nobody went reading this far, I'd just like some input as how you're doing your things with n:n tables. And if you have any mailinglist you know that is more about database design itself.. Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Newbie Question
) 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
Beginner question
When creating a table, can we specify that the combinaison of two fields needs to be unique but each of those two fields may have duplicates, just not both the same? Can we have a required attribute on one of two fields? I have phone_line_french and phone_line_english, i require one of those two to be filled (or both). I can check that in my script, just asking if we can do it in mySQL Regards, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: Please redo this horrible web page
I know you won't read my answer since I'm not from mysql but I wanna give my 2 cents. First don't you think you could go the smooth way for making a request? Either I'm not in a good mood or I can't read english, but your post seemed harsh. It's probably a really huge task to have this archive in a better way, yes it would help, having a searcheable index, search function, etc etc. But if you fool around a little you'll realize that all mail archives are this way (check the one of [EMAIL PROTECTED]) Anyways, I don't think by writing Let's make everything as hard as is possible for the newbies. you'll help our newbie cause. Etienne raezor wrote: Let's make everything as hard as is possible for the newbies. Please alphabetize or at least use some sort of date organization for the http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b instead of making us search through every entry, including those that have never been responded to. The Messages by date are messages by submitter. If this is not true, make the site say date=Nov.1(listed messages) Nov.2(listed messages). What a waste of time this is for anyone, nonetheless us newbies. I assumed the purpose of this list was to make things easier. If I am incorrect or viewing this incorrectly, please reply and let me know (only responses from email address @mysql.com will be read). thanks - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: date type
right Etienne Jose Gerardo Amaya Giron wrote: Thanks I now understand the difference. I can use a timestamp If I used a database to log access for example I only make an insert to the other fields and the timestamp insert the current time and date right? Gerardo Amaya Alok K. Dhir wrote: You probably want to start with datetime rather than timestamp, as timestamp comes with some additional magic to auto-set it for you and you may not want this. A good source for this type of information is, incidentally, the MySQL reference, at www.mysql.com. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] m] On Behalf Of Fabio Roger Sent: Wednesday, November 28, 2001 12:35 PM To: Jose Gerardo Amaya Giron; [EMAIL PROTECTED] Subject: Re: date type timestamp is a good start - Original Message - From: Jose Gerardo Amaya Giron [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 2:42 PM Subject: date type Hello all I got a a simple question, I changing from access to MySQL. I have in access some fields that have date and time. What type of field in MySQL can handle this. thanks Gerardo Amaya - 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 - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
Another basic question - index()
What is the exact difference between this index(col1,col2). that index(col1),index(col2). and this index(col1),index(col2),index(col1,col2). I read in the manual about it, but it's not really clear about the way to should be used / created. Any sql pseudo-teacher in here? :) Thanks a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: MySQL 3.23 Manual - PDF
i have to disagree you should read it before asking us to go read it! Title is on top of each page: MySQL Technical Reference for Version 4.0.1-alpha I am also looking for the latest 3.xx version manual. Etienne Tony wrote: Image you had a product and wanted to make a PDF manual available for your users. Where would you put it? Website, under documentation. BINGO! http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf Not sure why this MySQL list has so many questions and folks have to be trained to check the main website first. Heck it even says to RTFM in the trailer message on each of the posts...but people post Q's here first. I know. I was one. For 3 months. The truth is, the main website, bitbybit FAQ and Paul DuBois' MySQL book have an enormous wealth or well organized information. Not trying to bust your chops, I did it (and still do from time to time), just letting you know that there is a faster (and more complete) way to find answers. HTH, Kind regards, Tony On Wednesday 28 November 2001 01:27 pm, A. Clausen wrote: Is there still a PDF-formatted version of the MySQL 3.23 manual available? A. Clausen [EMAIL PROTECTED] - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
[OT] Comments about my DB layout
Good afternoon, This is my first post on that list, I was looking for relational database mailing list, and found none. So I will post my question here since my database will be under mySQL and users on this list probably have good experiece with DB design. I designed my database, and before all coding the interface, I'd like some experts to have a quick look to it to at least tell me if there are major mistakes in the design. I read Database design for mere mortals a little while ago and this is my first attempt in a real-world and complex (well compared to what I done before) DB. I attached an image copy of the file made with Visio. Visio is made for Access, I managed to get the primary and foreign keys to be as my original sketches (playing with weak and strong tables and identifying or not links) So for the ones interested in my structure, let me know any questions you may have regarding the way everything works and any comments you have. Thanks a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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