Re: Qeury Help - Joining 4 tables!
Join many table with 1 query is the ideal. Because you must sure that there are the valid data integrity. If there is only 1 broken join key (any part of table1.key=table2.key), you'll got the null row. When you need to display all of the first table value and retrieve another information from other table, try to make more than 1 query like this $qry1 = select * from table1;; $result = mysql_query($qry1, $mysql_link) if ($result) { while($row = mysql_fetch_array($mysql_result)) { ... display as you want before check value in another table $qry2 = select * from othertable where code='$row[cid]';; $result2 = mysql_query($qry2, $mysql_link); if ($result2) { $row2 = mysql_fetch_array($result2); if (trim($cname)==) { $cname = N/A; } else {$cname = trim($row2[name]). .trim($row2[surname]); } } else {$cname = N/A;} print $cname\n; } } hope to help you, Sommai, At 23:34 31/3/2002 -0800, David McInnis wrote: Can anyone tell me a more efficient way to structure this query? It works fast enough now, but I don't have that much data yet. I am concerned with future performance. I need all of the rows from the project table that match the first where clause. The other information saves me from having to run a bunch of additional queries to get information that I need to display. select a.clientid, a.pid, a.writerid, a.dt_assigned, b.itemname, c.fname, c.lname, d.company fromprojects a, catalog b, clients c, partners d where a.writerid = 2 and a.sku = b.sku and a.clientid = c.id and c.partnerid = d.id; Thanks, David McInnis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: moodss-15.11
Note: I am not subscribed to this list, so please Cc me at [EMAIL PROTECTED] if you reply to this message. Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 8 modules, such as the new myreplication, myerrorlog and myhealth modules, are available. This new version features minor bug fixes in the myerrorlog module, text formatting in the free text viewers, minor GUI improvements in Windows version and the usual bug fixes. Please refer to the http://jfontain.free.fr/moodss-15.11.CHANGES for a complete list of changes. More examples and documentation, various screenshots and other modules for MySQL (myhealth, mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Watch this space for new modules... Downloads: http://jfontain.free.fr/moodss-15.11.tar.bz2 http://jfontain.free.fr/moodss-15.11.zip http://jfontain.free.fr/moodss-15.11-1.i386.rpm http://jfontain.free.fr/moomps-1.4-1.i386.rpm http://jfontain.free.fr/moodss-15.11-1.spec Enjoy! -- Jean-Luc Fontaine mailto:[EMAIL PROTECTED] http://jfontain.free.fr/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris 8 Library Problems.
hi stephen, the ncurses library is not part of the mysql distribution. it's available as a solaris binary package at www.sunfreeware.com. look for ncurses-5.2. HTH michael Stephen D. Myles wrote: Hi, I am new to MYSQl so any help is much apreciated! I have recently instaled mysql version 3.23.45 on Sun solaris 8 (sparc). The server installed fine but I am unable to connect to the server using the mysql command due to some missing libs. Both the server and client are running locally. # ./mysql -h tilda -u mysql ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed A truss of the above output shows mw whitch lib files. # truss ./mysql execve(mysql, 0xE72C, 0xE734) argc = 1 mmap(0x, 4096, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xEF7B resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT open(/usr/local/mysql/lib/mysql/libncurses.so.5, O_RDONLY) Err#2 ENOENT open(/usr/local/lib/libncurses.so.5, O_RDONLY) Err#2 ENOENT open(/usr/lib/libncurses.so.5, O_RDONLY) Err#2 ENOENT ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory write(2, l d . s o . 1 : . / m.., 81) = 81 getpid()= 1028 [1027] I can find no reference to this files in any of the documentation at all which leaves me a little confused. Any ideas? thanx smyles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build error in mysql
Hello, Can anybody help me out in solving the build error problem for mysql I am trying to build MySQL-3.23.49-1.src.rpm with the linux command rpm --rebuild MySQL-3.23.49-1.src.rpm. Using redhat linux 6.2 with glibc2.1.3. Following is the error while compiling- make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:195: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 Bad exit status from /var/tmp/rpm-tmp.34558 (%build) Thank you Laxmikant __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover 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: Build error in mysql
On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant Agarwal wrote: Hello, Can anybody help me out in solving the build error problem for mysql I am trying to build MySQL-3.23.49-1.src.rpm with the linux command rpm --rebuild MySQL-3.23.49-1.src.rpm. Using redhat linux 6.2 with glibc2.1.3. What gcc version are you using? -- 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 52 days, processed 1,462,253,397 queries (320/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
mysql innodb error
Placed At : Hi ... I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha on a redhat linux machine.. My table type is innodb. the error is as follows.. ERROR 1030: Got error 101 from table handler I do not have a very complex table structure and this error comes up only for one record or so..I restart the mysql on the server then the update starts working for this record..I 'm not able to create another table selecting from this table also..I feel that there is somekind of lock that gets set..but i have fought for long with this problem .. Should i go for a higher version of mysql can anyone suggest please.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Build error in mysql
i am using egcs 2.91.66 --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant Agarwal wrote: Hello, Can anybody help me out in solving the build error problem for mysql I am trying to build MySQL-3.23.49-1.src.rpm with the linux command rpm --rebuild MySQL-3.23.49-1.src.rpm. Using redhat linux 6.2 with glibc2.1.3. What gcc version are you using? -- 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 52 days, processed 1,462,253,397 queries (320/sec. avg) __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover 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
Query for Summary Report
Hello All, I've got an SQL question. I have a database that contains Reviews of some of a clients publications. The client is interested in generating some summary reports and I simply can't wrap my head around a single SQL query (if that's possible) that will generate the information I'm looking for. The one they are most interested in is this... We have a table (built on user submissions) that has something like this... DocName DocSubj Usefulness Processors Upgrading 1 Processors Upgrading 2 Hard Drives Upgrading 1 PrintersReviews 3 They want to get something like this... Subject # Reviews Avg Rating Upgrading 3 1.3 Reviews 1 1 And I'm just missing something... I'm sure it has to possible but I can't think of good way to do this. (The only way I can think of is to run one query to grab all the distinct subjects, loop over that resultset and then fetch the count and average for that particular subject on each iteration) Any advice is greatly appreciated. Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to get a back up?
kaps, Sunday, March 31, 2002, 10:51:14 AM, you wrote: k how can i get a backup of the database using the mySQL Server terminal k access with my mySQL Sever? k any help? Look at the section 4.4.1 Database Backups in the manual: http://www.mysql.com/doc/B/a/Backup.html Take a look at mysqldump and mysqlhotcopy utilities. k cheers k kaps -- 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
mysqld: Can't find file: 'host.frm' even though file exits
Kenneth, Sunday, March 31, 2002, 2:13:47 AM, you wrote: KLSubmitter-Id: submitter ID KLOriginator:Kenneth Lerman KLOrganization: KL Systems Essentials Limited KLMySQL support: none KLSynopsis: Can't find file: 'host.frm' even though it exists KLSeverity: critical KLPriority: high KLCategory: mysql KLClass: support KLRelease: mysql-3.23.49 (Source distribution) Kenneth, give me the full output of error and the .err file content. -- 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
Re: can i use java stored procedure
MySQL plans to implement stored procedures in 4.1 though :-) --- Jeremy Zawodny [EMAIL PROTECTED] wrote: MySQL doesn't have stored procedures yet. It has user defined functions (UDFs), but that's not what you're looking for here. Jeremy __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover 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: VC++ Examples
Troy writes: Hi all, Just wondering if there are any examples on the web that will compile using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get the example to compile. Thanks in advance Troy HI! MySQL++ requires VC++ 6.0. -- 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
joining tables from selected values
Hi! Id would like to have 4 tables files ( id int(8), type set(directory, file, link), ) files_directory ( id int(8), is_files int(8), name varchar(20) ... ) files_file ( id int(8), is_files int(8), name varchar(20) ... ) files_link ( id int(8), is_files int(8), name varchar(20) ... ) And be able to make one query to get the info from, for example the files_directory-table just having an id for the files-table, such as: select files.type as #type, files_#type.* from files, files_#type where files.id =$id and files_$type.is_files=$id $id is a value from php-script #type is a for me imaginary value that I would like mysql to generate and being able to use. is this possible, or should I rename the values in the files.type-set to files_directory, files_file, files_link? or wouldn't this help either? regards, tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie - Different commands....?
* Gordon Stewart I've been following the website of :- http://www.wdvl.com/Authoring/DB/SQL/Build/ And its the best ive seen - so far... Im up to this page :- http://www.wdvl.com/Authoring/DB/SQL/Build/build4-5.html now i'm stuck - I need to know 2-3 more things that i can do WITHIN / USING Perl.. My coder (see below)... From the build4-5 web-page above, I'll assume that $result = @mysql_query(show databases); would be the correct code to SHOW the databases available.. That is correct. However its not going the website doesnt have the 2 commands that i want to do.. oki... what 2 commands, and what happens? Do you get an error message? Can someone advise me the commands to :- 1) View/List Databases / Tables SHOW DATABASES; and SHOW TABLES; URL: http://www.mysql.com/doc/S/H/SHOW_DATABASE_INFO.html 1A) Add / create a Database/Table (I'll assume you use the @mysql_query in some way. CREATE DATABASE MyBrandNewDatabase; USE MyBrandNewDatabase; CREATE TABLE MyBrandNewTable ( MyIdField int primary key, MyTextField varchar(30) ); URL: http://www.mysql.com/doc/C/R/CREATE_TABLE.html And yes, in PHP you use mysql_query() to execute the sql statements on the mysql server you have connected with mysql_connect(). If the query returns a result, you use the mysql_fetch_*()-functions or mysql_result() to get the result. To make away with one common mistake: the mysql_query() function accepts _one_ single sql statement, without a semicolon at the end. You can always execute multiple statements, but they have to be in separate mysql_query() calls. On this mailinglist you will frequently see sql with semicolons (like my code above.) This is because the semicolon is _required_ when you execute the statements in the mysql client console. (Actually, the semicolon can be replaced by \g or \G, but this is not so common.) Just ignore the semicolons when you but the statements in your mysql_query() function call. 2) Ive figured out what these mean - But are there others _ that do other things ? - A list of them ? @mysql_select_db @mysql_query The PHP site has a special page for mysql: URL: http://www.php.net/manual/en/ref.mysql.php There are quite a lot of functions... :) mysql_fetch_array Can someone explain why theres no @ sign - a website that explains this further... The @ operator is used to ignore any errors the function generates. It can be used with any function, but it is usually better to catch the error and do some apropriate error handling. Read more about @ here: URL: http://www.php.net/manual/en/language.operators.errorcontrol.php // Request the text of all the jokes $result = @mysql_query(show databases); if (!$result) { echo(pError performing query: . mysql_error() . /p); exit(); } // Display the text of each joke in a paragraph while ( $row = mysql_fetch_array($result) ) { echo(p . $row[JokeText] . /p); } There is no column called JokeText in the output of the show databases query... that is why this does not work. The name of the column returned is Database. Change your script to $row[Database], and it should work. The name of the column of tables returned by show tables is named Tables_in_ . $db_name, like in Tables_in_test or Tables_in_mydb. You can check this by running your query (show databases; or show tables;) in the mysql client console. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: filemaker to mysql
You might also want to consider looking at Lasso Professional 5 www.blueworld.com. This product has MySQL built-in, while also connecting directly with external MySQL and FMP database sets. For me, its the perfect solution when bringing parts of MySQL and FMP together using a browser interface. - Jim Van Heule[EMAIL PROTECTED] VH Publications, Inc.direct: 616.844.0066 I got some more information -- rory oconnor asked: I have a new client that wants to use filemaker on his mac to enter data for site information. I'm sure that I can take that and export the files and import into the site's MySQL database...but I'm wondering if it is possible to link his filemaker database to the MySQL database using ODBC? I have done this with MS Access on a PC, but not filemaker on a mac. Has anybody done this or know where I can get more information? I asked about this on the Apple boards and got the following links: http://www.filemaker.com/ti/105748.html http://www.profdata.nl/pdm/generic.jsp?taxonomy_id=5 (I asked in the devoloper discussions area, if anyone's curious.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
pb while starting mysql
Hi all, I accidently move some database dir temporary (for space pb) but when moving I surely forget something I cant no longer start my server. I put the sock file where it had to be but nothing more. See that www:/var/lib/mysql# ls -ls total 100 4 drwxr-xr-x2 mysqlmysql4096 avr 1 02:04 ddbase/ 4 -rw-rw1 mysqlmysql 0 avr 1 02:58 ibdata1 4 drwxr-xr-x2 mysqlmysql4096 mar 21 00:43 mysql/ 0 srwxrwxrwx1 mysqlmysql 0 avr 1 03:05 mysql.sock= 88 -rwxr-xr-x1 mysqlmysql 84518 avr 1 03:05 www.mydomain.com.err* www:/var/lib/mysql# telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused www:/var/lib/mysql# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) What can i do ?, I dont know what things i delete or forgot to move again, everythings seem ok. my os : linux mandrake 8.1 ... thanks. _ 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
help: table update program?
Does anyone know of a program or algorithm that will take a table structure and update another table to the new one? Like, to just change or add a column? What I'm trying to do is continually update the table with different fields, or change the field types whenever I feel the need to add a new feature or something. Thank you. sql -- Romans 12:9 Let love be without hypocrisy. Abhor what is evil. Cling to what is good. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
Did you dump the 24 records on both boxes and compare them? Maybe someone updated the records on the slave, and now the dates don't match. Vico Timmermans wrote: I think i stumbled upon a bug that's got something to do with join size. Detailed information below. Using 2 intel-linux platforms with replication the query stated below works fine on one machine: - mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686) - Linux deedee 2.2.16-SMP #1 SMP Wed Aug 16 05:07:06 GMT 2000 i686 unknown and gives reduced results on the other: - mysql Ver 11.15 Distrib 3.23.41, for suse-linux (i686) - Linux blossom 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown The query states as follows: SELECT isp.naam AS provider, MID(log.logtijd,1,10) AS datum, acties.adres AS adres, acties.omschrijving AS adres_omschrijving, SUM(log.data) AS bytes, SUM(log.duur)/10 AS seconden, SUM(log.data)*80/SUM(log.duur) AS kbs, COUNT(*) AS aantal, inbelpunten.id, inbelpunten.plaats, inbelpunten.netwerk FROM log, taken, deploy , acties , inbelpunten, isp WHERE log.taakID = taken.ID AND taken.deployID = deploy.ID AND log.actieID = acties.ID AND taken.inbelpuntid=inbelpunten.id AND inbelpunten.ispid=isp.id AND log.logtijd = '2002-03-22' and log.logtijd DATE_ADD('2002-03-28', INTERVAL 1 DAY) AND (deploy.keyword = 'STISDN') AND taken.medium='isdn' AND ((log.meldingid = 10) OR (log.meldingid = 11) OR (log.meldingid = 12)) GROUP BY isp.ID ORDER BY kbs DESC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: help: table update program?
* James Gosnell Does anyone know of a program or algorithm that will take a table structure and update another table to the new one? Like, to just change or add a column? What I'm trying to do is continually update the table with different fields, or change the field types whenever I feel the need to add a new feature or something. Thank you. I don't know of any program, but this is how I do it: First, you can use ALTER TABLE directly on an existing table to change or add a column. URL: http://www.mysql.com/doc/A/L/ALTER_TABLE.html To copy the structure of an existing table: CREATE TABLE new_table SELECT * FROM old_table WHERE 1=0; The WHERE 1=0 is to avoid copying any rows. If you want to copy the content of the table, just remove the WHERE clause. Finally, if I need to copy the table structure and keep any defined indexes, I use SHOW CREATE TABLE MyTable; and copy paste the output to my text editor, where I edit the table name and any fields I need to change, before I submit it by copy paste it back to the mysql client console. Very easy. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL text column with PHP4
I need some help formatting a MySQL longtext column for presentation via PHP When I pull the data with PHP the line feeds are not respected unless I use the pre/pre HTML tags around my data field. This does not have the desired effect. how can I pull the data into the php web page and maintain line feeds/carriage returns while still respecting other text layout commands? Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql innodb error
Kannan, please upgrade to 3.23.49a or 4.0.1. 101 used to mean lock wait timeout. It has been replaced by a clear-English error code. 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 - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 01, 2002 1:30 PM Subject: mysql innodb error Placed At : Hi ... I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha on a redhat linux machine.. My table type is innodb. the error is as follows.. ERROR 1030: Got error 101 from table handler I do not have a very complex table structure and this error comes up only for one record or so..I restart the mysql on the server then the update starts working for this record..I 'm not able to create another table selecting from this table also..I feel that there is somekind of lock that gets set..but i have fought for long with this problem .. Should i go for a higher version of mysql can anyone suggest please.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem with '
On 31 Mar 2002, at 17:34, Alex Behrens wrote: My statement is this and it still gives me an error and wont add the data, the addslashes doesn't seem to be working: $sql = addslashes(INSERT INTO hwureviews (name,title,picurl,url,author,email,category,num,info) VALUES ('$name','$title','$picurl','$url','$author','$email','$category','$num','$i nfo')); I imagine addslashes() is working fine. It's just not doing what you think it should. The addslashes() function isn't magical -- it doesn't know that you want the single quotes inside $name backslashed but not the ones around it. You have to apply addslashes() to your individual values, not to the whole SQL statement. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql innodb error
I thought the 4.0 series was still Beta? On Mon, 1 Apr 2002, Heikki Tuuri wrote: Date: Mon, 1 Apr 2002 18:09:53 +0300 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: mysql innodb error Kannan, please upgrade to 3.23.49a or 4.0.1. 101 used to mean lock wait timeout. It has been replaced by a clear-English error code. 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 - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 01, 2002 1:30 PM Subject: mysql innodb error Placed At : Hi ... I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha on a redhat linux machine.. My table type is innodb. the error is as follows.. ERROR 1030: Got error 101 from table handler I do not have a very complex table structure and this error comes up only for one record or so..I restart the mysql on the server then the update starts working for this record..I 'm not able to create another table selecting from this table also..I feel that there is somekind of lock that gets set..but i have fought for long with this problem .. Should i go for a higher version of mysql can anyone suggest please.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql innodb error
William, - Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 6:29 PM Subject: Re: mysql innodb error I thought the 4.0 series was still Beta? yes, 4.0.1 is beta or alpha, depending on terminology. 4.0.2 will contain a lot of new MySQL code. Thus we cannot yet say how stable 4.0.2 will be. InnoDB in 4.0 and 3.23 is the same. Thus the InnoDB part is stable also in 4.0.2. Regards, Heikki On Mon, 1 Apr 2002, Heikki Tuuri wrote: Date: Mon, 1 Apr 2002 18:09:53 +0300 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: mysql innodb error Kannan, please upgrade to 3.23.49a or 4.0.1. 101 used to mean lock wait timeout. It has been replaced by a clear-English error code. 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 - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 01, 2002 1:30 PM Subject: mysql innodb error Placed At : Hi ... I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha on a redhat linux machine.. My table type is innodb. the error is as follows.. ERROR 1030: Got error 101 from table handler I do not have a very complex table structure and this error comes up only for one record or so..I restart the mysql on the server then the update starts working for this record..I 'm not able to create another table selecting from this table also..I feel that there is somekind of lock that gets set..but i have fought for long with this problem .. Should i go for a higher version of mysql can anyone suggest please.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
if I dont have the mysql.sock running in the temp folder how do I start it??? I tried service mysql start and it did work it give me the same error in the subject line - Original Message - From: andy thomas [EMAIL PROTECTED] To: colin o [EMAIL PROTECTED] Cc: Mike Yrabedra [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 2:56 PM Subject: Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) On Tue, 26 Mar 2002, colin o wrote: Same thing happens to me, i just use bin/safe_mysqld --user=root to start to server so that i can use mysql. I don't know exactly why it happens though. Possibly permissions?? It is better to run mysqld as a non-root user, such as mysql. --- Mike Yrabedra [EMAIL PROTECTED] wrote: What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Is the socket? It should show up in a directory listing of /tmp - if it isn't there then mysqld isn't running. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very large BLOBS in MySQL 4.0.1
Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But like I said, the file is only 34 MB, so theoretically it shouldn't be a problem. As for the client, I'm trying to insert the record with the Perl DBI, which, according the documentation, uses the server's max_allowed_packet value. There's no way to set it on the client side that I'm aware of. On Saturday, March 30, 2002, at 12:11 PM, Peter Zaitsev wrote: Hello Adriano, Friday, March 29, 2002, 11:38:32 PM, you wrote: As I remember there are max_allowed_packet options exists both for client and server. You may wish to try to raise both of them. AM I've been using a perl script to insert a very large blob (up to about 8 AM MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, AM so I upgraded to MySQL 4.0.1. First off, I can't get AM max_allowable_packet to go higher than 64M, regardless of what I set it AM to, but that shouldn't be the problem, right? But I still keep getting AM DBD::mysql::st execute failed: MySQL server has gone away AM when it tries to do the insert or update. It continues to work fine for AM smaller files. The field is a longblob, BTW. Any help would be greatly AM appreciated. And please don't tell me not to store large blobs in the AM database. I wouldn't be doing it if I didn't have to. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlmanager
Can you tell me what the mysqlmanager application will end up doing? Currently you say it is for testing purposes. But what is the future intended use of this program? What is in store for this application down the road? I see one of the parameters is a command length. Will this app allow a mysql server process to be managed remotely? Like starting and stopping from the shell, or doing data checks? -RG On Mon, 1 Apr 2002, Michael Widenius wrote: Hi! Russell == Russell E Glaue Russell writes: Russell in the '{MYSQLROOT}/bin' there are two executables in particular. Russell mysqlmanager Russell mysqlmanagerc Russell I see these are version 1.0, and such are recently added. Russell Can anyone tell me: Russell What does bin/mysqlmanager do, and how do I use it? Russell Why does the bin/mysqlmanagerc give me an error that it cannot Russell connect to the server and port mysqlmanager is listening on? The above programs are to still in development. Currently they are only usable for the mysql test suite to allow testing of stop and restart of the MySQL server, but in the near future these will be used by the 'failsafe' replication code. Russell I'll execute 'bin/mysqlmanager --port=3307 --host=127.0.0.1' cut Russell So, why do I get this error? Russell And if I get this corrected, what can I do with 'bin/mysqlmanager' and Russell 'bin/mysqlmanagerc' applications? I do not see documentation anywhere. Currently you should not yet try to use invoke these programs yourself, but just regard them as part of our test system. 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
ib* files and their rules
i run a mysql : mysql select version(); +---+ | version() | +---+ | 4.0.2-alpha-debug | +---+ 1 row in set (0.00 sec) on a mandrake 8.1 box. on /var/lib/mysql (DATADIR), I have several ib* file note that I have mysql max install. what the rule of this big file about 60Mb gor my ? Is it index for fulltext of MySQL file (ino db) ? I remove mysql max can i remove this files ? I remove Thanks. _ 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
KDE/QT--DRIVER NOT LOADED
ERROR MESSAGE: 1 WE R DEVELOPING A PRODUCT USING KDE2.0/QT3.0.2 ENVIRONMENT, USING MYSQL AS DATABASE. WHILE CONGIGURING THE QT3.0.2--- $./configure -qt-sql-mysql -I/usr/local/qt/include -system-libjpeg -qt-gif -qt-libpng -debug ...ENTER AFTER CONFIGURATION FOR gmake WE R GETTING THE FOLLOWING MESSAGE: /usr/bin/ld:cannot find -lmysqlclient collect2: ld returned 1 exit status gmake[2]: *** [/usr/local/qt/libqt.so.3.0.2] ERROR1 gmake[1]: leaving directory '/usr/local/qt/src' gmake[1]: ***[sub-src] ERROR2 gmake[1]: leaving directory '/usr/local/qt' gmake: *** [init] ERROR 2 ERROR MESSAGE: 2 WHILE CREATING DATABASE CONNECTION USING QT3.0.2-- Project/DatabaseConnections--- Connecting the uiform with Databse we r getting a MESSAGE PLEASE ENSURE THAT Database Server is running and all the connection information is correct[DRIVER NOT LOADED]. But the Database Server is running... Please give the sufficient information regarding how to load driver for Qt3.0.2 ERROR MESSAGE: 3 WHILE GIVING PROJECT/BUILD RPM PACKAGE from KDE-2.0 its asking for spec file .We have to write the spec file or it will generate the spec file while we CONFIGURE RPM PACKAGE.WHAT R ALL THE OPTOINS WE HAVE TO GIVE in CONFIGURE RPM PACKAGE...Just suggest the reason for that. thanking you, V.SRINIVASA SRIKIRAN, Software Engineer, BitPlus Infotech, Bangalore. [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Patch to facilitate compilation on NetBSD/powerpc systems
Description: Existing mit-pthreads code does not compile on current NetBSD/powerpc How-To-Repeat: Attempt to compile Fix: Apply patch $NetBSD$ *** mit-pthreads/machdep/syscall-powerpc-netbsd.S Thu Feb 14 12:30:14 2002 --- mit-pthreads/machdep/syscall-powerpc-netbsd.S Mon Mar 25 09:52:47 2002 *** *** 1,10 #include machine/asm.h #define COMPAT_43 #include sys/syscall.h - #ifndef __CONCAT - #include sys/cdefs.h - #endif - #defineCONCAT __CONCAT #undef SYSCALL --- 1,6 *** *** 26,45 SYSCALL invocation. */ ENTRY(machdep_cerror) ! mflr0 # Save LR in 0 ! stwu1,-16(1)# allocate new stack frame ! stw 0,20(1) # Stash 0 in stack ! stw 31,8(1) # Stash 31 in stack (since it's callee-saved ! mr 31,3# and we stash return there) bl PIC_PLT(_C_LABEL(__errno)) ! stw 31,0(3) # *errno() = err ! lwz 0,20(1) # Restore LR from stack to 0 ! neg 3,31# return -errno to 3 ! lwz 31,8(1) # Restore 31 from stack mtlr0 ! la 1,16(1) # Restore stack frame ! li 4,-1# Put -1 in r4 for those syscalls that return ! blr # two values /* The fork system call is special... */ ENTRY(machdep_sys_fork) --- 22,41 SYSCALL invocation. */ ENTRY(machdep_cerror) ! mflr0 /* Save LR in 0 */ ! stwu1,-16(1)/* allocate new stack frame */ ! stw 0,20(1) /* Stash 0 in stack */ ! stw 31,8(1) /* Stash 31 in stack (since it's callee-saved */ ! mr 31,3/* and we stash return there) */ bl PIC_PLT(_C_LABEL(__errno)) ! stw 31,0(3) /* *errno() = err */ ! lwz 0,20(1) /* Restore LR from stack to 0 */ ! neg 3,31/* return -errno to 3 */ ! lwz 31,8(1) /* Restore 31 from stack */ mtlr0 ! la 1,16(1) /* Restore stack frame */ ! li 4,-1/* Put -1 in r4 for those syscalls that ret */ ! blr /* two values */ /* The fork system call is special... */ ENTRY(machdep_sys_fork) *** *** 55,64 li 0,SYS_pipe sc bso PIC_PLT(_C_LABEL(machdep_cerror)) ! stw 3,0(5) # Success, store fds stw 4,4(5) li 3,0 ! blr # And return 0 #ifndef SYS___sigsuspend14 /* The sigsuspend system call is special... */ --- 51,60 li 0,SYS_pipe sc bso PIC_PLT(_C_LABEL(machdep_cerror)) ! stw 3,0(5) /* Success, store fds */ stw 4,4(5) li 3,0 ! blr /* And return 0 */ #ifndef SYS___sigsuspend14 /* The sigsuspend system call is special... */ *** *** 72,91 #ifndef SYS___sigprocmask14 /* The sigprocmask system call is special... */ ENTRY(machdep_sys_sigprocmask) ! or. 4,4,4 # Set == NULL ? ! li 6,1 # how = SIG_BLOCK beq Ldoit ! lwz 4,0(4) # if not, replace it in r4 with #set mr 6,3 ! Ldoit:mr 3,6 # ... using sigprocmask(SIG_BLOCK) li 0,SYS_compat_13_sigprocmask13 sc bso PIC_PLT(_C_LABEL(machdep_cerror)) ! or. 5,5,5 # Check to see if oset requested ! beq Ldone # if oset != NULL ! stw 3,0(5) # *oset = oldmask Ldone: ! li 3,0 # return 0 blr #endif /* SYS_sigprocmask14 */ --- 68,87 #ifndef SYS___sigprocmask14 /* The sigprocmask system call is special... */ ENTRY(machdep_sys_sigprocmask) ! or. 4,4,4 /* Set == NULL ? */ ! li 6,1 /* how = SIG_BLOCK */ beq Ldoit ! lwz 4,0(4) /* if not, replace it in r4 with #set */ mr 6,3 ! Ldoit:mr 3,6 /* ... using sigprocmask(SIG_BLOCK) */ li 0,SYS_compat_13_sigprocmask13 sc bso PIC_PLT(_C_LABEL(machdep_cerror)) ! or. 5,5,5 /* Check to see if oset requested */ ! beq Ldone /* if oset != NULL */ ! stw 3,0(5) /* *oset = oldmask */ Ldone: ! li 3,0 /* return 0 */ blr #endif /* SYS_sigprocmask14 */ Submitter-Id: submitter ID Originator:Allen Briggs Organization: Wasabi Systems, Inc. MySQL support: none Synopsis: Patch to facilitate compilation on NetBSD/powerpc systems Severity: critical Priority: high Category: mysql Class: change-request
ORDER BY when selecting a TEXT type column uses disk based temp table
I have a query: SELECT feature_type.title, feature.title FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal When I include the ORDER BY the query uses a disk based temporary table. If I remove the ORDER BY the temporary table is not used. Also if I change the query to include the first 255 characters of the TEXT column: SELECT feature_type.title, LEFT(feature.title, 255) FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal a disk based temporary table is not used. If I change the query to include the first 256 characters of the TEXT column: SELECT feature_type.title, LEFT(feature.title, 256) FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal the disked based temporary table is used. Has anyone experienced this? If so is there any server settings I can change to allow larger text based columns? I'm not sorting by the TEXT column, I'm actually sorting by an INT column. Thanks for any help you might be able to offer. Robert V. Zwink http://www.zwink.net/daid.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connecting to server through C API
Sihem, Sunday, March 31, 2002, 1:26:00 AM, you wrote: SAY problem in connecting to server through C API function SAY mysql_real_connect() SAY the mysql handle returned by mysql_init() is not null SAY error message says: SAY Program received signal SIGSEGV, Segmentation fault. SAY 0x4000807d in _dl_lookup_versioned_symbol (undef_name=0x8048b73 sprintf, ref=0xb610, symbol_scope=0x0, SAY reference_name=0x40010c27 , version=0x40014910, reloc_type=7) at do-lookup.h:70 SAY 70 do-lookup.h: No such file or directory. SAY where is do-lookup.h supposed to be? it's not in mysql.h How did you installed the MySQL C API (and libmysql)? SAY sihem -- 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
Multiple Inserts
Anton, Sunday, March 31, 2002, 10:53:45 PM, you wrote: AC REALFROM: Anton Chalbaud [EMAIL PROTECTED] AC HOUR: 2002033122 AC Hi, if I need to do multiple INSERTS (I mean into different tables) which is AC the best way to manage this? Do I have to run a different Query for each AC INSERT ? Or is there a faster better way to do it. Yes. INSERT INTO table(field1, field2) VALUES ('data1','data2'), ... lots here.. ('data1','data2'), ('data1','data2'); AC Thanks. -- 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
problem for starting or connecting ?
David, Monday, April 1, 2002, 4:07:53 AM, you wrote: Dy I accidently move some database dir temporary (for space pb) but when moving Dy I surely forget something I cant no longer start my server. Dy I put the sock file where it had to be but nothing more. Looks like the server is not running - start it. safe_mysqld will do the thing. Dy thanks. -- 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
limiting a select
Alex, Saturday, March 30, 2002, 6:50:17 PM, you wrote: AB quick question, I'm setting up a script that does headlines for my site and AB I need to pull some information from a table with my review info from it but AB I only want to view the 7 latest reviews, how do I make it so I can only AB view like 7 highest values for the num column? AB my query is this: AB $r = mysql_query(SELECT * FROM hwureviews LIMIT (MAX(num)-7),7); Does this AB work or am I way off? Try something like SELECT * FROM hwureviews ORDER BY date_entered DESC LIMIT 7 AB -Alex Big Al Behrens -- 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
Import Oracle tables into mysql
Art, Sunday, March 31, 2002, 11:28:17 PM, you wrote: AF Does anyone know how or where there is a howto to import tables from an AF Oracle Database into Mysql and then to keep the Mysql syncronized with the AF Oracle database? There is no such thing as syncronizing between Oracle and MySQL since servers are different. But you can always manage a little script in perl that does it all. AF Art -- 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
installation problem
Shelly, Sunday, March 31, 2002, 4:12:49 PM, you wrote: Looks like MySQL server is not running. Please check that. SY After running setup on Window professional , I tried SY to install using the follow command. I got error. SY C:\mysql\binmysqladmin -u root shutdown SY mysqladmin: connect to server at 'localhost' failed SY error: 'Can't connect to MySQL server on 'localhost' SY Check that mysqld is running on localhost and that th SY You can check this by doing 'telnet localhost 3306' SY Then I tried to telnet: SY C:\mysql\bintelnet localhost 3306 SY Connecting To localhost...Could not open a connection SY to host on port 3306 : Con SY nect failed SY I appreciate if you could help to solve the problem. SY Shelly -- 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
RE: mysqldump problem
kaps, Sunday, March 31, 2002, 9:54:00 AM, you wrote: k i m fairly new to mySQL. I have to work on already set up live database k which can be managedwith phpAdmin system. k Now i was wondering how can i take a backup (dump) of the database with that k system? Use mysqldump utility: http://www.mysql.com/doc/m/y/mysqldump.html k kaps -- 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
Re: Using MySQL text column with PHP4
Try this function nl2br() Mat - Original Message - From: Rance Hall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 7:51 AM Subject: Using MySQL text column with PHP4 I need some help formatting a MySQL longtext column for presentation via PHP When I pull the data with PHP the line feeds are not respected unless I use the pre/pre HTML tags around my data field. This does not have the desired effect. how can I pull the data into the php web page and maintain line feeds/carriage returns while still respecting other text layout commands? Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using MySQL text column with PHP4
nl2br() works, thanks for the info manual stinks on this subject example code should be something like: $newtext = nl2br($oldtext); Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Mat Murdock [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:03 AM To: Rance Hall Cc: [EMAIL PROTECTED] Subject: Re: Using MySQL text column with PHP4 Try this function nl2br() Mat - Original Message - From: Rance Hall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 7:51 AM Subject: Using MySQL text column with PHP4 I need some help formatting a MySQL longtext column for presentation via PHP When I pull the data with PHP the line feeds are not respected unless I use the pre/pre HTML tags around my data field. This does not have the desired effect. how can I pull the data into the php web page and maintain line feeds/carriage returns while still respecting other text layout commands? Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Multiple Inserts
* Egor Egorov AC REALFROM: Anton Chalbaud [EMAIL PROTECTED] AC HOUR: 2002033122 AC Hi, if I need to do multiple INSERTS (I mean into different tables) which is I think he asked about inserting into multiple tables... ;) -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Join problem, Please help.
Hi. I am running MySQL 3.23.44-Max I have 2 tables. Table A +---++ IDName +---++ 1 string 1 2 string 2 +---++ Table B +---++ IDName +---++ 2 string 2 3 string 3 +---++ And I need result +---++ IDName +---++ 1 string 1 2 string 2 3 string 3 +---++ How I could get (my version of mySQL haven't UNION statement) Sincerely yours, Ivan Latysh. [EMAIL PROTECTED] http://ivan.yourmail.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
Arabic Support
hi guys, how can i use arabic language in the mysql tables data, my data in the table looks like Extended Ascii, and it is re-interpreted in windows programs - as MySQLMaker - into arabic, how can i let MySQL itself understand arabic? thx -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PigeonRank
Is it true that mysql is planing to implement google's famous PigeonRank system in it's FTS word weighting schema??? *drool* :-) -- 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
mysql schema manager
Hi there, can anyone reccommend a free schema manager for MySQL? I've heard of Kermit, but it's very expensive. Thanks, 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
RE: mysql schema manager
If you are looking for a web version, the best is phpMyAdmin which allows you to do just about everything you need to manage any number of mysql dbs. Andrew Hazen -Original Message- From: Vu, Steve [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 2:54 PM To: [EMAIL PROTECTED] Subject: mysql schema manager Hi there, can anyone reccommend a free schema manager for MySQL? I've heard of Kermit, but it's very expensive. Thanks, 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: PigeonRank
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Montag, 1. April 2002 21:38 Colin Faber wrote: Is it true that mysql is planing to implement google's famous PigeonRank system in it's FTS word weighting schema??? I allready have a simple quick-n-dirty implementation running on our local mysql servers (using spades instead of pigeons), so it shouldn't be too difficult to phase this development into the main cvs-trunk later. The only problem I wasn't yet able to resolve reliably is to store the three possible values into one bit, hence I'm using two bits for the decision logic and call this three-valued boolean storage unit a 'peck'. But it's my feeling, that there must be better a solution; after all if a qbit can hold 4 values (as modern physics says), why shouldn't a peck be able to mark 3 possibilities (or even 4 if you count 'not-yet-pecked' as the fourth). Working on it. Michael - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) [EMAIL PROTECTED] phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8qL3g72vu22ltWBERAj4nAJ43ozoANVzaNc7sFhEi4TQSLikp0QCfYYa8 DxDIMKhmecG7gx6BmxKZxnE= =GEhN -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing function
I have the 3.23.49 Version of MySQL and it is saying the load data command does not work with this version. I also read in my book that any version past 3.22.15 should be able to complete this function. Please advise. Rosina M. Everitte, B.A., Research Assistant University of Arkansas for Medical Sciences Division of Biometry 508 South Cedar, Trailer 3, Slot 781 Little Rock, AR 72205 (501)296-1556 (501)686-8297 - fax - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ORDER BY when selecting a TEXT type column uses disk based temp table
Just to clarify, my problem is that I do not want MySQL to use disk-based temp file. Everytime I try to ORDER a result set that contains a TEXT type field, MySQL will use disk based temp file. What can I do to: 1. SELECT a TEXT type field 2. ORDER by an INT column 3. not use a disk based temp file? This only seems to occur when the TEXT type field is greater than 255 characters. You can find the complete query below. Thanks, and sorry for the re-post. Robert Zwink http://www.zwink.net/daid.php -Original Message- From: Robert V. Zwink [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:47 AM I have a query: SELECT feature_type.title, feature.title FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal When I include the ORDER BY the query uses a disk based temporary table. If I remove the ORDER BY the temporary table is not used. Also if I change the query to include the first 255 characters of the TEXT column: SELECT feature_type.title, LEFT(feature.title, 255) FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal a disk based temporary table is not used. If I change the query to include the first 256 characters of the TEXT column: SELECT feature_type.title, LEFT(feature.title, 256) FROM feature_build LEFT JOIN feature ON feature_build.feature_id = feature.id LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id WHERE feature_build.product_id = '112479' AND feature_type.full_ordinal != 0 ORDER BY feature_type.full_ordinal the disked based temporary table is used. Has anyone experienced this? If so is there any server settings I can change to allow larger text based columns? I'm not sorting by the TEXT column, I'm actually sorting by an INT column. Thanks for any help you might be able to offer. Robert V. Zwink http://www.zwink.net/daid.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: PigeonRank?
How about using the state transitions, i.e. 0 - 1 state changed, no error 0/1 - 0/1 state unchanged, no error 1 - 0 state changed, overflow C:~ -Original Message- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 12:07 PM To: Colin Faber; [EMAIL PROTECTED] Subject: Re: PigeonRank? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Montag, 1. April 2002 21:38 Colin Faber wrote: Is it true that mysql is planing to implement google's famous PigeonRank system in it's FTS word weighting schema??? I allready have a simple quick-n-dirty implementation running on our local mysql servers (using spades instead of pigeons), so it shouldn't be too difficult to phase this development into the main cvs-trunk later. The only problem I wasn't yet able to resolve reliably is to store the three possible values into one bit, hence I'm using two bits for the decision logic and call this three-valued boolean storage unit a 'peck'. But it's my feeling, that there must be better a solution; after all if a qbit can hold 4 values (as modern physics says), why shouldn't a peck be able to mark 3 possibilities (or even 4 if you count 'not-yet-pecked' as the fourth). Working on it. Michael - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) [EMAIL PROTECTED] phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8qL3g72vu22ltWBERAj4nAJ43ozoANVzaNc7sFhEi4TQSLikp0QCfYYa8 DxDIMKhmecG7gx6BmxKZxnE= =GEhN -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PigeonRank
i've read the bit on google about thier pigeon rank thing, sounds like a cross between reality and alittle aprils' fools to me, either way id apreciate a better explanation of this technology and how it may be implemented into mysql -dan _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ib* files and their rules
David, - Original Message - From: David yahoo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 01, 2002 7:10 PM Subject: ib* files and their rules i run a mysql : mysql select version(); +---+ | version() | +---+ | 4.0.2-alpha-debug | +---+ 1 row in set (0.00 sec) on a mandrake 8.1 box. on /var/lib/mysql (DATADIR), I have several ib* file note that I have mysql max install. what the rule of this big file about 60Mb gor my ? Is it index for fulltext of MySQL file (ino db) ? I remove mysql max can i remove this files ? yes, you can remove the ib* files if you did not create any InnoDB tables and wnat to keep them. I remove Thanks. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PigeonRank
Who knows with google... ;-) Though I do like Michael's 'peck' 'not-yet-pecked' system. I question though how much more performance we could get out of Rats rather than Winged Rats. Dan Zarrella wrote: i've read the bit on google about thier pigeon rank thing, sounds like a cross between reality and alittle aprils' fools to me, either way id apreciate a better explanation of this technology and how it may be implemented into mysql -dan _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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
running the server problem
./safe_mysqld --user=mysqld --datadir=/db/ ./safe_mysqld --user=mysqld --datadir=/db/ 020401 16:55:04 mysqld started 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020401 16:55:04 mysqld ended My unix user is called mysqld and I want databases to go in /db/. Does anybody know what it is trying to do? I put in a non-standard location (/d2/usr2/local/) and I used a non-standard user (mysqld). I have no scripts nor var directories as the documentation says I should. scripts/mysql_install_db. I have version 3.23.49 of the source. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DATE_ADD ?
DATE_ADD(date,INTERVAL expr type) DATE_SUB(date,INTERVAL expr type) ADDDATE(date,INTERVAL expr type) SUBDATE(date,INTERVAL expr type) http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat e_and_time_functions Mike - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, April 01, 2002 3:04 PM Subject: DATE_ADD ? Hi, How do i the current timestamp plus 20 minutes in MYSQL? I have a Timestamp(14) field and i need to insert the current datetime plus 20 minutes. Thank u very much, Dirso. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Beginners Question
Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: running the server problem
I had the exact same problem. when you install mysql there is a database that stores all the user permissions and that table is created for you. the mysql server can start without that permissions file but you have to send a -Sg option to the server if you are on unix, linux or the like This option allows the server to start without checking for the grant tables. This is bad form if you want a production database. I was never able to fix my installation when I had this problem. I had to uninstall and reinstall and then specify the custom data path to the .configure file from a source install. Good Luck Rance Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Bob Lockie [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:50 PM To: mysql mailing list Subject: running the server problem ./safe_mysqld --user=mysqld --datadir=/db/ ./safe_mysqld --user=mysqld --datadir=/db/ 020401 16:55:04 mysqld started 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020401 16:55:04 mysqld ended My unix user is called mysqld and I want databases to go in /db/. Does anybody know what it is trying to do? I put in a non-standard location (/d2/usr2/local/) and I used a non-standard user (mysqld). I have no scripts nor var directories as the documentation says I should. scripts/mysql_install_db. I have version 3.23.49 of the source. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Myisamchk question
Hi, As I'd got not answer, I repost my question ;) I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI files, I'm performing the following action : For exemple : dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1 of=/home/mirror/mysql/Hardwarefr /cookie.MYI (to restore the valid first 16 K block) [root@forum] /home/mirror/mysql/Hardwarefr ls -la cookie.MYI -rw-r--r--1 root root16384 Mar 12 01:52 cookie.MYI Then I execute : myisamchk -r cookie.MYI - recovering (with sort) MyISAM-table 'cookie' Data records: 95290 - Fixing index 1 Data records: 95289 [root@forum] /home/mirror/mysql/Hardwarefr ls -la cookie.MYI -rw-r--r--1 root root 879616 Mar 12 01:55 cookie.MYI [root@forum] /home/mirror/mysql/Hardwarefr myisamchk -e cookie Checking MyISAM file: cookie Data records: 95289 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check records and index references Things seems to be perfect here, but : myisamchk -o cookie - recovering (with keycache) MyISAM-table 'cookie' Data records: 95289 [root@forum] /home/mirror/mysql/Hardwarefr ls -la cookie.MYI -rw-r--r--1 root root 1577984 Mar 12 01:56 cookie.MYI Why does the MYI is know nearly twice as big as the old cookie.MYI file ? Thanks you ! Jocelyn Fournier Presence-PC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple delete for mysql
Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record something like that I dont when to select but delete delete from externallink as link, topic as topic, topiclink as joiner where link.resid = joiner.resid and topic.catid = joiner.catid and topic.rid like %Industry%; I want to delete row from link joiner and topic too on cascad that correspond to that. Or have i to do 3 delete ? delete from topic where rid like %industry% and now how to delete ? where topic.id not in joiner ? and finaly how to delete link that doesnt have their id in joiner ? Thanks. _ 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
easy query question
I want to do a query that will find all the titles I have in my db that start with numbers and ambigious characters (i.e. 0-9, , #, $ etc...). My query is below, however I don't know what to change the a too in order for it to return what I just described. select id, shortdescription, title from reviews where title LIKE UPPER(\a%\) ORDER BY title ASC Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginners Question
MySQL will be good for this type of stuff. Tyler - Original Message - From: Zhao, Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 3:53 PM Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
InnoDB and Table Corruption
I am working with a low-load, mission-critical database. Although I have yet to have a corrupted table, I seem to read about it a lot on the list. This is a scary thought for me, considering the importance of the data I manage. Can anyone tell me if this is a rare occurrence? Is it even rarer if I choose to use InnoDB tables? Are there any statistics on corruption? There seems to be plenty of material on MySQL and InnoDB and speed vs the other major dbs, but what about stability and safety of data? Craig query,sql,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB and Table Corruption
Graig, I've been using mysql for about a year now on a linux machine and it has not crashed or had any corrupted tables in that time. I believe mysql is just as good in stability and safety of data has it is in speed. Mike - Original Message - From: Scalper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 8:01 PM Subject: InnoDB and Table Corruption I am working with a low-load, mission-critical database. Although I have yet to have a corrupted table, I seem to read about it a lot on the list. This is a scary thought for me, considering the importance of the data I manage. Can anyone tell me if this is a rare occurrence? Is it even rarer if I choose to use InnoDB tables? Are there any statistics on corruption? There seems to be plenty of material on MySQL and InnoDB and speed vs the other major dbs, but what about stability and safety of data? Craig query,sql,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DATE_ADD ?
Use a combination of the DATE_ADD function and the NOW function: SELECT DATE_ADD(NOW(), INTERVAL 20 MINUTE) --jeff - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, April 01, 2002 12:04 PM Subject: DATE_ADD ? Hi, How do i the current timestamp plus 20 minutes in MYSQL? I have a Timestamp(14) field and i need to insert the current datetime plus 20 minutes. Thank u very much, Dirso. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginners Question
Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie - Different commands....?
At this 14:31 1/04/02 +0200 Roger Baklund told us all something interesting :- From the build4-5 web-page above, I'll assume that $result = @mysql_query(show databases); would be the correct code to SHOW the databases available.. That is correct. However its not going the website doesnt have the 2 commands that i want to do.. oki... what 2 commands, and what happens? Do you get an error message? Ok - I think ive de-bugged it, Worked out what is wrong.. (although not sure how to de-bug it.. I'm off to bed now, so ive uploaded it to one of my sites (doesnt have PHP - (I dont think..)) as a text file... http://homepages.slingshot.co.nz/~gordon52/3.txt I just 'viewed source' I saw all the correct source-code.. The problem is where it says :- performing query - no error I think its the while-loop that is wrong - Its not displaying the list of databases.. it displays the no error remark - but then nothing happens... (my pc at home has php active..) PS - Some text refers to a joke-list example - Ive changed it a bit... im stuck on the while-loop The website i got it from (in my last few posts) didnt have an adequate example of what i want to do.,.. G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't connect
I downloaded mysqlgui linux semi static binary and installed it. I copy my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up it prompts for password then indicates that it can't connect. I am using the same USER/PASS that I use successfully with mysql --user=USER --password=PASS. Yet I get the error: Can't connect to local MySQL server through socket (111) My .my.cnf and MySql.options files are below. How do I correct this? Carl # Options file generated by MySQL client user=cwk host=localhost port=3306 num_of_queries=20 timeout=60 defbase=gxsnmp socket= queries_file=/home/cwk/.mysql_history queries_root=/home/cwk/.guiclient/queries last_database_file=/home/cwk/.guiclient/ladb terminator=, enclose=' password=1 compress=0 ask=1 max_width=50 update_timeout=10 font_used= style_file= # Example mysql config file. # You can copy this to one of: # @sysconfdir@/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] port=3306 host=localhost user=cwk [client_fltk] help_file=~/.guiclient/MySQL.help client_file=~/.guiclient/MySQL.options history_length=20 #database = telcent queries_root=~/.guiclient/queries last_database_file=~/.guiclient/ladb -- Carl W. Kalbfleisch NTT/VERIO www.nttverio.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
PS: RE: Newbie - Different commands....?
Ive uploaded it to one of my sites (doesnt have PHP - (I dont think..)) as a text file... http://homepages.slingshot.co.nz/~gordon52/3.txt I just 'viewed source' I saw all the correct source-code.. Ive changed some text of my PHP script :- New lines are :- (see above URL - view source ) - if ($result) { echo(pperforming query - no error: . mysql_error() . /p); echo(Result - . $result . /br); while ( $row = mysql_fetch_array($result) ) { echo(p . $row[JokeText] . /p); } } - When i view the screen on the website, here is what i see... --- performing query - no error: Result - Resource id #2 --- Now - What is Resource id #2 - I think it means ive got 2 databases to choose from ... But how do i list the actual database names ? G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - ERROR 2002
G'day, I keep on getting the following error message when trying to connect to MySQL - ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' This can be fixed by creating a link from the /tmp/mysql.sock file. Which I have done and still get the same error I have searched on Google and on Mysql.com (plus a whole range of other Linux sites) and I realize the default directory for Mysql was the directory as it comes with RH7.2 - I have re-installed a newer version of MySQL with RPMs and still get the same error. Before I try re-install with the binary version has anybody had a similar problem ? Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LDAP authentication for mySQL databases
I'd like to authenticate mySQL users against an LDAP directory. Can I do that? If so, how? Couldn't find anything anywhere ... Thanks, Johannes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: To run MySQL Server from the remote machine
-Original Message- From: Chetan Lavti Sent: Thursday, March 28, 2002 11:39 AM Subject: RE: To run MySQL Server from the remote machine hi, Is it possible to Start the MySQL Server from the remote machine..?? Mysql provides a Api's for shut down the server from the remote place i.e. ( mysql_shutdown(mysqlhadler)) but I can't see any api for starting the Mysql server from the remote machine. Does it mean that every time when I have to run the server it will be done manually... Please, if anybody knows about this..?? do help me.. I have to do this as soon as possible...?? 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: Newbie - Different commands....?
* Gordon Stewart [...] http://homepages.slingshot.co.nz/~gordon52/3.txt [...] while ( $row = mysql_fetch_array($result) ) { echo(p . $row[JokeText] . /p); [...] But how do i list the actual database names ? The result column of the show databases command is named Database, not JokeText. -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Calculate current age with given birthday
On Sat, 30 Mar 2002, Paul DuBois wrote: At 17:15 -0500 3/30/02, Michael Stassen wrote: On Sat, 30 Mar 2002, Paul DuBois wrote: At 21:25 +0100 3/30/02, Roger Baklund wrote: * Son Nguyen == I tried this query, but... it's not working out: SELECT YEAR(now()-birthday) from users where loginName=test; You are very close: SELECT YEAR(now())-YEAR(birthday) as age from users where loginName=test; That won't adjust for the relative difference within the calendar year of the two dates. This works better: mysql SELECT - YEAR(CURDATE()) - YEAR(birthday) - - IF(RIGHT(CURDATE(),5) RIGHT(birthday,5),1,0) - AS 'age in years' - FROM users WHERRE loginName=test; Or SELECT YEAR(FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS(birthday))) AS 'age in years' FROM users WHERE loginName='test'; Michael mysql SET @birth = CURDATE() - INTERVAL 1 YEAR; mysql SELECT - CURDATE(), @birth, - YEAR(FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS(@birth))) - AS 'age in years'; +++--+ | CURDATE() | @birth | age in years | +++--+ | 2002-03-30 | 2001-03-30 |0 | +++--+ Yes, it seems from_days(N) expects N to be days since -00-00, rather than -01-01, which is reasonable. Thus, 0001-01-01 is from_days(366), so I was off by one day. I should have said YEAR(FROM_DAYS(1 + TO_DAYS(CURDATE()) - TO_DAYS(birthday))). On the other hand, now that I think about it, there may be certain combinations of CURDATE and birthday which will still be off by one (for a day) due to leap year. So your way is better (and it's in the manual! http://www.mysql.com/doc/D/a/Date_calculations.html). mysql SELECT - CURDATE(), @birth, - YEAR(CURDATE()) - YEAR(@birth) - - IF(RIGHT(CURDATE(),5) RIGHT(@birth,5),1,0) - AS 'age in years'; +++--+ | CURDATE() | @birth | age in years | +++--+ | 2002-03-30 | 2001-03-30 |1 | +++--+ While looking into this, however, I ran across some strange behavior for from_days and to_days which I didn't expect. from_days(N) appears to work only for N=366. mysql select from_days(1), from_days(365), from_days(366); +--+++ | from_days(1) | from_days(365) | from_days(366) | +--+++ | -00-00 | -00-00 | 0001-01-01 | +--+++ I would have expected -01-01, -12-31, 0001-01-01, respectively. Perhaps there's a good reason for this. If not, I'd call it a bug. to_days(D) appears to work only for D = 0200-01-01 mysql select D, to_days(D), from_days(to_days(D)) from day_test; +++---+ | D | to_days(D) | from_days(to_days(D)) | +++---+ | -00-00 | NULL | NULL | | -01-01 | 730485 | 2000-01-01| | -12-31 | 730850 | 2000-12-31| | 0001-01-01 | 730851 | 2001-01-01| | 0069-01-01 | 755688 | 2069-01-01| | 0070-01-01 | 719528 | 1970-01-01| | 0099-01-01 | 730120 | 1999-01-01| | 0100-01-01 | 730485 | 2000-01-01| | 0169-01-01 | 755688 | 2069-01-01| | 0170-01-01 | 756053 | 2070-01-01| | 0199-01-01 | 766645 | 2099-01-01| | 0200-01-01 | 73049 | 0200-01-01| +++---+ I imagine this is Y2K related, as it seems to be treating my 4-digit years as if they were 2-digit for to 0099, or 3-digit for 0100 to 0199. But I really did specify 4 digits! Perhaps there's a good reason to do this, but again, if there isn't, I'd call it a bug. Of course, I don't expect MySQL to be too worried about these. They did tell me, after all, that to_days and from_days aren't intended for dates before 1582, due to the calendar change, and the date type itself isn't supported before year 1000. But, I think there's a difference between saying the output will be inaccurate for early dates because the calendar changed and saying your output will be wrong even if you pretend the current calendar was always in effect. Regardless of calendar changes, I would have expected FROM_DAYS(TO_DAYS(D)) = D and TO_DAYS(FROM_DAYS(N)) = N. I would have been wrong for D 0200-01-01 and N 73049. At the very least, it would be nice if the ranges for which these functions are mathematically valid were included in the docs. Now that I've made a mountain out of a molehill, I think the real problem is that while we have methods to add/subtract an interval to/from a
komma and dot
Hi, How I can use ',' instead of '.' in a number values in mysql. I changed charactermap but nothing. MySQL 3.23.41 RH7.2 Liivar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP/MySQL/XML
I have created a database called friends with four columns: Name / Address / City / State I also made an XML file to coincide with those variables: test contacts friends nameFriend 1/name address999 Foo Avenue/address cityFoo Town/city stateFO/state /friends /contacts /test The variables in the XML doc above are already in the database BUT - what I want to do - using PHP and MySQL - is something like this: $connection = mysql_connect(localhost, foo, bar) or die (Could not connect to server.); $db = mysql_select_db(friends) or die (Could not select database.); $sql = select * from friends order by name asc; $sql_result = mysql_query($sql, $connection) or die (Could not execute query.); echo ?xml version=\1.0\ encoding=\ISO-8859-1\?\n; echo ?xml-stylesheet type=\text/xsl\ href=\friends.xsl\?\n\n; echo test\n; echo \tcontacts\n; echo \t\tfriends\n; echo \t\t\tname; echo $name; echo \t\t\t/name\n; echo \t\t\taddress; echo $address; echo \t\t\t/address\n; echo \t\t\tcity; echo $city; echo \t\t\t/city\n echo \t\t\tstate; echo $home; echo \t\t\t/state\n; echo \t\t/friends; echo \t/contacts; echo /test; ? Can this be done and am I going about it the right way? Should you have any questions, comments or concerns, feel free to call me at 318-338-2034. Thank you for your time, Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A == Bayou Internet..(888) 30-BAYOUhttp://www.bayou.com Mississippi Internet...(800) MISSISSIPPI...http://www.mississippi.net Vicksburg Online..(800) MISSISSIPPIhttp://www.vicksburg.com == Tel: (318) 338-2034ICQ: 38823829 Fax: (318) 323-5053 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php