Re: How to sum() with php query?
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote: At 19:53 -0500 2/7/02, Floyd Baker wrote: I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? The SQL SUM() function has nothing to do with PHP. SELECT SUM(some_numeric_column) FROM tbl_name is one example of how it works. That I know. I have your book in my hand... But I'm not able to make it work from a php script. By php syntax I mean something like your example on page 360 using count(). I'm replacing it with sum(). $result = mysql_query( select SUM('cost') from $table); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I get result = array(0)... Can you tell me what's wrong? Thanks much. Floyd -- - 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: Distributed Fulltext?
On Friday 08 February 2002 08:56, Vincent Stoessel wrote: Apples and oranges. Yeah, I know. But let's see if we can make some distinctions. If, say, Google, can search 2 trillion web pages, averaging say 70k bytes each, in 1 second, and Mysql can search 22 million records, with an index on 40 bytes each, in 3 seconds (my experience) on a good day, what's the order of magnitude difference? Roughly 10^9. Have you seen the /hardware/ run that enterprise with? Irrelevant, you're unlikely to get 9 orders of magnitude difference with faster hardware or even with clustering. Google runs on cheap pc hardware with local IDE disk... nothing fancy. The majority of the speed comes from sharding the data to distributed indexes which are optimized for what they do, and having a frontend that knows where to route those requests. Also, their software is optimized for full text searches and that is /all/ they do. Mysql is an SQL database and is optimized as such. Absolutely granted. You are completely right. And I don't expect the data format to change. BUT: thought experiment: When Mysql decides to generate a FULLTEXT index, it is using an index file, the .MYI file, which can have ANY FORMAT it wants to. If the .MYI format is poorly optimized for fulltext searches, they can improve the format. They can even introduce a new index file type .MYF solely for optimizing fulltext searche. Agreed... however I don't know if that's the case either. Anyone (developers?) know enough about the internals to comment on such an approach? It seems if you know your goal is fulltext speed.. things could probably be done better. Thinking out loud... Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 modifies other fields than intended
At 17:29 -0800 2/7/02, Johan van Reijendam wrote: Hi all, I have run into the following issue and was wondering if anyone else has ever run into the same and if there is an answer to this behaviour. I have a record which contains the following fields: id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, create_time TIMESTAMP, modify_time TIMESTAMP, noteTEXT When I update this record and modify any of the fields other than the 'create_time' field then the 'create_time' field gets updated as well. None of my calls to the database however address the 'create_time' field. Is there some feature that I am overlooking which may be causing this ? Yes, what you're seeing is the way the first TIMESTAMP column in a table is supposed to behave. See: http://www.mysql.com/doc/D/A/DATETIME.html - 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 4 - FullText searching syntax?
Hi! On Feb 07, Alain Fontaine - Consultant and developer wrote: -- snip -- select BienID from biens where MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE) -- snip -- This does not produce the correct result, whereas this does: -- snip -- select BienID from biens where MATCH(Notes) AGAINST('appartemen*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('lux*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE) -- snip -- That looks like a bug, can you create a test case for it ? 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 - 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: printing camera-ready mysql report
On Mon, 28 Jan 2002, David S. Jackson wrote: I'm just starting my first MySQL db, and I'm going to want to print out reports from it and produce a camera-ready document. Has anyone done this before, using, say, Star Office or AbiWord or something? David, I go this way for high quality output: echo $QUERY | mysql db | filter.sh tempfile.tex tex tempfile.tex -- tempfile.dvi dvips tempfile.dvi -- tempfile.ps filter.sh may be quite complex. It is a shell script (or you can use perl) launching sed or awk to produce the TeX source. The appendix is an example of a filter to produce verbatim output from plain ASCII text with fixed spacing. Thomas Spahni (pass the spam filter: MySQL table database query) #!/bin/sh # print ASCII texts AS IS # this acts like a filter: taking input from stdin # and sending output to the printer # these are user-definable TMPDIR=/tmp TMPFILE=printfile PRINTER=lpr -Php # --- no user configuration beyond this line --- TMPDEST=${TMPDIR}/${TMPFILE} # just to avoid any conflicts: # tmpfile is our lockfile at the same time if test -e ${TMPDEST}.tex ; then echo $TMPDEST exists; aborting 2 exit 1 fi # create the necessary header first cat ${TMPDEST}.tex -'XXX' \message{A4 paper size}% \hsize 159.2mm %210mm - 1in * 2 for margins \vsize 246.2mm %297mm - 1in * 2 for margins % Define special characters for direct use \catcode`Ç=\active \defÇ{\c{C}} \catcode`ü=\active \defü{\u} \catcode`é=\active \defé{\'e} \catcode`â=\active \defâ{\^a} \catcode`ä=\active \defä{\a} \catcode`à=\active \defà{\`a} \catcode`å=\active \defå{{\aa}} \catcode`ç=\active \defç{\c{c}} \catcode`ê=\active \defê{\^e} \catcode`ë=\active \defë{\e} \catcode`è=\active \defè{\`e} \catcode`ï=\active \defï{{\\i}} \catcode`î=\active \defî{{\^\i}} \catcode`ì=\active \defì{{\`\i}} \catcode`Ä=\active \defÄ{\A} \catcode`Å=\active \defÅ{{\AA}} \catcode`É=\active \defÉ{\'E} \catcode`æ=\active \defæ{{\ae}} \catcode`Æ=\active \defÆ{{\AE}} \catcode`ô=\active \defô{\^o} \catcode`ö=\active \defö{\o} \catcode`ò=\active \defò{\`o} \catcode`û=\active \defû{\^u} \catcode`ù=\active \defù{\`u} \catcode`Ö=\active \defÖ{\O} \catcode`Ü=\active \defÜ{\U} \catcode`á=\active \defá{\'a} \catcode`í=\active \defí{{\'\i}} \catcode`ó=\active \defó{\'o} \catcode`ú=\active \defú{\'u} \catcode`ñ=\active \defñ{\~n} \catcode`Ñ=\active \defÑ{\~N} \catcode`ß=\active \defß{{\ss}} \def\quest{?} % % strange fontsize to ensure that 80 characters make up one line \font\vtt=cmtt10 at 10.77pt \footline={\vtt\hfil - \the\pageno\ -\hfil} % \def\uncatcodespecials{\def\do##1{\catcode`##1=12 } \dospecials} \def\setupverbatim{% \par \vtt \spaceskip=0pt % Make sure we get fixed vtt spacing \obeylines\uncatcodespecials\obeyspaces\verbatimdefs} % This macro turns on verbatim mode until ?endverbatim is seen. \def\verbatim{\begingroup \setupverbatim \parskip=0pt plus .05\baselineskip \parindent=0pt \catcode`\ =13 \catcode`\^^M=13 \catcode`\?=0 \verbatimgobble} {\catcode`\^^M=13{\catcode`\ =13\gdef\verbatimdefs{\def^^M{\ \par}\let =\ }} \gdef\verbatimgobble#1^^M{}} % This defines ?endverbatim to end the group which begins with \verbatim \let\endverbatim=\endgroup \let\|=\relax \verbatim XXX #echo -e \n ${TMPDEST}.tex # now add what we get from stdin cat - | sed -e s/?/?quest?|/g ${TMPDEST}.tex # add the tail cat ${TMPDEST}.tex -'XXX' ?endverbatim \vfill\eject \end XXX sync (cd $TMPDIR tex ${TMPFILE}.tex) if test -r ${TMPDIR}/${TMPFILE}.dvi ; then (cd $TMPDIR dvips $DVIARGS ${TMPFILE}.dvi) $PRINTER ${TMPDIR}/${TMPFILE}.ps fi # clean up (cd $TMPDIR rm -f \ ${TMPFILE}.tex ${TMPFILE}.log ${TMPFILE}.dvi ${TMPFILE}.ps) - 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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with length of String aliases with 4.0.0
Hello. I was adviced to write to you about this from an experiensed mySQL user, as this might be a bug in 4.0.0 Im trying to do this: select col1,col2,col3,'text' as name from tabel where blahblah now, this would add 'text' to all rows in the result, and that works just fine but, if i try with 'elektronikksenteret' its cut off after 16 chars in the result. So no matter what i try to insert, if its longer then 16 chars, it will be cut of there. Is this a bug in the new version ? Or are there any new features that i might have missed. Regards Jostein Solstad Norbits AS www.norbits.no - 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: long query on php
Surprisingly it is mote than 64 KB! (I count strlen=74KB) Bravo!! Makis -Original Message- From: savaidis [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:08 AM To: [EMAIL PROTECTED]; 'Nathan' Cc: 'MySQL' Subject: RE: long query on php Just a comment: Doing so it's possible to insert a line between $query.. statements. (comments ecc) Its very simple to write it with copy+paste and I prefer this. Thanks. PS. I'll check the string limit and I let you know. I think it has to be the 64KB. I think only Visual Basic has this high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- How is possible to pass a long query to MySQL server with php? I mean i.e a create table statement with more than 400 chars. Have I to use shorter create and then alter? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Fw: Problem with length of String with 4.0.1
I might add this bit of information. What i was trying to do worked with version 3.23.37 It did NOT work with version 4.0.1-alpha-nt Regards Jostein - Original Message - From: Jostein Solstad [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 08, 2002 3:45 PM Subject: Problem with length of String with 4.0.1 Hello. I was adviced to write to you about this from an experiensed mySQL user, as this might be a bug in 4.0.0 Im trying to do this: select col1,col2,col3,'text' as name from tabel where blahblah now, this would add 'text' to all rows in the result, and that works just fine but, if i try with 'elektronikksenteret' its cut off after 16 chars in the result. So no matter what i try to insert, if its longer then 16 chars, it will be cut of there. Is this a bug in the new version ? Or are there any new features that i might have missed. Regards Jostein Solstad Norbits AS www.norbits.no - 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: What is ROWNUM of oracle in mysql
not the exact equivalent but if you are looking at a query like: select * from mytable where rownum=8; you can do : select * from mytable limit 7,1 select query .. [LIMIT [offset,] rows] http://www.mysql.com/doc/S/E/SELECT.html - Original Message - From: Ramaraju.R.V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 5:17 AM Subject: What is ROWNUM of oracle in mysql Hi, What is the alternative in mysql for ROWNUM of Oracle? Thanks, Rama Raju - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query advice, please
Hi: I'd like to store user preferences in one table, such that there are default values but a user can override the preference. Default preferences are stored as user 0. This is trivial to do with two queries, but I'd like to compress it to one. Here's an example of what I mean: +--+--+---+ | user | eid | value | +--+--+---+ |0 |1 | green | |0 |2 | black | |1 |1 | pink | +--+--+---+ In this case, a query for user 1 should return black and pink, as the green element was overwritten by pink (eid == element id). I think I'm overanalyzing this whole query, and it should be very simple but I can only think of how to do it with two queries. Thanks, m0x __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - 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: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. I do not want to sound touchy, touchy, but that is as saying, that e.g. SyBase does not have replication everywhere, as you have to set it with various options. And SyBase has practically invented RDMBS replication, if my memory serves me well. There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: PostgreSQL
Trond Eivind Glomsr=F8d writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: =20 I said everywhere - you need to use Innobase to get foreign keys, a= nd=20 innobase/db3 to get transactions. =20 --=20 Trond Eivind Glomsr=F8d Red Hat, Inc. =20 =20 As EVERY binary and source we distribute has InnoDB in it, then we have transactions and foreign keys everywhere.=20 It is only up to the user to enable it.=20 --=20 Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]= / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Get hash of MySQL row
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: Hi I want to retrieve a row of MySQL data using Perl and DBI, so I do it like this: [code] my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; $sth = $dbh-prepare($sqlquery); $sth-execute or die(Can't execute SQL query. [$DBI::err] $DBI::errstr); $ref = $sth-fetchrow_hashref(); $sth-finish; [/code] Seems reasonable. But what I want is to populate a %hash with all name/value pairs retruned from this query. Are you sure that there is data returned? I tried: [code] my %hash = %$ref; [/code] But that doesn't work. It should. I'm not sure why you'd want to do it, but it should work. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 100,373,948 queries (475/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 / PHP Augmenting Variables For UPDATE
Hi, I am making a form for editing the rows in a table. It displays each row as a row in a table(structure id tinyiny,name varchar(30) ), with the value inside a textbox so it can be changed. When doing the $submit to MySQL, I need do this: for($count=0;$count=$i;$count++) { $current_id = $$count.-id; $current_name = $$count.-name; $sql = UPDATE committee_names SET name ='$current_name' WHERE committee_id = '$current_id' $result = mysql_query($sql); }; Each time a record is displayed in the HTML table the textbox is given a name like $0-name then $1-name dynamically until all the records in the table have been displayed. Does anyone know how I can accomplish this? Many Thanks. - Matt Rudderham - 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: Errors that i can't see find in the help system on mysql
Oops i was a bit hasty, this problem occurs after the mysql has been running for a little while, kill the mysql and restart it and it can run just fine again for a while. Terkel -Original Message- From: Terkel Olsen Sent: 7. februar 2002 09:24 To: '[EMAIL PROTECTED]' Subject: Errors that i can't see find in the help system on mysql 020206 15:11:47 mysqld started /usr/pkg/libexec/mysqld: ready for connections 020207 1:02:00 Error in accept: Too many open files 020207 1:06:19 Error in accept: Too many open files 020207 1:10:37 Error in accept: Too many open files 020207 1:14:56 Error in accept: Too many open files 020207 1:19:14 Error in accept: Too many open files 020207 1:23:33 Error in accept: Too many open files 020207 1:27:52 Error in accept: Too many open files 020207 1:32:10 Error in accept: Too many open files 020207 1:36:29 Error in accept: Too many open files 020207 1:40:47 Error in accept: Too many open files 020207 1:45:06 Error in accept: Too many open files 020207 1:49:24 Error in accept: Too many open files 020207 1:53:43 Error in accept: Too many open files 020207 1:58:01 Error in accept: Too many open files 020207 2:02:20 Error in accept: Too many open files 020207 2:06:39 Error in accept: Too many open files 020207 2:10:57 Error in accept: Too many open files 020207 2:15:16 Error in accept: Too many open files 020207 2:19:34 Error in accept: Too many open files 020207 2:23:53 Error in accept: Too many open files 020207 2:28:11 Error in accept: Too many open files 020207 2:32:30 Error in accept: Too many open files 020207 2:36:48 Error in accept: Too many open files 020207 2:41:07 Error in accept: Too many open files 020207 2:45:26 Error in accept: Too many open files 020207 2:49:44 Error in accept: Too many open files 020207 2:54:03 Error in accept: Too many open files 020207 2:58:21 Error in accept: Too many open files 020207 3:02:40 Error in accept: Too many open files 020207 3:06:58 Error in accept: Too many open files 020207 3:11:17 Error in accept: Too many open files 020207 3:15:36 Error in accept: Too many open files 020207 3:19:54 Error in accept: Too many open files 020207 3:24:13 Error in accept: Too many open files 020207 3:28:31 Error in accept: Too many open files 020207 3:32:50 Error in accept: Too many open files 020207 3:37:08 Error in accept: Too many open files 020207 3:41:27 Error in accept: Too many open files 020207 3:45:45 Error in accept: Too many open files 020207 3:50:04 Error in accept: Too many open files 020207 3:54:23 Error in accept: Too many open files 020207 3:58:41 Error in accept: Too many open files 020207 4:03:00 Error in accept: Too many open files 020207 4:07:18 Error in accept: Too many open files 020207 4:11:37 Error in accept: Too many open files 020207 4:15:55 Error in accept: Too many open files 020207 4:20:14 Error in accept: Too many open files 020207 4:24:32 Error in accept: Too many open files 020207 4:28:51 Error in accept: Too many open files 020207 4:33:10 Error in accept: Too many open files 020207 4:37:28 Error in accept: Too many open files 020207 4:41:47 Error in accept: Too many open files 020207 4:46:05 Error in accept: Too many open files 020207 4:50:24 Error in accept: Too many open files 020207 4:54:42 Error in accept: Too many open files I can't find this in any of the helpfiles on your website, nor can i find it on NetBSD helpfile mysql Ver 11.15 Distrib 3.23.47, for -netbsdelf (i386) And 1.5ZA NetBSD 1.5ZA I Same error on 3.23.43 i tried upgrading both the kernel and the mysql, but still no avail. Have you had any others with similar problems, if so i'd love to hear about it Terkel -- Terkel D. Olsen Systemadministrator Bonnierforlagene A/S Frederiksborggade 1. 2.sal 1360 Kbh K Tlf: 33 69 50 85 Mob: 40 18 70 85 - 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: Problems with SQLGetInfo and SQLColumnPrivileges
Can you send exact message as this one to [EMAIL PROTECTED] ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Compile options
Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (sql) - 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: Problems with select
15.8 has no exact binary representation, so a test for equality will fail. Do not use floating point if you want to test for equality. Try DECIMAL Miguel Figueiredo wrote: Hello all, I have a (probably dumb) question. My table temperatura has two fields described bellow. mysql describe temperatura; +-+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | datetime | datetime | YES | | NULL| | | temperatura | float| YES | | NULL| | +-+--+--+-+-+---+ 2 rows in set (0.00 sec) When I try to select rows with floats, the result is an empty set. For example: mysql select datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00; +-+-+ | datetime| temperatura | +-+-+ | 2002-02-08 09:30:00 |15.8 | +-+-+ 1 row in set (0.00 sec) got one row :) mysqlselect datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura=15.8; Empty set (0.00 sec) -- same thing but with the temperatura value, gives me an empy set :( When I try to select another row but the temperatura field has an integer this is what happens: mysql select datetime,temperatura from temperatura where datetime=2002-01-25 09:40:00; +-+-+ | datetime| temperatura | +-+-+ | 2002-01-25 09:40:00 | 16 | +-+-+ 1 row in set (0.00 sec) --- got one row :) mysql select datetime,temperatura from temperatura where datetime=2002-01-25 09:40:00 and temperatura=16; +-+-+ | datetime| temperatura | +-+-+ | 2002-01-25 09:40:00 | 16 | +-+-+ 1 row in set (0.00 sec) -- It works now :/ Does anyone have an idea why this happens? How can I select float numbers? Best wishes, Miguel - 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: InnoDB foreign keys crash MySQL
Harald, I tested the below with 3.23.48, and it worked ok. Could it be that you have not used DROP TABLE or DROP DATABASE to remove InnoDB tables? Then the internal data dictionary may be out-of-sync from the .frm files of your tables. Please use innodb_table_monitor (section 9.1 in http://www.innodb.com/ibman.html ) to print the contents of the internal data dictionary, and compare it to the .frm files you have for the tables. Please send the output to the mailing list. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Harald Fuchs wrote in message ... (MySQL 4.0.1-alpha-Max-log, your Linux binary) The following works fine (just a slight variation of what is in the manual): CREATE TABLE t1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) TYPE=InnoDB; CREATE TABLE t2 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t1id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t1id), FOREIGN KEY (t1id) REFERENCES t1(id) ) TYPE=InnoDB; The following, however, crashes MySQL: CREATE TABLE t1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) TYPE=InnoDB; CREATE TABLE t2 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t1id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t1id), FOREIGN KEY (t1id) REFERENCES t1(id) ) TYPE=InnoDB; CREATE TABLE t3 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t2id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t2id), FOREIGN KEY (t2id) REFERENCES t2(id) ) TYPE=InnoDB; The log file says: InnoDB: foreign constraint creation failed; InnoDB: internal error number 17 InnoDB: Assertion failure in thread 45067 in file dict0crea.c line 1241 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; I can send you the stack trace if necessary. - 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
problem and question
admin, Wednesday, February 06, 2002, 4:40:30 AM, you wrote: a hello, a This is my problem and question: a I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to install mysql-3.23.47 to the platform and I hope the two versions are both useful. How should I configure the a parameters when I configure? You can find info about it in the manual, look at: http://www.mysql.com/doc/I/n/Installing_many_servers.html and http://www.mysql.com/doc/M/u/Multiple_servers.html a I want mysql supporting the BDB tables as well,is that using '--with-berkeley-db=./bdb' enough? Get some more info about BDB tables here: http://www.mysql.com/doc/B/D/BDB_install.html and http://www.mysql.com/doc/B/D/BDB_start.html a I'm waiting for your replying and thank you for that! a admin a [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: 1 billion row
Interesting subject ;-) Can you provide some more information; Like exactly what failed, any errors you received, if it crashed, how big the database files got before the failure happened etc. Magyari Istvan wrote: Hi, I have been trying to build a 1 billion row database, in mysql version 3.23.47, under Suse 7.3, but failed a several times, i reached around 600.000.000 rows... The table has an int(10) unsigned and a bigint(20) field, indexed by the bigint(20) field. The hardisk is 26GB SCSI, the computer is a dual Pentium III with 1GHz, with 2GB memory I'd like to have your opinion about what should I be carefull at the table creation or mysqld settings, and how fast will be the queries in this 1 billion row and if its worth to make all in 1 table. Thank you, Magyari Istvan - 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Manual references to safe_mysqld
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Tue, Jan 29, 2002 at 03:27:17PM -0500, Ken Menzel wrote: With MySQL 4.0 are we not supposed to be using mysqld_safe? Should'nt references in the manual be modified from safe_mysqld to mysqld_safe? Jeremy I think so. I just did that recently in my book. Imagine how many Jeremy times I got it backwards and ended up second-guessing myself. :-( Yes, on is suppled to use mysqld_safe on MySQL 4.0. We have been a bit reluctant to update the manual, as most of our users are still using 3.23 and could easily be confused by this. I think we should wait until 4.0 goes into beta before doing the update. I could make this change if you like. Also I am getting ready to update references to freebsd. Not being familiar with bitkeeper I assume I use: bk send -d manual.texi This would be ok. Jeremy I'm not sure how they're generated (possibly from the manual), but the Jeremy INSTALL-SOURCE and INSTALL-BINARY files in 4.x also have references to Jeremy safe_mysqld rather than mysqld_safe. These files are automaticly generated from the manual. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
MyODBC 3.51 released
Hi! MyODBC 3.51 driver was released a few days ago. Version 3.51 of the MyODBC driver is now released by MySQL AB and available for download. An ODBC (Open Database Connectivity) driver enables client programs to access a database or data source. The new version 3.51 MySQL ODBC driver is a greatly enhanced successor version to the existing MyODBC 2.50, rewritten to follow the ODBC 3.5x specifications. It provides complete and up-to-date ODBC functionality when accessing any MySQL database. Changelog and API reference for MyODBC 3.51.01: -- SQLAllocHandle -- SQLFreeHandle -- SQLSetEnvAttr, using this, the driver can be configured its functionality based on the ODBC version -- SQLGetEnvAttr -- SQLSetConnectAttr -- SQLGetConnectAttr -- SQLSetStmtAttr -- SQLGetStmtAttr -- SQLFetchScroll -- SQLBulkOperations with SQL_ADD (Bulk Inserts) -- SQLGetDiagRec -- SQLGetDiagField -- SQLCloseCursor -- SQLEndTran -- SQLGetInfo, re-written completly -- SQLGetFunctions, re-written completly -- Complete changes to error handling. Also driver returns the SQLSTATE values based on the ODBC version. -- Support of dynamic cursor type -- Enhanced cursor handling -- Changed SQLGetTypeInfo to return column headers as per 3.5 spec -- Changed all catalog APIs to return column headers as per 3.5 spec -- Support of dynamic cursor type -- New feature called 'Test Data Source' in the DSN setup dialog, so that the DSN settings can be tested while configuring. -- Added 'HELP' button to DSN setup dialog, which links to online MyODBC manual. -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the following cases: - BeforeStart AND FetchOffset = 0 - CurrRowsetStart = 1 AND FetchOffset 0 - CurrRowsetStart 1 AND CurrRowsetStart + FetchOffset 1 AND |FetchOffset| RowsetSize - CurrRowsetStart 1 AND CurrRowsetStart + FetchOffset 1 AND |FetchOffset| = RowsetSize -- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the case when FetchOffset 0 AND |FetchOffset| LastResultRow AND |FetchOffset| RowsetSize -- Fix to memory leaks on unix when linked with iodbc or unixodbc. -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- FILEDSN support Apart from the above, -- MyODBC 3.51 allows backward compatibility, i.e. all 2.50 applications will work without any problems. -- MySQL ODBC 3.51 Programmer's Reference Manual and frequently Asked Questions(FAQs) are live. For more information about MyODBC, visit http://www.mysql.com/products/myodbc/index.html Regards Venu Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Questions about MYSQL GUI
At 08:12 AM 2/8/2002 , you wrote: Hi, sir/madam: I'm new to MYSQL. I'm now doing my final year project, and intend to use mysql as the database system. I installed the version mysql-3.23.46a-win and myodbc-2.50.39-nt on my computer for testing. I would like to download a MYSQL GUI for data management instead of inputing data through the DOS. Would you mind giving me some suggestions on which version of GUI I should dl, if (a) mysql is running on WIN 95?, or (b) mysql is running on Win NT? Thanks for your kind attention looking forward to ur reply. Regards, Polly Polly, Try MySQL-Front from http://www.anse.de/mysqlfront/. I have it running on Win2k with no problems. You'll like the price, free! :) There is also MySQLMgr from http://ems-hitech.com/mymanager/ which comes with a 30 day eval and costs $99. Brent - 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: INSERTing duplicate values to a UNIQUE-indexed table
I want to thank everyone for their contributions on this thread,and especially Erik for posting the question. I'm in the middle of the problem, and was about to write excessive code using Erik's suggestion No.1. Thank you, thank you to all. - Original Message - From: Erik Price [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 04, 2002 1:10 PM Subject: INSERTing duplicate values to a UNIQUE-indexed table Hello, everyone. I have a slight dilemma, and was wondering what the standard workaround is. I have three tables: owners (auto_increment primary key is owners_id), objects (auto_increment primary key is objects_id), and owners_objects (which is a foreign key table that I created, under advice from someone on this list a while back whose email address has changed -- there are two columns in owners_objects: owners_id and objects_id, and there are two unique indexes on the table, owners_id / objects_id and objects_id / owners_id -- this is to keep duplicates combinations in this table, since they would only take up extra disk space). I am designing an application in PHP which stores the relationship between an Owner and an Object using the owners_objects table in a many-to-many relationship. When someone adds a new owner, they can choose from an HTML listbox any number of objects to associate with that owner. The PHP code creates an INSERT statement that inserts the data into owners, and then takes the auto_incremented primary key of the last insert (which is the insert into owners) and uses that as the value for the second INSERT statemetn: to insert into owners_objects.owner_id. In this second INSERT statement, the objects_id of the Object(s) selected from the listbox go into the second column of owners_objects. I am sure that many people have done this sort of setup. But what do you do to get around the problem of INSERTing a pair of values that already exist? Because the combinations in owners_objects are UNIQUE (the UNIQUE indexes), MySQL won't accept a pair that is already present. I see two possible options: 1) Check to see if the combination is already present, and if so, do not run the INSERT query 2) run the INSERT query regardless and suppress the error message The disadvantage of the first one is that it adds an extra SQL query to the process. The disadvantage of the second one is that I think it is somewhat tasteless to execute code that will knowingly error -- or should I just stop trying to be such a perfectionist? I would post code but this is all pseudocode right now b/c I haven't solved this dilemma yet -- all experimentation with this has been done from the mysql client. Thanks for your advice! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB foreign keys crash MySQL
In article 003b01c1b0a4$351665f0$540ec5c2@omnibook, Heikki Tuuri [EMAIL PROTECTED] writes: Harald, I tested the below with 3.23.48, and it worked ok. Could it be that you have not used DROP TABLE or DROP DATABASE to remove InnoDB tables? Then the internal data dictionary may be out-of-sync from the .frm files of your tables. I just tried it again on a fresh MySQL/InnoDB installation (a new database to be created etc) and it still crashes. Please use innodb_table_monitor (section 9.1 in http://www.innodb.com/ibman.html ) to print the contents of the internal data dictionary, and compare it to the .frm files you have for the tables. Please send the output to the mailing list. Before the crash: === 020208 14:42:39 INNODB TABLE MONITOR OUTPUT === -- TABLE: name SYS_FOREIGN, id 0 11, columns 8, indexes 3, appr.rows 0 COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; FOR_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; REF_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; N_COLS: DATA_INT len 4 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL_PTR len 7 prec 0; INDEX: name ID_IND, table name SYS_FOREIGN, id 0 11, fields 1/6, type 3 root page 46, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: ID DB_TRX_ID DB_ROLL_PTR FOR_NAME REF_NAME N_COLS INDEX: name FOR_IND, table name SYS_FOREIGN, id 0 12, fields 1/2, type 0 root page 47, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: FOR_NAME ID INDEX: name REF_IND, table name SYS_FOREIGN, id 0 13, fields 1/2, type 0 root page 48, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: REF_NAME ID -- TABLE: name SYS_FOREIGN_COLS, id 0 12, columns 8, indexes 1, appr.rows 0 COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; POS: DATA_INT len 4 prec 0; FOR_COL_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; REF_COL_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL_PTR len 7 prec 0; INDEX: name ID_IND, table name SYS_FOREIGN_COLS, id 0 14, fields 2/6, type 3 root page 49, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: ID POS DB_TRX_ID DB_ROLL_PTR FOR_COL_NAME REF_COL_NAME -- TABLE: name test/innodb_table_monitor, id 0 18, columns 5, indexes 1, appr.rows 0 COLUMNS: a: DATA_INT len 4 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL_PTR len 7 prec 0; INDEX: name GEN_CLUST_INDEX, table name test/innodb_table_monitor, id 0 20, fields 0/4, type 1 root page 51, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: DB_ROW_ID DB_TRX_ID DB_ROLL_PTR a --- END OF INNODB TABLE MONITOR OUTPUT == No tables whatsoever, as you can see. During the crash: InnoDB: foreign constraint creation failed; InnoDB: internal error number 17 InnoDB: Assertion failure in thread 53260 in file dict0crea.c line 1241 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=67104768 record_buffer=258048 sort_buffer=2097144 max_used_connections=1 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 295531 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. InnoDB: Thread 20486 stopped in file os0sync.c line 374 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db8f 0x82bc35a 0x817c93b 0x817fd18 0x81a2725 0x80d99c3 0x80cd6ed 0x80c1f46 0x80de9c2 0x808662a 0x808a522 0x8085117 0x808a954 0x8084556 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at
Re: OT: *nix text editor?
On Mon, 4 Feb 2002, Matthew Walker wrote: I need to find a text editor for Linux that doesnt load the whole file into memory. I need to edit a 1.5 gig text flatfile to add two lines. But I dont have enough ram to open it in most programs. Can anyone recommend something? man sed Rather obscure at the beginning but does the job. (Filter: MySQL database table query) Thomas Spahni - 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: I must ask.
At 17:40 + 2/8/02, Andr=E9 Ferreira wrote: Hello ppl. I am playing hard with mysql, cause my ultimate objective is to make a big databank for a game. I notice that i cant find a way to make relations beteen tables. It's called a join. You'll find information about joins in any number of MySQL sources, including the MySQL manual. Check the tutorial chapter, for example (section 3.3.4.9). Must i do it also with PHP ? Thanck for the tips. And if i am rigth, my dont gays put so relation ? That's a very difficult sentence to understand. :-) - 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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: Yes, SIZEOF_INT is 4: $ grep SIZEOF_INT config.h #define SIZEOF_INT 4 $ grep SIZEOF_INT include/my_config.h #define SIZEOF_INT 4 -- albert chin ([EMAIL PROTECTED]) We shall have to llok at it. An interim fix is to set key_buffer_size to 4G - 4096 bytes ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Resolved: mysql_insert_id error
At 14:07 -0700 2/6/02, Nathan Bank wrote: Though this is a PHP issue, for those that use PHP here's what was wrong: mysql_insert_id() requires your connection link identifier, which is what is returned from mysql_connect and mysql_pconnect. This is contrary to almost all other mysql_ functions, which want the result resource returned from your query. I guess that's one way to look at it. Another way is that mysql_insert_id() is consistent with all the other mysql_ functions in that it requires arguments that are appropriate for the type of information you're requesting. :-) In this particular case, the insert-id is maintained on a connection-specific basis, so it would be strange for it to require a result resource rather than a connection identifier. Hope this saves a few people some agony. # Nathan - 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
MyODBC BDE invalid configuration error (BDE Error 12550)
We're running a MySQL 3.23.47 server on Windows 98, and when trying to connect to BDE version 3.0 (bundled with Borland C++ Builder 1) using MyODBC version 3.51 we get something like Invalid configuration parameter: Alias: database_alias BDE Error 12550 [0x31][0x6] I've searched the list archives and realize that some people have occasionally come across this problem but haven't found a solution or an indication of what the problem is ... Borland,s web site says of BDE Error 12550 12550 Invalid configuration parameter. One possible cause for the error: ODBC ALIASES. When creating and/or using a BDE alias that is using an ODBC DSN make sure that the ALIAS parameter ODBC DSN is set to the DSN that you wish to use and that has been created using ODBC Manager. Available ODBC DSN's can be chosen from the parameter's drop-down edit using the BDE Administrator. Another possible cause: Using ISAPI app and ODBC against NT web server. ODBC DSN on NT machine should be set to system instead of user. Has anyone run into this before ? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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 - 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: Default install directory
It is not platform-specific so much as installation-specific. Typically, it would be in /usr/local/mysql/data/ but that's again entirely dependant on what install you have. A quick locate mysql | grep data | more should reveal the locations of all your database files quickly. If you didn't already know, database files end with *.MYI, *.MYD, and *.frm extensions. # Nathan - Original Message - From: Jonas Fornander [EMAIL PROTECTED] To: Sent: Friday, February 08, 2002 11:42 AM Subject: Default install directory I have a crashed computer and need the mysql databases recovered. What is the default installation directory and default database directory for mysql on Mandrake 7.2? Jonas Fornander - System Administrator Netwood Communications, LLC - www.netwood.net Find out why we're better - 310-442-1530 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Manual references to safe_mysqld
Hi! Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Hi Jeremey! I think so. I just did that recently in my book. Imagine how many times I got it backwards and ended up second-guessing myself. :-( Ken Yes I have that confusion all the time, but it is good to have all Ken mysql tools begin with my or mysql. Also because the installation of Ken MySQL does not remove or alter safe_mysqld, on ends up with two Ken scripts startin mysql. This may not be a problem today however if in Ken the future the mysqld_safe script is altered for (saftey/features/some Ken important reason) people may end up using the wrong startup script. Ken I know my servers use the wrong script! Ken My suggestiion would be to check if safe_mysqld exists during the 4.0 Ken install and if it does remove it, then create a link to mysqld_safe Ken named safe_mysqld. This maintains compatibility for anyone who has Ken existing scripts and uses only one! Then in 4.1 perhaps deprecate the Ken safe_mysqld completely, but I don't think it's a big problem to Ken maintain the link if it exists. Ken Thoughts anyone? Sounds like a good suggestion. We will look into fixing this for our .RPM's cut Ken One other thing, I noticed that Multi-table update is mentioned in Ken the 4.0.2 release notes, but the syntax is not yet in the manual and Ken I didn't see the commit! Did I miss the commit? I want to pull this Ken ASAP and test it. The multi-table-update is committed, but I haven't had time to review the code yet; As soon as this is done, we will update the documentation about this. Ken Thanks everyone, Ken Ken Ken P.S. to Monty have been trying to recreate the 'row 0' error with Ken mysqldump unsuccesfully. I am not sure what has changed. :( Regards, Monty - 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
Hello! Date question....
Hi all... This is my first post to the list. I've been working on MySQL now for about a week and really like it. I have a question that I can't find in any of the books or how-tos. When I add a line to my customer's table I need it to put today's date in the indate column. Is there anyway to do this like the auto for numbers? Thanks! -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer - 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
Exclusion Query help
I am trying to run a query I have a table Records |Record_ID| |Phase_ID | |Record_Date| I need to find the records that have a record date between date1 and date 2 but exclude the records with a matching Phase_ID that opccured between date3 and date 4 so if I had the following table Record_IDPhase_IDRecord_Date 1 11/01/01 2314/01/01 3114/01/01 I would want want the query to return only Record number 2 (Given that 1/01/01 is between date 3 4 and 14/01/01 is between date 1 2) Does anyone know how to do this? mySQL, SQL - 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: InnoDB foreign keys crash MySQL
Harald, I tested now with the official Linux binary of 4.0.1 (not -max) and it worked ok on our dual Xeon Linux-2.4.16-SMP-64GB. I did not define any InnoDB startup options in my.cnf. When you recreated the InnoDB data files, did you remember to remove the .frm files of the InnoDB tables t1, t2, t3 in the database directory 'test'? What is your my.cnf like? Regards, Heikki heikki@donna:~/mysql-4.0.1-alpha-pc-linux-gnu-i686/bin mysqld InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file ./ibdata1 size to 64 MB InnoDB: Database physically writes the file full: wait... InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020208 16:31:36 InnoDB: Started 020208 16:31:36 mysqld: Table 'mysql.func' doesn't exist 020208 16:31:36 Can't open mysql/func table mysqld: ready for connections heikki@donna:~/mysql-4.0.1-alpha-pc-linux-gnu-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.1-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql mysql mysql CREATE TABLE t1 (id INT UNSIGNED NOT NULL AUTO_INCREMENT, - PRIMARY KEY (id) ) TYPE=InnoDB; Query OK, 0 rows affected (0.00 sec) mysql mysql CREATE TABLE t2 ( - id INT UNSIGNED NOT NULL AUTO_INCREMENT,t1id INT UNSIGNED NOT NUL L, - PRIMARY KEY (id),KEY (t1id),FOREIGN KEY (t1id) REFERENCES t1( id) - ) TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) mysql mysql mysql CREATE TABLE t3 (id INT UNSIGNED NOT NULL AUTO_INCREMENT, - t2id INT UNSIGNED NOT NULL,PRIMARY KEY (id),KEY (t2id), - FOREIGN KEY (t2id) REFERENCES t2(id) ) TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) mysql .. === 020208 16:38:29 INNODB TABLE MONITOR OUTPUT === -- TABLE: name SYS_FOREIGN, id 0 11, columns 8, indexes 3, appr.rows 2 COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; FOR_NAME: DATA_VARCHAR DA TA_ENGLISH len 0 prec 0; REF_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; N_COL S: DATA_INT len 4 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_I D: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL_PTR len 7 prec 0; INDEX: name ID_IND, table name SYS_FOREIGN, id 0 11, fields 1/6, type 3 root page 46, appr.key vals 2, leaf pages 1, size pages 1 FIELDS: ID DB_TRX_ID DB_ROLL_PTR FOR_NAME REF_NAME N_COLS INDEX: name FOR_IND, table name SYS_FOREIGN, id 0 12, fields 1/2, type 0 root page 47, appr.key vals 2, leaf pages 1, size pages 1 FIELDS: FOR_NAME ID INDEX: name REF_IND, table name SYS_FOREIGN, id 0 13, fields 1/2, type 0 root page 48, appr.key vals 2, leaf pages 1, size pages 1 FIELDS: REF_NAME ID -- TABLE: name SYS_FOREIGN_COLS, id 0 12, columns 8, indexes 1, appr.rows 2 COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; POS: DATA_INT len 4 prec 0; FOR_COL_NAME: DATA_VARCHAR DATA_ENGLISH len 0 prec 0; REF_COL_NAME: DATA_VARC HAR DATA_ENGLISH len 0 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_ TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL_PTR l en 7 prec 0; INDEX: name ID_IND, table name SYS_FOREIGN_COLS, id 0 14, fields 2/6, type 3 root page 49, appr.key vals 2, leaf pages 1, size pages 1 FIELDS: ID POS DB_TRX_ID DB_ROLL_PTR FOR_COL_NAME REF_COL_NAME -- TABLE: name test/innodb_table_monitor, id 0 18, columns 5, indexes 1, appr.rows 0 COLUMNS: a: DATA_INT len 4 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROLL _PTR len 7 prec 0; INDEX: name GEN_CLUST_INDEX, table name test/innodb_table_monitor, id 0 20, fi elds 0/4, type 1 root page 55, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: DB_ROW_ID DB_TRX_ID DB_ROLL_PTR a -- TABLE: name test/t1, id 0 13, columns 5, indexes 1, appr.rows 0 COLUMNS: id: DATA_INT len 4 prec 0; DB_ROW_ID: DATA_SYS DATA_ROW_ID len 6 prec 0; DB_TRX_ID: DATA_SYS DATA_TRX_ID len 6 prec 0; DB_ROLL_PTR: DATA_SYS DATA_ROL L_PTR len 7 prec 0; INDEX: name PRIMARY, table name test/t1, id 0 15, fields 1/3, type 3 root page 50, appr.key vals 0, leaf pages 1, size pages 1 FIELDS: id DB_TRX_ID DB_ROLL_PTR FOREIGN KEY CONSTRAINT 0_15: test/t2 ( t1id ) REFERENCES
give me a sample to print out to printer
when i click the icon client1(in end client, it's show up from php application) that the icon has link to mysql and the result directly print the out put to printer (share or local printer) by coulomb. there's anyone knows about this, please help me. Rgds, Franky Aniversarius - 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: Hello! Date question....
Jim,=20 What you're asking about is the timestamp data type. =20 Look at : http://www.mysql.com/doc/D/A/DATETIME.html In a nutshell, if you assign 'null' to a timestamp column it will put in value of 'NOW()'. Eric Mayers Software Engineer -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:50 AM To: [EMAIL PROTECTED] Subject: Hello! Date question =20 Hi all... =20 This is my first post to the list. I've been working on MySQL=20 now for about a=20 week and really like it. I have a question that I can't find=20 in any of the=20 books or how-tos. =20 When I add a line to my customer's table I need it to put=20 today's date in the=20 indate column. Is there anyway to do this like the auto for numbers? - 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
How to setup MySql on my Solaris 8?
I got mysql-3.23.47-sun-solaris2.8-sparc.tar from mysql.com, then I untarred it into /mysql. Then I enter /mysql and did ls: # ls binincludescriptssql-bench tests data libshare support-files # What should I do to set it up now? I entered /mysql/bin and tried running mysql, but get such an error message: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # I don't get it. Jack __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - 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 won't start...
I have 2 SuSE Linux 7.2 machines at home... These boxes have completely different hardware in each... But the O/S on each, contains virtually all of the same applications... On the first machine, MySQL started right up, and has been working correctly ever since... On the second machine, MySQL will NOT start... It tries to start, but keeps aborting... Here are the only messages that I can seem to find: 020126 18:01:29 mysqld started 020126 18:01:29 /usr/sbin/mysqld: Table 'mysql.host' doesn't exist 020126 18:01:29 mysqld ended 020126 18:04:56 mysqld started 020126 18:04:57 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020126 18:04:57 mysqld ended 020126 18:07:31 mysqld started 020126 18:07:31 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) Each time I try to restart, I get the above messages... If anyone can point me to some specific log files, that would help to debug this problem further, I would much appreciate it... my.cnf is locate in /etc, as it's supposed to be... host.frm exists, but it exists in the following location: (I'm thinking that something in /usr/sbin/mysqld isn't pointing to the file...) /var/lib/mysql/mysql/host.frm Is there a configuration file someplace, that I can modify to point to this host.frm file? If so, what is the correct command, including syntax? TIA Joe 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 - 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
Default install directory
I have a crashed computer and need the mysql databases recovered. What is the default installation directory and default database directory for mysql on Mandrake 7.2? Jonas Fornander - System Administrator Netwood Communications, LLC - www.netwood.net Find out why we're better - 310-442-1530 - 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: Default install directory
Depends on the install. The rpm from mysql will install to /var/lib/mysql The worst of it, most linux default installs, /var is the smallest Unknowing to myself, I had a database running away, default installs the both of them (well default then some modifications ) about 2 months later, CRASH!!! Wasted the whole system (as far as I am concerned) , mysql wasnt nice enough to stop writing when /var was full lucky for me the database was the only thing important on that server, and a backup was just done that morning (successfully to boot) -Original Message- From: Jonas Fornander [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:42 PM To: [EMAIL PROTECTED] Subject: Default install directory I have a crashed computer and need the mysql databases recovered. What is the default installation directory and default database directory for mysql on Mandrake 7.2? Jonas Fornander - System Administrator Netwood Communications, LLC - www.netwood.net Find out why we're better - 310-442-1530 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with select
MySQL manual A.5.7 Problems with floating point comparison =dn - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 08 February 2002 15:24 Subject: Re: Problems with select 15.8 has no exact binary representation, so a test for equality will fail. Do not use floating point if you want to test for equality. Try DECIMAL Miguel Figueiredo wrote: Hello all, I have a (probably dumb) question. My table temperatura has two fields described bellow. mysql describe temperatura; +-+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | datetime | datetime | YES | | NULL| | | temperatura | float| YES | | NULL| | +-+--+--+-+-+---+ 2 rows in set (0.00 sec) When I try to select rows with floats, the result is an empty set. For example: mysql select datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00; +-+-+ | datetime| temperatura | +-+-+ | 2002-02-08 09:30:00 |15.8 | +-+-+ 1 row in set (0.00 sec) got one row :) mysqlselect datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura=15.8; Empty set (0.00 sec) -- same thing but with the temperatura value, gives me an empy set :( When I try to select another row but the temperatura field has an integer this is what happens: mysql select datetime,temperatura from temperatura where datetime=2002-01-25 09:40:00; +-+-+ | datetime| temperatura | +-+-+ | 2002-01-25 09:40:00 | 16 | +-+-+ 1 row in set (0.00 sec) --- got one row :) mysql select datetime,temperatura from temperatura where datetime=2002-01-25 09:40:00 and temperatura=16; +-+-+ | datetime| temperatura | +-+-+ | 2002-01-25 09:40:00 | 16 | +-+-+ 1 row in set (0.00 sec) -- It works now :/ Does anyone have an idea why this happens? How can I select float numbers? Best wishes, Miguel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fatal: libncurses.so.5
// michael.s, Wednesday, February 06, 2002, 12:22:15 PM, you wrote: Hi, I just installed mysql in my Solaris (Sparc) box, but when I run mysql ( mysqld running ), I get the following err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed Any help will be appreciated! Victoria Reznichenko [[EMAIL PROTECTED]] Please, tell us more about the problem appeared. How did you install MySQL? Did you install a downloaded from the mysql site binary distributive or you have compiled the server on your own? Thanks, Victoria Reznichenko. Yes, I just installed a downloaded MySQL from ftp://ftp.sunfreeware.com/pub/freeware/sparc/2.5/mysql-3.23.45-sol25-sparc-l ocal.gz, and the server was running after I added package libgcc-3.0.3-sol26-sparc-local.gz - 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
Checking the Table Size
Hi guys, I am not able to insert into the MySQL database anymore. I think it has reached the table size. How do i check the size to see if it has reached the table size? Also let me know how to increase the table size in case it is reached the limit. Thanks, Satish = The only person in the world who is enviable is one who does not envy others __ Satish Santhakumar Graduate Student IIT, Chicago and Computer Programmer University of Chicago. __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - 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
Question from Meruzhan Grigoryan
Dear Sir, I have one question apropos of Mysql database version 3.23. What greatest quantity of tables may store Mysql a database. Thank You in advance. Sincerely Meruzhan Grigoryan - 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 connection to mysql
Hi, I am facing problem conneting to mysql from client machine. I have MySQL server running on dummy2 machine and programs running on other client machine. when I check netstat -a , I get following tcp sockets in TIME_WAIT and ther are few in ESTABLISHED Any one has idea about , why the socket connection remains in TIME_WAIT. and how to solve this problem. Regards, Bharat Below is sample of netstat -a Actual connetions : 12425 TIME_WAIT 93 ESTABLISHED tcp0 0 dummy2.ezee:mysql dummy77.ezee:3262 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3261 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3260 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3259 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3258 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3257 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3256 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3255 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3254 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2302 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2298 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2296 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2295 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2290 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy50.ezee:4741 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2283 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2281 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2277 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2274 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2271 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2270 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy50.ezee:4735 TIME_WAIT - 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 4.1
Dear friends, I wish to know when would MySQL 4.1 be released with all the TODO features developed. In case you know, please reply. Regards, Nitz __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
Re: Tweaking MySQL my.cnf
On Thu, Feb 07, 2002 at 09:59:52PM -0500, James Riordon wrote: Hi Again, I have honed this question pretty well I think (MySQL 3.23.37): I am using large-my.cnf as my my.cnf file. It is for servers with 512 MB of RAM from what I read. On our server that has 512MB of RAM I notice in top the following: 10244 mysql 16 0 147M 147M 1684 S 0 16.7 29.2 0:08 mysqld 10260 mysql 14 0 148M 148M 1684 R 0 8.0 29.4 0:10 mysqld All instances of mysqld are using between 146-154MB of RAM each. This seems awefully large to me. Nah, that's just the key_buffer doing its job. ;-) Is this correct or should I be reducing the amount of RAM each child gets. Something tells me you're running Linux. Those are actually all threads of the same process. So there's nothing to worry about. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 4 days, processed 165,402,717 queries (413/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Old Messages
Greetings: Anyone else getting lists messages from several days, or longer ago? Phrrrp!: sql database table mysql Van -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: release_lock
On Mon, Feb 11, 2002 at 04:37:39AM -0800, Konstantin Yotov wrote: Hello there! I'm using Apache-Session module and it seems that everything work properly, but in bin log is this query: DO RELEASE_LOCK(Apache-Session-0c47492fccde576b180ea37fa07de395); What could be wrong in it? I'm missing something? What's the problem? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 4 days, processed 165,435,386 queries (412/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql_fetch_array
you're right the user that i was using to connect to bd was wrong, i changed it and it works perfect. thanx for your help.. you're a Master. - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: [AFQ]T1T4N [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 1:28 AM Subject: Re: mysql_fetch_array On Mon, 11 Feb 2002, [AFQ]T1T4N wrote: dear friends.. i'm doing a simple script that use mysql_fetch_array() and it give me the following error. Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 10 Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 16 here is the code, there is no problem with the connection to BD, i probe it and it works.. but this problem don't let print nothing in a web page.. i'll appreciate your help... You say there is no problem connecting to the db, but the code you've supplied doesn't check. Since $result is not a valid MySQL result resource, it appears that the call to mysql_query failed somehow, probably because mysql_connect or mysql_select_db failed. I'd suggest adding code to check: html body ? include(config.inc); $db = mysql_connect($servidor, $usuariodb, $password) or die(Couldn't connect . mysql_error()); mysql_select_db($base,$db) or die(Couldn't select $db: .mysql_error()); ? ? $result = mysql_query(select nombres,email from usuarios) or die (Couldn't query: . mysql_error()); while ($row = mysql_fetch_array($result)) { echo user_id: .$row[nombres].br\n; echo user_id: .$row[0].br\n; echo email: .$row[email].br\n; echo fullname: .$row[1].br\n; } mysql_free_result($result); ? /body /html Chances are you'll find the problem. Unless this turns out to be a MySQL problem, which I doubt, you'll probably have better luck on the PHP lists. See http://www.php.net/mailing-lists.php Good luck. Michael - 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
Need Help pls.......
Hi my names is Francis Pena im trying to compile Mysql-3.23.48, when i run ./configure is is the result [jigax@RHL mysql-3.23.48]$ ./conf loading cache ./config.cache checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking build system type... i686-pc-linux-gnu checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) gawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes checking for BSD-compatible nm... (cached) /usr/bin/nm -B checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/bin/ld) is GNU ld... yes checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking command to parse /usr/bin/nm -B output... ok checking how to hardcode library paths into programs... immediate checking for /usr/bin/ld option to reload object files... -r checking dynamic linker characteristics... Linux ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking for bison... bison -y checking for pdftex... manual.pdf checking return type of sprintf... configure: error: can not run test program while cross compiling - 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_fetch_array
On Tuesday, 12. February 2002 03:22, [AFQ]T1T4N wrote: G'Morning! Put an echo mysql_error(); behind your mysql_query statement and check error ouput. html body ? include(config.inc); $db = mysql_connect($servidor, $usuariodb, $password); mysql_select_db($base,$db); ? ? $result = mysql_query(select nombres,email from usuarios); + echo mysql_error(); while ($row = mysql_fetch_array($result)) { echo user_id: .$row[nombres].br\n; echo user_id: .$row[0].br\n; echo email: .$row[email].br\n; echo fullname: .$row[1].br\n; } mysql_free_result($result); ? /body /html George - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another question - Re: Quick SQL design help
Hi Amer Thanks for replying - I wonder if you could clear up a point for me. I'm going to have many, many possible multi values - too many for a SET or ENUM column as some other people have suggested. I'm happy using the following tables: parts (partid int, partname varchar(255)) cats(catid int, catname varchar(255)) parts_cats (id int, partid int, catid int) To track which categories are assigned to which parts. I can use the following query to return parts and associated categories: SELECT partid,catid,partname,catname FROM parts_cats LEFT JOIN parts ON parts_cats.partid=parts.partid LEFT JOIN cats ON parts_cats.catid=cats.catid However, as I won't know how many categories are assigned to a given part, how can I: a) Form a query that only returns a list of parts that match a specifc set of categories (e.g. 1=CatA' AND 5='CatE' AND 26='CatZ' only) b) Know how many unique records I'm dealing with. Using the SQL above, if a part has, say, 3 categories then 3 rows would be returned. 4 categories and 4 rows are returned, etc. - how can I tell how big my result set is so that I can page through it using LIMIT? Thanks again- james At 22:43 10/02/2002 -0500, Amer Neely wrote: Hello MySQL users I was wondering if one of you could advise me on the best solution to a problem I'm having - I'm sure this has been done before but haven't found anything in the archives. Basically the problem I am having is how best to handle multiple values for a specific column, in this case the values in question are coming from an HTML SELECT MULTI box processed by PHP. The way I have been doing this so far is to have a delimited value stored in a varchar column, e.g. If my select box returns the values 2,4 and 7 I insert into my table the string '|2|4|7|'. Surely there must be a better way than this - but it escapes me. In this setup the only way to match a specifc value when searching is to use the query: SELECT dataid,title FROM table WHERE category LIKE '%|4|%' Which obviously has a huge performance penalty - and of course you can't JOIN against any of these values. The only other way I thought of was to use a separate table for the category entries: SELECT dataid,title,category FROM table LEFT JOIN table_categories ON table.dataid=table_categories.dataid But in the example above this would return 3 entries, which I don't want, and I can't select a particular dataid which satisfies more than category, e.g. has categories 4 and 7 (i.e. for the example above the LIKE statement would be: WHERE category LIKE '%|4|%' AND LIKE '%|7|%'). One thing you could do is add a little programming to split the entry into its parts, once retrieved, then run your select on those. But a better solution would be to re-design your table/s to accomodate multiple values. -- Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for shopping carts, data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php James Carrier Bullet Online :: Aim Higher [http://www.bulletonline.com] 41b Beavor Lane, London W6 9BL Tel +44 (0) 20 8834 3442 Fax +44 (0) 20 8741 2790 - 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: LIKE work around??
At 12:50 -0800 2/7/02, Cindy wrote: Rutledge, Aaron writes: MySQL doesn't support LIKE does it? I got an error when I tried. I use it all the time. Maybe post the error message you got. RLIKE on the other hand...sigh. sigh, what? RLIKE works. It's the same as REGEXP. --Cindy - 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
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 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 - 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 .so missing - help!
Hi I am new to MySQL and PHP, so - please be gentle.. We are running PHP4.0.1 and mysql 9.38 (Distrib 3.22.32) on our development server (Debian Linux). I am trying to setup a database with mysql and PHP. I tried to install phpMyAdmin 2.2.3 and can't access the index page. I get an error about the mysql extension: cannot load MySQL extension, please check PHP Configuration MySQL is there, I can get to it and create databases etc but it won't talk to php. In php.ini, there is no reference to MySQL.so under Dynamic Extensions. Further, I can't locate the file MySQL.so or mysql.so *anywhere* on the server. I used the locate command to try find it. I didn't set up apache, php and mysql and am a little nervous about making changes - any suggestions? Thanks Alka [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
Configure-options for compiled MySQL?
Hi, I've a compiled MySQL and I need to know if it support unixODBC (Is configured with --with-unixODBC=...). Is there anyway I can see which configure options that was used to produce the binary? -- * John Ericson [EMAIL PROTECTED] * ICQ: 7325429 JID: [EMAIL PROTECTED] * web: http://john.pp.se - 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: Distributed Fulltext?
For the slice servers, you simply assume that if one is lost, you lose X% of the data until it is revived, which is usually not even noticable by the end user. For the aggregators, we had four behind a load-balancer. In practice, we had nearly zero downtime over a roughly 18 month period. james montebello On 7 Feb 2002, Amir Aliabadi wrote: How do you make something like this fault tolerant? The answer is probably what I suspect, 2 of every thing. How does the aggregator handle this or are these machines in a cluster? We are thinking of how to rebuild our fulltext search. Currently it is in MS SQL 7.0 - MySQL 4.0 seems to blow the doors off the cataloging time as compaired to MS SQL 7.0 Or even 8.0. On Thu, 2002-02-07 at 15:19, James Montebello wrote: I did this at a previous job, and we split the data up more or less this way (we used a pre-existing item number for the split which was essentially random in relation to the text data), with a aggregator that did the query X ways, each to a separate box holding 1/X of the data. The results from each unit were paged and sorted, so all the aggregator did was do a simple merge sort on a page of the set, which was fast. On a 6M record dataset, it produced millisecond-range search results. Not exactly Google-class, but pretty good for 12 Linux boxes, two programmers, and about six weeks of effort. james montebello On Thu, 7 Feb 2002, Brian Bray wrote: It seems to me like the best solution that could be implemented as-is would be to keep a random int column in your table (with a range of say 1-100) and then have fulltext server 1 psudo-replicate records with a the random number in the range of 1-10, server 2 11-20 and server 3 21-30 and so on. Then run your query on all 10 servers and merge the result sets and possibly re-sort them if you use the score column. The problem with splitting the index up by word is that is messes up all your scoring and ranking. For example what if you search using 5 keywords, all starting with letters from different groups? Your going to get pretty bad score for each match, and it could totally break boolean searches. -- Brian Bray Brian DeFeyter wrote: On Thu, 2002-02-07 at 15:40, Tod Harter wrote: [snip] Wouldn't be too tough to write a little query routing system if you are using perl. Use DBD::Proxy on the web server side, and just hack the perl proxy server so it routes the query to several places and returns a single result set. Ordering could be achieved as well. I'm sure there are commercial packages out there as well. I don't see why the individual database servers would need to do anything special. [snip] If I'm understanding you correctly, I think you're refering to routing based on the first character of the word. That would work for cases where the query is searching for a word that begins with a certain character.. however fulltext searches also return results with the term in the middle. ie: a search for 'foo' could return: foo.txt foobar but also could return: thisisfoo that_is_foolish I could be wrong, but it's my understanding that MySQL stores it's fulltext index based on all the 'unique words' found. For such a system as you mentioned above, you'd probably have to create your own fulltext indexing system to determine: a) where to store the data 'segments' and b) how to route queries. It seems like this could probably be done much more efficiently inside of the server. - Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compression
Sommai, Wednesday, February 06, 2002, 8:01:13 AM, you wrote: SF Hi, SF I need to know that MySQL has any compression method when it store SF data? If the answer is Yes, How the different compression between MySQL SF and other tools (zip, gzip)? I asked this question because I need to store SF some text file for future used (at least 1 Mbyte per day). I was used SF Winzip in Windows to compress and keep in file server. If MySQL could SF compress some byte of data I think it better than flat file. myisampack is used to compress MyISAM tables, after packing tables become read-only. See at : http://www.mysql.com/doc/m/y/myisampack.html You can also read about packed compressed table at: http://www.mysql.com/doc/C/o/Compressed_format.html SF Sommai -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 possible 1 query with 2 selects?
Hello to all, I'm trying to make a query with only one command but I can't see how to do it. Supose that are 2 tables like: table QA table QB ref text ref text --- --- a1 texta1 b1 textb1 a2 texta2 b2 textb2 a3 texta3 b3 textb3 and there is a table that indicates the relation between QB and QA data: table relAB A B -- -- a1 b2 a1 b3 a1 b4 a2 b1 a2 b2 This example says that b2,b3,b4 are related to a1 and b1,b2 are related to a2. What I want to do is get a list from table QB related to an item from table QA: For example, get a list from QB related to item 'a1': 1. select B from relAB where A='a1'; (result: b2, b3, b4) 2. select * from QB where ref in ('b2','b3','b4'); (result: only 'a1' related items) There is a way of make this query with only one command? Something like: 1. select * from QB where ref in (select B from relAB where A='a1'); Please help me in this matter. Thanks very much, -- Nuno Teixeira pt-quorum.com /* PGP Public Key: http://www.pt-quorum.com/pgp/nunoteixeira.asc Key fingerprint: 8C2C B364 D4DC 0C92 56F5 CE6F 8F07 720A 63A0 4FC7 */ - 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 won't start...
Mysql must own its files and directories. chown -R mysql /var/lib/mysql assumong /var/lib/mysql is the data directory. FISHER,JOE (Non-HP-Roseville,ex1) wrote: I have 2 SuSE Linux 7.2 machines at home... These boxes have completely different hardware in each... But the O/S on each, contains virtually all of the same applications... On the first machine, MySQL started right up, and has been working correctly ever since... On the second machine, MySQL will NOT start... It tries to start, but keeps aborting... Here are the only messages that I can seem to find: 020126 18:01:29 mysqld started 020126 18:01:29 /usr/sbin/mysqld: Table 'mysql.host' doesn't exist 020126 18:01:29 mysqld ended 020126 18:04:56 mysqld started 020126 18:04:57 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020126 18:04:57 mysqld ended 020126 18:07:31 mysqld started 020126 18:07:31 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) Each time I try to restart, I get the above messages... If anyone can point me to some specific log files, that would help to debug this problem further, I would much appreciate it... my.cnf is locate in /etc, as it's supposed to be... host.frm exists, but it exists in the following location: (I'm thinking that something in /usr/sbin/mysqld isn't pointing to the file...) /var/lib/mysql/mysql/host.frm Is there a configuration file someplace, that I can modify to point to this host.frm file? If so, what is the correct command, including syntax? TIA Joe 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 - 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: Checking the Table Size
Satish: You can see how much space is used (among other things) with a query like: show table status from database like 'Syslog'; Increasing the maximum table size is a little more complicated and depends on what OS and table type you're using. Eric -Original Message- From: Satish Santhakumar [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 2:21 PM To: [EMAIL PROTECTED] Subject: Checking the Table Size =20 =20 Hi guys, =20 I am not able to insert into the MySQL database anymore. I think it has reached the table size. How do i check the size to see if it has reached the table size? Also let me know how to increase the table size in case it is reached the limit. Thanks, Satish =20 =3D=3D=3D=3D=3D The only person in the world who is enviable is one who does=20 not envy others __ Satish Santhakumar Graduate Student IIT, Chicago and Computer Programmer University of Chicago. =20 __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) =20 To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail=20 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php =20 =20 - 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: I must ask. also ...
Ferreira, [I have posted this back to the list. There are many others who will be able to help - some from Portugal. Also I have noticed questions and comments from many people working on collections/libraries of CDs, videos, books, etc] Thack for all that knowleg... ( wisdonw ) pardon my englihs =please do not feel it necessary to apologise - your ability to write in English is much better than mine in Portugese! in this case, and before the big databank, i am tring to build a DB to organise my cds. I have 6 tables. Table Principal has: a id and for exmple tipo ( type). Table Tipo (Type ) has: a idT and Descrição ( description). my question: in table Principal e call the column tipo has idT and i have a relation? or i just call it Tipo and manualy work on it so it can get the values i have on the other table ? ( I am a self-teacher all i know i read it somewere sorry if the questions are dull ) =it's trying to keep the answers from sounding dull, that is challenging! =yes I think you have the correct answer. When you define the two tables (using a CREATE statement) there is no need to specify/hard-code, some linkage between them. When you populate the tables with data, the data-values will make apparent/show the linkages (field(s) to field(s) and thus row(s) to row(s)) =the two tables Principal and Tipo are logically related - logic demands that there be no entry in Principal.tipo that does not have a corresponding entry in the Tipo table. (this is called data integrity). So we can write a SELECT (or other) command to only work with data within this correspondence/relationship, eg ... WHERE Principal.tipo = Tipo.idT =from there (for two examples), we can ask to see only CDs of a certain type, or we can ask for a list of all the CDs purchased during 1999 (assuming relevant data columns are available) organised into groups by type/tipo - simply by adding more conditions/constraints into the WHERE clause (etc). =thus it is not when you CREATE the tables that the linkage is specified, but each query that you run against the tables can/must specify the linkage (and therefore you can relate different tables at different times, even in different ways at different times). Relationships are/can be 'dynamic', rather than constant/'fixed' at table creation time. =if you want to demand a data integrity feature, whilst it is not available in native-MySQL, it is available in one of the add-on components. Thancks in advance. =my pleasure - and don't hesitate to request clarification if my choice of English words is not readily understandable. =dn I am playing hard with mysql, cause my ultimate objective is to make a big databank for a game. I notice that i cant find a way to make relations beteen tables. Must i do it also with PHP ? Just to confuse you, the mathematical jargon for table is relation... May I suggest that you search the web for some tutorials on the use of SQL in general/MySQL in particular - it will help your playing, and ultimately your game. There are some RDBMS-es that implement SQL to the point of apparently setting up a construct that links tables - foreign key based data integrity being the first example that springs to (my) mind. However relational logic suggests that the way to set up a linkage between tables is to show this in dynamic logic - your SQL statement, eg SELECT * FROM tbl1, tbl2 WHERE tbl1.PrimaryKey = tbl2.ForeignKey; will produce a result-row for every intersection 'match' between the two tables. One of the MAJOR advances of relational databases over their predecessors was this move 'away' from structural 'connections'. However these have been maintained as 'features' by some, usually to promote speed/efficiency. Perhaps this is a major interest for you/gaming - but in which case, you will find that indexed-file systems will likely be a better/faster/smaller option. (?) An original objective, and one well worth bearing in mind today, is that relational technology allows one to establish a 'relationship' between items of data today, that was not anticipated/designed into the system when it was first built n-years ago. Flexibility! Regards, =dn - 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: Configure-options for compiled MySQL?
On Feb 08 23:40, John Ericson wrote: Hi, I've a compiled MySQL and I need to know if it support unixODBC (Is configured with --with-unixODBC=...). Is there anyway I can see which configure options that was used to produce the binary? -- * John Ericson [EMAIL PROTECTED] * ICQ: 7325429 JID: [EMAIL PROTECTED] * web: http://john.pp.se (Please CC me since Im not a member of the maillinglist) -- * John Ericson [EMAIL PROTECTED] * ICQ: 7325429 JID: [EMAIL PROTECTED] * web: http://john.pp.se - 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
How to duplicate a table complete with indexes? #
At 10:34 AM 2/8/2002 , you wrote: Quite often I'd like to duplicate an existing table using SQL. Normally I'd do a create table NewTable select * from OldTable; and if I don't want any data transferred I'll slap on a Limit 0 on the end of the statement. This works fine except it doesn't create any indexes that OldTable had. Is there a generic way to duplicate a table that includes the indexes? I don't want to have to manually create indexes for it. TIA Brent - 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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: Yes, SIZEOF_INT is 4: $ grep SIZEOF_INT config.h #define SIZEOF_INT 4 $ grep SIZEOF_INT include/my_config.h #define SIZEOF_INT 4 However, according to http://docs.sun.com/ab2/coll.45.13/SOL64TRANS/%40Ab2PageView/1865;td=5?Ab2Lang=CAb2Enc=iso-8859-1, in the LP64 (64-bit) environment, int is 32-bits and long is 64-bits so it would appear SIZEOF_INT == 4 is correct above. -- albert chin ([EMAIL PROTECTED]) It is correct. It is a smnall problem in our code. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: How to duplicate a table complete with indexes? #
At 13:22 -0600 2/8/02, BD wrote: At 10:34 AM 2/8/2002 , you wrote: Quite often I'd like to duplicate an existing table using SQL. Normally I'd do a create table NewTable select * from OldTable; and if I don't want any data transferred I'll slap on a Limit 0 on the end of the statement. This works fine except it doesn't create any indexes that OldTable had. Is there a generic way to duplicate a table that includes the indexes? I don't want to have to manually create indexes for it. Not using just SQL, no. In a program, you can get the output from a SHOW CREATE TABLE statement, perform a substitution to change the table name, then execute the statement. That will create a copy (empty) that includes the indexes. TIA Brent - 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: Memory limit issue with 64 bit mysql.3.23.46
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote: Albert Chin writes: MySQL 3.23.46 was built with the Sun C++ compiler: $ CC -V CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 It was built as follows: CC=cc CFLAGS=-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9 \ CXX=CC CXXFLAGS=-xO2 -xtarget=generic -xarch=v9 \ CPPFLAGS=-I/opt/TWWfsw/readline42a/include \ -I/opt/TWWfsw/zlib11/include -I/opt/TWWfsw/ncurses5/include \ -I/opt/TWWfsw/ncurses5/include/ncurses \ LDFLAGS=-L/opt/TWWfsw/readline42a/lib/sparcv9 \ -L/opt/TWWfsw/zlib11/lib/sparcv9 -L/opt/TWWfsw/ncurses5/lib/sparcv9 \ -L/opt/TWWfsw/readline42a/lib/sparcv9 \ -R/opt/TWWfsw/readline42a/lib/sparcv9:\ /opt/TWWfsw/zlib11/lib/sparcv9:/opt/TWWfsw/ncurses5/lib/sparcv9 \ -xarch=v9 ./configure --localstatedir=/var/opt/TWWfsw/mysql32346 \ --sysconfdir=/etc/opt/TWWfsw/mysql32346 --enable-shared \ --enable-static --without-debug --with-innodb --without-bench \ --without-readline --enable-strcoll --with-libwrap \ --with-berkeley-db --enable-thread-safe-client \ --prefix=/opt/TWWfsw/mysql32346 -- albert chin ([EMAIL PROTECTED]) Please tell me a value for this #define in config.h and my_config.h : SIZEOF_LONG $ grep SIZEOF_LONG config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 $ grep SIZEOF_LONG incldue/my_config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 -- albert chin ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL RE: insertion problem !!
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:22 PM To: Chetan Lavti Subject: Re: insertion problem !!=20 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: hi, I have two tables as:=3D20 please concentrate on domain_id and INDEX=3D20 Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3D3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3D3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I have made sure that the value I am inserting for the 'domain_id' exists in the ls_domain table.) please tell me what could be the problem... INSERT INTO ls_user(ls_user,domain_id,user_name,user_flag,user_passwd,user_addr,user _email,created_by, created_date) VALUES(1,1,'Chetan Lavti','y','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for the same... Thanks and regards, Chetan Lavti - 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: Cannot connect to MySQL server with a java application
Almost, but not exactly the same . DriverManager.getConnection(dburl, dbuser, dbpasswd) -- note, 3 arguments here -Original Message- From: debian [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: Cannot connect to MySQL server with a java application hello, i tried to connect my MySQL-Server with a short java application. The application can't connect to the server, obviously the server is running on localhost:3306. I append the SourceCode (roughly the same: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolp ak ) and the error-message. SourceCode: import java.sql.*; class SQLtest2 { public static void main(String[] args) { try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); System.out.println(register the Driver: OK); } catch (Exception e){} try { Connection conn = DriverManager.getConnection(jdbc:mysql://127.0.0.1:3306/test?user=testpa ss word=teschd); System.out.println(... ccnnected); Statement s = conn.createStatement(); s.close(); conn.close(); } catch(SQLException e) { System.out.println(SQLException: + e.getMessage()); System.out.println(SQLState: + e.getSQLState()); System.out.println(VendorError: + e.getErrorCode()); } } } Error-Msg: register the Driver: OK java.io.IOException: Connection timed out at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:56) (some EXCeptions more) SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.io.IOException) SQLState: 08S01 VendorError: 0 is there somebody who can help me? thnx bobby - 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: How to duplicate a table complete with indexes? #
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query This 'anti-spam' measure, is kinda lame, I must say. (Picture that said in an Ed Grimley voice. If you understand _that_, shame on you! :) If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Fri, Feb 08, 2002 at 01:22:08PM -0600, BD wrote: This works fine except it doesn't create any indexes that OldTable had. Is there a generic way to duplicate a table that includes the indexes? I don't want to have to manually create indexes for it. What's wrong with outright copying the files associated with the table? (Assuming the table's not in use). I would _assume_ that this would work; i havent' tested it, of course... TIA Brent -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Hello! Date question....
Hi Jim, Welcome to our relatively?relationally happy band. This is my first post to the list. I've been working on MySQL now for about a week and really like it. I have a question that I can't find in any of the books or how-tos. A whole week and no post... When I add a line to my customer's table I need it to put today's date in the indate column. Is there anyway to do this like the auto for numbers? You didn't mention which date format you are using. At this reference (6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types) you will find coverage of the automatic inserting/updating of TIMESTAMP values, and the equivalent for DATE/DATETIME values. Remember that the auto-input feature is a two-edged sword! Regards, =dn - 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
Regarding Disk Accesses Main Memory ussage.
Dear members, 1) How can we know the no. of disk accesses main memory used to execute a particular query in mysql ? 2) Is any one familier with mysql source code for windows. Plz help me in this as I desparately need this information at the earliest. Plz reply asap. Thanx in advance.. Pravin Sirupa - 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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be available? -- albert chin ([EMAIL PROTECTED]) Just look into Changelog's of the versions that come out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Configure-options for compiled MySQL?
John Ericson [EMAIL PROTECTED] writes: I've a compiled MySQL and I need to know if it support unixODBC (Is configured with --with-unixODBC=...). Is there anyway I can see which configure options that was used to produce the binary? Look for MyODBC - there is a link at the MySQL web page (it's also included in RHL 7.2) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 SQL question
Hello, I hope this isn't too far afield of the list discussions but here goes. I'm trying to fashion a query against a MySQL database. There are three tables that are relevant. They are: listing (ID, OfficeID, CatID, SubID, Visible, Deleted) category (ID, Name) subcategory (ID, CatID, Name) the ID fields are all AUTO_INCREMENT (1, 2, 3, ...). Basically what I want is: listing.ID, category.Name, subcategory.Name, listing.Visible I've been messing with it for over two hours and still have not gotten the thing right. The wrinkle is that listing.SubID may = 0, which has no matching row in table subcategory. In that case, I'm looking for a NULL in subcategory.Name. All I've managed to eek out of it is rows where SubID has a matching subcategory.ID. SELECT listing.ID, category.Name, subcategory.Name, listing.Visible FROM listing, category, subcategory WHERE Deleted=N AND OfficeID=1 AND subcategory.ID = listing.SubID AND category.ID = listing.CatID I have tried all manner of LEFT, RIGHT, INNER, OUTER, STRAIGHT and NATURAL joins. 1/2 of them spit out syntax errors or 100s of rows. I have not managed to get it to handle SubID = 0 which means None. I'd be most grateful if someone could weave me a path thru the JOIN syntax (which I really don't get and the manual is not exactly clear about) and suggest how I might convince MySQL to spit out what I want. Michael - 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: Error codes
On Tuesday, 12. February 2002 06:07, Chetan Lavti wrote: Hi! hi, I am using C api's for accessing the MySQL server, I want to make use of the mysql api's inside the functions I have made. I do not want to print the description of the error, instead, I want to display out the error code corresponding to that message. maybe you're looking for http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_errno ?! Regards Georg - 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 modifies other fields than intended
On Thu, 2002-02-07 at 18:29, Johan van Reijendam wrote: Hi all, I have run into the following issue and was wondering if anyone else has ever run into the same and if there is an answer to this behaviour. I have a record which contains the following fields: id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, create_time TIMESTAMP, modify_time TIMESTAMP, noteTEXT When I update this record and modify any of the fields other than the 'create_time' field then the 'create_time' field gets updated as well. None of my calls to the database however address the 'create_time' field. Is there some feature that I am overlooking which may be causing this ? Hi Johan! You are experiencing the intended behavior of that column type. Columns of the type timestamp are designed to automatically update when the rest of the column is updated. Please review http://www.mysql.com/doc/D/A/DATETIME.html -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ www.mysql.com 403.244.7213 - 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 needed with three tables and joins
Is there anyone who could help me with this simple query, I am not that familiar with multiple joins. best regards, Andreas From: Andreas Habereder [EMAIL PROTECTED] Date: Mon Feb 11, 2002 02:21:52 Uhr Europe/Berlin To: Manish Mehta [EMAIL PROTECTED] Subject: Re: SQL-Problem with three tables and joins Manish thanks for your prompt reply. I tried your correction but then I got this: your query ( I changed only the table names): SELECT at.name, av.value, at.unit, at.id, a.product_id FROM attribute_type at LEFT OUTER JOIN attribute a on (at.id = a.type_id) LEFT OUTER JOIN attribute_value av on (av.id = a.value_id) WHERE (a.product_id = 21 OR a.product_id IS Not NULL OR a.value_ID IS Not NULL OR a.type_ID IS Not NULL) and the result: | name | value | unit | id | product_id | | height | 10| cm | 1 | 21 | | width| 20| cm | 2 | 32 | | width| 30| cm | 2 | 40 | | diameter | 222 | cm | 3 | 21 | Number of Results: 4 I only want to have attributes for one product_id (e.g. 21). However, every attributetype available has to be in the result and any corresponding value or NULL. So my preferred result should look like that: | name | value | unit | id | product_id | | height | 10| cm | 1 | 21 | | width| NULL| cm | 2 | NULL | because width is for this product still empty but should be available to fill with a value | diameter | 222 | cm | 3 | 21 | Number of Results: 3 Any chance to achieve this? regards, Andreas On Montag, Februar 11, 2002, at 10:19 Uhr, Manish Mehta wrote: Hi, Try This SELECT at.name, av.value, at.unit, at.id, a.product_id FROM attribute_type at LEFT OUTER JOIN attribute a on (at.id = a.type_id) LEFT OUTER JOIN attribute_value av on (av.id = a.value_id) WHERE (a.product_id = 21 OR a.product_id IS Not NULL OR a.value_ID IS Not NULL OR a.type_ID IS Not NULL) Regards Manish - Original Message - From: Andreas Habereder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 10, 2002 4:04 PM Subject: SQL-Problem with three tables and joins Hi It would be great if anyone could help me with a problem in mySQL. I have 3 tables to describe attributes for a product database. e.g. attribute_type: ++--+--+ | id | name | unit | ++--+--+ | 1 | height | cm | | 2 | width| cm | | 3 | diameter | cm | ++--+--+ attribute_value: ++--+ | id | value| ++--+ | 1 | 10 | | 2 | 20 | | 3 | 30 | | 4 | 222 | ++--+ attribute: ++--+--++ | id | type_id | value_id | product_id | ++--+--++ | 1 | 1| 1| 21 | | 2 | 2| 2| 32 | | 3 | 2| 3| 40 | | 4 | 3| 4| 21 | ++--+--++ In a web form where I edit the product, there is also an attribute section where I would like to give certain attributes values specific for the product. The problem is when I associate values to attributes in one product, the same attribute in other products is hidden (not in the result of the query). Therefore I would like to list all attribute_types for each product regardless if there are values assigned or not. I used the following query and I think there must be something wrong: SELECT at.name, av.value, at.unit, at.id, a.product_id FROMattribute_type at LEFT OUTER JOIN attribute a on (at.id = a.type_id) LEFT OUTER JOIN attribute_value av on (av.id = a.value_id) WHERE (a.product_id = 21 OR a.product_id IS NULL OR a.value_ID IS NULL OR a.type_ID IS NULL) regards, Andreas - Andreas Habereder private: [EMAIL PROTECTED] mobile: +49 172 838 7771 - - 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 - Andreas Habereder Kirchenstr. 17e 81675 München private: [EMAIL PROTECTED] fax: +49 1212 5 107 37 317 mobile: +49 172 838 7771 - This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the
update to mysql 4.01 under mandrake
hi all, This question is a little like the suse update. But perhaps I could find answer. I have a mandrake distrib with rpm support, u know that mandrake is derive from redhat. Can I install a mysql 4.0.1 package on it ? thanks. a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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 - 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
Problems with SQLGetInfo and SQLColumnPrivileges
--Message-Boundary-21483 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Dear all, today I have switched from myodbc 2.50.39.00 to 3.51.01.00, because I had a problem using SQLColumnPrivileges (see below) After that I couldn't use my application because of the ConnectionHandle was destroyed. After logging the application I have found, that there is an problem inside of SQLGetInfo. I made a call: SQLHDBC hdbc=NULL; SQLUSMALLINTMaxStatementHdls; SQLSMALLINT len; SQLGetInfo (hdbc, SQL_ACTIVE_STATEMENTS, MaxStatementHdls, sizeof (MaxStatementHdls), len); after that, the hdbc lost his low part. The reason for that seems to be the variable MaxStatementHdls defined as SQLUSMALLINT (like the description of ODBC in MSDN). len says, that in MaxStatementHdls will be returned a value with a lenght of 4 (instead of 2). As work around I have changed the definition of MaxStatementHdls from SQLUSMALLINT to int. And this is my original problem - but here I can't find a reason: If I try to call SQLColumnPrivileges (hstmt, NULL, 0, NULL, 0, (SQLCHAR*)patdat, SQL_NTS, NULL, 0) ? I get a error message [Microsoft][ODBC Driver Manager] Driver does not support this function if I use myodbc V2.50. If I try to do the same with myodbc V3.51 I will get [mysqld-3.23.43]Driver doesn't support this yet. But the documentation says, this functions is included in both versions. Has anyone the same problems or is something wrong at my site ? - With best regards Peter Klinge --- Dipl.-Ing. Peter Klinge AMEDTEC Medizintechnik Aue GmbH, Schneeberger Str. 5, 08280 Aue Tel.: +049 3771 722133Fax: +049 3771 722106 Email: [EMAIL PROTECTED] --- --Message-Boundary-21483 Content-type: text/plain; charset=US-ASCII Content-disposition: inline Content-description: Attachment information. Der folgende Abschnitt dieser Nachricht enthält einen Dateianhang im Internet MIME Format. Wenn Sie Pegasus Mail oder ein anderes MIME-kompatibles Programm verwenden, sollten Sie den Anhang speichern oder ansehen können. Sollte das nicht funktionieren, fragen Sie Ihren Systembetreuer um Rat. The following section of this message contains a file attachment prepared for transmission using the Internet MIME message format. If you are using Pegasus Mail, or any another MIME-compliant system, you should be able to save it or view it from within your mailer. If you cannot, please ask your system administrator for assistance. Datei-Informationen / File information --- Datei/File: SQL.LOG Datum/Date: 6 Feb 2002, 14:18 Größe/Size: 930 bytes. Typ/Type: Binary --Message-Boundary-21483 Content-Type: text/plain; charset=iso-8859-1 - 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 --Message-Boundary-21483-- - 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
libncurses not found; have bad workaround
Description: When loading initial data from a text file, mysql looks for libncurses.so.4, doesn't find it and quits the command with an error. This happens under Red Hat Linux 7.2, because it has libncurses.so.5.x. How-To-Repeat: This must be done on a system without an accessible libncurses.so.5. Follow the tutorial in the manual to create a text file to load into the pet database. Then, execute the following command: load data local infile pet.txt into table pet; Fix: This desperate hack worked for me: cd /usr/lib ln -s libncurses.so libncurses.so.4 After this, the load data command worked fine, however, I do not know further ramifications of masquerading the 5.x libncurses as 4. Submitter-Id: [EMAIL PROTECTED] Originator:[EMAIL PROTECTED] Organization: R-Mode Corp. MySQL support: none Synopsis: libncurses not found on load data Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.47 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, 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.47 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 22 hours 44 min 26 sec Threads: 2 Questions: 30 Slow queries: 0 Opens: 8 Flush tables: 1 Open tables: 1 Queries per second avg: 0.000 Environment: Dual P3-450, RH7.2, unknown, unknown System: Linux titus 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 29 18:07 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 Sep 4 12:49 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 12:34 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 12:34 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - 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
Outgoing Data ?
I'm brand new to the list so forgive me if this has been covered (didn't see it in the archives). Have recently installed V 3.21 onto a Windows 2k Pro system with no web services running and Outpost Firewall v1.0.1220.2238 .. Last night I notices that MySQL-nt.exe was sending data out over port 3306 while WinMySqlAdmin was listening on 1029.. Since I had loopback enabled, that wasn't a big concern... However, during the 5ish hours that I watched, almost 5MB of data went out, with less than .5MB returning. Where is this data going to and why? Steve Whitacre Packetderm, LLC Information Security and Privacy www.packetderm.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
Foreign keys in InnoDB tables
According to the manual it should in fact be possible to enforce foreign = key constraint in MySql if both the referreing and referred tables are = of type InnoDB. But I haven't been able to, make the foreign keys work, = they did'nt blok any insertions. Are foreign keys still only for compability, or is there a way to = actually make the constraints work if the tables are InnoDB ? =20 I am running 4.0.1-alpha-max on win98 =20 =20 Regards =20 =20 Martin Bratbo - 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
Retrieving a numeric series from a SELECT
Hi, everybody How can I get a numeric column from a SQL SELECT statement? I mean, with a SELECT get something like this ColNum or ColNum 1 10 2 11 3 12 4 13 5 14 6 15 ... ... Some time ago, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266 - 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: Retrieving a numeric series from a SELECT
Hi, If you have a table with at least the number of rows that you want in your series you can do this. Set @Colnum := 0; Select @Colnum := @colnum+1 as colnum from tablename limit (number of rows required); set @column := 0; If you want a series starting from a value other than 1, initialize colnum value to one less than required starting value. Anvar. At 03:08 PM 08/02/2002 -0600, you wrote: Hi, everybody How can I get a numeric column from a SQL SELECT statement? I mean, with a SELECT get something like this ColNum or ColNum 1 10 2 11 3 12 4 13 5 14 6 15 ... ... Some time ago, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA - 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 Client/Server problem - AGAIN, sorry!!!
Marcelo, Wednesday, February 06, 2002, 12:42:26 PM, you wrote: MM Hi all, MM I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. MM How can I do this? I need some services running in the Server (in my case, SUN MM Solaris). What means the message: MM Host my_IP is not allowed to connect to this MySQL server ?? It means that you try to connect from other host than specified in table user in mysql db, see at: http://www.mysql.com/doc/A/c/Access_denied.html Check the following links too: http://www.mysql.com/doc/W/i/Windows_and_SSH.html http://www.mysql.com/doc/C/o/Connecting.html MM Thanks in advance, MM Marcelo Muzilli -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
MyODBC 3.51 released
Hi! MyODBC 3.51 driver was released a few days ago. Version 3.51 of the MyODBC driver is now released by MySQL AB and available for download. An ODBC (Open Database Connectivity) driver enables client programs to access a database or data source. The new version 3.51 MySQL ODBC driver is a greatly enhanced successor version to the existing MyODBC 2.50, rewritten to follow the ODBC 3.5x specifications. It provides complete and up-to-date ODBC functionality when accessing any MySQL database. Changelog and API reference for MyODBC 3.51.01: -- SQLAllocHandle -- SQLFreeHandle -- SQLSetEnvAttr, using this, the driver can be configured its functionality based on the ODBC version -- SQLGetEnvAttr -- SQLSetConnectAttr -- SQLGetConnectAttr -- SQLSetStmtAttr -- SQLGetStmtAttr -- SQLFetchScroll -- SQLBulkOperations with SQL_ADD (Bulk Inserts) -- SQLGetDiagRec -- SQLGetDiagField -- SQLCloseCursor -- SQLEndTran -- SQLGetInfo, re-written completly -- SQLGetFunctions, re-written completly -- Complete changes to error handling. Also driver returns the SQLSTATE values based on the ODBC version. -- Support of dynamic cursor type -- Enhanced cursor handling -- Changed SQLGetTypeInfo to return column headers as per 3.5 spec -- Changed all catalog APIs to return column headers as per 3.5 spec -- Support of dynamic cursor type -- New feature called 'Test Data Source' in the DSN setup dialog, so that the DSN settings can be tested while configuring. -- Added 'HELP' button to DSN setup dialog, which links to online MyODBC manual. -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the following cases: - BeforeStart AND FetchOffset = 0 - CurrRowsetStart = 1 AND FetchOffset 0 - CurrRowsetStart 1 AND CurrRowsetStart + FetchOffset 1 AND |FetchOffset| RowsetSize - CurrRowsetStart 1 AND CurrRowsetStart + FetchOffset 1 AND |FetchOffset| = RowsetSize -- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the case when FetchOffset 0 AND |FetchOffset| LastResultRow AND |FetchOffset| RowsetSize -- Fix to memory leaks on unix when linked with iodbc or unixodbc. -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- FILEDSN support Apart from the above, -- MyODBC 3.51 allows backward compatibility, i.e. all 2.50 applications will work without any problems. -- MySQL ODBC 3.51 Programmer's Reference Manual and frequently Asked Questions(FAQs) are live. For more information about MyODBC, visit http://www.mysql.com/products/myodbc/index.html Regards Venu Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail the address shown in the List-Unsubscribe header of this message. For additional commands, 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
Table appears in multiple joins returns null column
I have the below query that returns the correct records but the POINTFUND.description field is all NULL while it has values in the table. Any idea why? Thanks. SELECT RACES.RACE_ID, RACES.sequence, TYPES.typelong, SCHEDULE.event, SCHEDULE.date, PARTY.lname, POINTFUND.description FROM TYPES LEFT JOIN RACES ON RACES.TYPE_ID = TYPES.TYPE_ID LEFT JOIN POINTFUND ON POINTFUND.TYPE_ID = TYPES.TYPE_ID, SCHEDULE, PARTY WHERE RACES.SCHEDULE_ID = SCHEDULE.SCHEDULE_ID AND PARTY.PARTY_ID = SCHEDULE.TRACK_ID ORDER BY SCHEDULE.date, PARTY.lname - 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
Avanced query question
Hello, I have a question about a query. We have a guestbook and I want to do some statistics for the messages in it. So I've created a query that looks like this. select hour(msg_date_time), count(*) from messages where user_id = 'almar' group by hour(msg_date_time) It returns the hour and the number of messages posted in that hour. However, there are hours where no messages have been posted, so the result would look like this: hour msg_count 0 10 1 15 3 6 So in the example between 2 a clock and 3 a clock no messages have been posted. But I do want it to return 0 for hour 2. I know that my query will never return that result. We are using perl DBI. Does anyone have an idea? Kind regards Almar van Pel - 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: InnoDB File Size
Hi! I just tried with 3.23.48 on Linux-2.4.16-SMP-64GB (ext2 I think), and a 5000 MB data file was created. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com -Original Message- From: Gurupartap Davis [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, February 09, 2002 2:32 AM Subject: Re: InnoDB File Size Yes, I saw that before...My filesize was limited to 2GB before, but now with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file now, right? So something's wrong... as I said before, I have successfully created a 9GB file on this machine before, so the filesystem isn't to blame for a 4GB limitation... From http://www.innodb.com/ibman.html : MySQL/InnoDB-3.23.44, November 2, 2001 You can define foreign key constraints on InnoDB tables. An example: FOREIGN KEY (col1) REFERENCES table2(col2). You can create 4 GB data files in those file systems that allow it. Thus 4 G files should be available also on 4.0.1. Best regards, Heikki Tuuri Innobase Oy Gurupartap Davis wrote in message ... I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I accidentally made a 9GB log file the other day. Is this a limit of innodb? Is there somewhere I can adjust this limit? Thanks -Partap Davis Syncrasy, LLC - 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: InnoDB File Size
Yes, I saw that before...My filesize was limited to 2GB before, but now with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file now, right? So something's wrong... as I said before, I have successfully created a 9GB file on this machine before, so the filesystem isn't to blame for a 4GB limitation... From http://www.innodb.com/ibman.html : MySQL/InnoDB-3.23.44, November 2, 2001 You can define foreign key constraints on InnoDB tables. An example: FOREIGN KEY (col1) REFERENCES table2(col2). You can create 4 GB data files in those file systems that allow it. Thus 4 G files should be available also on 4.0.1. Best regards, Heikki Tuuri Innobase Oy Gurupartap Davis wrote in message ... I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I accidentally made a 9GB log file the other day. Is this a limit of innodb? Is there somewhere I can adjust this limit? Thanks -Partap Davis Syncrasy, LLC - 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
COUNT --- GROUP BY --- LEFT JOIN
I am attempting to combine COUNT, GROUP BY, and LEFT JOIN.. Adopting the theme on http://www.mysql.com/doc/C/o/Counting_rows.html my goal is to display only species/sex combinations that occur more than once. Additionally I wish to include the count for each row, and some keyed field from another table.. So I added a separate table owner containing foreign key petID and the field zipcode.. A couple rows of output might look like (species=dog sex=male animalcount=3 zipcode=5) (species=dog sex=female animalcount=2 zipcode=5). There would be no rows with a count of 1, and zipcode can repeat.. The following statement unfortunately includes zipcode when determining uniqueness. It's as close as I've come! Any suggestions?: SELECT species, sex, zip, COUNT(*) as animalcount FROM pet LEFT JOIN owner ON pet.petID = owner.petID GROUP By species, sex HAVING animalcount 1; __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - 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: AW: Which Hardware do I need ?
Hi, A 16MB key buffer seems very small; this is OK for a personal workstation with 64/128MB RAM not for a high performance 1GB server. If your queries are using indexes, you should check Key_read_requests and Key_reads values, if your query buffer is efficient, Key_read_requests should be MUCH greater than Key_reads. As an example, here are the values from our main MySQL server: | Key_blocks_used | 186985 | | Key_read_requests| 3214556494 | | Key_reads| 183458 | If you want to optimize Key_buffer parameter, you should evaluate the size of all your indexes (check *.MYI sizes) and use this value as a starting point. Regards -- Joseph Bueno NetClub/Trader.com Daniel Backhausen wrote : Hi. Our queries seem well optimized, maybe there are some slow queries in there but sometimes you have no other choice and we are using indexes. Our Key Buffer size is about 16MB (standard). Thx for helping ... Greetz - Daniel -Ursprungliche Nachricht- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 23:53 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: Which Hardware do I need ? On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: Hi. Does somebody know which server hardware I have to buy to realize my following problem ? I have 3 tables. They are all connected to each other with some queries. 1st table has momentary 10.000 and should be upgraded to 50.000 records. 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time. 3rd table has 200.000 records and should be upgraded to 1.500.000 records. Does somebody have experience with such a huge amount of records in mySQL ? That's not huge. :-) We've got one table with over 267 million rows in it and it grows daily. We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a load of 40 and restarts after some time. That should be more than sufficient. Are your queries well optimized and using indexes? How large is your key buffer? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - 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 won't start...
FISHER, Friday, February 08, 2002, 9:01:10 PM, you wrote: Feoen I have 2 SuSE Linux 7.2 machines at home... These boxes Feoen have completely different hardware in each... But the Feoen O/S on each, contains virtually all of Feoen the same applications... Feoen On the first machine, MySQL started right up, and has Feoen been working correctly ever since... Feoen On the second machine, MySQL will NOT start... Feoen It tries to start, but keeps aborting... Feoen Here are the only messages that I can seem to find: Feoen 020126 18:01:29 mysqld started Feoen 020126 18:01:29 /usr/sbin/mysqld: Feoen Table 'mysql.host' doesn't exist Feoen 020126 18:01:29 mysqld ended Feoen 020126 18:04:56 mysqld started Feoen 020126 18:04:57 /usr/sbin/mysqld: Can't find Feoen file: Feoen './mysql/host.frm' (errno: 13) Feoen Each time I try to restart, I get the above messages... Feoen If anyone can point me to some specific log files, that Feoen would help to debug this problem further, I would much Feoen appreciate it... Feoen my.cnf is locate in /etc, as it's supposed to be... Feoen host.frm exists, but it exists in the following Feoen location: (I'm thinking that Feoen something in /usr/sbin/mysqld isn't pointing to the Feoen file...) Feoen /var/lib/mysql/mysql/host.frm Feoen Is there a configuration file someplace, that I can Feoen modify to point to this host.frm file? Feoen If so, what is the correct command, including syntax? $ perror 13 Error code 13: Permission denied Does your user have permission to read, write and execute those dirs and files? Feoen TIA Feoen Joe F. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 RE: insertion problem !!
Chetan, the type of the column user_id is different in your two tables: in the parent table it is UNSIGNED, but signed in the child table. The internal storage format of a signed integer is different from an unsigned integer. That is why adding the child row fails. I changed now InnoDB-3.23.48 so that it gives an error in CREATE TABLE if the integer type signedness is not consistent in the foreign key declarations. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Chetan Lavti wrote in message ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:22 PM To: Chetan Lavti Subject: Re: insertion problem !! Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: hi, I have two tables as:=20 please concentrate on domain_id and INDEX=20 Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I have made sure that the value I am inserting for the 'domain_id' exists in the ls_domain table.) please tell me what could be the problem... INSERT INTO ls_user(ls_user,domain_id,user_name,user_flag,user_passwd,user_addr,user _email,created_by, created_date) VALUES(1,'Chetan Lavti','y','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for the same... Thanks and regards, Chetan Lavti - 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: bug report: mysql_install_db hangs on execution.
Legault, Alain writes: SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: Subject: Mysqld hangs on initialization with mysql_install_db. Hi! A usual cause for the above behaviour is a difference in the patch level between your OS and the one on which our binary was built. More info in our manual. -- Consider taking our support. Visit : https://order.mysql.com Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 possible 1 query with 2 selects?
I don't know you table structure but something like this would do it... SELECT * from QB as tbl1 JOIN relAB as tbl2 ON tbl2.A=tbl1.A where tbl2.a='a1' Butch Bean -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 09, 2002 7:24 AM To: [EMAIL PROTECTED] Subject: is possible 1 query with 2 selects? Nuno, Friday, February 08, 2002, 11:04:51 PM, you wrote: NT Hello to all, NT I'm trying to make a query with only one command but I can't see how to do NT it. [skip] NT What I want to do is get a list from table QB related to an item from NT table QA: NT For example, get a list from QB related to item 'a1': NT 1. select B from relAB where A='a1'; NT (result: b2, b3, b4) NT 2. select * from QB where ref in ('b2','b3','b4'); NT (result: only 'a1' related items) NT There is a way of make this query with only one command? NT Something like: NT 1. select * from QB where ref in (select B from relAB where A='a1'); MySQL doesn't curently support sub-selects, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html It is in our plans to support sub-selects in future: http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html NT Please help me in this matter. NT Thanks very much, -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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