Re: 7 MySQL Language Reference till the end ,on my hard drive back home
On Wed, Jul 04, 2001 at 11:03:25PM -0700, Ken Sommers wrote: Is there any way to get from chapter 7 MySQL Language Reference till the end of the MySql Manual,on my hard drive back home? I'm a bit confused. Are you looking for the downloadable manual? It's on www.mysql.com along with all the other downloads. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 140,365,739 queries (85/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
download Mysql manual to win 95?
Hello, how do I download the Mysql manual to win 95? what is a Tarball? Ken
Mysql and Cobalt
Hi all, just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so ne recommendations on how to go about doing it? thanx heaps D --- Send the right message --- + Today freemail + Get your free, private email address at http://www.today.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: download Mysql manual to win 95?
On Wed, Jul 04, 2001 at 11:31:01PM -0700, Ken Sommers wrote: Hello, how do I download the Mysql manual to win 95? what is a Tarball? It's sort of like a ZIP file on Windows. You can use WinZip to extract it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 140,535,024 queries (86/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
Unicode Support in MYSQL C -API
Sir/Madam, I am using MYSQL C-API to access MYSQL database . I am having problems when i gave Unicode support to my code, as the API functions accept parameters of the type const char * .With Unicode support the values being passed are the of the type unsigned short. Is there any way I can make the MYSQL functions UNICODE compatible. Please suggest some solution in form of code changes or API to overcome my problem. Thank You. Regards Jofy
always get error when check table
Hi, I use php to connect to mysql server. after that I check my table, myisamchk report that client not properly close the connection how to avoid this error? where should I check? thx. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Big ass query?
Hi ya'll! I have a little problem with a query, no actually not o little problem but a big one. I haven't got o clue how to write it. This is what I want: This is the table id | drink_id | ing_id | vol_id --- 1 | 10 | 1 | 5 2 | 10 | 5 | 1 3 | 10 | 2 | 3 4 | 11 | 5 | 6 5 | 11 | 3 | 23 5 | 11 | 9 | 57 6 | 12 | 34 | 11 7 | 12 | 21 | 9 8 | 12 | 32 | 34 9 | 13 | 89 | 3 10 | 13 | 76 | 7 11 | 13 | 23 | 54 12 | 13 | 7 | 10 13 | 14 | 5 | 22 14 | 14 | 1 | 34 15 | 15 | 39 | 21 16 | 15 | 27 | 2 17 | 15 | 50 | 5 18 | 16 | 3 | 45 19 | 16 | 5 | 35 If a person enters that he has the following ing_id 1, 2, 3, 5 I whant to get the drink_id wich has 1, 2, 3 OR 5 but NOTHING else. So if I would run this query I would get the following drink_id: 10 because it has ing_id 1,5,2 14 because it has ing_id 5,1 16 because it has ing_id 3,5 NOT 11 because it has ing_id 5,3 AND 9 and there is not a 9 in the list. Someone? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[3]: Proposition: Attach a comment to each connection
Bonjour Werner, My web site as a lot of hits (really!), it's load balanced on the web side on more than 30 servers. I've to save database load as much as possible. The problem with your implementation is that it needs at least one more insert query for each page or even more if there are more than one query on the page. Web pages (PHP) are not the only things doing queries on my Mysql servers. There are a lot of cronjobs in Perl or C which are recording data, doing some maintenance and that from many machines. Implementing recording a query log like the one you described would generate really to much queries and would ask a lot of work. What I though was to had an information in Mysql on it's clients connection. For example, we could add one more parameter to mysql_real_connect : MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag, char *comment) Which could be use like : mysql_real_connect(mysql,myserver.com,me,mypass,mydb,3306,null,0,From page .phtml on server X); Mysql would keep in memory, with other data about that connection, the comment From page .phtml on server X. Then mysqladmin process would return : +--+---+-+--+-+--+---+-+-+--+ | Id | User | Host| db | Command | Time | State | Comment | | Info | +--+---+-+--+-+--+---+---+--+ | 1405 | me| xxx.xxx.xxx.xxx | mydb | Query | 3| | From page |.phtml on server X | SELECT FORM ... | | 5973 | root | localhost | | Query | 0| | | | show processlist | +--+---+-+--+-+--+---+---+--+ This would be really helpful, in my opinion not to hard to implement in Mysql and easy to use from the client. This would not use much memory (only a string for each connection which number is limited) and would not ask more work to Mysql and the server. Regards, Alex. WS How about tracking your own record until then? Create a table and WS insert a record for each connection. WS If you would use a class to connect like db_mysql.inc from WS PHPLIB, it would be a snap to implement. From php, you know all WS sorts of variables to identify your general setting. WS I assume that the query itself will identify the job quite WS easily, so you use that in a text field to track your query. WS The Link-ID would identify your connection, which would be a WS permanent connection most probably. I think that this is what you WS call process, right? WS If you don't need all that information, just drop some of that. WS The table will grow pretty big very fast, if you record all WS connections, but so what? Any tracking record is of that kind, WS and Apache does well recording all hits, so this should't be much WS of a problem. WS You might as well normalize your table to get the most out of it. WS If you invest a little more work or don't work with a class, you WS would introduce, say two parameters, file name and line number, WS and go through all your code and supplement the queries with this WS information (and wirte a wrapper function for it, in case of no WS class, to issue the query and record the data). WS It is a one time work. Then you would have no problem finding out WS where any query comes from. WS This is exactly the kind of information you might be interested WS in, which MySQL cannot provide by itself, AFAICS. WS Am I naive or is this a viable proposition? WS Sie schrieben am Mittwoch, 4. Juli 2001, 23:59:44: Bonjour, I sent this post a few days ago but it didn't get a lot of contributions. Wouldn't it be an interresting feature ? When you have a big web site with a lot of pages, programs, cronjobs, applications ... connecting to Mysql, it's sometimes difficult to find from where a given query/connection comes from. And it's sometimes urgent to find the origin of a disturbing query. So, I think it would be great to be able to give a comment when connecting to Mysql. mysqladmin processlist could show this comment and this may be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
Re: Can't download files from MySql.com
try going downloading it from www.rpmfind.net thats a good site too bye Luis - Original Message - From: Michael Tam [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 12:36 AM Subject: Can't download files from MySql.com Hi all, Did anyone experience any difficulty on downloading files from mysql.com?? I tried to download MyODBC from the download page but none of the downloads seems working at all Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: different subdir for database
At 12:10 05/07/2001 +0800, Jaime Teng wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and NT/Win2k. 3- mysqld-max-nt.exe the optimized version for NT/Win2k with support for named pipes. The Max stuff besides the support of symbolic links has the support of transactional tables InnoDB and BDB. Below the instructions how to use the symbolic link. Notice if you don't want the support of InnoDB and BDB tables un comment the variables skip-innodb and skip-bdb. Otherwise read the item 8.7.2 InnoDB startup options of the \mysql\docs\Manual.html. 1- Create the configuration file c:\my.cnf or \windir\my.ini.file. 2- Edit the configuration file: [mysqld] basedir=c:/mysql datadir=c:/mysql/data use-symbolic-links #skip-innodb #skip-bdb Notice that in the sample above, you have the grant tables on c:\mysql\data. If you want to have all the databases on d:\ecom, so you don't need to use symbolic link, you only need to move the all c:\mysql\data\mysql directory to d:\ecom\mysql and modify the variable datadir=d:/ecom. Now assuming that you want a database called mylink on d:\ecom. First create on c:\mysql\data directory a file called mylink.sym. Edit this file with the text: d:\ecom\mylink Create the directory d:\ecom\mylink Regards, Miguel Hi, I have mysql on NT4 (soon to be win2000). one question is that the database files all reside under drive c. NT does not have symbolic link is there a way to tell mysql that a particular database is located on a different folder? where is the documentation for this one? jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alternate database handlers / tests
Hi, did anybody ever try to run the standard test suite with another table handler? We think about switching to InnoDB, but we see problems..: - The maximum blob/text length. We use MySQL for our support emails. (Restructuring the database to use a mix of InnoDB and myISAM would work, but not in the short term.) The docs say this should be fixed by now, but is it?? - No fulltext index on non-MyISAM tables. (Why not? You could keep the fulltext index in a separate file.) - The worst, though, is that the standard test suite fails when using InnoDB as the default handler. IMHO it shouldn't -- all tests which are not table-specific should work with all tables, and those that are should explicitly specify the table type they need. -- Matthias Urlichs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unlock tables when process has killed.
Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? Thanks in advance. Nick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
three tables and count() - Urgent i need it to my job !!
Hi my friends !! Some few days i have problems with count(). i have 3 tables: t1 holds: +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | | 5 | five | | 6 | sixs | +++ t2 holds: ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1| 2001-07-03 15:03:34 | | 2 | 1| 2001-07-03 15:03:34 | | 3 | 1| 2001-07-03 15:03:34 | | 4 | 2| 2001-07-03 15:03:34 | | 5 | 3| 2001-07-04 12:00:00 | | 6 | 3| 2001-07-04 12:00:00 | | 7 | 4| 2001-07-04 13:11:00 | ++---+-+ t3 have it: ++---+-+ | id | id_t1| t| ++---+-+ | 1 | 1| 2001-07-04 13:11:00 | | 2 | 2| 2001-07-04 13:11:00 | | 3 | 3| 2001-07-04 13:11:00 | | 4 | 1| 2001-07-04 13:11:00 | | 5 | 4| 2001-07-04 13:11:00 | | 6 | 4| 2001-07-04 13:11:00 | | 7 | 4| 2001-07-04 13:11:00 | ++--+--+ so, my target is: how many rows there are in table t2 and t3 coresponding to t1. Column id_t1 in t2 and t3 are values that are present in t1.id. It is important, it must be one query to database. I make this query: select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc But the result is not correct. What shuld to be a query to get right result ??? i would like to have this (it is correct): id | number | count(t2_id1) | count(t3_id1)| 1 | one | 3 | 2 | 2 | two | 1 | 1 | 3 | three| 2 | 1 | 4 | four | 1 | 3 | 5 | five | 0 |0 | 6 | six| 0 |0 | Does anybody help me p.s; mayby that is impossible ?? Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
Re[4]: Proposition: Attach a comment to each connection
Bonjour Werner, Am I naive or is this a viable proposition? WS Oh, I see, you would like to connect this information with the WS pid, right? I wouldn't know how to do that. How do you get a pid? WS Is this something MySQL could provide? No, not with the pid. With the number of places from where sql queries are executed and the number on different queries, it's not always easy to find from where a query, which is for example locking Mysql, as been executed. The only thing I would like is to be able to attach a comment to a connection id which could be returned by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems Installing MySQL
We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux 7.1 Deluxe Edition installed. We would like to create databases in MySQL and use PHP scripting to enable the apache web server to provide access to the database via an intranet or the internet. Initially we selected MySQL to be installed during the Red Hat Linux installation. When we ran the ³mysqladmin u root ping² command we received an error message stating that the MySQL Daemon did not start. We then ran ³./bin/safe_mysqld user=mysql ² command which started the Daemon, but we still could not launch MySQL. We contacted Red Hat Support and they pointed us to your site where we printed out ³Installing MySQL². However we are still having problems with the installation. 1. We created a Directory /usr/local/mysql and copied the following files from the Red Hat Linux 7.1 CD to the /usr/local/mysql Directory: mysql-3.23.36.1.i386.rpm : mysql-devel-3.23.36.1.i386.rpm :mysql-3.23.36.1.i386.rpm : mysqlclient9-3.23.22.4.i386.rpm : mysqlserver-3.23.36.1.i386.rpm 2. We then ran the rpm i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm Command from the /usr/local/mysql Directory and received an error message that the file did not exist. 3. We then ran the rpm i mysql-3.23.36.1.i386.rpm mysqlclient9-3.23.22.4.i386.rpm Command from the /usr/local/mysql Directory. Something happened, but the var/lib/mysql Directory was not created. Could you please help with the installation. Can we make MySQL accessible via the KDE main menu if the installation is successful? Best regards Gavin Phillips-Page
Re: Unlock tables when process has killed.
On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR :Can't find file: './mysql/host.frm' (errno: 13)
Allthough I had changed the permission of the directory, my troubles follow again, I reinstall the package and all turn rigth. -Mensaje original- De: Gerald Clark [SMTP:[EMAIL PROTECTED]] Enviado el: martes 3 de julio de 2001 16:52 Para: [EMAIL PROTECTED] Asunto: Re: ERROR :Can't find file: './mysql/host.frm' (errno: 13) No, that is permission denied. chown -R mysql /var/mysql ( or whatever data path is ) Werner Stuerenburg wrote: The error indicated means that the table host is missing. I would reinstall the package. If it doesn't work, I would download the latest package from mysql.com and install that (it is the recommended path, anyway) - it works fine. -- Gerald L. Clark [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
Init Mysql throuht the sockets
I´ve already installed mysql, but i can only connect via TCP/IP, and i can´t do it by socket. I´ve got all the permissions rigth and the mysql.socket file in the rigth directory. Can anybody help me? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 3.23.38 bug
Hello mysql, It seems like if load data infile initiated to dammaged table sometimes after repair it does not unblock itself: maindb:/spylog/db/tmpd # mysqladmin processlist | grep -v Sleep ++--++---+-+---+--+--+ | Id | User | Host | db| Command | Time | State| |Info | | ++--++---+-+---+--+--+ | 30 | root | localhost | tmpd | Query | 71545 | | |load data infile '/spylog/db/tmpd/domip.txt' ignore into table domip | | | 12122 | root | localhost | tmpd | Query | 67021 | Locked | |select count(*) from domip | | | 58048 | titan| hydra.local| | Query | 0 | preparing| |select id,cy,ts from misc.yandex_sites where url='auto.dp.ua' | | | 109643 | titan| emerald.local | | Query | 1 | Sending data | |select lsl.status, lsl.source_id fr | | 111042 | titan| emerald.local | counter | Query | 0 | preparing| |SELECT * from statistics.user_options where stat_id='53' and SITE_ID='153529' | | | 111337 | root | localhost | | Query | 0 | | |show processlist | | ++--++---+-+---+--+--+ If I'm not mistaken this problem presented couple of months ago for select statement, may be it's the same sort of bug. During this almost 20 hours mysql does not show any disk/CPU load which should be if this process would go, also data file for domip table did not change. -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: Proposition: Attach a comment to each connection
The only thing I would like is to be able to attach a comment to a connection id which could be returned by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. Yes!! Great idea. This would be helpful for hosters with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unlock tables when process has killed.
Sorry. It's possibly a bug under WinNT (version 3.23.39). For Linux (debian) is OK (version 3.23.39).! Now KILL id_process executed and executed hitherto. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 11:24 AM Subject: Re: Unlock tables when process has killed. On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[6]: Proposition: Attach a comment to each connection
The only thing I would like is to be able to attach a comment to a connection id which could be returned by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. AB Yes!! Great idea. This would be helpful for hosters with many AB client-connectors to identify them. It could contain for example the name of AB the client-application (useragent), client-OS and some version-info. i AB think 100 chars will do. It would be some char where you can put any comment you would like depending on your needs. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
This thread has been interesting to follow. But I considered it completely blue sky. Are you guys supporting a change to the MySQL wire protocol? Are you guys supporting a change to _all_ API's that currently use MySQL that would then have to stick somewhere all these nice things in the exchange connection handshake? What is the idea of the user agent in this case? I suppose what is meant is that the thinking is that this comment field in the wire protocol would be loaded up with whatever the API wanted. On a typical web site running Apache/PHP/MySQL, the sequence would have to be, I think: 1. PHP gets the user agent 2. PHP passes the arg to the connection request 3. This user agent sticks in the data in the wire protocol. 4. MySQL sticks this user agent into a (new) datastructure somewhere associated with the connection. 5. A (new) API call to MySQL can fetch this information What am I missing here? It seems to me that all you are asking for is 1. Change in the wire protocol 2. Design change in the MySQL API 3. Upgrade of all applications using the API in the world 4. Depending on all programs to stick data in this requested comment field in the same consistent manner, unless you are asking for more riders/piggybacks and more fields in the wire protocol such as user agent. Again, what am I missing here? I don't see this as a so-called trivial thingy. It maybe could be done in one local place (as first requested), but this isn't trivial, and has no trivial impact, if it is to be used generally. _jef Ansgar Becker wrote: The only thing I would like is to be able to attach a comment to a connection id which could be returned by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. Yes!! Great idea. This would be helpful for hosters with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compile
Hi! I download mysql 3.23.39 source code and compile it on HP-UX 11.00. It shows error message as attached text file. Can you tell me how to solve it? Thank you for replying. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE
Hi, I have a CSV-file exported from another database. It contains fields with dates and dates and times. A somplefied CSV-file version looks like so. 20.12.1999;21.12.1999 03:35:27 When I import it with LOAD DATA INFILE... and use fieldtypes date and datetime it sadly does not work. It imports as many records as lines are given in the file to import but each date is zero (NULL). Is there a possibility to import it that simple way rather to import it as text in one table and export it using date conversion-functions in another table? Best Regards Bernhard Dobler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
client library
Hi! Sorry for bothering you again. Can you tell me more about how to compile client library? I want to install DBD module after installing mysql binary and it can't find client library. Is it true that if I compile source code successfully, it will be included? It seems that the document of DBD module says, I need to compile mysql source so that library will be included. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE
From my experience, if you want to import data into a date field, you have to make sure that the date format in your csv file conforms to a date format required by MySQL. This part is covered in MySQL documentation. So, your 20.12.1999 date should become 2001-12-20 and so on. P.S. Don't forget to specify TERMINATED BY ',' while using LOAD DATA INFILE. I use this feature VERY often and never had any trouble.. :-) Bernhard Doebler wrote: Hi, I have a CSV-file exported from another database. It contains fields with dates and dates and times. A somplefied CSV-file version looks like so. 20.12.1999;21.12.1999 03:35:27 When I import it with LOAD DATA INFILE... and use fieldtypes date and datetime it sadly does not work. It imports as many records as lines are given in the file to import but each date is zero (NULL). Is there a possibility to import it that simple way rather to import it as text in one table and export it using date conversion-functions in another table? Best Regards Bernhard Dobler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Linking C++ API
Malkhaz Mangoshvili writes: Hello. My name is Mike. I am writing a C++ program to access a MySQL database. I have MySQL-3.23.36 server running on Linux Mandrake 8.0. I downloaded mysql++-1.7.9 version from the internet and installed it successfully. When I try to compile my C++ program using: g++ /usr/local/lib/libsqlplus.so - it compiles ,but after typing a.out to run my program it gives me such an error message: a.out: error while loading shared libraries: libsqlplus.so.1: cannot load shared object file: No such file or directory. I don't know how to fix this problem. I tried from mysql manual pages by entering my login and password, but I couldn't get any information. Please if anybody could help me I would appreciate that. Thank you. Follow normal building steps : automake (ignore warnings) autoconf ./configure make make install (as root) and then make a directory containing libsqlplus.so visible to your dynamic linker. -- 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
Re: Proposition: Attach a comment to each connection
I don't know why I got interested in this thread... I suppose you don't need a change to the wire protocol if you have, logically, something like below. The API has to be changed, however. id = do_a_connedtion(arg) set_comment_on_connection(id, this_is_my_comment) // later some_array = get_connection_comments() // parse the array comments // do something or other as function of comment Question: Why, again, do you want this? You must see some utility in this other than academic interest, or taking statistics, or mischief, such as munging some field returning data to a Windows client with Screw Bill Gates prepended to his blob requests, or kicking off connections to, say, any client in Tana Tuva. For readers like me, sitting on the sidelines, the need for this facility is obscure. Please make your case more evident. _jef -- Ansgar Becker wrote: The only thing I would like is to be able to attach a comment to a connection id which could be returned by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. Yes!! Great idea. This would be helpful for hosters with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permission
Hi All ! I have just installed MySQL and do not know how to setup permissions for the database that I have just created. Can anyone help Thanks Pankaj Ahuja - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems Installing MySQL
We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux 7.1 Deluxe Edition installed. We would like to create databases in MySQL and use PHP scripting to enable the apache web server to provide access to the database via an intranet or the internet. Initially we selected MySQL to be installed during the Red Hat Linux installation. When we ran the ³mysqladmin u root ping² command we received an error message stating that the MySQL Daemon did not start. We then ran ³./bin/safe_mysqld user=mysql ² command which started the Daemon, but we still could not launch MySQL. We contacted Red Hat Support and they pointed us to your site where we printed out ³Installing MySQL². However we are still having problems with the installation. 1. We created a Directory /usr/local/mysql and copied the following files from the Red Hat Linux 7.1 CD to the /usr/local/mysql Directory: mysql-3.23.36.1.i386.rpm : mysql-devel-3.23.36.1.i386.rpm :mysql-3.23.36.1.i386.rpm : mysqlclient9-3.23.22.4.i386.rpm : mysqlserver-3.23.36.1.i386.rpm 2. We then ran the rpm i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm Command from the /usr/local/mysql Directory and received an error message that the file did not exist. 3. We then ran the rpm i mysql-3.23.36.1.i386.rpm mysqlclient9-3.23.22.4.i386.rpm Command from the /usr/local/mysql Directory. Something happened, but the var/lib/mysql Directory was not created. Could you please help with the installation. Can we make MySQL accessible via the KDE main menu if the installation is successful? Best regards Gavin Phillips-Page
Re: Mysql and Cobalt
dijana cetinic writes: Hi all, just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so ne recommendations on how to go about doing it? thanx heaps D I have never done it, but those that have done it have used ODBC. Nije lako ali je moguce . -- 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
RE: Insert queries add TWO records to database
I'm not convinced as I have the same problem in Netscape. More likely to be a PHP or MySQL configuration problem as the code is fine. Or maybe IIS? May try it on a different server. Regards, John Stoops Software Engineer _ Neutralize (*\*) Independent Online Marketing Services T/F: +44 (0)1209 210910 E: [EMAIL PROTECTED] U: http://www.neutralize.com _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this by persons or entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. The contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While NUERA Limited has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. -Original Message- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 03:48 To: [EMAIL PROTECTED] Subject: Re: Insert queries add TWO records to database On Wed, 4 Jul 2001 21:22, you wrote: I think I saw on the mysql list you had pinned this problem on IE? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Beam me up Scotty. This isn't the men's room. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unlock tables when process has killed.
Thanks, Miguel.
I understand.
If after killing a process, program of this process come to the end
incorrectly (fail), then the table remains locked.
Something like have than mysql.exe after killing process don't touch. Other
mysql.exe will wait for this process killed, but it doesn't kill while
mysql.exe executed.
Sorry for my English.
Nick.
At 12:26 05/07/2001 +0300, Nick Kostirya wrote:
Hi!
Nick I have interest how you did the lock and how
the table remains locked on NT. Below I show you
a sequence on Win2k machine and how you see after
a kill I was able to insert a new row to the table.
The client was put down without to close the connection ?
E:\mysql\binmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.39-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql lock tables mm1 read;
Query OK, 0 rows affected (0.00 sec)
mysql insert into mm1 values ('',more one test);
ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated
mysql show processlist;
+++---+--+-+--+---+-
-+
| Id | User | Host | db | Command | Time | State | Info
|
+++---+--+-+--+---+-
-+
| 1 | miguel | localhost | test | Sleep | 0| | NULL
|
| 7 | ODBC | localhost | test | Query | 0| NULL | show processlist
|
+++---+--+-+--+---+-
-+
2 rows in set (0.00 sec)
mysql kill 7;
Query OK, 0 rows affected (0.00 sec)
mysql unlock tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:8
Current database: test
Query OK, 0 rows affected (0.22 sec)
mysql insert into mm1 values ('',more one test);
Query OK, 1 row affected (0.05 sec)
mysql
Regards,
Miguel
Sorry. It's possibly a bug under WinNT (version 3.23.39).
For Linux (debian) is OK (version 3.23.39).!
Now KILL id_process executed and executed hitherto.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Nick Kostirya [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 11:24 AM
Subject: Re: Unlock tables when process has killed.
On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote:
Hello, All.
Help me.
One process locks a table. Then it has been killed. The table
remains locked. How unlock the table if the process is not exist?
If that's what happened, you've found a bug in MySQL. Can you reliably
reproduce it? What version are you using?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Cobalt
At 07:45 05/07/01, dijana cetinic wrote: Hi all, just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so ne recommendations on how to go about doing it? I've installed it on a Cobalt RAQ. I tried several of the rpm files (from both MySQL and Red Hat), but none of them worked, so in the end I downloaded the source tarball: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39.tar.gz) and then followed the instructions on MySQL.com. The chapter in the online manual is 4.7 Installing a MySQL Source Distribution which you can find at: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_source I didn't have any problems doing it this way - I accepted all the defaults when prompted and it worked first time. It is more timeconsuming than using a binary or rpm, but the Cobalt is such an odd environment that the source is probably the best option! Mark -- With sufficient thrust, pigs fly just fine. From RFC1925 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[3]: Trouble with mysql
Hello Michael, Wednesday, July 04, 2001, 1:49:25 AM, you wrote: MW Next time the table gets corrupt, please upload a copy to 'secret' MW before you repair it so that I can take a look at this when I come MW back. OK. MW Do you have anything in the logs about the table being automaticly repaired? No. It's bot autorepaired (only after mysqld crashes) but a lot of 134 errors appears. -- Best regards, Petermailto:[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
First time MySQL
Hi, I am first time user of MySQL. My ISP has just been installed mysql... I have connected to server through telnet and access MySQL by following command.. and connected successfully. mysql -h myhostname -u root -p password :- mysq But when I tried to access any database or trying to create database it is giving error :- Access Denied for [EMAIL PROTECTED] Can any one from you please help me in this regards... Thanks in advance.. Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Enhanced MySQL
Hello All, Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/ Enhanced MySQL and what advantages, if any it may have. THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Fax: 1(225)686-2285 Tel: 1(225)686-2002 Toll Free: 1(800)594-4782 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE
Hi, thanks for your answer. You never have problems since youalways use the date format in the standard way, no european exception ;-) mmhhh... It's hard to make the company administering the original data base change the export format. So I'll have to import dates as strings and somehow convert dates (change the order of day, month and year as well as the delimiter). Any Tip's welcome. Best Regards Bernhard - Original Message - From: --==[bMan]==-- [EMAIL PROTECTED] To: Bernhard Doebler [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 12:23 PM Subject: Re: LOAD DATA INFILE From my experience, if you want to import data into a date field, you have to make sure that the date format in your csv file conforms to a date format required by MySQL. This part is covered in MySQL documentation. So, your 20.12.1999 date should become 2001-12-20 and so on. P.S. Don't forget to specify TERMINATED BY ',' while using LOAD DATA INFILE. I use this feature VERY often and never had any trouble.. :-) Bernhard Doebler wrote: I have a CSV-file exported from another database. It contains fields with dates and dates and times. A somplefied CSV-file version looks like so. 20.12.1999;21.12.1999 03:35:27 When I import it with LOAD DATA INFILE... and use fieldtypes date and datetime it sadly does not work. It imports as many records as lines are given in the file to import but each date is zero (NULL). Is there a possibility to import it that simple way rather to import it as text in one table and export it using date conversion-functions in another table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Enhanced MySQL
Foxserv is also go it has Apache/PHP/MYSQL for Windows Its pretty good and easy to install. http://sourceforge.net/projects/foxserv/ nusphere has Perl and if your not planing on using it theirs no need for it. Cesar Cuneo President Corpsoft Inc. 10855 NW 33 Street Miami FL 33172 Tel. 305-971-8032 Fax. 305-232-2227 Visit our website: --- www.corpsoftinc.com -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Thursday, July 05, 2001 7:24 AM To: [EMAIL PROTECTED] Subject: Enhanced MySQL Hello All, Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/ Enhanced MySQL and what advantages, if any it may have. THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Fax: 1(225)686-2285 Tel: 1(225)686-2002 Toll Free: 1(800)594-4782 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE
This is what i wrote to convert dates in PHP before putting them into db:
$new_date = dbDate($HTTP_POST_VARS[Date]);
// Converts DD/MM/YY to /MM/DD
function dbDate($date) {
$pos1=strpos($date,'/')+1;
$pos2=strpos($date,'/',$pos1)+1;
$month=substr($date,$pos1,$pos2-$pos1-1);
if (strlen($month)==1) {
$month=0.$month;
}
$day=substr($date,0,$pos1-1);
if (strlen($day)==1) {
$day=0.$day;
}
$year=substr($date,$pos2,strlen($date));
if (strlen($year)4) {
if ($year 90) {
$year=20.$year;
} else {
$year=19.$year;
}
}
$date=$year.'-'.$month.'-'.$day;
return $date;
} // dbDate
Maybe able to run a similar function?
John (*\*)
-Original Message-
From: Bernhard Doebler [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2001 12:46
To: [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE
Hi,
thanks for your answer. You never have problems since youalways use the date
format in the standard way, no european exception ;-)
mmhhh... It's hard to make the company administering the original data base
change the export format. So I'll have to import dates as strings and
somehow convert dates (change the order of day, month and year as well as
the delimiter).
Any Tip's welcome.
Best Regards
Bernhard
- Original Message -
From: --==[bMan]==-- [EMAIL PROTECTED]
To: Bernhard Doebler [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 12:23 PM
Subject: Re: LOAD DATA INFILE
From my experience, if you want to import data into a date field, you have
to make sure that the date format in your csv file conforms to a date format
required by MySQL. This part is covered in MySQL documentation. So, your
20.12.1999 date should become 2001-12-20 and so on.
P.S. Don't forget to specify TERMINATED BY ',' while using LOAD DATA
INFILE. I use this feature VERY often and never had any trouble.. :-)
Bernhard Doebler wrote:
I have a CSV-file exported from another database.
It contains fields with dates and dates and times. A somplefied CSV-file
version looks like so.
20.12.1999;21.12.1999 03:35:27
When I import it with LOAD DATA INFILE... and use fieldtypes date and
datetime it sadly does not work. It imports as many records as lines are
given in the file to import but each date is zero (NULL). Is there a
possibility to import it that simple way rather to import it as text in
one table and export it using date conversion-functions in another table?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
error 127
MySQL version .38 With a query that is supposed to retrieve something like 8 records from a MyISAM table, I often get the following error: 010705 16:16:26 read_next: Got error 127 when reading table ./sunbow_domains/junit_userprof and the query aborts. Also, I have very often the following errors: 010705 16:14:44 Aborted connection 110 to db: 'tbook_testimport' user: 'webuser_gamma' host: `servweb.interne' (Got timeout reading communication packets) 010705 16:14:44 Aborted connection 172 to db: 'sunbow_domains' user: 'dmeetoo' host: `192.168.0.42' (Got timeout reading communication packets) 010705 16:14:44 Aborted connection 9 to db: 'sunbow_topics' user: 'webuser_gamma' host: `192.168.0.41' (Got timeout reading communication packets) 010705 16:14:44 Aborted connection 168 to db: 'sunbow_topics' user: 'webuser_gamma' host: `192.168.0.42' (Got timeout reading communication packets) 010705 16:14:44 Aborted connection 8 to db: 'unconnected' user: 'webuser_gamma' host: `192.168.0.31' (Got timeout reading communication packets) 010705 16:14:45 Aborted connection 17 to db: 'sunbow_apps' user: 'webuser_gamma' host: `192.168.0.31' (Got timeout reading communication packets) 010705 16:14:45 Aborted connection 169 to db: 'sunbow_topics' user: 'webuser_gamma' host: `192.168.0.33' (Got timeout reading communication packets) etc... My network is clean, so I do not understand. Any idea on these problems would be of much help Julien
How to create...
Hi, 1) I am migration from Oracle to MySQL DB. How can I create the SEQUENCE and the TRIGGER in MySQL style/way . /**/ CREATE SEQUENCE SYS_MSG_TEMPL_SEQ MINVALUE 1 MAXVALUE 999 CYCLE; CREATE TRIGGER sys_msg_templ_trig BEFORE INSERT ON SYS_MSG_TEMPL REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN SELECT sys_msg_templ_seq.NEXTVAL INTO :new.template_id FROM dual; End; / /**/ CREATE SEQUENCE AD_MNG_SYS_SEQ MINVALUE 1 MAXVALUE 99 CYCLE; CREATE TRIGGER AD_MNG_SYS_TRIG BEFORE INSERT ON AD_MNG_SYS REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN Select AD_MNG_SYS_SEQ.NEXTVAL INTO :new.AMS_ID FROM Dual; END; /**/ 2) what is equal to 'sysdate' (to get/put the system date in a table) in MySQL DB. Thanks, Ilan _ ILAN FAIT Tel: 972-9-9519133 Ex.247iWeb Technologies Fax: 972-9-951913491 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:[EMAIL PROTECTED]www.iweb.com
Re: LOAD DATA INFILE
Hi, it seems to me I have to do something like this. It originally was my goal to only use SQL but this does not seem to be possible. Or do you think it's possible to reformat the string using left(), mid() and right() functions in MySQL and put it in a date-field? Best regards and thanks so far Bernhard Doebler - Original Message - From: John (*\*) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Bernhard Doebler [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 2:13 PM Subject: RE: LOAD DATA INFILE This is what i wrote to convert dates in PHP before putting them into db: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unlock tables when process has killed.
At 14:09 05/07/2001 +0300, Nick Kostirya wrote:
Hi Nick,
One more thing: the client application is running locally in the
same computer of the MySQL server or remotely connected ?.
What type of table you are using: MyISAM, BDB or InnoDB.
Regards,
Miguel
Thanks, Miguel.
I understand.
If after killing a process, program of this process come to the end
incorrectly (fail), then the table remains locked.
Something like have than mysql.exe after killing process don't touch. Other
mysql.exe will wait for this process killed, but it doesn't kill while
mysql.exe executed.
Sorry for my English.
Nick.
At 12:26 05/07/2001 +0300, Nick Kostirya wrote:
Hi!
Nick I have interest how you did the lock and how
the table remains locked on NT. Below I show you
a sequence on Win2k machine and how you see after
a kill I was able to insert a new row to the table.
The client was put down without to close the connection ?
E:\mysql\binmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.39-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql lock tables mm1 read;
Query OK, 0 rows affected (0.00 sec)
mysql insert into mm1 values ('',more one test);
ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated
mysql show processlist;
+++---+--+-+--+---+-
-+
| Id | User | Host | db | Command | Time | State | Info
|
+++---+--+-+--+---+-
-+
| 1 | miguel | localhost | test | Sleep | 0| | NULL
|
| 7 | ODBC | localhost | test | Query | 0| NULL | show processlist
|
+++---+--+-+--+---+-
-+
2 rows in set (0.00 sec)
mysql kill 7;
Query OK, 0 rows affected (0.00 sec)
mysql unlock tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:8
Current database: test
Query OK, 0 rows affected (0.22 sec)
mysql insert into mm1 values ('',more one test);
Query OK, 1 row affected (0.05 sec)
mysql
Regards,
Miguel
Sorry. It's possibly a bug under WinNT (version 3.23.39).
For Linux (debian) is OK (version 3.23.39).!
Now KILL id_process executed and executed hitherto.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Nick Kostirya [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 11:24 AM
Subject: Re: Unlock tables when process has killed.
On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote:
Hello, All.
Help me.
One process locks a table. Then it has been killed. The table
remains locked. How unlock the table if the process is not exist?
If that's what happened, you've found a bug in MySQL. Can you reliably
reproduce it? What version are you using?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permission
Hi, Check out this URL it is very good to start with. URL: http://home.ubalt.edu/abento/797/mysql/ I hope that it will help Best Regards, Ilan _ ILAN FAIT Tel: 972-9-9519133 Ex.247iWeb Technologies Fax: 972-9-951913491 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:[EMAIL PROTECTED]www.iweb.com
Update locking table forever
My site regularly gets extremely slow. When I check the running queries with 'show processlist;' I get this: update XYZ set ... where id=... select ... from XYZ where id=... select ... from XYZ where id=... select ... from XYZ where id=... [...100's of similar selects...] in other words: a single update is locking a table until all threads are used up. How is this possible ? The server is working on one single simple query (the update), the other queries are waiting. What is the server doing ? The problem occurs with different tables XYZ. The tables aren't very large and the indices are simple. I would very much like to hear how I can solve this. My site is getting unacceptably slow and I dont really know what to do. I thought of experimenting with LOW/HIGH priority but decided not to do it because it doesn't make sense to me in this particular case. mysql: 3.23.39 (rpm) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unlock tables when process has killed.
locally and MyISAM
- Original Message -
From: Miguel Angel Solórzano [EMAIL PROTECTED]
To: Nick Kostirya [EMAIL PROTECTED]; [EMAIL PROTECTED]; Miguel
Angel Solórzano [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 3:35 PM
Subject: Re: Unlock tables when process has killed.
At 14:09 05/07/2001 +0300, Nick Kostirya wrote:
Hi Nick,
One more thing: the client application is running locally in the
same computer of the MySQL server or remotely connected ?.
What type of table you are using: MyISAM, BDB or InnoDB.
Regards,
Miguel
Thanks, Miguel.
I understand.
If after killing a process, program of this process come to the end
incorrectly (fail), then the table remains locked.
Something like have than mysql.exe after killing process don't touch. Other
mysql.exe will wait for this process killed, but it doesn't kill while
mysql.exe executed.
Sorry for my English.
Nick.
At 12:26 05/07/2001 +0300, Nick Kostirya wrote:
Hi!
Nick I have interest how you did the lock and how
the table remains locked on NT. Below I show you
a sequence on Win2k machine and how you see after
a kill I was able to insert a new row to the table.
The client was put down without to close the connection ?
E:\mysql\binmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.39-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql lock tables mm1 read;
Query OK, 0 rows affected (0.00 sec)
mysql insert into mm1 values ('',more one test);
ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated
mysql show processlist;
+++---+--+-+--+---+
-
-+
| Id | User | Host | db | Command | Time | State | Info
|
+++---+--+-+--+---+
-
-+
| 1 | miguel | localhost | test | Sleep | 0| | NULL
|
| 7 | ODBC | localhost | test | Query | 0| NULL | show
processlist
|
+++---+--+-+--+---+
-
-+
2 rows in set (0.00 sec)
mysql kill 7;
Query OK, 0 rows affected (0.00 sec)
mysql unlock tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:8
Current database: test
Query OK, 0 rows affected (0.22 sec)
mysql insert into mm1 values ('',more one test);
Query OK, 1 row affected (0.05 sec)
mysql
Regards,
Miguel
Sorry. It's possibly a bug under WinNT (version 3.23.39).
For Linux (debian) is OK (version 3.23.39).!
Now KILL id_process executed and executed hitherto.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Nick Kostirya [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 11:24 AM
Subject: Re: Unlock tables when process has killed.
On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote:
Hello, All.
Help me.
One process locks a table. Then it has been killed. The table
remains locked. How unlock the table if the process is not exist?
If that's what happened, you've found a bug in MySQL. Can you reliably
reproduce it? What version are you using?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
-
Before posting, please check:
RE: Insert queries add TWO records to database
Check your access_log (or IIS equivalent -- if this is occurring on IIS then it's got to be a php bug). I wasn't convinced that it was strictly a browser issue (IE) when apache support laid blame there. However the problem DOES go away by using an older version of apache, AND was not reproducable by telnetting into port 80. Maybe it's a browser/php interaction issue. Try this: telnet www.myserver.com 80 GET /whatevermyproblempageis.phtml See in the log if it gets run twice Check to see if the insert/update is run twice The problem is not with mysql, since I have the exact issue within Sybase I've seen people have it with postgres. Perhaps PHP is somehow internally redirecting the request so it runs twice. My initial suspicion was it was a PHP bug, but like I say, it only occurs with Apache 1.3.20, not on older 1.3.9. Rob. -Original Message- From: John (*\*) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 5:53 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Insert queries add TWO records to database I'm not convinced as I have the same problem in Netscape. More likely to be a PHP or MySQL configuration problem as the code is fine. Or maybe IIS? May try it on a different server. Regards, John Stoops Software Engineer _ Neutralize (*\*) Independent Online Marketing Services T/F: +44 (0)1209 210910 E: [EMAIL PROTECTED] U: http://www.neutralize.com _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this by persons or entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. The contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While NUERA Limited has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. -Original Message- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 03:48 To: [EMAIL PROTECTED] Subject: Re: Insert queries add TWO records to database On Wed, 4 Jul 2001 21:22, you wrote: I think I saw on the mysql list you had pinned this problem on IE? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Beam me up Scotty. This isn't the men's room. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE
Only if the date being converted is a standard length, i.e. not 2/4/99 All dates would have to be DD/MM/ or MM/DD/, eg. 02/04/1999 If so then yes it can be done in MySQL else u wouldn't know your /'s from your dates John (*\*) -Original Message- From: Bernhard Doebler [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 13:35 To: [EMAIL PROTECTED] Subject: Re: LOAD DATA INFILE Hi, it seems to me I have to do something like this. It originally was my goal to only use SQL but this does not seem to be possible. Or do you think it's possible to reformat the string using left(), mid() and right() functions in MySQL and put it in a date-field? Best regards and thanks so far Bernhard Doebler - Original Message - From: John (*\*) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Bernhard Doebler [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 2:13 PM Subject: RE: LOAD DATA INFILE This is what i wrote to convert dates in PHP before putting them into db: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No way to get offending Lines during laod data ?
[EMAIL PROTECTED] writes: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Hi, I know the docs say that Warnings are not stored. However, is there a way to enable some logging, either in the server or locally (if using load date LOCAL infile), that tells me which lines are bad ? I have a few 10k of lines, and don't want to go over them individually... The mentioned select into outfile and diff'ing won't work either, since float are printed with different precision, giving me not a single identical line... Any ideas ? Yours, Steffen /* excerpt from info file */ Warnings occur under the same circumstances as when values are inserted via the `INSERT' statement (*note `INSERT': INSERT.), except that `LOAD DATA INFILE' also generates warnings when there are too few or too many fields in the input row. The warnings are not stored anywhere; the number of warnings can only be used as an indication if everything went well. If you get warnings and want to know exactly why you got them, one way to do this is to use `SELECT ... INTO OUTFILE' into another file and compare this to your original input file. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: three tables and count() - Urgent i need it to my job !!
Ireneusz Piasecki wrote: Hi my friends !! Some few days i have problems with count(). i have 3 tables: t1 holds: +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | | 5 | five | | 6 | sixs | +++ t2 holds: ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1| 2001-07-03 15:03:34 | | 2 | 1| 2001-07-03 15:03:34 | | 3 | 1| 2001-07-03 15:03:34 | | 4 | 2| 2001-07-03 15:03:34 | | 5 | 3| 2001-07-04 12:00:00 | | 6 | 3| 2001-07-04 12:00:00 | | 7 | 4| 2001-07-04 13:11:00 | ++---+-+ t3 have it: ++---+-+ | id | id_t1| t| ++---+-+ | 1 | 1| 2001-07-04 13:11:00 | | 2 | 2| 2001-07-04 13:11:00 | | 3 | 3| 2001-07-04 13:11:00 | | 4 | 1| 2001-07-04 13:11:00 | | 5 | 4| 2001-07-04 13:11:00 | | 6 | 4| 2001-07-04 13:11:00 | | 7 | 4| 2001-07-04 13:11:00 | ++--+--+ so, my target is: how many rows there are in table t2 and t3 coresponding to t1. Column id_t1 in t2 and t3 are values that are present in t1.id. It is important, it must be one query to database. I make this query: select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc Hello, I don't know what exactly you want to count, but one thing seems to be obviously to me: You can't make a left join between t2 and t3 on t3.id_t1=t1.id (line 3 of the query). Pozdrowienia do Polski, Robert Vetter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: three tables and count() - Urgent i need it to my job !!
Original Message - From: Robert Vetter [EMAIL PROTECTED] To: Ireneusz Piasecki [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 4:26 PM Subject: Re: three tables and count() - Urgent i need it to my job !! Ireneusz Piasecki wrote: Hi my friends !! Some few days i have problems with count(). i have 3 tables: t1 holds: +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | | 5 | five | | 6 | sixs | +++ t2 holds: ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1| 2001-07-03 15:03:34 | | 2 | 1| 2001-07-03 15:03:34 | | 3 | 1| 2001-07-03 15:03:34 | | 4 | 2| 2001-07-03 15:03:34 | | 5 | 3| 2001-07-04 12:00:00 | | 6 | 3| 2001-07-04 12:00:00 | | 7 | 4| 2001-07-04 13:11:00 | ++---+-+ t3 have it: ++---+-+ | id | id_t1| t| ++---+-+ | 1 | 1| 2001-07-04 13:11:00 | | 2 | 2| 2001-07-04 13:11:00 | | 3 | 3| 2001-07-04 13:11:00 | | 4 | 1| 2001-07-04 13:11:00 | | 5 | 4| 2001-07-04 13:11:00 | | 6 | 4| 2001-07-04 13:11:00 | | 7 | 4| 2001-07-04 13:11:00 | ++--+--+ so, my target is: how many rows there are in table t2 and t3 coresponding to t1. Column id_t1 in t2 and t3 are values that are present in t1.id. It is important, it must be one query to database. I make this query: select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc Hello, I don't know what exactly you want to count, but one thing seems to be obviously to me: You can't make a left join between t2 and t3 on t3.id_t1=t1.id (line 3 of the query). Pozdrowienia do Polski, Robert Vetter Hi, it's me again. select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc I would like to have this result from above query: this result is correct (i hope) id | number | count(t2_id1) | count(t3_id1)| 1 | one | 3 | 2 | 2 | two | 1 | 1 | 3 | three| 2 | 1 | 4 | four | 1 | 3 | 5 | five | 0 |0 | 6 | six| 0 |0 | With above result i now how many records is in t2 for every records from t1 and how many is in t3 for every records from t1. But, i don't konw, how can i bulid this correct query, to have correct result. Thansk Regards Ireneusz Piasecki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Indexing is slow
Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC wrote: We are using mysql 3.23.39 . We have the table p6882 with following structure : +---+-+--+-+-+-- --+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+-- --+ | id| int(10) | | PRI | NULL| auto_increment | | pc| char(2) | YES | | NULL || | pn| varchar(10) | YES | | NULL || | kd| char(2) | YES | | NULL || | st| char(1) | YES | | NULL || | pb| date| YES | | NULL || | yr| char(2) | YES | | NULL || | an| varchar(13) | YES | | NULL || | ad| date| YES | | NULL || | ec| text| YES | | NULL || | dc| text| YES | | NULL || | ca| text| YES | | NULL || | ip| text| YES | | NULL || | ap| text| YES | | NULL || | ac| text| YES | | NULL || | nm| text| YES | | NULL || | ti| text| YES | MUL | NULL || | cppr | text| YES | | NULL || | pd| date| YES | | NULL || +---+-+--+-+-+-- --+ 19 rows in set (0.00 sec) and we have to create indexes allmost on all fields. Till now we have created index on ti field(Fulltext Index) and now we are creating index on field pc(char(2))(using create index).It has taken over 24 hours and the status is as below : -rw-rw1 root root 1694718180 Jul 4 22:46 #sql-299_a8.MYD -rw-rw1 root root 894477312 Jul 5 09:45 #sql-299_a8.MYI -rw-rw1 root root 8914 Jul 4 09:39 #sql-299_a8.frm -rw-r--r--1 root root0 Jul 5 09:45 index.txt -rw-rw1 root root 1694718180 Jul 3 22:29 p6882.MYD -rw-rw1 root root 853310464 Jul 3 22:29 p6882.MYI -rw-rw1 root root 8914 Jul 3 09:32 p6882.frm Can anyone tell us why it is taking so much time and also how to speed up indexing or something wrong with our table. records in the tables are 93,50,000. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi, You don't give too much details on your system configuration - OS - RAM size - mysql configuration so it is difficult to give you accurate recommandations. However, obviously, you are building very big indexes; you should make your 'key_buffer' as big as possible based on your hardware configuration. In my case, indexing one table went from 4 hours down to 3 minutes after changing this parameter from 16M to 64M and resulting index file was around 50Mb. However, your index file is so big (~900Mb) that it will not fit in memory unless you can allocate ~1Gb to your key_buffer ! Hope this helps -- Joseph Bueno NetClub/Trader.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 mysql is running 10 minutes and then shuts down.
Hi With this message: show table status/usr/bin/safe_mysqld: line 156: 30874 Segmentation fault nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking $err_log 21 Please help want is wrong. Regards Gerlinde BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
web search form for a mysql database
I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of dealer bulletins. I have created a web page to allow easy input of new bulletins into the database, and a second web page to display those bulletins. On this page are links to allow displaying the bulletins in several differant sort orders. This all works just fine. I was asked to also add a search field. I have searched the online docs but cannot find an answer to this: how do I get a user inputted reqest into the mysql query string? Here's what I have tried most recently: (lots of snipped code) form action=bulletin_sorter.php name=form1 Enter a search word(s): input type=text name=body INPUT TYPE=hidden NAME=orderby VALUE=request /form (lots of snippage) elseif ($orderby == 'request'): $sql = select * from bulletin where match (bulletin_subject,body) against '$request'; (lots more snippage) I have tried variations on the above query statement, none of which would work. I can do this without any problem from the mysql command line by entering the word I am interested in searching on. The problem seems to be with the part after against, just how do I get the user input data into that field? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Store picture
- Original Message - From: Duncan Hill [EMAIL PROTECTED] To: MySQL News Group [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 7:46 PM Subject: Re: Store picture On Wed, 4 Jul 2001, Moonesh Suggun wrote: hi To All, Has anyone try to insert images e.h. gif into mysql database.. I have tried using blob type but how would I verify that it is OK. It can be done, however general wisdom is that one should use the filesystem to store images, simply because its designed to store files. At one point I did have a link on how to store images in a database, but after testing, found that is was indeed, more efficient to store the images in the filesystem, and store path pointers to the images in the database. -- Sapere aude My mind not only wanders, it sometimes leaves completely. Greeting To All, Thanks for the advice but how to we store the images.. what should be included in the insert sql command.. I have tried using escape character but only the name is stored not the data... Thanks in advance, Regards, Moonesh _ 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
Re: Query from two different databases ?
use 'select/insert/... db1.tbl2.fields3, ... db2.tbl3.fld4 from db1.tbl2, db2.tbl3 ... ' etc. in your query. Andrey F. Mindubaev wrote: Hi, How to create query to get data from tables of two different databases ? Best regards, Andrey [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[2]: Proposition: Attach a comment to each connection
Bonjour Justin, user agent was just an example of what the commentary could be. You could put what you want as long as it's a string. I agree with you and I already had this reflection that it could be a modification that could create some problems to some. Instead of modifying the protocol and the connection handshake, we could maybe do that through a query. This would be a new type of query which would only modify a field in the connection's data : ... mysql_real_connect(,,,.); mysql_query(SET CONNECTION_COMMENTARY 'Query from page xxx.phtml on server X'); ... JF 4. MySQL sticks this user agent into a (new) JF datastructure somewhere associated with JF the connection. Yes. But once more user agent was an example. On my own I think that there are other information more interesting that could go there. JF 5. A (new) API call to MySQL can fetch this JF information Not necessarily. I mentioned that this connection's commentary could be return in the process list of Mysql (when you do a 'mysqladmin process' for example). Or it could be returned by a query like : mysql_query(GET CONNECTION_COMMENTARY); My idea of this feature is that it could really help a lot in administrating a big database with a lot of connections. JF It seems to me that all you are asking for is JF 1. Change in the wire protocol No. JF 2. Design change in the MySQL API No modification of the API. Only a new query understood by Mysql. I've already been at the source of some modifications in the SQL syntax of Mysql (SQL_BUFFER_RESULT) so I know that when something improves Mysql, something can be coded in Mysql. JF 3. Upgrade of all applications using the API JF in the world No. By default the commentary would be empty or maybe any default information. You would not HATE TO give a commentary. JF 4. Depending on all programs to stick data in JF this requested comment field in the JF same consistent manner, unless you are JF asking for more riders/piggybacks and more fields JF in the wire protocol such as user agent. Nothing new in the communication protocol. A new field in the connection structure + a new query type. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Proposition: Attach a comment to each connection
Bonjour Justin, JF I don't know why I got interested in this thread... More important (or less), why are you so negative ? JF I suppose you don't need a change to the wire protocol if JF you have, logically, something like below. The API has JF to be changed, however. JF id = do_a_connedtion(arg) JF set_comment_on_connection(id, this_is_my_comment) JF // later JF some_array = get_connection_comments() JF // parse the array comments JF // do something or other as function of comment Not even have to modify the API. Read my previous email. JF Question: Why, again, do you want this? You must see some utility JF in this other than academic interest, or taking statistics, or JF mischief, such as munging some field returning data to a Windows JF client with Screw Bill Gates prepended to his blob requests, or JF kicking off connections to, say, any client in Tana Tuva. I see an interest has an administrator of a really big site with 10 Mysql servers each answering more than 1000 queries each seconds. Queries that could come from hundreds of dynamic web pages, scripts, cronjobs, applications ... When something goes wrong, this feature would really help to debug and to fine a lot more quickly where the problems comes from. JF For readers like me, sitting on the sidelines, the need for this JF facility is obscure. Please make your case more evident. Hope this is more clear to you now. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Proposition: Attach a comment to each connection
Bonjour Scott, SH Beyond that, you can already accomplish 90% of what you'd want by SH simply coding your queries as /* Comment */ SELECT ..., and so SH on. For connections which are not currently running a query, this SH won't work - but in my experience, you usually don't care much SH about connections which aren't currently running a query. A really good idea !!! Is the /* comment */ shown in the Info column when you run 'mysqladmin process' ? Or is it showing only the Query itself ? I have to test that. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: web search form for a mysql database
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the string
search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the search string
appears in the filed but as part of the string and not an exact match). We will have
to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a partial value of
$search. Note that I modified $search and added % on both ends. This allows to
search for the search to ignore the leading characters and the characters following
the search string.
Ok, now lets assume we want to search all the field of the table and not only the Name
field. In order to do that we need to choose the records with Name LIKE $srch or Last
LIKE $srch etc. The translation to MySQL query is:
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch' || email
LIKE '$srch' || comment LIKE '$srch';
The complete srch.php3 script top to bottom should look like:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to DataBase);
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch' || email
LIKE '$srch' || comment LIKE '$srch';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 7/5/01 10:13
SUBJECT: web search form for a mysql database
I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of
dealer bulletins.
I have created a web page to allow easy input of new bulletins into the
database, and a second
web page to display those bulletins. On this page are links to allow
displaying the bulletins
in several differant sort orders. This all works just fine. I was asked to
also add a search field.
I have searched the online docs but cannot find an answer to this: how do I
get a user inputted
reqest into the mysql query string? Here's what I have tried most recently:
(lots of snipped code)
form action=bulletin_sorter.php name=form1
Enter a search word(s): input type=text name=body
INPUT TYPE=hidden NAME=orderby VALUE=request /form
(lots of snippage)
elseif
($orderby == 'request'):
$sql = select * from bulletin where match
moving entire databases
Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.ism file not found In my OLD mysql server there was NO file called host.ism at all So how do I use all the old data which has just the .frm , .myd and .myi files but the new server requires .ism files also Please help The mysql version on my new computer is 3.21.29a-gamma-debug-log chris
INSERT INTO
Hi, I am trying to insert data from one table to another with the command: INSERT INTO attrib_values (attrib_id,attrib_value) values (Select attrib_id,attrib_default_value FROM attribs) And I get error massage: You have an error in your SQL syntax near 'Select attrib_id,attrib_default_value FROM attribs)' at line 1 Why do I get this error and how can I insert the data from one table to the other? Best Regards, Ilan _ ILAN FAIT Tel: 972-9-9519133 Ex.247iWeb Technologies Fax: 972-9-951913491 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:[EMAIL PROTECTED]www.iweb.com
Re: web search form for a mysql database
What if you want to search for a number of terms? Say you have a database
of common computer problems and solutions with a (simplifid) schema like
this:
Name
Email
Problem
Solution
Say you want to search on the Problem field. The Problem field would be
strings of text like Problem with auto starting MySQL on Mac OS X.
So the user would want to search on MySQL and Mac and would enter those
terms in the box. How would you do it?
I'd assume you'd frst have to count the words being sent to script and then
build a select statement based on the number of search terms.
Is there an easier way?
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the
string search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the
search string appears in the filed but as part of the string and not an exact
match). We will have to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a partial
value of $search. Note that I modified $search and added % on both ends.
This allows to search for the search to ignore the leading characters and the
characters following the search string.
Ok, now lets assume we want to search all the field of the table and not only
the Name field. In order to do that we need to choose the records with Name
LIKE $srch or Last LIKE $srch etc. The translation to MySQL query is:
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
The complete srch.php3 script top to bottom should look like:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to DataBase);
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 7/5/01 10:13
SUBJECT: web search form for a mysql database
I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of
dealer bulletins.
I have created a web page to allow easy input of new
Re: moving entire databases
On Thu, Jul 05, 2001 at 06:41:15PM +0100, christopher sagayam wrote: Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.ism file not found In my OLD mysql server there was NO file called host.ism at all So how do I use all the old data which has just the .frm , .myd and .myi files but the new server requires .ism files also Please help The mysql version on my new computer is 3.21.29a-gamma-debug-log Woah! Download a newer version of MySQL. That one is very, very, very old. MySQL 3.23.xx would be a much better choice. And it won't look for a host.ism file. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 143,706,807 queries (85/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
MySQLGUI
Are there any know issues or bugs with MySQLGUI running on Solaris 8 thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: moving entire databases
Wonderful answer ..my problem solved Thanks chris - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: christopher sagayam [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 6:49 PM Subject: Re: moving entire databases On Thu, Jul 05, 2001 at 06:41:15PM +0100, christopher sagayam wrote: Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.ism file not found In my OLD mysql server there was NO file called host.ism at all So how do I use all the old data which has just the .frm , .myd and .myi files but the new server requires .ism files also Please help The mysql version on my new computer is 3.21.29a-gamma-debug-log Woah! Download a newer version of MySQL. That one is very, very, very old. MySQL 3.23.xx would be a much better choice. And it won't look for a host.ism file. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 143,706,807 queries (85/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems Installing MySQL
Oh, and if you're going to use this system as a server for intranet/internet resources, why do you have a Win98 drive installed ?? You won't be able to use it if you're going to keep the system up, running Linux... - Original Message - From: Steve Brazill [EMAIL PROTECTED] To: Gavin Phillips-Page [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 11:06 AM Subject: Re: Problems Installing MySQL You shouldn't place the actual 'RPM's in /usr/local/mysql (/tmp would probably be a better place). I don't think that you have any control over the installation location when using the RPM technique... I am attaching my 'webdocs' on setting up a RedHat Linux system, including the installation and configuration of Apache/PHP/MySQL. Though the 'docs' refer to RedHat 6.2, the installation instructions are the same (I have just built 2 RedHat 7.1 systems without any problems...) If you're going to do any 'real' work with PHP and MySQL, you'll want to install and build the 'source' packages of each product (as apposed to the RPM technique that you have attempted to use). My 'docs' instruct you how to install the 'source' distributions of each package... Since you seletect the 'workstation' type of RedHat install, there might be some packages missing that you'll need to compile each product. Good Luck... - Original Message - From: Gavin Phillips-Page [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 3:51 AM Subject: Problems Installing MySQL We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux 7.1 Deluxe Edition installed. We would like to create databases in MySQL and use PHP scripting to enable the apache web server to provide access to the database via an intranet or the internet. Initially we selected MySQL to be installed during the Red Hat Linux installation. When we ran the ³mysqladmin u root ping² command we received an error message stating that the MySQL Daemon did not start. We then ran ³./bin/safe_mysqld Daemon, but we still could not launch MySQL. We contacted Red Hat Support and they pointed us to your site where we printed out ³Installing MySQL². However we are still having problems with the installation. 1. We created a Directory /usr/local/mysql and copied the following files from the Red Hat Linux 7.1 CD to the /usr/local/mysql Directory: mysql-3.23.36.1.i386.rpm : mysql-devel-3.23.36.1.i386.rpm :mysql-3.23.36.1.i386.rpm : mysqlclient9-3.23.22.4.i386.rpm : mysqlserver-3.23.36.1.i386.rpm 2. We then ran the rpm i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm Command from the /usr/local/mysql Directory and received an error message that the file did not exist. 3. We then ran the rpm i mysql-3.23.36.1.i386.rpm mysqlclient9-3.23.22.4.i386.rpm Command from the /usr/local/mysql Directory. Something happened, but the var/lib/mysql Directory was not created. Could you please help with the installation. Can we make MySQL accessible via the KDE main menu if the installation is successful? Best regards Gavin Phillips-Page - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposition: Attach a comment to each connection
BAUMEISTER Alexandre wrote: Bonjour Justin, JF I don't know why I got interested in this thread... More important (or less), why are you so negative ? Je ne suis pas contre. I just haven't felt the need for this, but after reading your scenario, I can't understand why. Email obscures a lot of preconceptions of the writer. Hope this is more clear to you now. And, it is. I can see the utility of this functionality if I was tracing a suspect that was trying to get, as an example, credit card numbers out of our database BY NOT GOING THROUGH OUR CLIENTS. However, it would not help at all if the attacker was sophisticated, because he ain't gonna write in any comments. Without thinking too much, I can see the utility of knowing which of YOUR ten servers was going bonkers, from which of, say, YOUR 250 web sites using the ten MySQL servers. If I had felt this need, I probably would have just added another field to the schema of a sensitive table, and had my apps write in a comment, like, for a shopping cart, The guy using this credit card has IP so-and-so, and his user agent is so-and-so and the DNS resolves to 12345.nasty.net. I just would not have thought about your idea. Et alors, bonne chance with this request _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT INTO
On 05-Jul-01 Ilan Fait wrote: Hi, I am trying to insert data from one table to another with the command: INSERT INTO attrib_values (attrib_id,attrib_value) values (Select attrib_id,attrib_default_value FROM attribs) And I get error massage: You have an error in your SQL syntax near 'Select attrib_id,attrib_default_value FROM attribs)' at line 1 Why do I get this error and how can I insert the data from one table to the other? Your syntax is mixed-up. INSERT INTO attrib_values (attrib_id,attrib_value) Select attrib_id,attrib_default_value FROM attribs; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: web search form for a mysql database
I think then you get into using Index's or FullText searchs
http://www.mysql.com/doc/M/y/MySQL_indexes.html
http://www.mysql.com/doc/F/u/Fulltext_Search.html
-Original Message-
FROM: Patrick J. Larkin
TO: MySQL List
DATE: Thu 7/5/01 11:51
SUBJECT: Re: web search form for a mysql database
What if you want to search for a number of terms? Say you have a database
of common computer problems and solutions with a (simplifid) schema like
this:
Name
Email
Problem
Solution
Say you want to search on the Problem field. The Problem field would be
strings of text like Problem with auto starting MySQL on Mac OS X.
So the user would want to search on MySQL and Mac and would enter those
terms in the box. How would you do it?
I'd assume you'd frst have to count the words being sent to script and then
build a select statement based on the number of search terms.
Is there an easier way?
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the
string search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the
search string appears in the filed but as part of the string and not an exact
match). We will have to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a partial
value of $search. Note that I modified $search and added % on both ends.
This allows to search for the search to ignore the leading characters and the
characters following the search string.
Ok, now lets assume we want to search all the field of the table and not only
the Name field. In order to do that we need to choose the records with Name
LIKE $srch or Last LIKE $srch etc. The translation to MySQL query is:
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
The complete srch.php3 script top to bottom should look like:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to DataBase);
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE '$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
MS-DOS
Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.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
Re: web search form for a mysql database
For my needs, that would not be necessary, just a simple single word
search. I now have
to figure out how to integrate what Mr. Massey suggested into my existing
form, so far I have
not got it to work. I guess I'm just stupid with mysql, I'm a newbie just
trying to get something
the marketing people want to work.
--
Chip
Patrick J. Larkin [EMAIL PROTECTED] on 07/05/2001 07:45:40 PM
Internet mail from:
To: MySQL List [EMAIL PROTECTED]
cc:
Subject: Re: web search form for a mysql database
What if you want to search for a number of terms? Say you have a database
of common computer problems and solutions with a (simplifid) schema like
this:
Name
Email
Problem
Solution
Say you want to search on the Problem field. The Problem field would be
strings of text like Problem with auto starting MySQL on Mac OS X.
So the user would want to search on MySQL and Mac and would enter those
terms in the box. How would you do it?
I'd assume you'd frst have to count the words being sent to script and then
build a select statement based on the number of search terms.
Is there an easier way?
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the
string search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the
search string appears in the filed but as part of the string and not an
exact
match). We will have to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a
partial
value of $search. Note that I modified $search and added % on both
ends.
This allows to search for the search to ignore the leading characters and
the
characters following the search string.
Ok, now lets assume we want to search all the field of the table and not
only
the Name field. In order to do that we need to choose the records with
Name
LIKE $srch or Last LIKE $srch etc. The translation to MySQL query is:
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE
'$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
The complete srch.php3 script top to bottom should look like:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to DataBase);
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE
'$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo
Re: web search form for a mysql database
First NO ONE IS STUPID! Somethings have to be learned that's all. Now back to the
search function.
I use http://www.weberdev.com and a few other sites to pull tutorials from that show
you how to do different things. Go join and search for Search and you'll find that
there are allot of other scripts there.
This script has Two pages
search.php the inital one
Srch.php3 the results
If you want to change the database to yours change all of the database stuff to yours
or create this one.
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
I'll look for a simpler search but I don't have anytime right now..
Cheers
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 7/5/01 12:51
SUBJECT: Re: web search form for a mysql database
For my needs, that would not be necessary, just a simple single word
search. I now have
to figure out how to integrate what Mr. Massey suggested into my existing
form, so far I have
not got it to work. I guess I'm just stupid with mysql, I'm a newbie just
trying to get something
the marketing people want to work.
--
Chip
Patrick J. Larkin [EMAIL PROTECTED] on 07/05/2001 07:45:40 PM
Internet mail from:
To: MySQL List [EMAIL PROTECTED]
cc:
Subject: Re: web search form for a mysql database
What if you want to search for a number of terms? Say you have a database
of common computer problems and solutions with a (simplifid) schema like
this:
Name
Email
Problem
Solution
Say you want to search on the Problem field. The Problem field would be
strings of text like Problem with auto starting MySQL on Mac OS X.
So the user would want to search on MySQL and Mac and would enter those
terms in the box. How would you do it?
I'd assume you'd frst have to count the words being sent to script and then
build a select statement based on the number of search terms.
Is there an easier way?
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the
string search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the
search string appears in the filed but as part of the string and not an
exact
match). We will have to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a
partial
value of $search. Note that I modified $search and added % on both
ends.
This allows to search for the search to ignore the leading characters and
the
characters following the search string.
Ok, now lets assume we want to search all the field of the table and not
only
the Name field. In order to do that we need to choose the records with
Name
LIKE $srch or Last LIKE $srch etc. The translation to MySQL query is:
$query = select * from visitors WHERE Name LIKE '$srch' || Last LIKE
'$srch'
|| email LIKE '$srch' || comment LIKE '$srch';
The complete srch.php3 script top to bottom should look like:
?
if ($search) // perform search only if a
Re: MS-DOS
WinME has this built right in, elsewise try doskey Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft - Please do not resell my e-mail address to anyone or send me unsolicited e-mail - - Original Message - From: Sibel Toprakkiran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 2:34 PM Subject: MS-DOS Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS-DOS
On Thu, Jul 05, 2001 at 03:17:05PM -0400, Matt TrollBoy Wiseman wrote: WinME has this built right in, elsewise try doskey How does WinME know what to do in the mysql command-line interpreter? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 143,938,020 queries (85/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: web search form for a mysql database
Thanks, I guess I just meant I'm just stupid on this subject, not stupid
overall, heh heh. Anyway,
thanks for the reference, I'll check it out shortly.
--
Chip
[EMAIL PROTECTED] on 07/05/2001 09:03:56 PM
Internet mail from:
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc:
Subject: Re: web search form for a mysql database
First NO ONE IS STUPID! Somethings have to be learned that's all. Now back
to the search function.
I use http://www.weberdev.com and a few other sites to pull tutorials from
that show you how to do different things. Go join and search for Search and
you'll find that there are allot of other scripts there.
This script has Two pages
search.php the inital one
Srch.php3 the results
If you want to change the database to yours change all of the database
stuff to yours or create this one.
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
I'll look for a simpler search but I don't have anytime right now..
Cheers
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 7/5/01 12:51
SUBJECT: Re: web search form for a mysql database
For my needs, that would not be necessary, just a simple single word
search. I now have
to figure out how to integrate what Mr. Massey suggested into my existing
form, so far I have
not got it to work. I guess I'm just stupid with mysql, I'm a newbie just
trying to get something
the marketing people want to work.
--
Chip
Patrick J. Larkin [EMAIL PROTECTED] on 07/05/2001 07:45:40 PM
Internet mail from:
To: MySQL List [EMAIL PROTECTED]
cc:
Subject: Re: web search form for a mysql database
What if you want to search for a number of terms? Say you have a database
of common computer problems and solutions with a (simplifid) schema like
this:
Name
Email
Problem
Solution
Say you want to search on the Problem field. The Problem field would be
strings of text like Problem with auto starting MySQL on Mac OS X.
So the user would want to search on MySQL and Mac and would enter those
terms in the box. How would you do it?
I'd assume you'd frst have to count the words being sent to script and then
build a select statement based on the number of search terms.
Is there an easier way?
Here's a simple search in MySQL and PHP.
Cheers
M;-)
Search.php3:
html
headtitleSearching the Guest Book/title
/head
body bgcolor=#ff
h1Searching the Database/h1
form method=post action=srch.php3
table width=90% align=center
trtdsearch for:/tdtdinput type=text name='search' size=60
maxlength=255/td/tr
td/tdtdinput type=submit/td/tr
/table
/form
?php include ('links.x');?
/body
/html
Srch.php3:
?
if ($search) // perform search only if a string was entered.
{
mysql_connect() or die (Problem connecting to Database);
$query = select * from visitors WHERE Name='$search';
$result = mysql_db_query(guest_book, $query);
if ($result)
{
echo Here are the results:brbr;
echo table width=90% align=center border=1tr
td align=center bgcolor=#00Visit time and date/td
td align=center bgcolor=#00User Name/td
td align=center bgcolor=#00Last Name/td
td align=center bgcolor=#00Email/td
/tr;
while ($r = mysql_fetch_array($result)) { // Begin while
$ts = $r[TimeStamp];
$name = $r[Name];
$last = $r[Last];
$email = $r[email];
$comment = $r[comment];
echo tr
td$ts/td
td$name/td
td$last/td
td$email/td/tr
tr td colspan=4 bgcolor=\#a0\$comment/td
/tr;
} // end while
echo /table;
} else { echo problems; }
} else {
echo Search string is empty. br Go back and type a string to search;
}
include ('links.x');
?
Some explanations. This scripts performs the following tasks:
Checks whether a string was entered.
Retrieves all the records that match the search string.
Prints all the retrieved records in a formatted table.
Clearing all the mumbo jumbo, the actual code that we need to work on is:
$query = select * from visitors WHERE Name='$search';
Yes, this line does all the work. We will play with it a bit later.
Ok, this query gets all the records where the Name field is equal to the
string search. Please note that an exact match is needed.
Lets assume we want to search for a partial string match (i.e. where the
search string appears in the filed but as part of the string and not an
exact
match). We will have to modify the script as follows:
$srch=%.$search.%;
$query = select * from visitors WHERE Name LIKE' $srch';
The LIKE comparison argument will return '1' if the Name field has a
partial
value of $search. Note that I modified $search and added % on both
ends.
This allows to search for the search to ignore the leading characters and
the
characters following the search string.
Ok, now lets assume we want to search all the field of the table and not
only
the Name field. In order to do that we need to choose the
problems with dowloads
I cant download in this link: Win32 static binary of MySQLGUI 1.7.5-1 The client software. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't init Databases
I get an error 'Can't init databases' how would I fix that? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MS-DOS
hi. use mysqlc instead of mysql when you start the client. hth. -ravi. -Original Message- From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: MS-DOS Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS-DOS
hi, thanks a lot. It's going. regards, sibel. --- Ravi Raman [EMAIL PROTECTED] wrote: hi. use mysqlc instead of mysql when you start the client. hth. -ravi. -Original Message- From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: MS-DOS Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.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
Innodb
Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
restorin a nt 4 database
Hi, cen anyone help me with this question. To restoring a database [in the event of a disk crash for example], run the restore from tape and rebuild the database, then take the transaction logs and upload those into the database to bring it up to date. From what I can tell, Mysql does NOT support transaction logging, at least not for NT. Can anyone help, if transactions are not supported, how are those folks that have mysql running on NT, restoring a database? I'm using Mysql version 3.23.27. Thanks! ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIKE Magic
You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Jakub Wasielewski wrote: Hello! Could somebody explain me why it's like that: mysql select count(*) from docs where kword_10 LIKE '%Ukraina%'; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.09 sec) ^^^ This is true! mysql select count(*) from docs where kword_10 NOT LIKE '%Ukraina%'; +--+ | count(*) | +--+ | 2788 | +--+ 1 row in set (0.08 sec) mysql select count(*) from docs; +--+ | count(*) | +--+ | 8001 | +--+ 1 row in set (0.00 sec) Wow?!? I tried this on 3.23.36 3.22.30 and both returned different vaules in second examle. Table docs is execkly the same on both MySQL's and kword_10 is a varchar(50). Please help me understand... Cheers, -- Jakub Wasielewski [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: Innodb
On Thu, Jul 05, 2001 at 04:29:05PM -0400, Brandon Berry wrote: Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? Did you put all the InnoDB related options in your my.cnf file? Could you post the relevant section and the error message you got? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 144,464,243 queries (85/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIKE Magic
Dibo Chen == [EMAIL PROTECTED] napisa(a): You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Yes it's true! But why NOT LIKE gives false for NULL values? How can I get rid of this NULL's? Is "update docs set kword_10 = '' where kword_10 IS NULL" enough? Cheers, I love MySQL ;) -- Jakub Wasielewski [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: Innodb
These are the options I used. [mysqld] innodb_data_file_path = ibdata; innodb_data_home_dir = /usr/local/mysql/data set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /usr/local/mysql/data set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M Here's the error. 010705 16:03:06 mysqld started 010705 16:03:06 Can't init databases 010705 16:03:06 mysqld ended if I take the options out mysql starts fine. - Oso -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:53 PM To: Brandon Berry Cc: [EMAIL PROTECTED] Subject: Re: Innodb On Thu, Jul 05, 2001 at 04:29:05PM -0400, Brandon Berry wrote: Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? Did you put all the InnoDB related options in your my.cnf file? Could you post the relevant section and the error message you got? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 144,464,243 queries (85/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
Browser GUI
Hi All, I've been looking at alot of the GUI's offered at mysql.com, and was wondering if someone could recommend a good full MySQL administrator, for fully maintaining MySQL server/clients that is used thru the browser and not locally on a PC. thanks, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Fax: 1(225)686-2285 Tel: 1(225)686-2002 Toll Free: 1(800)594-4782 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql securely via network
If I connect to mysql: mysql -u username -p wherever.net is that encrypted at all? and if I make a network program via the C API, would that be encrypted too? Thanks James Gosnell [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: Innodb
hi. make sure you have the right binary...i believe it's called mysql-max or something... hth. -ravi. -Original Message- From: Brandon Berry [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:55 PM To: Ravi Raman Subject: RE: Innodb It's a binary install. - Oso -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:41 PM To: Brandon Berry Subject: RE: Innodb hi. was mysql compiled with innodb support? ./ configure --with-innodb hth. -ravi. -Original Message- From: Brandon Berry [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:29 PM To: [EMAIL PROTECTED] Subject: Innodb Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Loading data into a remote server from csv file?
I need to be able to add a .csv file into a database table running on a mysql server of IP address 10.0.0.10 I know that load data infile 'me.txt' into table stock; will do the job locally but what's the easiest way for me to add me.txt to stock on 10.0.0.1? For arguments sake we can assume that the csv file is in the correct format. One for the MySQL guru's? Thanks Thanks lots David Ayliffe ([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
newbie - connecting to data base with php sql_pconnectstatement
I am trying to connect to a mysql server fom a php script using the php sql_pconnect statement. I have used localhost as the host name, and the userid and password I normally use when connecting from the console. However, when executing the sql_pconnect statement I get an error message that reads Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) . Any ideas on what is wrong. This is my first attempt at this. Please respond via email, as I do not have access to the discussion list through my current isp. Thank you ...
VB: Recordset with ASP
Hi There! I have some trouble with a webaplication. I used to run it with an Access dbase but have changed to a nice MySQL dbase and then i got problems with the commands Addnew,Update,MoveFirst I use the samt locks and cursors as I did earlyer. Any good solution? Are there any parameters to set in The MySQL or the MyODBC Please respond wia mail BG /Fredde - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access to Other Databases Thru MySQL
What about to connect to Access from MySQL. -- Thomas S. Brettin Staff Member Bioscience Division, MS-M888 Los Alamos National Laboratory Los Alamos, NM 87545 505-665-3334 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIKE Magic
Dibo Chen == [EMAIL PROTECTED] napisa?(a): You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Yes it's true! But why NOT LIKE gives false for NULL values? NULL values fail all comparisons except IS NULL. How can I get rid of this NULL's? Is update docs set kword_10 = '' where kword_10 IS NULL enough? Sounds good. Cheers, I love MySQL ;) -- Jakub Wasielewski [EMAIL PROTECTED] -- Paul DuBois, [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
Help me improve my table search
Hi, Below is the table I have mysql describe eventlog; +-+--+--+-+ | Field | Type | Null | Key | +-+--+--+-+ | id | int(10) unsigned | | PRI | | timestamp | int(10) unsigned | | MUL | | type| tinyint(4) | | MUL | | source | char(15) | | MUL | | description | char(100)| | MUL | +-+--+--+-+ currently, each column are individual indexes and were defined by: mysql alter table eventlog index (timestamp); mysql alter table eventlog index (type); mysql alter table eventlog index (source); mysql alter table eventlog index (description); I am having performance problem with search. I would like to search the table given a word or words that are found in 'description'. Currently, I am doing it this way: SELECT * FROM eventlog WHERE description LIKE '%word1%' AND description LIKE '%word2%' AND description LIKE '%word3%' ORDER by id DESC LIMIT 20; Reading the documentations, it was mentioned that doing a LIKE '%word%' search will not use indexes. I ask, how do I perform search effectively on such a table? DO you suggest that I create an index table wherein each word in the eventlog description now forms a single row in this index table that cross references the eventlog table? mysql describe indextable; +-+--+--+-+ | Field | Type | Null | Key | +-+--+--+-+ | id | int(10) unsigned | | MUL | | keyword | char(20) | | MUL | +-+--+--+-+ SELECT e.* FROM eventlog e, indextable i WHERE (i.keyword = 'word1' OR i.keyword = 'word2' OR i.keyword = 'word3') AND e.id = i.id ORDER by i.id DESC LIMIT 20; I dont like doing the above workaround as it would take another messy table, any suggestions? Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MS VB
I am developing a Visual Basic application requiring a database on a win32 machine running 98SE and wanted to know if mySQL will run on this machine. I would like to avoid using MS SQL server as I will not require stored procedures and this will be running on a laptop for demo purposes. Also, my hosting company has mySQL on my server and I want to know if mySQL is ODBC compliant in the latest version. Thanks Simon Metz check out my website http://www.columbia.edu/~sdm39 coming soon http://www.simonmetz.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: newbie - connecting to data base with php sql_pconnectstatement
One reason could be the server isn't running. This problem has been documented, please RTFM. - Original Message - From: Roger deBry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 6:11 Subject: newbie - connecting to data base with php sql_pconnectstatement I am trying to connect to a mysql server fom a php script using the php sql_pconnect statement. I have used localhost as the host name, and the userid and password I normally use when connecting from the console. However, when executing the sql_pconnect statement I get an error message that reads Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) . Any ideas on what is wrong. This is my first attempt at this. Please respond via email, as I do not have access to the discussion list through my current isp. Thank you ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL MS VB
Yes, you can run MySQL on a Windows machine and you'll need MyODBC if you're connecting through ODBC. - Original Message - From: Simon Metz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 9:05 Subject: mySQL MS VB I am developing a Visual Basic application requiring a database on a win32 machine running 98SE and wanted to know if mySQL will run on this machine. I would like to avoid using MS SQL server as I will not require stored procedures and this will be running on a laptop for demo purposes. Also, my hosting company has mySQL on my server and I want to know if mySQL is ODBC compliant in the latest version. Thanks Simon Metz check out my website http://www.columbia.edu/~sdm39 coming soon http://www.simonmetz.com --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
