Re: need mysql sample to accomplish existing asp function
Well, whaddaya know?? Ya can use asp for a cheap price!!! Doesn't mean that your ISP is going to support it though or any other language/scripting tool for that matter. - Original Message - From: "Joshua Chamas" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED] Cc: "Joe and Nancy M" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 15:25 Subject: Re: need mysql sample to accomplish existing asp function Rolf Hopkins wrote: My ISP told me they supported asp, so I had a friend of mine set up the asp code for me and he tested it on his server. When I put the code in my pages, it did not work. I called my ISP back and found out the first person was wrong. They run Unix and DO NOT support asp. ... I'm not surprised that many ISPs don't support asp. Someone correct me if I'm wrong, but Chillisoft, the only program I know of that let's you run asp on unix, costs something like US$1000. Apache::ASP is free supports ASP perl scripting on Linux/Unix. I run it on Linux, Solaris x86 NT personally. Check out: http://www.apache-asp.org http://perl.apache.org for more information. Apache::ASP is just one of the development environments available to the mod_perl environment on Apache. Other favorites there include HTML::Embperl, HTML::Mason AxKit. Chances are however, that your friend's scripts are written with VBScript, as that is the primary dev language under IIS/ASP. I don't think there are alternatives to Chilisoft for VBScript ASP on Unix. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - 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
UPDATE query with ORDER BY and LIMIT
Hi to all! I have to use an UPDATE query with ORDER BY and LIMIT clauses. This is the query: UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY INS_DATE LIMIT 1; MySql tells me that I have an error in my SQL syntax near 'ORDER BY INS_DATE' at line 1. I use Mysql 3.23.30-gamma with MyIsam table format. I have read the manual and the syntax, according to that, seems to be correct... but... nothing is as it seems What is wrong? Thank you to all for the help! Denis [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
Save image to database
Dear all, Can images be saved in an mysql database as a BLOB? If so, how can I write the code in sql to add an image to a mysql database record, and then subsequently view image in a browser via perl programming ? --- Thank you ---
RE: UPDATE query with ORDER BY and LIMIT
Hi to all! I have to use an UPDATE query with ORDER BY and LIMIT clauses. This is the query: UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY INS_DATE LIMIT 1; MySql tells me that I have an error in my SQL syntax near 'ORDER BY INS_DATE' at line 1. I use Mysql 3.23.30-gamma with MyIsam table format. I have read the manual and the syntax, according to that, seems to be correct... but... nothing is as it seems What is wrong? Then you need to go back to reading the manual again. UPDATE statements do not allow for ORDER BY clauses. / Carsten - 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 install questions...
Hi! I was introduced to MySQL on the web and was wondering whether anyone can answer the following questions about MySQL: 1) I am being hosted on a server and the server is Cobalt RaQ3 type with linux. It's a unix based server. Is it possible to install MySQL on my server? If so, which type of the many different MySQL packages should I download? 2) How large would the installation of MySQL take up server space? Thank you for your time. Julian - 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: Save image to database
Hi I asked the same Q a while ago about bin data if you look in the archives of this list it should still be there look under "binary data" as the subject To point you in the right direction tho here are some excerpts from my answers that I kept... if you look at the second excerpt there is a perl example to laod the data, but I think that there is a function called loadfile() I think and you can use this too! I just remember seeing it, but I forgot to save that message :-( Apparently it escapes all your bin zeros, ", \ etc although after lots of discussions with other ppl we decided it is better to have a reference to the files instead of storing the actual file on the DB, although ppl, do still find it useful to do it, we didnt... Hope this helps = 1. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0 http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0 2. Hi Barry, I do not know what do you use for feeding your database, but in Perl you shoud use the DBI module, and insert the binary data through bindings. use DBI; use strict; ... my $dbh = DBI-connect("dbi:mysql:image_db", "user", "password") || die "$DBI::errstr\n";# connect to the database ... my $sth = $dbh-prepare("INSERT jpeg_table SET size_x = $size_x, size_y =$size_y, image_data = ?;") || die "$DBI::errstr\n";# prepare the insert statement, replacing the image data with a question mark $sth-bind_param(1, $image_data); # binding the binary data $sth-execute() || die "$DBI::errstr\n";# executing the insert ... $dbh-disconnect(); # disconnect Regards, Peter Szekszardi 3. -Original Message- From: Didi [mailto:[EMAIL PROTECTED]] Sent: 21 February 2001 10:35 To: [EMAIL PROTECTED] Subject: Save image to database Dear all, Can images be saved in an mysql database as a BLOB? If so, how can I write the code in sql to add an image to a mysql database record, and then subsequently view image in a browser via perl programming ? --- Thank you --- - 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: UPDATE query with ORDER BY and LIMIT
I see the definition of update in the online manual... This is the link: http://www.mysql.com/doc/U/P/UPDATE.html and this is what is written: From MySQL manual ONLINE *** UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [ORDER BY ...] [LIMIT #] UPDATE updates columns in existing table rows with new values. The SET clause indicates which columns to modify and the values they should be given. The WHERE clause, if given, specifies which rows should be updated. Otherwise all rows are updated. If the ORDER BY clause is specified, the rows will be updated in the order that is specified. End From MySQL manual ONLINE *** So i read the manual... but is the manual wrong? Denis At 10.52 21/02/01, Carsten H. Pedersen wrote: Hi to all! I have to use an UPDATE query with ORDER BY and LIMIT clauses. This is the query: UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY INS_DATE LIMIT 1; MySql tells me that I have an error in my SQL syntax near 'ORDER BY INS_DATE' at line 1. I use Mysql 3.23.30-gamma with MyIsam table format. I have read the manual and the syntax, according to that, seems to be correct... but... nothing is as it seems What is wrong? Then you need to go back to reading the manual again. UPDATE statements do not allow for ORDER BY clauses. / Carsten - 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
Bigint BUG
hi all i have make sure there is a bug of mysql with mysql-3.23.32 repeat this bug. CREATE TABLE A ( B bigint(20) unsigned DEFAULT '0' NOT NULL, value bigint(20) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (B) ); *p.s the same with take off primary key insert into A values(9229307903454284864,1) insert into A values(9229307903454284864,1) then you will see it say MySQL said: Duplicate entry '9229307903454285824' for key 1 see?!.. it says duplicate with 9229307903454285824. not what we input 9229307903454284864 before. browse the table. you can see there are one rows 9229307903454285824 812 this is not what we insert before, either. and no matter you select * from A where B=9229307903454285824 or select * from A where B=9229307903454284864 it all return zero row. i try this on mysql-3.23.32 on FreeBSD 4.2-RELEASE mysql-3.23.25-beta on FreeBSD 3.3-STABLE mysql-3.22.32 on Linux test 2.4.1 #2 SMP i686 unknown mysq-3.23.24 on FreeBSD 4.0-STABLE all the same situation. oh...suddenly i think there is another fast way to test. that is select ; ( 18446744073709551615, max of unsigned bigint) it returns 0656 is it overflow?. Regards chChen
RE: UPDATE query with ORDER BY and LIMIT
I stand corrected - sorta. Look further down in the manual: ORDER BY for UPDATE is not introduced until v. 4.0.0. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 11:05 AM To: Carsten H. Pedersen; [EMAIL PROTECTED] Subject: RE: UPDATE query with ORDER BY and LIMIT I see the definition of update in the online manual... This is the link: http://www.mysql.com/doc/U/P/UPDATE.html and this is what is written: From MySQL manual ONLINE *** UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [ORDER BY ...] [LIMIT #] UPDATE updates columns in existing table rows with new values. The SET clause indicates which columns to modify and the values they should be given. The WHERE clause, if given, specifies which rows should be updated. Otherwise all rows are updated. If the ORDER BY clause is specified, the rows will be updated in the order that is specified. End From MySQL manual ONLINE *** So i read the manual... but is the manual wrong? Denis At 10.52 21/02/01, Carsten H. Pedersen wrote: Hi to all! I have to use an UPDATE query with ORDER BY and LIMIT clauses. This is the query: UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY INS_DATE LIMIT 1; MySql tells me that I have an error in my SQL syntax near 'ORDER BY INS_DATE' at line 1. I use Mysql 3.23.30-gamma with MyIsam table format. I have read the manual and the syntax, according to that, seems to be correct... but... nothing is as it seems What is wrong? Then you need to go back to reading the manual again. UPDATE statements do not allow for ORDER BY clauses. / Carsten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need mysql sample to accomplish existing asp function
Rolf Hopkins wrote: My ISP told me they supported asp, so I had a friend of mine set up the asp code for me and he tested it on his server. When I put the code in my pages, it did not work. I called my ISP back and found out the first person was wrong. They run Unix and DO NOT support asp. ... I'm not surprised that many ISPs don't support asp. Someone correct me if I'm wrong, but Chillisoft, the only program I know of that let's you run asp on unix, costs something like US$1000. Apache::ASP is free supports ASP perl scripting on Linux/Unix. I run it on Linux, Solaris x86 NT personally. Check out: http://www.apache-asp.org http://perl.apache.org for more information. Apache::ASP is just one of the development environments available to the mod_perl environment on Apache. Other favorites there include HTML::Embperl, HTML::Mason AxKit. Chances are however, that your friend's scripts are written with VBScript, as that is the primary dev language under IIS/ASP. I don't think there are alternatives to Chilisoft for VBScript ASP on Unix. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - 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: i stand corrected if this is wrong - :-
oops sorry again the DBD stuff should be install Bundle::DBD::mysqlenter ... and in the rush to attempt to help, the little kahuna makes numerous mistakes... but in the end truth and justice prevails... he hopes... -Original Message- From: Irmund Thum [mailto:[EMAIL PROTECTED]] Sent: 21 February 2001 10:32 To: Barry Radloff Subject: Re: i stand corrected if this is wrong - :- Barry Radloff wrote: oops wrong site name :-( go to www.cpan.org... Sorry -Original Message- From: Barry Radloff Sent: 21 February 2001 08:16 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: :mySQL hi ryan DBD::... are 'drivers' for perl to a specific db, you need to go to www.cpan.com and download the DBI module for perl and the relevant driver I assume mysql as this is a mysql list... alternatively if you have net access you can use: perl -MCPAN -e shell and type install Bundle::DBIENTER (i stand corrected if this is wrong) and install Bundle::mysqlENTER (see disclaimer above) cpan install Bundle::mysql Can't install Bundle::mysql, don't have an associated bundle file. :-( at /usr/lib/perl5/5.6.0/CPAN.pm line 1806 (Mysql is correct :-) read the docs and enjoy... Barry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] -- http://it97.dyn.dhs.org -- IrmundThum +49 179 6998564 +49 6374 992541 - 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: XML support under mySQL
By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple "Jeremy D. Zawodny" wrote: On Wed, Feb 21, 2001 at 09:38:23AM +0100, Gorjan Todorovski wrote: Is there support for XML in mySQL? What does your question mean? XML is about representing data in a structured and easily interchanged fashion. MySQL is all about *storing* and *retrieving* data which is stored in a normalized, relational model. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
XML support under mySQL
Is there support for XML 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
problem with blob
Hi, I'm new to MySQL so please forgive me if this post is very rudimentary. I've created a new database and added all my tables, etc... Everything seems to be fine except for a blob field in one of my tables. I'm using myODBC and ColdFusion 4.0 on Win2000. When I output the content the blob contains all that it displays are a series of letters and numbers, nothing remotely like the data I put in. But when I use the console and run the query it shows me the data that's in there. Thanks in advance, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa
Buggy comparison with varchar2 containing Greek (ISO8859-7) on linux
Hi, In addition to what Balanis found about a year ago : I have some problems with mysql because it does not cooperate very well with greek characters. The first problem is that mysql distinguishes the capital characters with accend from all the other possible "ways" the same letter can be found: 1) capital without accend 2) small with/without accend e.g. select "A" = "'A"; *** * "A"="'A"* *0 * It matches all the other possible "ways" e.g.: "A"="a" "A"="'a" "a"="'a" Although it doesnt (the previous) completely hold as of Mysql 3.23.32-1, the problem is much worse: the set {0xD3,0xD4) (greek S and T) are considered the same char by the = comparison. the set {0xEC, 0xED, 0xEE} (greek Mi, Ni, Ksi) of chars are also considered equivalent in comparison. I am really surprised!! Are the developers aware of the problenatic behaviour for greek lang?? -- Á÷éëëÝáò ÌÜíôæéïò Application Developer Eurisko A.E. ÐéíäÜñïõ 9 106 71 ÁèÞíá Ôçë: +301 3633362 Öáî: +301 3633074 e-mail: [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
FW: DTS with MySQL
Doesnt anyone have ever had problems while transfering a large database from windows to mysql (unix) with an ODBC connection??? Do I missed something here?? Rafael Teruszkin -Original Message- From: Rafael Teruszkin [mailto:[EMAIL PROTECTED]] Sent: tera-feira, 20 de fevereiro de 2001 09:44 To: [EMAIL PROTECTED] Subject: DTS with MySQL Hy, Ive created an ODBC Connection to make the updates in my MySQL DB while in Windows Plataform. To make faster updates Im doing a DTS to that ODBC. The problem is that there are something like a million registers to be updated and when something like 40.000 registers had been updated the next ones are being truncated or shitfed, what obviously is really strange... Do you have any experience with that problem?? Any sugestions?? I really have to be make these updates in the Windows plataform : (( Waiting for inputs, Rafael Teruszkin - 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
BDB Transaction support on NT?
Hi, Does anyone know if the DBD Transaction Safe Table support has been implemented (and working) for the NT release of 3.23.33 ? I have created tables with type=BDB but fail to have any joy with transactions Cheers, Bruce Percy Peopledoc Ltd. - 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
Yet more root password hell
Hi All, i'm currently setting up my first mySQL database, and have made the mistake of updating the root user's password without using the Password() function, meaning i am unable to get at the mysql database, or the new one i had just created. As has been suggested on this list, i have tried using the command below: safe_mysqld --skip-grant-tables However i receive a "Permission denied : cannot unlink `/var/lib/mysql/mysql.sock' error, and nothing happens. This could be due to my inability to shut down the mysql server, as to do that (Using mysqladmin) requires the root login. Is there any other way to restore the database, or should i try and re-install? (No data will be lost) Also, if a reinstall is the only way, does anyone have any experience of doing this remotely, on a Cobalt Raq4 server? Thanks very much in advance, Mark Edward - 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 Tables
On Wed, 21 Feb 2001, Rolf Hopkins wrote: Have you tried checktable? Are there many numbers giving weird results or just one? Are you running an old version of Mysql? Any of the columns auto inc by any chance. in the database there's only one auto_increment field in another table. I haven't tried checktable, is it available in MySQL-3.20.32? Yes, I KNOW it's old. But upgrading is not an option. BTW you really shouldn't "cut" your original message unless it isn't really important. This is in case someone knows the answer but didn't get your first posting. Yes, true. BTW, you should CC to me if you're sending to the list, as I'm subscribed to it :) I'm getting the mails twice. * MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/ * MP OnLine? EL BBS? FeedBack? - System Fork!!! 4799-2510 TLD 24hs * El sexo es como el Hacking. Entras, salis y esperas no haber dejado * nada por lo que puedan rastrearte. * Panic? My kernel doesn't panic! We are doomed! DustDustDust - 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
changing character set used for data and sorting
Hello, can anyone help me to solve the following problem: I've installed MySQL server Ver 8.0 Distrib 3.22.32 from FreeBSD 4.1 ports while installing OS. Now I need to make the server sort data strings encoded in koi8-ru in SELECT .. ORDER BY .. statements correctly. At this stage I don't need any other extra functionality other than sorting strings in russian language correctly. I looked through the manuals and mail lists and figured out eventually that MySQL server must be started with --default-character-set=koi8_ru. The first problem is that there is no share/mysql/charsets/ directory installed. And the second - server doesn't understand this option if I put it in /etc/my.cfn like [mysqld] default-character-set=koi8_ru There is error message in log file saying: /usr/local/libexec/mysqld: unrecognized option `--default-character-set=koi8_ru' What the server does understand is [mysqld] language=russian but it has nothing to do with the data sorting. Why does the server fail to start with the default-character-set=koi8_ru option in /etc/my.cfn? Do I have to compile it from the sources with --with-charset=koi8_ru option in order to solve the problem or I just can copy share/mysql/charsets/ from appropriate tarball distribution and restart the server? In case I have to compile it, I have to recompile php, apache and DBI as well, don't I? Please send your responses directly to my email address because I'm not subscribed to this list. Best regards, Kirill Magdalinin [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user
Hello, I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal SuSE-MySQL packages and creates the default tables. I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19 What can I do? Hagen -- Hagen Hoepfner Uni MD / FIN / ITI / AG DB - eMail: [EMAIL PROTECTED] Homepage: http://wwwiti.cs.uni-magdeburg.de/~hoepfner - 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 Tables
- Original Message - From: "Arturo Busleiman" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 20:38 Subject: Re: MySQL Tables On Wed, 21 Feb 2001, Rolf Hopkins wrote: Have you tried checktable? Are there many numbers giving weird results or just one? Are you running an old version of Mysql? Any of the columns auto inc by any chance. in the database there's only one auto_increment field in another table. I haven't tried checktable, is it available in MySQL-3.20.32? Yes, I KNOW it's old. But upgrading is not an option. Ouch, that is old. I don't think even the MySQL team support that version anymore but I could be wrong. Don't know if it existed in that version or not. I'm sure the manual will have something about it. Why is upgrading not an option? There should be ismchk but I can't say for sure BTW you really shouldn't "cut" your original message unless it isn't really important. This is in case someone knows the answer but didn't get your first posting. Yes, true. BTW, you should CC to me if you're sending to the list, as I'm subscribed to it :) I'm getting the mails twice. That's true to but how do I know whose subscribed and whose not, so I reply all. O | O \/ * MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/ * MP OnLine? EL BBS? FeedBack? - System Fork!!! 4799-2510 TLD 24hs * El sexo es como el Hacking. Entras, salis y esperas no haber dejado * nada por lo que puedan rastrearte. * Panic? My kernel doesn't panic! We are doomed! DustDustDust - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Once again... quotas...
At the company I work for we decided to try and implement reverse quotas. rather than limit said user to x we keep track of their usage and compare it to x. If they should happen to exceed that values then they are billed for the overage. It's very muhc like how UU bills us on our bandwidth for the burstable circuits. Cheers, Mikel Tristan 'Minty' Colgate wrote: Hi There, I have recently been asked to implement per database quotas for mysql for a large scale shared webhosting environmnet, from the lists it seems pretty obvious that mysql cant achieve this at the moment (without using filesystem quotas), file system quotaing is pretty awkward with our environment. Ive been asked to investigate the possibility of implementing this and my boss has agreed that we can release the code back to the community if we decide to do it. I found one posting that mentioned that someone at MySQL had some ideas on how you would like this implemented, if this is still the case could they post them to me, if it can fit in our timeframe Id be more than happy to do it. It really would be a nice feature. -- Tristan 'Minty' Colgate [EMAIL PROTECTED] | ICQ #645908 --- "You can get all you daily vitamins from 43 pints of guinness and a glass of milk" - 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
Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog
Hello, I've recently successfully downloaded and installed both MySQL and MyODBC on my Win2000 "box". Everything thing works great, except that for every connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver Connect" pops up and I have to hit its OK button to close it. There is a checkbox named "Don't prompt on connect" which I thought was ment to have it stop poping up that dialog, but it has no effect. Any idea what to do? Thanks /Jan R Andersson /Kalix /Sweden WEB: www.jra.nu www.mobilesweden.org WAP: jra.nu/main.wml wap.mobilesweden.org - 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
Localization
I sent this a couple of weeks ago at the time I joined the list, but I didn't see it. Please excuse if it is a duplicate, but I still need to know the answer. I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins
Re: format masks for a Masked edit control
I would also like to add to this, that I think it would be a good addition to the documentation. Gregg - Original Message - From: Gregg Housh [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 4:08 PM Subject: format masks for a Masked edit control I am working on an auto-generating form in VB. Its time to add a mask control, if the FieldType is a number. I need input and display masks for each of the numeric field types. (for the Microsoft MaskEdBox control that comes with VB 6). If anyone is any good at masks, please help me out here. I just dont seem to be good at getting them right. Gregg - 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
MySQL Index
Hi, I would like to know whether the primary keys are automatically indexed in MySQL or do you have to index them explicitly? Thanks in advance, Aruna. - 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: Future suggestion
Yeah, I totally agree with the idea of limiting the fields selected for most operations. But it would be useful even for using something like the MySQL client -- I want to see the majority of fields but don't care about a few text or varchar fields. It's a pain to type in the field list every time. I just think that an EXCEPT clause in the field list would make sense in a lot of ways. Too bad about Microsoft's "Not Invented Here" treatment of Visual FoxPro. It's a much better tool than Visual Beginners All Purpose Symbolic Instruction Code -- er, I mean Visual Basic, but that's an argument for another list ;-). - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: "Jason Landry" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 11:07 AM Subject: RE: Future suggestion Hey HEY! Another old Fox-Jockey! :) (There are still a few of us left in the world) While I understand your suggestion, I would suggest that you steer clear of using Select * at all except when testing or when there is no other way. You will get better performance by specifying the fields you want returned in your result set explicitly. Just my $0.02, Cal http://www.calevans.com -Original Message- From: Jason Landry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 9:41 AM To: [EMAIL PROTECTED] Subject: Future suggestion I just started using MySQL in the past month or so, and love it so far. I come from a background that includes a lot of FoxPro (way back in the days of FoxBase for the Macintosh). I also have had a bit of MS SQL Server experience, but more using it as a back end for Visual Foxpro. One of the things that have always bugged me about writing a SELECT statement has been the inablility to exclude certain fields. When doing a select * from a join, it would be nice to be able to do something like this: SELECT * EXCEPT invoice.custpo, payment.custid FROM remainder of select statement Is there anything holding back the developers of MySQL from implementing such a construct in MySQL, like the goal of ANSI compatability? Am I being a big dumbass for desiring such functionality? In any case, thanks to everyone who contributed to MySQL for such a cool product. - 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: Is this normal?
Paul A. Rubin writes: Hello all, I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I have encountered any visible problems, but the error log is full of messages like the following: 010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin' host: `localhost' (Got timeout reading communication packets) Since I'm asleep at 2 a.m. local time, I assume this was generated by someone hitting a Cold Fusion page that queries the database using my id and password. Some of the errors are definitely from Cold Fusion accesses. It's possible they all are, but in many cases I cannot tell. The Cold Fusion server is running on the same Linux box, by the way. Is this normal behavior? TIA, Paul *** Paul A. RubinPhone:(517) 432-3509 Department of Management Fax: (517) 432- The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED] Michigan State Universityhttp://www.msu.edu/~rubin/ East Lansing, MI 48824-1122 (USA) *** Mathematicians are like Frenchmen: whenever you say something to them, they translate it into their own language, and at once it is something entirely different.J. W. v. GOETHE Hi! That is nothing to worry about. The above only means that client program has not called mysql_close() function. For example, PHP until 4.0.4 (they say) does not do it at all. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
mySQL and GoLive 5.0
Does anyone know how to do a Dynamic Link from GoLive 5.0 (PC) to mySQL running on a Solaris web server? Any advice or direction would be appreciated. -- -- Mac Support WebSite: http://macweb.ida.org/ -- Scott G. Hartwick Voice: 703-845-2524 Lead Microcomputer Resource Analyst FAX: 703-845-6977 Institute for Defense Analysesmailto:[EMAIL PROTECTED] 1801 N. Beauregard Street WWW: http://www.ida.org/ Alexandria, VA 22311-1772 -- - 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: Can this query not be done in MySQL.
How about : select a.flight_no, a.sequence, a.city from stop_offs a left join stop_offs b on b.sequence = a.sequence + 1 and a.flight_no = b.flight_no where b.sequence is NULL; Richard Reina wrote: Steve, I never received Mr. Van Engen's response. I appreciate your response. However, my question remains unanswered. If you put "sequence" in the GROUP BY it does not give you the value that correspond to the MAXIMUM sequence. As a matter of fact I can't find any combination of values that you can put in the GROUP BY clause that will give you the values that correspond with MAX. What good is an aggregate function like MAX if it does not give you the value ( and only that ) that corresponds to that aggregate function. In this case shouldn't (MAX(sequence)) give you only those values that correspond to the maximum sequence for each flight which would be: +---+ |flight_no |sequence|City | | 127 | 2 |Boston | | 391 | 1 |Miami | +---+ The documentation in the documentation under GROUP BY functions (section 7.3.12) seems to advocate this syntax -- specifically with their example of querying orders by MAX(payments) -- although they don't show the results of their examples. If this cannot be done in MySQL will someone with authority on the subject -- perhaps Sasha or Monty -- simply say that MySQL cannot perform this type of query. If it can be done will someone demonstrate how it can be done in MySQL. I believe I can do it in other DBMSs with the following subselect: SELECT soo.flight_no, soo.sequence, soo.city FROM stop_offs soo /* That's "stop_offs outer" */ WHERE soo.sequence = (select max(soi.sequence) FROM stop_offs soi /* "stop_offs inner" */ where soi.flight_no = soo.flight_no ) however, it is my understanding that MySQL does not support subselects. I have once again included a copy of the table below. Once again, thank you for your attention in this matter. Here is the table: +--+ | STOP_0FFS | +--+ |FLIGHT_NO |CITY | SEQUENCE| |127 |Chicago |1| |127 |Boston |2| |391 |Miami|1| +--+ SELECT flight_no, MAX(sequence), city FROM stop_offs GROUP BY flight_no; gives the result: +---+ |flight_no |sequence|City | | 127 | 2 |Chicago| | 391 | 1 |Miami | +---+ However Chicago is the city of the first stop off (sequence 1) not the value that corresponds with a sequence of 2 which would be 'Boston'. The desired result is the following: +---+ |flight_no |sequence|City | | 127 | 2 |Boston | | 391 | 1 |Miami | +---+ Steve Ruby wrote: Your question was answered already after you posted it on Saturday by Fred van Engen... Basicaly you should not be able to do a group by without perfoming an aggregate function (max, avg, sum, count) on columsn that do not appear on the "GROUP BY" clause. Richard Reina wrote: I posted this question to this list on Saturday. I realize that not everyone on the list knows whether this query is possible using MySQL. However, if I could please here back from someone who does know, I would appreciate it. I'm getting flack from informix ( and other DBMS ) users on my perl user list who are now doubting whether I can get it to work in MySQL. I have great confidence in MySQL and believe there must be a way to get the query to work. I have searched through my MySQL/mSQL O'Reilly book and in the user manual (specifically GROUP BY functions (section 7.3.12)). Can someone please help me out? - 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
Ho´w can I configure MySQL?
Hi there, I installed the binary file of MySQL on Windows 2000 and want to configure it now. I tried to do it with the winmysqladmin tool. When I use the button my.ini setup there are just the two following lines written: [WinMySQLAdmin] Server=C:/mysql/bin/mysqld.exe How can I configure MySQL? Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Hi there, I installed the binary file of MySQL on Windows 2000 and want to configure it now. I tried to do it with the winmysqladmin tool. When I use the button my.ini setup there are just the two following lines written: [WinMySQLAdmin] Server=C:/mysql/bin/mysqld.exe How can I configure MySQL? ThanksGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] Rel DB Question
Your link approach is fine (and I consider it preferable). Assume you suddenly start selling ties. With the Link_type approach, you simply need to create a new link type and you're ready to roll. Much simpler than needing to create a new table/relationship. Also, suppose you're asked: Show me everything that bob purchased. Easier to do a single join then to have to join against all the different tables. Ray At 1:16 PM -0500 2/21/01, Clarence Kwei wrote: I have a relational DB question. I'll preface this and say I've had no formal training in DB's only on-the-job knowledge. I've been trying out some CASE tools and have discovered the following: ... Is there anything wrong with using this one table instead of four tables to implement these relationships? Obviously, if "PANTS" becomes "TROUSERS" I'll have to do a replace, but as far as relational DB's go, is there anything wrong with have a relationship based on two keys and a char field. Any insights would be greatly appreciated. Thanks very much. -- Clarence Kwei [EMAIL PROTECTED] ScienCentral, Inc. (212) 244-9577 ext. 118 -- --- Raymond Cote, President Appropriate Solutions, Inc. www.AppropriateSolutions.com [EMAIL PROTECTED] 603.924.6079(v) POB 458, Peterborough, NH 03458603.924.8668(f) - 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: XML support under mySQL
On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple You cannot do that with MySQL. But that's probably a philosophical difference. Many would argue that the database server has no business dealing with XML. That should be the job of the program which is putting the data into the database... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog
You could try the Sendkeys command in VB to pre answer the message box SendKeys {ENTER}, False ' Answer for box before it appears 'if the Wait parameter was true the Answer would go into the sheet cell 'but with it false the Dialog box appears before the Answer is sent -Original Message- From: Jan R Andersson [SMTP:[EMAIL PROTECTED]] Sent: 21 February 2001 15:22 To: [EMAIL PROTECTED] Subject: Connecting via MyODBC always brings up the "TDX mysql Driver Connect" dialog Hello, I've recently successfully downloaded and installed both MySQL and MyODBC on my Win2000 "box". Everything thing works great, except that for every connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver Connect" pops up and I have to hit its OK button to close it. There is a checkbox named "Don't prompt on connect" which I thought was ment to have it stop poping up that dialog, but it has no effect. Any idea what to do? Thanks /Jan R Andersson /Kalix /Sweden WEB: www.jra.nu www.mobilesweden.org WAP: jra.nu/main.wml wap.mobilesweden.org - 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
Is this normal?
Hello all, I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I have encountered any visible problems, but the error log is full of messages like the following: 010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin' host: `localhost' (Got timeout reading communication packets) Since I'm asleep at 2 a.m. local time, I assume this was generated by someone hitting a Cold Fusion page that queries the database using my id and password. Some of the errors are definitely from Cold Fusion accesses. It's possible they all are, but in many cases I cannot tell. The Cold Fusion server is running on the same Linux box, by the way. Is this normal behavior? TIA, Paul *** Paul A. RubinPhone:(517) 432-3509 Department of Management Fax: (517) 432- The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED] Michigan State Universityhttp://www.msu.edu/~rubin/ East Lansing, MI 48824-1122 (USA) *** Mathematicians are like Frenchmen: whenever you say something to them, they translate it into their own language, and at once it is something entirely different.J. W. v. GOETHE - 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: install (still!) hangs on RedHat 6.2
David Vender wrote: Description: I've posted before on this: running scripts/mysql_install_db hangs at 'Installing all prepared tables' and when i say hangs kill -9 is the only option. I have been told to check permissions (they're all fine in comparison with a working system also running RH6.2) and to install from source (Yes, i've manually deleted everything that had anything to do with mysql off the system and installed from sources as per instructions. Everything went cleanly until the mysql_install_db script). Can anyone help with what the script is doing at that point (i looked but can't figure it out). Why does it not report an error? Hanging like that does not give me any clue as to what i should be trying to fix. More info: There was a working version of mysql running on this machine (3.22.32 which stopped working (accepting connections) without really dying (daemon kept running and starting on reboot)). That was installed from an RPM and deinstalled using rpm. i have since manually removed mysql directories that are not removed by rpm. How-To-Repeat: scripts/mysql_install_db hangs every time, whether the install is from RPM, binary or source Fix: Throw the computer out the window? Submitter-Id: submitter ID Originator:David Vender Organization: MySQL support: none Synopsis: /mysql_install_db hangs at 'Installing all prepared tables' Severity: critical Priority: high Category: mysql Class: sw-bug Make sure you setup a linux user named mysql. chown -R mysql /usr/local/mysql ( or whatever ) chown -R mysql /var/mysql ( or whatever ) create ( if you don't have one ) /etc/my.cnf Add the following two lines: [mysqld] user=mysql chmod 744 /etc/my.cnf mysql_install_db --user=mysql Make sure that the directory that will contain the mysql.sock is world readable and searchable. It hangs because it can't read or write a critical file. Release: mysql-3.23.33 (Source distribution) Environment: System: Linux axel.physics.dcu.ie 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 8 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql Perl: This is perl, version 5.005_03 built for i386-linux - 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
MySql-3.22.32-client doesn`t install
Hello Sinisa, I have mailed you regarding Installation on .rpm binary of mysql. I am once again telling you, I have a Linux6.2 OS , and want to install MySql3.22.32 client and development. But it give imediate following error error:MySql-client-3.22.32-1.i386 cannot be installed and same error i m faing eith development rpm. Pls reply me asap Regards, Jatin. SNTPL
RE: Error when writing a sql statement into a field.
I am sorry, my error message was not clear. The following is an error message.. Statement: Syntax error or access violation: You have an error in your SQL syntax near 'xxx","c","-1","-1",")' at line 1 I was simply writing a sting into a database field. The field was logMessage in the following table. mysql explain applog - ; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | applogid | int(10) | | PRI | NULL| auto_increment | | logMessage | varchar(255) | YES | | NULL|| | timedate | timestamp(14) | YES | | NULL|| ++---+--+-+-++ The string written was compiled from the following code: query = "INSERT INTO passtbl(user,pass,employeeId,customerId) VALUES"; query += "(\"" + this.getuserId() + "\","; query += "\"" + this.getpass() + "\","; query += "\"" + this.employeeId + "\","; query += "\"" + this.customerId + "\","; The string was an Insert statment which mySql acted upon. It should have just written the string into the logMessage field. The table below which is being used to log transactions, shows that select statments can be written into the message field. Insert statments cannot. mysql select * from applog; +--+ ++ | applogid | logMessage | timedate | +--+ ++ |1 | checkUser | 20010221092931 | |2 | updateCustomer | 20010221093150 | |3 | checkUser | 20010221093408 | |4 | checkUser | 20010221093423 | |5 | updateCustomer | 20010221093501 | |6 | checkUser | 20010221094134 | |7 | updateCustomer | 20010221094152 | |8 | updatePage3 | 20010221094359 | |9 | updatePasstbl | 20010221094359 | | 10 | Syntax error or access violation: You have an error in your SQL syn tax near '' at line 1 | 20010221094359 | | 11 | checkUser | 2001022111 | | 12 | 564: Select * from passtbl Where user ='s' | 2001022111 | | 13 | updateCustomer | 20010221100018 | | 14 | checkUser | 20010221100437 | | 15 | 564: Select * from passtbl Where user ='xxx' | 20010221100437 | | 16 | updateCustomer | 20010221100455 | | 17 | checkUser | 20010221100632 | | 18 | 564: Select * from passtbl Where user ='xx' | 20010221100639 | | 19 | checkUser | 20010221101121 | | 20 | 564: Select * from passtbl Where user ='kjlkjlkjlkjl' | 20010221101121 | | 21 | updatePage3 | 20010221101224 | | 22 | updatePasstbl | 20010221101224 | | 23 | Syntax error or access violation: You have an error in your SQL syn tax near '' at line 1 | 20010221101224 | | 24 | checkUser | 20010221101530 | | 25 | 564: Select * from passtbl Where user ='lkjlkjlkjllkjlkj' | 20010221101530 | | 26 | updatePage3 | 20010221101652 | | 27 | updatePasstbl | 20010221101652 | | 28 | checkUser
So, what do you do with a tarball anyways.
So, what do you do with a "tarball" anyways. Since compiling the source is hopless( "sql_yacc.cc"), I'm looking for a binary. - 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: case sensitive selects
Ji Mikul wrote: Hi all. I have problem with MySQL 3.23.32 on FreeBSD4.2 SELECTs are not case sensitive, any suggestion how to set it ? I'v looked into DOCs, but i'm not so clever from it :(( ... my config options was only ./configure --prefix=/usr/local/mysql Many thaks. Jiri Mikulas [EMAIL PROTECTED] http://www.anglictina.com ICQ: 108 36 60 66 Admin - anglictina.com There are several ways: 1. When creating tables, use "text" fields instead of "char" or "varchar". 2. When creating tables, use "char binary" or "varchar binary" fields. 3. Cast the field in the query. Ex: SELECT * FROM names WHERE BINARY fname = "Joe"; Most importantly, read the manual. - 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] Rel DB Question
Hey, it depends on what type of relation you want. I'm no expert, but here's my 2cents. If PEOPLE can only have one shirt, one pants, one shoes ... then (1)your PEOPLE table might look like. CREATE TABLE PEOPLE( people_id auto.. blaa pants_idint .. shirt_idint .. shoe_id int .. .. ) (2)but if people can have more than one stuff .. then. you'll need a seperate table called PEOPLE_LINK CREATE TABLE PEOPLE_LINK( people_link_id auto.. blaa people_id int .. pants_idint .. shirt_idint .. shoe_id int .. .. ) option two is the best, gives you more flexiblility. your SHIRT, PANTS .. table might look something like this. CREATE TABLE SHIRTS( shirts_id auto.. blaa shirts_name varchar... .. ) now assume you want to do a select .. SELECT P.name,S.shirts_name FROM people AS P, people_link AS PL, shirts AS S WHERE P.people_id=PL.people_id AND P.people_id='people_id' AND PL.shirts_id = S.shirts_id this will give you the person's name and all the shirts he/she owns. hope this helps. cheers Ken -- please reply to : [EMAIL PROTECTED] www.mysqlwebring.com -- I have a relational DB question. I'll preface this and say I've had no formal training in DB's only on-the-job knowledge. I've been trying out some CASE tools and have discovered the following: Lets say I have a table that stores PEOPLE. I also have a table that stores SHIRTS, PANTS, SHOES. Now in the CASE tools when I create relationships between these tables, I get tons of "link" tables to relate PEOPLE to SHIRTS, PEOPLE to PANTS, PEOPLE to SHOES, and then I've got SHIRTS to PANTS, SHIRTS to SHOES, etc. I guess this is the proper way to implement these relationships. My question is, what I've done in the past is create a table like the following: PEOPLE_LINK -- people_link_id int people_id int link_type char link_id int Where link_type is either SHIRT, PANTS, SHOES (like an ENUM). Depending on what the "link_type" is, the link_id is either the shirt_id, pants_id, shoes_id. Is there anything wrong with using this one table instead of four tables to implement these relationships? Obviously, if "PANTS" becomes "TROUSERS" I'll have to do a replace, but as far as relational DB's go, is there anything wrong with have a relationship based on two keys and a char field. Any insights would be greatly appreciated. Thanks very much. -- Clarence Kwei [EMAIL PROTECTED] ScienCentral, Inc. (212) 244-9577 ext. 118 http://www.stn2.com http://www.sciencentral.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 - 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: XML support under mySQL
Have you tried the -H flag to the mysql client ? The client at least can produce HTML. "Mehalick, Richard RE SSI-GRAX" wrote: The database does it. It is my understanding that MSSQL will return the results of a query in XML. The idea, as I understand it, is to create web pages with XML data. (I attended a XML class where we did this) Since the web page contains code to call the database and the result is in XML, then it should be easier to present the page. (Note: some browsers can already do this with native XML) Another reason, maybe even a better one, is that XML is less database specific. So too will be the data. So the result of a query is no longer tied to the database that produced it. Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 1:20 PM To: Mehalick, Richard RE SSI-GRAX Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: Some relational databases return results in XML format. The *database* does that, or an add-on query tool does that? It'd be trivial to implement an add-on for mysql (xmlmysql, a command-line tool maybe) which would do it. But making the database server itself do it seems rather, uh... strange. I'm not saying it's a bad idea, but I just don't see the utility in it. Can someone who would use such a feature explain how and why? Seeing as how folks ask about this once in a while, I'm more than a bit curious at this point. Thanks, Jeremy -- - 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: Copying a ddatabase from one server to another
I just importa data created by mysqldump using mysql -u username -p dbname table MySQL asks for my password and it's done. BR, Fábio Ottolini - Original Message - From: "Jeff Gannaway" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 1:21 PM Subject: Copying a ddatabase from one server to another Here's my situation I've been hosting my sites with one company for over a year and am now moving to a dedicated server operated by the same company. My existing database is large, containing around a dozen tables and over 5,000 entries. I want to copy the database structure and data to the new dedicated server. I've already created the new database, but not the tables. At first I tried copying the files from the database directory on my old server to the new database directory. I was able to read them but no combination of permissions or ownerships would allow me to insert/update the values (even when logged in as the super user). I found the mysqldump command in the MySQL docs. I created a dump file using the following command: [EMAIL PROTECTED] ysql.com mysqldump -uUSERNAME -pPASSWORD database dbBackup.sql and it created the dump file. I transferred it to the new server then tried to load it into my new database using the following command: mysqldump -uUSERNAME -pMILLER31 database dbBackup.sql (I also tried it with the -c option) I received the following output: # MySQL dump 8.12 # # Host: localhostDatabase: database # # Server version3.23.32 It did not insert any of the tables (and obviously not the data either). I tried another variation I found in the MySQL docs. I went to the original server and entered in the following command: mysqldump -uUSERNAME -pPASSWORD database | mysql --host=[IP Address of New Server] database -uUSERNAME -pPASSWORD and I received the following output: ERROR 1130: Host 'old.server.hostname.net' is not allowed to connect to this MySQL server Any tips??? Thanks, Jeff Gannaway ___ 2001 Wall Calendars * Art, Jazz, Blues, Women's, African-American. * Everyday Discounts. * Excellent paper and reproductions. And as always, a great selection of abstract, contemporary and African-American art prints. PopStreet.com is your avenue to art. http://www.popstreet.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 - 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: ranking album plays by city, help me beat Oracle
Hi. On Wed, Feb 21, 2001 at 12:32:21PM -0800, [EMAIL PROTECTED] wrote: I will respond in more detail later but just quickly now : Hm. Sorry, I don't understand your argument. By the for loop, your query does the same, doesn't it (selecting the rank of one album in each metro is the same as selecting for all metros the rank of one album)? The subtle difference is that the query I'm using ( I didn't actually write it ) calculates the rank of the single album in question by figuring out how many albums have greater play totals not caring what the more popular albums or what their totals were. Perhaps ignoring albums with smaller play totals using the HAVING focusing on just one album's position helps a lot. Ah. Okay. I thought about that meaning, but could not get positive that you actually meant it this way. Well. I doubt that this could be the reason, because HAVING is applied last, i.e. your query executes (almost) as if there was no HAVING clause, and then HAVING is applied (in fact, it is a bit different, but the main point is that _all_ albums will be examined and only the ones with a higher total_play will be returned). As I said, I guess it's rather the fact, that about 100 times more data has to be processed in _one_ turn, and MySQL decides to stores the intermediate result on disk (I believe, the default limit for in-memory temporary tables is 1MB, but it might be that I am just mixing up things here). [...] I am really curious, whether my arguments hold, and therefore what your test results are. Thank you in advance. If you are sufficiently curious I could send you a little Perl script that will create the ALBUM_BY_METRO table, populate it with test data allow you to more easily analyze the problem. Would you like that ? Yes, I would. Be sure to include enough data (so that the optimizer may not attempt to do a full table scan due to few rows). If this gets to big, just send it privately to me (or make it available for download on the web). It could take some days, because I am just upgrading my mysql version and have to do some regression tests on my software first. By the way, which MySQL version do you use? Bye, Benjamin. - 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
Future suggestion
I just started using MySQL in the past month or so, and love it so far. I come from a background that includes a lot of FoxPro (way back in the days of FoxBase for the Macintosh). I also have had a bit of MS SQL Server experience, but more using it as a back end for Visual Foxpro. One of the things that have always bugged me about writing a SELECT statement has been the inablility to exclude certain fields. When doing a select * from a join, it would be nice to be able to do something like this: SELECT * EXCEPT invoice.custpo, payment.custid FROM remainder of select statement Is there anything holding back the developers of MySQL from implementing such a construct in MySQL, like the goal of ANSI compatability? Am I being a big dumbass for desiring such functionality? In any case, thanks to everyone who contributed to MySQL for such a cool product.
Re: MySQL Index
"Gorantla, Aruna" wrote: Hi, I would like to know whether the primary keys are automatically indexed in MySQL or do you have to index them explicitly? Thanks in advance, Aruna. A primary key is a unique index. - 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
mysql_config in 3.23.33 has a shell programming bug
Description: I'm testing various pieces of freeware to make sure they work well under Solaris; mysql_config didn't work on my system, due to (I believe) a shell programming problem: if ! test $# -gt 0; then usage; fi For whatever reason, standard solaris Bourne shell doesn't like this line, and outputs !: not found Substituting bash for /bin/sh, however, works ok. I suggest correcting the line to if test $# -eq 0; then usage; fi Which seems to work. How-To-Repeat: invoke mysql_config on Solaris Fix: See above Submitter-Id: submitter ID Originator: Organization: Daniel Price - Solaris I/O - [EMAIL PROTECTED] MySQL support: none Synopsis: mysql_config doesn't work on Solaris with 3.23.33 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: SunOS cagey 5.8 Generic i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/ccs/bin/make /home/kg/bin/gmake /home/kg/bin/gcc /opt/teamware/bin/cc GCC: Reading specs from /home/kg/i386/egcs-1.1b/lib/gcc-lib/i386-pc-solaris2.7/egcs-2.91.57/specs gcc version egcs-2.91.57 19980901 (egcs-1.1 release) Compilation info: CC='gcc' CFLAGS='-O3' CXX='g++' CXXFLAGS='' LDFLAGS='-L/home/kg/lib -R/home/kg/lib' LIBC: -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 15 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 15 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/home/kg/share/mysql-3.23.33 --exec-prefix=/home/kg/i386/mysql-3.23.33 --without-bench --without-berkeley-db Perl: This is perl, version 5.005_03 built for i86pc-solaris - 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
Specification of the MySQL Server/Client protocol
Hello, Perhaps you can call me stupid or just blind, but I can't find a specification of the MySQL Server/Client protocol anywhere... I need it to implement a simple, lightweight MySQL client for mIRC (so using MySQL++/libmysql is out of the question). Is there such a document lying around, if so where can I get it? Thanks in advance, Steven Wittens (I'm not sure how this list works, but I'm not subscribed, so if needed, please CC replies to me) - 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
HELP!!
Please, How can i insert the "'" character (like "sbie'2000") in a database using the INSERT command? tanks, Elaine. Don't E-Mail, ZipMail! http://www.zipmail.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Printed MySQL manual
I highly recommend Paul DuBois' book, it's an excellent read and a great reference. At 04:05 PM 2/21/2001 -0500, Thalis A. Kalfigopoulos wrote: As an alternative, I would suggest one of the fine books on MySQL. Our developers each have a copy of the Paul DuBois book ("MySQL" / New Riders) as well as the O'Reilly book "MySQL mSQL". Both are excellent learning and reference resources, and are invaluable in understanding and applying SQL syntax. I assume both are pretty good (I can verify that the 2nd one is indeed), but still they are begining to show signs of their age. Mysql develops very fast and they are both '99 books (IIRC). Does anyone know of any plans for 2nd editions? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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: Printed MySQL manual
Denis: I'm not sure you really want a printed MySQL manual ... the software is dynamic, and is constantly being upgraded. The online manual is updated frequently, and is closer to the software you may be using. As an alternative, I would suggest one of the fine books on MySQL. Our developers each have a copy of the Paul DuBois book ("MySQL" / New Riders) as well as the O'Reilly book "MySQL mSQL". Both are excellent learning and reference resources, and are invaluable in understanding and applying SQL syntax. G. Jensen - Original Message - From: "Denis L. Menezes" [EMAIL PROTECTED] To: "mysql list" [EMAIL PROTECTED] Sent: Monday, February 19, 2001 8:36 PM Subject: Printed MySQL manual Hello friends. Can anyone please advise how I can obtain a printed copy of the MYSQL manual? thank you. denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Index
It's indexed.. if you create a table like so: create table planner( id integer not null auto_increment, tstamp timestamp, uid integer not null, db_id integer not null, vendor bool not null default 0, list bool not null default 0, companylist bool not null default 0, article bool not null default 0, plan bool not null default 0, accent bool not null default 0, key planner_key (id) ); mysql show keys from planner; +-++-+--+-+- --+-+--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | +-++-+--+-+- --+-+--+ | planner | 1 | planner_key |1 | id | A |NULL | NULL | +-++-+--+-+- --+-+--+ -Original Message- From: Gorantla, Aruna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 9:47 AM To: '[EMAIL PROTECTED]' Cc: Gorantla, Aruna Subject: MySQL Index Hi, I would like to know whether the primary keys are automatically indexed in MySQL or do you have to index them explicitly? Thanks in advance, Aruna. - 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
Help with slow select count(*)
I see in your 'Explain's, the 2 queries use different indexes, the fast one uses soc_date_idx, and the slower one uses q_idx. The trick, perhaps is to force soc_date_idx to be used in the 2nd case. (Adding ORDER BY soc_date might do it, 'soc_date=X and (queue_id=Y and server_id=Z) ) might do it. I dunno. Perhaps if you do ANALYZE TABLE, it will comply with your desire. Cheers, Kent - 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
Quoting numbers? (was Re:MySQL Tables)
I think you'll get better results if you don't quote your numbers. Quotes should be used for text and dates (depending) but not numbers. Out of curiosity, why? We use quotes for numbers all the time here, for consistency's sake; the programmer doesn't have to worry about the representation of, say, a salesman_id, but just reads/displays/stores it in the database. Aside from the fact that leaving them off is possible, is there a standards/compatibility/other reason to do so? (An example of a good reason not to use them would be if the db engine weren't smart enough to use an index when you say select * from table_name where numeric_key = '1234' but possibly (probably?) all dbms's are that smart.) --Pete - 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
Query Question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Excuse the wrapping.. Any ideas on how to speed this up? takes 10 secs on a p2 300. If i could get the second table to not scan all 132,775 rows, it would be great. I have indexes in it: mysql show keys from suppliersiclink; +-++-+--+- - +---+-+--+ | Table | Non_unique | Key_name| Seq_in_index | | Column_name | Collation | Cardinality | Sub_part | +-++-+--+- - +---+-+--+ | suppliersiclink | 1 | sic_link|1 | id | | A |NULL | NULL | suppliersiclink | | 1 | sic_index |1 | sic_code| A | | NULL | NULL | suppliersiclink | 1 | supplier_id | | 1 | sup_id | A |NULL | NULL | +-++-+--+- - +---+-+--+ Also, this query does not work in mySQL 3.23.33 any idea why? mysql explain - SELECT supplier.id,supplier.company_name,supplier.contact_name,supplier.addre ss_street, - supplier.address_city,supplier.address_state,supplier.address_zip,supp lier.phone_business, - supplier.url,supplier.miniweb_live,supplier.miniweb_name,supplier.spec ial_live, - subcatsicbond.sub_catid,subcatsicbond.siccode,specials.id,specials.s_t itle - FROM subcatsicbond - LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code - LEFT JOIN supplier ON suppliersiclink.sup_id=supplier.id - LEFT JOIN specials ON supplier.id=specials.sup_id - WHERE ((subcatsicbond.sub_catid=20) AND (supplier.max_latitude=32.99) - AND (supplier.min_latitude=31.55) AND (supplier.min_longitude=89.25) - AND (supplier.max_longitude=90.97)) - ORDER BY supplier.company_name ASC LIMIT 0,10; +-+--+---+-+-+ - +++ | table | type | possible_keys | key | key_len | | ref| rows | Extra | +-+--+---+-+-+ - +++ | subcatsicbond | ref | supplier_id | supplier_id | 4 | | ???| 7 || suppliersiclink | | ALL | sic_index | NULL|NULL | NULL | | 132775 || supplier| ref | vendor_key| | vendor_key | 4 | suppliersiclink.sup_id | 20 | where | used | specials| ALL | supplier_key | NULL| | NULL | NULL | 2 || +-+--+---+-+-+ - +++ 4 rows in set (0.00 sec) - - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOpP9vbFNxPoD98ryEQJPkwCgjIQ7hlHAk17sAQfSW38w0PkAEaoAoLIk AczTsf21QrUIwPfxiKstSf2Z =Kwl9 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error 35 with my.cnf
Hello Max, I am just catching up on my mysql messages and it didn't look like your question got answered. I am still learning mysql, but I know electronics. The first thing I would check, in your case, is the memory chips on the errant machine. Are the speeds identical? I have had a similar problem when I had chips 34 with a different clock rate than 12. How much memory is on board? Mysql is a memory hog. I had it working fine on 160Meg for development purposes, but I moved everything to a machine with 1.25Gig for production. Good luck. On 19 Feb 2001, at 12:09, Max Harper wrote: I work for a web hosting company that has mysql 3.22.23 on one of our servers. The server is Free BSD unix version 3.5. It seems every few weeks it pops up with this error. System Error: DBI-connect(WWWThreads:localhost) failed: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug at modules/w3t.pm line 480 The code that access mysql is fine because out of the 8 servers it is on this server is the only one having problems and is the only one that has mysql on it. It is configured the exact same way as all the other server except it has mysql on it. I checked the config file for mysql and it looks fine to me. If this is something that isn't setup on the server, can anyone please point me in the right direction as to how to fix it? Here is the my.cnf file [client] #password = my_password port = 3306 #socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 #socket = /var/lib/mysql/mysql.sock #pid-file = /var/run/mysql.pid big-tables skip-locking skip-name-resolve skip-networking #log #log-update set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = back_log=256 set-variable = key_buffer=5M set-variable = table_cache=64 set-variable = sort_buffer=5M set-variable = record_buffer=5M set-variable = max_connections=400 set-variable = join_buffer=5M skip-thread-priority [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk]set-variable = key_buffer=16M -Thank you. - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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
Error when writing a sql statement into a field.
Statement: Syntax error or access violation: You have an error in your SQL syntax near 'xxx","c","-1","-1",")' at line 1 Was updating a log table in the database that has a message field. The message field was being updataed with: query = "INSERT INTO passtbl(user,pass,employeeId,customerId) VALUES"; query += "(\"" + this.getuserId() + "\","; query += "\"" + this.getpass() + "\","; query += "\"" + this.employeeId + "\","; query += "\"" + this.customerId + "\","; mysql explain applog - ; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | applogid | int(10) | | PRI | NULL| auto_increment | | logMessage | varchar(255) | YES | | NULL|| | timedate | timestamp(14) | YES | | NULL|| ++---+--+-+-++ - 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: XML support under mySQL
On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) My naive understanding is that it would be effortless to write a module in perl that translates the data returned by the DBI to XML. I'm not a perl expert so I cannot speak to that. However, I doubt that it's effortless or trivial. -- Regards, Doug - 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
Why doesn't this work??
4.13.6 Splitting Data Across Different Disks Under Windows I can't get this to work, any idas? Thanx! Andreas - 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
lower_case_table_names=1 does not work with Solaris
lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici al MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shar ed Perl: This is perl, version 5.005_03 built for sun4-solaris Environment: System: SunOS vienna 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-60 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-con structors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1749356 Jul 20 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 19 13:28 /lib/libc.so - ./libc.so. 1 -rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1749356 Jul 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici al MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shar ed Perl: This is perl, version 5.005_03 built for sun4-solaris - 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: XML support under mySQL
Some relational databases return results in XML format. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:48 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? No la comprende, senor - XML is a markup language, MySQL is a database. What does ne have to do with the other? -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Working on mysql on ISP site
hello Friends. I am very new to mysql and web site work, so please help me. I am hosting a website at an ISP(Verio) with mysql support. Whenever I use the standard mysql commands, I get an "access denied" error. I presume one of the following is wrong : 1. Maybe the user@localhost should be changed in my start command. 2. Since mysql is distributed to many sites, the initial database will be named for my site? and then maybe I have to make my databases within this site?? can anyone advise how this remote database building is done? thank you denis
typos in support-files/my-*.cnf
Description: the comments in the my-*.cnf files say that they should be installed as /etc/mf.cnf. Fix: change the comments in my-*.cnf to read '/etc/my.cnf' Submitter-Id: submitter ID Originator:Gord Shier Organization: MySQL support: none (yet) Synopsis: typo in support-files/my-*.cnf Severity: non-critical Priority: low Category: mysql Class: Release: mysql-3.23.28-gamma (Official MySQL binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.12 Distrib 3.23.28-gamma, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.28-gamma-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 6 min 25 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.023 Environment: System: Linux hank.gordshier.com 2.2.17-21mdk #1 Thu Oct 5 13:16:08 CEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Feb 18 00:27 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 931668 Oct 4 12:26 /lib/libc-2.1.3.so -rw-r--r--1 root root 20749008 Oct 4 12:25 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 4 12:25 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
MySQL and JDBC: Communication link failure
Anybody know what's wrong? After 'java LoadDriver' I always get the message: Exception: Communication link failure: java.io.EOFException SQLState: 08S01 VendorError: 0 java.sql.SQLException: Communication link failure: java.io.EOFException at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:370) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:199) at LoadDriver.main(LoadDriver.java:20) Information about the system I'm working on: OS: Redhat Linux 2.2.17-6 DBMS: MySQL 3.23.11-alpha Java: jdk1.3 DB driver: mm.mysql-2.0.4-bin.jar CLASSPATH=/usr/java/jdk1.3/lib/mm.mysql-2.0.4-bin.jar:. Compile: javac LoadDriver.java Java code: // LoadDriver.java import java.sql.*; public class LoadDriver { public static void main(String args[]) { // Load the driver to allow connection to the db try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch (Exception e) { System.err.println("Failed to load JDBC/MySQL driver"); e.printStackTrace(); System.exit(1); // terminate the program } try { System.out.println("I'm going to connect to database"); Connection c = DriverManager.getConnection("jdbc:mysql://localhost/test?user=" + "nobodypassword=nobody"); System.out.println("I have connected to database"); }catch (SQLException e) { System.out.println("Exception: " + e.getMessage()); System.out.println("SQLState: " + e.getSQLState()); System.out.println("VendorError: " + e.getErrorCode()); e.printStackTrace(); } } } Thank you! -- Cecilia
aggregate UDF's
hi, i need to write my own very basic aggregate functions for MySQL and had a couple of questions regarding this: * does anybody know of a site with a collection of UDF's written by other MySQL user? * i read an old posting (from 99) about somebody writing a little tool, which enabled him to write UDFs in Perl: does anybody know more about this (excuse my naive question, but i guess there is nothing like that available for Java, or?) * any known problems for using UDFs over the JDBC-interface? * is it true that there is no way for using UDFs on the Windows-platform? * i could not find udf_example.cc neither in the Win-distribution, nor in the Linux-Intel-version. can anybody provide me with some basic example code, so that i see how aggregate functions should work? thanks a lot for your help, michi ps. i was already thinking about changing to a pure Java database, in order to write some functions on the DBserver-side in Java, since i am more familiar with this, but then i had to figure out there is nothing out there that is nearly as reliable, fast and inexpensive as MySQL!! keep up the good work, guys! - 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: Error when writing a sql statement into a field.
On Wed, 21 Feb 2001, allen2k wrote: Statement: Syntax error or access violation: You have an error in your SQL syntax near 'xxx","c","-1","-1",")' at line 1 Was updating a log table in the database that has a message field. The message field was being updataed with: query = "INSERT INTO passtbl(user,pass,employeeId,customerId) VALUES"; query += "(\"" + this.getuserId() + "\","; query += "\"" + this.getpass() + "\","; query += "\"" + this.employeeId + "\","; query += "\"" + this.customerId + "\","; drop the last comma, and add a close paranthesis. if you haven't already. also, you can use single quotes to separate values.. Atle - 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: changing character set used for data and sorting
Hi! On Feb 21, Kirill Magdalinin wrote: Hello, can anyone help me to solve the following problem: I've installed MySQL server Ver 8.0 Distrib 3.22.32 from ^^^ FreeBSD 4.1 ports while installing OS. Here's your problem. I don't know why FreeBSD Port Collection still has MySQL-3.22, while 3.23 is officially released as stable. Nevertheless, for 3.22 you should build MySQL with koi8 charset from sources. But if you're planning to build MySQL yourself anyway, I *strongly* recommend to use latest 3.23 tarball. It works ok on FreeBSD (I am, personally, using FreeBSD) - you will need gmake (from ports, e.g.) though. MySQL-3.23 is faster and has *a lot of* new features. And - to mention - all the bugfixes goes only to MySQL-3.23, MySQL-3.22 are no longer supported. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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
The security concerns about MySQL
Hi, I am not familiar with the current state of MySQL security. I know there were serious problems with previous versions, but that was a year ago. I am planning to install an application program that use MySQL as backend on our external server. There are other important database server running on the server too. Does anyone know how secure the MySQL is? Will it be safe to install it on the server host? My program is using MySQL3.22. Are there advisories out on MySQL? Thanks. = Abby __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! 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
seemingly anomalous behaviour in Selects entered manually vs. in a script
Hi! I've got this seemingly anomalous situation that occurs when using a SELECT. If I use the MYSQL command line thing and SELECT * FROM QUESTIONS, it tells me that there are 7 rows in the set. There are, in fact 7 rows. Perfect. HOWEVER, if I execute the following script I always get 1 row fewer than exist. If there ought to be only 1 row in the result I get nothing displayed! SNIP ?php MYSQL_CONNECT("localhost","yourID","yourPASSWORD"); mysql_select_db("yourDATABASE"); $ex=@MYSQL_QUERY("select * from questions where uid='1' "); echo 'table width="95%" border="1" cellspacing="4" cellpadding="4" align="center" bgcolor="#CC" bordercolorlight="#FF" bordercolordark="#99"'; echo "form action=\"integrateTest.php3\" method=\"GET\""; //THE NEXT TWO LINES -- TRY EXECUTING ONE SELECT AND THEN COMMENT THE OTHER LINE AND EXECUTE THE OTHER SELECT //$ex=@MYSQL_QUERY("select * from questions where uid='1' "); $ex=@MYSQL_QUERY("select * from questions "); $peek=@mysql_fetch_row($ex); while($row = mysql_fetch_array($ex)) { $var=$row["uid"]; echo "tr tddiv align=\"left\""; echo "bselect: /binput type='checkbox' name='ID[]' value='$var'"; echo "/b/div div align=\"left\"bQuestion:/b $row[question]/div/td /tr"; } echo "/table"; echo ' p align=centerinput type="submit" name="Submit" value="Create Test" /form/p'; ? SNIP I suspect that it is something ridiculous that I am doing (or not doing), but I just don't see it. Would someone mind setting me straight on what I'm not doing correctly? Thanks heaps! -Warren - 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: web based admin?
John Jensen ([EMAIL PROTECTED]) writes: Do you have a remote server? Do you have a lot of data to enter into your database? Ask yourself: Would you rather preface each and every insert with "INSERT [data] INTO [table.column] ...", than enter data by filling in blanks in a webform. All depends on what you want to do. mysqldump is my friend - I use it quite often, especially when I want to change the structure of a table, and I can't remember the ALTER TABLE syntax (or don't have access to a browser). I use mysqldump to dump the data with --add-drop-table, run it, edit the output file to alter the table structure, then feed it back to mysql. Works great. If I want to do CRUD on a few records or two, I'll use Escapade - it's faster than the PHP admin thingie for editing data. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: XML support under mySQL
One thing I want. A Java way to save a data structure and recover it later. Easy in perl, not so easy in Java. But XML would be a great way to do it in Java. Eric At 10:42 AM 2/22/01 +1000, Opec Kemp \( Ozemail \) wrote: *big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to choice to install external XML modules if you wish, if not why would you use it? I'm sure if you write the XML modules as an extension to MySQL in C or C++, it'll be just as fast as if it is built in. Not to maintion the fact that it'll be far easier of MySQL developer to put in other really "useful" RDMB related features like ForeinKeys etc etc. instead of "cool" but not critical features XML. And the code base for MySQL wouldn't be bloated either which means we as the users won't have to download 200MB RDMB servers :):) My $0.02 But you've yet to make a case for extending a database engine to do something it's not originally designed to do and something that I argue does not belong in a RDBMS engine. First, while I agree that XML is a great solution for 2 applications to exchange data, it is not a - 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 Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - 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: seemingly anomalous behaviour in Selects entered manually vs.in a script
On Wed, 21 Feb 2001, Warren wrote: SNIP ?php MYSQL_CONNECT("localhost","yourID","yourPASSWORD"); mysql_select_db("yourDATABASE"); $ex=@MYSQL_QUERY("select * from questions where uid='1' "); echo 'table width="95%" border="1" cellspacing="4" cellpadding="4" align="center" bgcolor="#CC" bordercolorlight="#FF" bordercolordark="#99"'; echo "form action=\"integrateTest.php3\" method=\"GET\""; //THE NEXT TWO LINES -- TRY EXECUTING ONE SELECT AND THEN COMMENT THE OTHER LINE AND EXECUTE THE OTHER SELECT //$ex=@MYSQL_QUERY("select * from questions where uid='1' "); $ex=@MYSQL_QUERY("select * from questions "); $peek=@mysql_fetch_row($ex); The above line assigns the first row of the query to the variable $peek (array), and then moves the internal pointer on to the next row. When you then do the following, no wonder you're receiving one less result... :) Atle while($row = mysql_fetch_array($ex)) { $var=$row["uid"]; echo "tr tddiv align=\"left\""; echo "bselect: /binput type='checkbox' name='ID[]' value='$var'"; echo "/b/div div align=\"left\"bQuestion:/b $row[question]/div/td /tr"; } echo "/table"; echo ' p align=centerinput type="submit" name="Submit" value="Create Test" /form/p'; ? SNIP I suspect that it is something ridiculous that I am doing (or not doing), but I just don't see it. Would someone mind setting me straight on what I'm not doing correctly? Thanks heaps! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Quoting numbers? (was Re:MySQL Tables)
- Original Message - From: "Pete Harlan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 4:51 Subject: Quoting numbers? (was Re:MySQL Tables) I think you'll get better results if you don't quote your numbers. Quotes should be used for text and dates (depending) but not numbers. Out of curiosity, why? For starters, I've had problems in the past doing this - getting incorrect results. Remove quotes and everything worked fine. The other is that not all databases/languages accept quotes around numbers. It's like comparing apples and oranges. We use quotes for numbers all the time here, for consistency's sake; the programmer doesn't have to worry about the representation of, say, a salesman_id, but just reads/displays/stores it in the database. Aside from the fact that leaving them off is possible, is there a standards/compatibility/other reason to do so? (An example of a good reason not to use them would be if the db engine weren't smart enough to use an index when you say Exactly. Not cross compatible with some databases/languages though it should be with today's databases. select * from table_name where numeric_key = '1234' but possibly (probably?) all dbms's are that smart.) I have used 2 diff. databases during my studies which would not accept the above because of quotes. Don't remember the names of the DBs but I do remember one ran under DOS and the other under VAX/VMS. --Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: XML support under mySQL
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Another reason, maybe even a better one, is that XML is less database specific. So too will be the data. So the result of a query is no longer tied to the database that produced it. Untrue. Data is data. The result of a query should *never* be tied to the database - if it is, you're doing something *very* wrong. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: Future suggestion
Also, specifying fields won't break things when people add fields to a table. On Wed, 21 Feb 2001, Cal Evans wrote: Date: Wed, 21 Feb 2001 11:07:36 -0600 From: Cal Evans [EMAIL PROTECTED] To: Jason Landry [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Future suggestion Hey HEY! Another old Fox-Jockey! :) (There are still a few of us left in the world) While I understand your suggestion, I would suggest that you steer clear of using Select * at all except when testing or when there is no other way. You will get better performance by specifying the fields you want returned in your result set explicitly. Just my $0.02, Cal http://www.calevans.com -Original Message- From: Jason Landry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 9:41 AM To: [EMAIL PROTECTED] Subject: Future suggestion I just started using MySQL in the past month or so, and love it so far. I come from a background that includes a lot of FoxPro (way back in the days of FoxBase for the Macintosh). I also have had a bit of MS SQL Server experience, but more using it as a back end for Visual Foxpro. One of the things that have always bugged me about writing a SELECT statement has been the inablility to exclude certain fields. When doing a select * from a join, it would be nice to be able to do something like this: SELECT * EXCEPT invoice.custpo, payment.custid FROM remainder of select statement Is there anything holding back the developers of MySQL from implementing such a construct in MySQL, like the goal of ANSI compatability? Am I being a big dumbass for desiring such functionality? In any case, thanks to everyone who contributed to MySQL for such a cool product. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: RE: XML support under mySQL
Aaron Weiker ([EMAIL PROTECTED]) writes: application interface. XML is this magic layer in the middle that each party No it's not. XML is simply an emerging standard to describe metadata. No magic involved. about to get this Email). The solution would be to have this other middle tier application be built, doesn't really matter what language but the requirement is to have it be able to work with XML and also with MySQL (or so be it, another database). It isn't MySQL's responsibility to do this, however it would be great if they could, would definably help MySQL be able to compete feature to feature against the other DB's that are out there. No, it wouldn't, because it's pretty trivial to write something that would wrap XML around data. Why do people constantly try to tie presentation layer stuff to either data or a particular database? It's evil to do so - and if I have to explain why, maybe it's time folks went back to school to take a computer science course or two and learn all about decoupled systems and why tightly coupled systems like this are *evil*. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Mysql++ problems
HI. When I was trying to include the "custon.hh" header file, I got some error messages like this. gcc -lsqlplus -I/usr/include -I/usr/include/mysql -L/usr/lib -o test3 test3.cc In file included from /usr/include/custom.hh:71, from test3.cc:5: /usr/include/custom-macros.hh:8299:16: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8354:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8371:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8389:5: warning: nothing can be pasted after this token /usr/include/custom-macros.hh:8427:50: warning: nothing can be pasted after this token ( . . . . . . and these messages repeated many many times) test3.cc:13:26: warning: pasting would not give a valid preprocessing token test3.cc:13:26: warning: pasting would not give a valid preprocessing token test3.cc:13:26: warning: pasting would not give a valid preprocessing token .(..well and these messages also repeated many times) /tmp/ccRsci15.o: In function `mysql_ColDataconst_string::operator int(void) const': /tmp/ccRsci15.o(.gnu.linkonce.t.__opi__Ct13mysql_ColData1Z12const_string+0x10): undefined reference to `int mysql_ColDataconst_string::convint(int) const' /tmp/ccRsci15.o: In function `mysql_ColDataconst_string::operator double(void) const':/tmp/ccRsci15.o(.gnu.linkonce.t.__opd__Ct13mysql_ColData1Z12const_string+0x12): undefined reference to `double mysql_ColDataconst_string::convdouble(double) const' collect2: ld returned 1 exit status make: *** [test3] Error 1 Should I always use gcc version 2.95.2? Does it work on gcc 2.96? I think I have linked the library's directory. Can you give me some hints? Thanks a lot :) - 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
LEFT JOINing a table you are already SELECTing
Is it possible to have the following situation: Schema: id first last optional_id I want to do a select like this: SELECT D.id, D.first, D.last, D.optional_id, db1.first, db1.last FROM db1 AS D LEFT JOIN db1 ON D.optional_id=db1.id; and have it return: |id|first|last|optional_id|first|last| -- | 1| bob | d.| NULL| NULL|NULL| | 2| guy | e.| 1| bob| d.| | 3| hrm | h.| NULL| NULL|NULL| Of course the above syntax is broken, but I was wondering if this was possible? Thanks! Graeme - 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: Printed MySQL manual
Gerald Jensen ([EMAIL PROTECTED]) writes: As an alternative, I would suggest one of the fine books on MySQL. Our developers each have a copy of the Paul DuBois book ("MySQL" / New Riders) as well as the O'Reilly book "MySQL mSQL". Both are excellent learning and reference resources, and are invaluable in understanding and applying SQL syntax. Contrary to my previous experiences with O'Reilly books, I much prefer Paul's book. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: XML support under mySQL
Jeremy D. Zawodny ([EMAIL PROTECTED]) writes: On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple You cannot do that with MySQL. MySQL doesn't understannd XML (nor should it) - but inserting a document into a table as data is trivial. Inserting an XML document as metadata is a whole 'nother kettle of fish - and one, IMO, for which MySQL should never be hacked up to do. It would make more sense to write a thin layer in C to do such a thing. But that's probably a philosophical difference. Many would argue that the database server has no business dealing with XML. That should be the job of the program which is putting the data into the database... I agree completely. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: seemingly anomalous behaviour in Selects entered manually vs. in a script
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 $peek=@mysql_fetch_row($ex); while($row = mysql_fetch_array($ex)) at that point in your code the first call to mysql_fetch_row() moves the result pointer up one position.. therefore, losing your first row. if you have to have $peek.. make a call to mysql_data_seek($ex,0); then you will move the result pointer back to row 0. - - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - -Original Message- From: Warren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:33 PM To: [EMAIL PROTECTED] Subject: seemingly anomalous behaviour in Selects entered manually vs. in a script Hi! I've got this seemingly anomalous situation that occurs when using a SELECT. If I use the MYSQL command line thing and SELECT * FROM QUESTIONS, it tells me that there are 7 rows in the set. There are, in fact 7 rows. Perfect. HOWEVER, if I execute the following script I always get 1 row fewer than exist. If there ought to be only 1 row in the result I get nothing displayed! SNIP ?php MYSQL_CONNECT("localhost","yourID","yourPASSWORD"); mysql_select_db("yourDATABASE"); $ex=@MYSQL_QUERY("select * from questions where uid='1' "); echo 'table width="95%" border="1" cellspacing="4" cellpadding="4" align="center" bgcolor="#CC" bordercolorlight="#FF" bordercolordark="#99"'; echo "form action=\"integrateTest.php3\" method=\"GET\""; //THE NEXT TWO LINES -- TRY EXECUTING ONE SELECT AND THEN COMMENT THE OTHER LINE AND EXECUTE THE OTHER SELECT //$ex=@MYSQL_QUERY("select * from questions where uid='1' "); $ex=@MYSQL_QUERY("select * from questions "); $peek=@mysql_fetch_row($ex); while($row = mysql_fetch_array($ex)) { $var=$row["uid"]; echo "tr tddiv align=\"left\""; echo "bselect: /binput type='checkbox' name='ID[]' value='$var'"; echo "/b/div div align=\"left\"bQuestion:/b $row[question]/div/td /tr"; } echo "/table"; echo ' p align=centerinput type="submit" name="Submit" value="Create Test" /form/p'; ? SNIP I suspect that it is something ridiculous that I am doing (or not doing), but I just don't see it. Would someone mind setting me straight on what I'm not doing correctly? Thanks heaps! - -Warren - - 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 -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOpR+jLFNxPoD98ryEQLdaACgoxEM6vnrWxzilBeSI+GNeQLDFCYAnRq6 0NMjNjdNvxbxMdcwGDqDn6Y5 =ZxYb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can this query not be done in MySQL.
The problem is that the value returned for a column requested in a group query without an agregate function is undefined, There is NO associated link between some column that you didn't put in the function and one that does not appear in the group by statement.. In fact usually (in my databases including mysql this will result in an error). Look at it this way.. What if you had two rows that corresponded to the max, how would it know which one to pick.. What if you were taking the Average instead of the max, and it returned 1.5 which row is it supposed to give you? As you can see there are many examples that illustrate why you can't do that query. Mr. Van Engen did have solutions for you posted to the list, I will forward you his response. It isn't that mysql can't perform the query you want, it is that the query you have shown is not compatible with SQL itself. If it were me I would do it in two queries... Get the max and then get the City corresponding to the flight and the max, in your case you should never have two cities that corespond to the max, but sql is a general language and cannot make such an assumption in all cases. Gerald Clark also posted another suggestion, another alternative, but you're not going to be able to do this with the query you state and it isn't mysql to blame... You can blame mysql for not haveing subqueries though :) Richard Reina wrote: Steve, I never received Mr. Van Engen's response. I appreciate your response. However, my question remains unanswered. If you put "sequence" in the GROUP BY it does not give you the value that correspond to the MAXIMUM sequence. As a matter of fact I can't find any combination of values that you can put in the GROUP BY clause that will give you the values that correspond with MAX. What good is an aggregate function like MAX if it does not give you the value ( and only that ) that corresponds to that aggregate function. In this case shouldn't (MAX(sequence)) give you only those values that correspond to the maximum sequence for each flight which would be: +---+ |flight_no |sequence|City | | 127 | 2 |Boston | | 391 | 1 |Miami | +---+ The documentation in the documentation under GROUP BY functions (section 7.3.12) seems to advocate this syntax -- specifically with their example of querying orders by MAX(payments) -- although they don't show the results of their examples. If this cannot be done in MySQL will someone with authority on the subject -- perhaps Sasha or Monty -- simply say that MySQL cannot perform this type of query. If it can be done will someone demonstrate how it can be done in MySQL. I believe I can do it in other DBMSs with the following subselect: SELECT soo.flight_no, soo.sequence, soo.city FROM stop_offs soo /* That's "stop_offs outer" */ WHERE soo.sequence = (select max(soi.sequence) FROM stop_offs soi /* "stop_offs inner" */ where soi.flight_no = soo.flight_no ) however, it is my understanding that MySQL does not support subselects. I have once again included a copy of the table below. Once again, thank you for your attention in this matter. Here is the table: +--+ | STOP_0FFS | +--+ |FLIGHT_NO |CITY | SEQUENCE| |127 |Chicago |1| |127 |Boston |2| |391 |Miami|1| +--+ SELECT flight_no, MAX(sequence), city FROM stop_offs GROUP BY flight_no; gives the result: +---+ |flight_no |sequence|City | | 127 | 2 |Chicago| | 391 | 1 |Miami | +---+ However Chicago is the city of the first stop off (sequence 1) not the value that corresponds with a sequence of 2 which would be 'Boston'. The desired result is the following: +---+ |flight_no |sequence|City | | 127 | 2 |Boston | | 391 | 1 |Miami | +---+ Steve Ruby wrote: Your question was answered already after you posted it on Saturday by Fred van Engen... Basicaly you should not be able to do a group by without perfoming an aggregate function (max, avg, sum, count) on columsn that do not appear on the "GROUP BY" clause. Richard Reina wrote: I posted this question to this list on Saturday. I realize that not everyone on the list knows whether this query is possible using MySQL. However, if I could please here back from someone who does know, I would appreciate it. I'm getting flack from informix ( and other DBMS ) users on my perl user list who are now doubting whether I can get it to work in MySQL. I have great confidence in MySQL and believe
Re: Re : Question???
I havent done any FoxPro pgmming but if u could you get the error message returned from Mysql.. It sounds like user privilege problem... Cheers! Thiru On Thu, 22 Feb 2001 11:15:23 +0800 "edith" [EMAIL PROTECTED] wrote: - Dear Sir/Madam, - I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: - CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE "tempdata" -STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO xConnHandle //return of 'xConnHandle' is positive that means connection is successful// -=SQLSETPROP(xConnHandle,'Transactions',2) //this return is negative that means there is an error on connection level// - I don't know why I can view the table but I cannot update the table through ODBC. Would you help me to solve this problem? Thank you! - Regards, - Edith - -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - 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: seemingly anomalous behaviour in Selects entered manually vs. in a script
I think your command $peek = @mysql_fetch_row($ex); fetches the first row - you don't output it - and the cursor goes to the next row. For all remaining rows you use mysql_fetch_array($ex) which starts from the second row (see above). This results in n rows, with the first one invisible and (n - 1) rows displayed. What's the above line about? I can't see any sense behind it. Remove it, and I think the thing will work... Gnther Pewny Warren wrote: Hi! I've got this seemingly anomalous situation that occurs when using a SELECT. If I use the MYSQL command line thing and SELECT * FROM QUESTIONS, it tells me that there are 7 rows in the set. There are, in fact 7 rows. Perfect. HOWEVER, if I execute the following script I always get 1 row fewer than exist. If there ought to be only 1 row in the result I get nothing displayed! SNIP ?php MYSQL_CONNECT("localhost","yourID","yourPASSWORD"); mysql_select_db("yourDATABASE"); $ex=@MYSQL_QUERY("select * from questions where uid='1' "); echo 'table width="95%" border="1" cellspacing="4" cellpadding="4" align="center" bgcolor="#CC" bordercolorlight="#FF" bordercolordark="#99"'; echo "form action=\"integrateTest.php3\" method=\"GET\""; //THE NEXT TWO LINES -- TRY EXECUTING ONE SELECT AND THEN COMMENT THE OTHER LINE AND EXECUTE THE OTHER SELECT //$ex=@MYSQL_QUERY("select * from questions where uid='1' "); $ex=@MYSQL_QUERY("select * from questions "); $peek=@mysql_fetch_row($ex); while($row = mysql_fetch_array($ex)) { $var=$row["uid"]; echo "tr tddiv align=\"left\""; echo "bselect: /binput type='checkbox' name='ID[]' value='$var'"; echo "/b/div div align=\"left\"bQuestion:/b $row[question]/div/td /tr"; } echo "/table"; echo ' p align=centerinput type="submit" name="Submit" value="Create Test" /form/p'; ? SNIP I suspect that it is something ridiculous that I am doing (or not doing), but I just don't see it. Would someone mind setting me straight on what I'm not doing correctly? Thanks heaps! -Warren - 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
BDB Problem with MAX() and multipart primary keys
Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql insert into sample values (1, 2); Query OK, 1 row affected (0.07 sec) mysql select id2 from sample where id1=1; +-+ | id2 | +-+ | 2 | +-+ 1 row in set (0.00 sec) mysql select min(id2) from sample where id1=1; +--+ | min(id2) | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql select max(id2) from sample where id1=1; +--+ | max(id2) | +--+ | NULL | +--+ 1 row in set (0.00 sec) Is this a bug in mySQL? Why does MIN() return the correct result, while MAX() does not? Is it a severe bug which possibly can cause data inconsistency within the table data or does there exist a "good" workaround for this problem with only modifying the query? Thanks Gnther Pewny - 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: XML support under mySQL
Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both implementing a lot of XML functionality in their RDBMS's. Oracle is ahead of SQLServer, I believe. Like it or not, these two RDBMS's are very influential with how the web/db community create applications. An Oracle/Java web combination is a powerful, object-oriented way for web app to speak to a database. When XML browser support matures, the web developer will be able to "easily" separate the db content from the display with style-sheets. XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. -- Regards, Doug - 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: Future suggestion
Hey HEY! Another old Fox-Jockey! :) (There are still a few of us left in the world) While I understand your suggestion, I would suggest that you steer clear of using Select * at all except when testing or when there is no other way. You will get better performance by specifying the fields you want returned in your result set explicitly. Just my $0.02, Cal http://www.calevans.com -Original Message- From: Jason Landry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 9:41 AM To: [EMAIL PROTECTED] Subject: Future suggestion I just started using MySQL in the past month or so, and love it so far. I come from a background that includes a lot of FoxPro (way back in the days of FoxBase for the Macintosh). I also have had a bit of MS SQL Server experience, but more using it as a back end for Visual Foxpro. One of the things that have always bugged me about writing a SELECT statement has been the inablility to exclude certain fields. When doing a select * from a join, it would be nice to be able to do something like this: SELECT * EXCEPT invoice.custpo, payment.custid FROM remainder of select statement Is there anything holding back the developers of MySQL from implementing such a construct in MySQL, like the goal of ANSI compatability? Am I being a big dumbass for desiring such functionality? In any case, thanks to everyone who contributed to MySQL for such a cool product. - 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] Rel DB Question
I have a relational DB question. I'll preface this and say I've had no formal training in DB's only on-the-job knowledge. I've been trying out some CASE tools and have discovered the following: Lets say I have a table that stores PEOPLE. I also have a table that stores SHIRTS, PANTS, SHOES. Now in the CASE tools when I create relationships between these tables, I get tons of "link" tables to relate PEOPLE to SHIRTS, PEOPLE to PANTS, PEOPLE to SHOES, and then I've got SHIRTS to PANTS, SHIRTS to SHOES, etc. I guess this is the proper way to implement these relationships. My question is, what I've done in the past is create a table like the following: PEOPLE_LINK -- people_link_id int people_id int link_type char link_id int Where link_type is either SHIRT, PANTS, SHOES (like an ENUM). Depending on what the "link_type" is, the link_id is either the shirt_id, pants_id, shoes_id. Is there anything wrong with using this one table instead of four tables to implement these relationships? Obviously, if "PANTS" becomes "TROUSERS" I'll have to do a replace, but as far as relational DB's go, is there anything wrong with have a relationship based on two keys and a char field. Any insights would be greatly appreciated. Thanks very much. -- Clarence Kwei [EMAIL PROTECTED] ScienCentral, Inc. (212) 244-9577 ext. 118 http://www.stn2.com http://www.sciencentral.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: So, what do you do with a tarball...
Steve Ruby ([EMAIL PROTECTED]) writes: it do 38+ hours of frantic disk swapping. I went to www.mysql.com and followed the seemingly most obvious path to downloads. There, i saw the section which says "Binary (tarball) distributions". I downloaded the item for FreeBSD. Only, it's not a "gz" it's not a "tar", I don't know what it it is. If there is a Do what? Both the FreeBSD binary tarballs are gzipped tar archives, or so they appear to me. "tar xvfz mysql-3.23.33-unknown-freebsdelf4.2-i386.tar.gz" works for me. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: XML support under mySQL
For someone like my self having a tool to export via XML is bloatware, Any XML handling should be delt with in the milddleware, where it will be utilized NOT the database it self. Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? My naive understanding is that it would be effortless to write a module in perl that translates the data returned by the DBI to XML. -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - 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
unzip problem
Win32 static binary of MySQLGUI 1.7.4-2 cant unzip it Keith
RE: XML support under mySQL
The database does it. It is my understanding that MSSQL will return the results of a query in XML. The idea, as I understand it, is to create web pages with XML data. (I attended a XML class where we did this) Since the web page contains code to call the database and the result is in XML, then it should be easier to present the page. (Note: some browsers can already do this with native XML) Another reason, maybe even a better one, is that XML is less database specific. So too will be the data. So the result of a query is no longer tied to the database that produced it. Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 1:20 PM To: Mehalick, Richard RE SSI-GRAX Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: Some relational databases return results in XML format. The *database* does that, or an add-on query tool does that? It'd be trivial to implement an add-on for mysql (xmlmysql, a command-line tool maybe) which would do it. But making the database server itself do it seems rather, uh... strange. I'm not saying it's a bad idea, but I just don't see the utility in it. Can someone who would use such a feature explain how and why? Seeing as how folks ask about this once in a while, I'm more than a bit curious at this point. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: HELP!!
INSERT INTO table VALUES ('sbie\'2000'); -Original Message- From: Elaine Silva [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 February 2001 12:17 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: HELP!! Please, How can i insert the "'" character (like "sbie'2000") in a database using the INSERT command? tanks, Elaine. Don't E-Mail, ZipMail! http://www.zipmail.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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: RE: XML support under mySQL
Eric Frazier ([EMAIL PROTECTED]) writes: One thing I want. A Java way to save a data structure and recover it later. Easy in perl, not so easy in Java. But XML would be a great way to do it in Java. Why Java? That's like going to a gas station and saying "I want gas specifically formulated for my 1998 Ford Taurus". If Java doesn't do what you want, maybe it's time to look at other options. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: Working on mysql on ISP site
Denis L. Menezes ([EMAIL PROTECTED]) writes: I am hosting a website at an ISP(Verio) with mysql support. Whenever I = use the standard mysql commands, I get an "access denied" error. I = presume one of the following is wrong : Every ISP I've hosted at has either a FAQ or a help desk for this sort of thing. Ask them. That being said, you'll probably find that (1) the login/password for the database is the same as the one you used to login to the server, (2) most ISPs will not allow you to connect to MySQL from the outside world, (3) you will have at least one uniquely named database for your own use, and (4) you will probably *not* have access to the database named "mysql". -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Bug?
This Report was made using the WinMySQLadmin 1.0 Tool 2001/02/22 07:34:49 Description: When using MyQDBC with Delphi TTable components and using the table names in uppercase the size of character fields is reported wrong as 128. I cannot change the table names of all TTable components to lowercase in the whole app. No other SQL database app. has problems with that. What should we do? How-To-Repeat : Fix: Synopsis : Submitter-Id : Originator : Organization : MySQL support : [none | licence | email support | extended email support ] Severity : [non-critical | serious | critical ] Priority : [low | medium | high ] Category : [mysqld, mysql client, C, PHP, PERL, ...] Class : [ sw-bug | doc-bug | change-request | support ] OS Platform: Windows NT detected Machine description: Compiler : VC++ 6.0 Architecture : i686 Total Memory : 130.612 MB RAM My.ini File [mysqld] basedir=C:/mysql datadir=C:/mysql/data Server Status Values Server Info3.23.33 Host Info localhost via TCP/IP Client Info3.23.22-beta Proto Info 10 Aborted_clients1 Aborted_connects 2 Bytes_received 0 Bytes_sent 0 Connections17 Created_tmp_disk_tables0 Created_tmp_tables 1 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 1 Handler_read_first 287 Handler_read_key 47487 Handler_read_next 47190 Handler_read_prev 0 Handler_read_rnd 450214 Handler_read_rnd_next 495554 Handler_update 0 Handler_write 941580 Key_blocks_used7764 Key_read_requests 4178181 Key_reads 73 Key_write_requests 991906 Key_writes 991905 Max_used_connections 3 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables20 Open_files 31 Open_streams 0 Opened_tables 755 Questions 996194 Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan12 Slave_running OFF Slave_open_temp_tables 0 Slow_launch_threads0 Slow_queries 10 Sort_merge_passes 0 Sort_range 0 Sort_rows 450214 Sort_scan 11 Table_locks_immediate 989835 Table_locks_waited 0 Threads_cached 0 Threads_created16 Threads_connected 1 Threads_running1 Uptime 56562 Variables Values ansi_mode OFF back_log 50 basedirc:\mysql\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8 _ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout5 datadirc:\mysql\data\ delay_key_writeON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_geminiNO have_innobase NO have_isam YES have_raid NO have_ssl NO init_file interactive_timeout28800 join_buffer_size 131072 key_buffer_size8388600 language c:\mysql\share\english\ large_files_supportON logOFF log_update OFF log_binOFF log_slave_updates OFF long_query_time10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 1048576
RE: seemingly anomalous behaviour in Selects entered manually vs. in a script
What are you intending to do with $peek? You only use it once and it's sucking up one of your rows. -jm -Original Message- From: Warren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 5:33 PM To: [EMAIL PROTECTED] Subject: seemingly anomalous behaviour in Selects entered manually vs. in a script Hi! I've got this seemingly anomalous situation that occurs when using a SELECT. If I use the MYSQL command line thing and SELECT * FROM QUESTIONS, it tells me that there are 7 rows in the set. There are, in fact 7 rows. Perfect. HOWEVER, if I execute the following script I always get 1 row fewer than exist. If there ought to be only 1 row in the result I get nothing displayed! SNIP ?php MYSQL_CONNECT("localhost","yourID","yourPASSWORD"); mysql_select_db("yourDATABASE"); $ex=@MYSQL_QUERY("select * from questions where uid='1' "); echo 'table width="95%" border="1" cellspacing="4" cellpadding="4" align="center" bgcolor="#CC" bordercolorlight="#FF" bordercolordark="#99"'; echo "form action=\"integrateTest.php3\" method=\"GET\""; //THE NEXT TWO LINES -- TRY EXECUTING ONE SELECT AND THEN COMMENT THE OTHER LINE AND EXECUTE THE OTHER SELECT //$ex=@MYSQL_QUERY("select * from questions where uid='1' "); $ex=@MYSQL_QUERY("select * from questions "); $peek=@mysql_fetch_row($ex); while($row = mysql_fetch_array($ex)) { $var=$row["uid"]; echo "tr tddiv align=\"left\""; echo "bselect: /binput type='checkbox' name='ID[]' value='$var'"; echo "/b/div div align=\"left\"bQuestion:/b $row[question]/div/td /tr"; } echo "/table"; echo ' p align=centerinput type="submit" name="Submit" value="Create Test" /form/p'; ? SNIP I suspect that it is something ridiculous that I am doing (or not doing), but I just don't see it. Would someone mind setting me straight on what I'm not doing correctly? Thanks heaps! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP!!
Escape it with a backslash - insert into table (field1) values ('sbie\'2000') This is covered in the manual http://www.mysql.com/manual.php jason - Original Message - From: "Elaine Silva" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 9:17 AM Subject: HELP!! Please, How can i insert the "'" character (like "sbie'2000") in a database using the INSERT command? tanks, Elaine. Don't E-Mail, ZipMail! http://www.zipmail.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 - 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: Backup
Li Joe ([EMAIL PROTECTED]) writes: I would like to perform database backup while the server is running. I don't want to use mysqldump as the tables are huge. So I consider to use BACKUP TABLE sql command to perform it. In addition, I find that this command only backups the .MYD and .frm, i.e. no .MYI files will be kept. What can I perform a better approach to have all stuffs without stop the server. mysqldump. So, your tables are huge - would you rather have an incomplete backup of your data? Besides, filtering the output of mysqldump through gzip reduces the output quite a bit. -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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