Re: Dropping foreing key without losing data
On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Character problems
In the last episode (Jan 30), Maximo Migliari said: Note that for the name field, the characters ç, í, â, are all appearing correctly. Now when I select this information from PHP and print it as a webpage, this is what I get: ? instead of â, ¡ instead of í ? instead of ç What's up? I used to do this before without any problems. I'm assuming this is some character encoding issue - however, I don't know if its in PHP or in MySQL the problem. Whenver you have non-ASCII characters in a web page, make sure you specify a character set in the Content-Type header: meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 Without that, a browser is free to use whatever it wants. -- Dan Nelson [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: timing
Mary, The Production server has MYSQL 3.23 and an older version of MYODBC then I have. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Maybe this won't help too much, but I've experienced that in some cases MyODBC 2.50 is sooo much slower than MyODBC 3.51. An export I did from MS Access to MySQL (some 1.5 million records) took hours with 2.50, and only 3 minutes with 3.51. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Mary Stickney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:08 PM Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [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: MySQL Truncated returns
On Thu, Jan 30, 2003 at 11:40:06AM -0500, Anna Noel Leavitt wrote: Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Hello Anna, It sounds like the data is getting truncated before it reaches MySQL or after it is selected and displayed. Try echoing out the query that you are sending to MySQL using PHP. Does the query look well-formed and complete? If not, then it is likely a problem in the PHP code. If the query seems fine, then try selecting the data directly using the MySQL command line client? i.e. mysql -uuser -p -eSELECT col FROM table WHERE col like 'Tampa'; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information GreenPeace: Raising Environmental Awareness (http://greenpeace.org) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Truncated returns
The problem is probably in either your PHP or HTML, not MySQL. It is common to store mutliple words separated by a whitespace in varchar and text fields. -Original Message- From: Anna Noel Leavitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:40 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Truncated returns Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Thanks- Anna - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I start my mysql server with max_connections option
On Thu, Jan 30, 2003 at 10:46:27PM +0530, [EMAIL PROTECTED] wrote: Hi Group, I want to start my mysql with max_connections option. Now I am getting To many connction error. So I want to allow 200 concurrent connections... I tried with safe_mysqld max_connections=200 But it is not coming up... How can I set max_connections as 200. Do I need to specify that in my.cnf Good Day! You are very close. :) Use safe_mysqld -O max_connections=200 Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Brisbane, February 24-28, 2003 Visit http://mysql.com/training for more information Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting Images in and out of a Blob
At 1:26 -0700 1/30/03, Mike Walth wrote: Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. Preferred web scripting is ColdFusion, but PHP/PERL would be helpful too. Thank you for your help. For Perl code, go to: http://www.kitebird.com/mysql-perl/ and download the webdb distribution. Look in the image directory. For PHP (and Perl and Python) code, go to: http://www.kitebird.com/mysql-cookbook/ and download the recipes distribution. Look in the apache/images directory. Mike Walth CinoFusion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Truncated returns
I'm 97.5% sure this will turn out to be a HTML form issue. You probably echo the field without quotes like this input type=text name=some_name value=Tampa Bay / instead of input type=text name=some_name value=Tampa Bay / -steve At 11:40 AM -0500 1/30/03, Anna Noel Leavitt wrote: Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Thanks- Anna -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | SETI@Home: 1001 Work units on 23 oct 2002 | | 3.152 years CPU time, 3.142 years SETI user... and STILL no aliens... | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting Images in and out of a Blob
: Has anyone done any work with getting images into and out of a MYSQL : database? I have used mysql for some time, but never : stored an image : in a : blob field. I am curious on how to insert the image from a web form : upload, : and how to display the picture on another HTML page. : : You might want to start here: : http://www.mysql.com/doc/en/String_functions.html. Look for LOAD_FILE. If you're writing a web application which takes the file from the file field, then it's a lot easier to read the file into memory and back into the table with an INSERT clause. As to LOAD_FILE(), you will have to store the file in a temporary location before being able to use LOAD_FILE(). To serve images straight off the database, simply read the files into memory using a SELECT query, set the content-type header in your application to the mime-type of the image, say image/png, and write it to the stdout. Voila! Sherzod - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is faster?..
Hello- I am in the early stages of setting up a website running mysql. The idea is for the user to be able to compare insurance policies and choose the best one. I want to give them the option of choosing several insurance plans and compare them side by side. My question is would it be faster/more efficient to: a) Store policy wording in html format in a mysql table; or b) generate them from a perl script example user chooses plan a and plan b - hits the compare button to see policy wording compared side by side - would it be better to call it from the mysql table or a perl script? I thank you in advance. Justin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to update the database through an applet?
PHP works fine to update a mysql database on the server. But I would like to access a device connected to the serial port or a USB port on the client computer through an applet and store this information in the database on the server. I have tried to find an example of such a transaction on the net, unsuccessfully. Has anybody out there experiences with this kind of problem? It could be any solution, such as PHP + javascript, or PHP all by itself. Is there a good publication talking about this issue? Thank you Mario __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: FreeBSD bin-log rotation script
I think flush logs should do it. http://www.mysql.com/doc/en/FLUSH.html Bhavin. - Original Message - From: Matthias Trevarthan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:31 PM Subject: FreeBSD bin-log rotation script Howdy list, Does anyone have a FreeBSD/MySQL bin-log rotation script that I could use? I'm not sure how to go about rotating the binary logs. Doesn't the index have to stay in sync? Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting auto increment start value
From postings at: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html ALTER TABLE tbl_name AUTO_INCREMENT = 1000 will start your records at 1000 Bhavin. - Original Message - From: Mike Doanh Tran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:15 PM Subject: setting auto increment start value Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
interface to python?
is there any simple ways to interface python with mysql if yes tell me the details how do we do it in windows and linux __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Making Lin/Win share DataSource
Hallo list, this might sound ridiculous. But, because my computer is dual booting Linux/Windows, I'm looking for ways to put the datasource in windows D:\ or vfat, so that the data can be shared mutually by the two OS. But until now I still cannot do that. I have tried to: - change the owner to mysql; - change the /etc/my.cnf Well, does somebody out there do something like this already? Thank you. JD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting auto increment start value
Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran: Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT SET INSERT_ID=1000 does it. Have a look at http://www.mysql.com/doc/en/SET_OPTION.html -- Christian Kohlschütter [EMAIL PROTECTED] http://www.newsclub.de - Der Meta-Nachrichten-Dienst - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : Dropping foreing key without losing data
Hello Zak, Thanks for your response. I try the way you told me, but it seems there is another problem : The old foreign keys always exist. In consequence, there are double references. How can i resolve that problem ? Thanks in advance. JeanClaude -Message d'origine- De : Zak Greant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about Table_Options
Hi When creating a table can you use multiple Table_Options? The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # . Thanks Jonathan - This mail sent through IMP: http://horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql, PHP and Javascript
Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.1 binaries
any further news about 4.1 binaries release date? TIA (mysql, sql) __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [ mysqlimport ]
Hi, You should not use mysqlimport but mysql: mysql my_db file.sql See http://www.mysql.com/doc/en/mysqldump.html for details. Regards, Joseph Bueno Elby Vaz wrote: I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? Thanks, e. _ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Difference between MySQL versions
Hi there, Can someone point me to amn (exhaustive) list of features in MySQL Max that are not present in MySQL Standard? Or any other documentation that lists the differences between the two? Thanks in advance, Vikram -- Luke: I don't believe it! Yoda: That, is why you fail. --Star Wars: The Empire Strikes Back - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [ mysqlimport ]
Elby, I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? You do this with mysql in batch mode, not with mysqldump: shell mysql your_database file.sql Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Elby Vaz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:39 PM Subject: [ mysqlimport ] I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? Thanks, e. _ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unknown table when doing insert...select..where
Donal With MySQL, temp_explanations MUST exist before you can INSERT INTO it. Based on the assumption that temp_explanations is non-existent, you will have to CREATE TABLE temp_explanations first before running an INSERT INTO. Hope that helps. Inyang Hello, I want to do the following query INSERT INTO temp_explanations(tip) SELECT tip FROM explanations WHERE explanations.file=temp_explanations.file AND explanations.level=temp_explanations.level; but I'm getting an 'unknown table temp_explanations' error. How can I get around this? Thanks, Donal -- For the largest free email in Ireland (25MB) File Storage space (20MB), visit http://www.campus.ie Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about Table_Options
Hi When creating a table can you use multiple Table_Options? The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # . Thanks Jonathan - This mail sent through IMP: http://horde.org/imp/ - End forwarded message - - This mail sent through IMP: http://horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I start my mysql server with max_connections option
You can add the entry to my.cnf: [mysqld] set-variable= max_connections=200 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: How can I start my mysql server with max_connections option Date: Thu, 30 Jan 2003 22:46:27 +0530 (IST) Hi Group, I want to start my mysql with max_connections option. Now I am getting To many connction error. So I want to allow 200 concurrent connections... I tried with safe_mysqld max_connections=200 But it is not coming up... How can I set max_connections as 200. Do I need to specify that in my.cnf Please help.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Use MSN Messenger to send music and pics to your friends http://messenger.msn.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.h and c++ problems
Hello I use Microsoft Visual Studio (not Dev-C++) to connect to mySQL using ADO. That works fine. If you are programming on the Microsoft Windows platform, you could try using ADO for your connection object (ADODB.Connection). Inyang Everytime I try to compile with the MySql.h or any other includes with a gcc++ compiler I have many errors. Are there any known issues with a current release of the files that any one knows of? If someone uses C++ to interact with a MySql database, please let me know or send a sample project to me. Currently, I am using Dev-C++ to edit my code. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
TIMESTAMP field is updated unintentionally
Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql describe T_ORDH; --+--+-+++ Field |Type |Null |Key |Default |Extra --+--+-+++ PK_ID |int(10) unsigned | |PRI |NULL|auto_inc ERSTELL_DATUM |timestamp(14) |YES ||NULL| STATUS|smallint(5) unsigned | ||0 | If I do mysql update T_ORDH set STATUS=2 where PK_ID=26272; ERSTELL_DATUM is set to the current date. I know that a timestamp takes the current time, if set it to NULL, but since I'm not touching it, it shouldn't change, should it? A quick workaround is mysql update T_ORDH set STATUS=2, ERSTELL_DATUM=ERSTELL_DATUM - where PK_ID=26272; The big question: Is it a bug or a feature? (mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)) -- Best regards, Marco 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: What is faster?..
The fastest way would be to use C. But the reason for using a DB would be. 1. Access to data. You could use PhPMyAdmin or some thing you put together to update the policy so making managing the data easy (possibly so non tickers should make changes). 2. If the data you are getting needs to be retrieved relationally. How I would set up you web sit is.. MySQL backend with just text fields storing the data. Put some perl/php/C/ruby together to fetch the data. Feed this into some XML. Then feed this to XHTML and use CSS. .NET mite be worth looking at to? Hope this helps a bit? Simon -Original Message- From: Justin Cook [mailto:[EMAIL PROTECTED]] Sent: 31 January 2003 02:32 To: [EMAIL PROTECTED] Subject: What is faster?.. Hello- I am in the early stages of setting up a website running mysql. The idea is for the user to be able to compare insurance policies and choose the best one. I want to give them the option of choosing several insurance plans and compare them side by side. My question is would it be faster/more efficient to: a) Store policy wording in html format in a mysql table; or b) generate them from a perl script example user chooses plan a and plan b - hits the compare button to see policy wording compared side by side - would it be better to call it from the mysql table or a perl script? I thank you in advance. Justin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
creating update files
Hi there, I have a little question for you in the mysql community.. I was wondering how persons in this community handles changes to the database when your application that uses the database needs some new tables, columns, etc... Do you have an application with a sort of upgrade functionallity that when started checks the database for incosistency and when it finds some updates the database? (ie compares the structure of the table in the database to some template stored in the application or as datafiles/scripts) Or do you use some version system where the application instead of looking for inconsistency just look at the version number of the database, compares it to some internal version, and updates the database accordingly? (ie manually creating all the needed updatescripts that needs to run the application and have the application select between these) Or perhaps you do this update of the database manually when intalling a new version? For me, version 1 would be preferable, but unfourtunally this does not work in every scenario, but i guess that it normally could take care of about 90% off all my changes... the second system would be able to take care of all type of changes, but it requires more labour... so, how do you all manage this? /Christian Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
partitionong MyISAM tables??
Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Do InnoDB tables support partitioning? thanks. Prasanth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Q: Booleans??
Have used many databases but am just getting into MySQL and am totally rapt about it :) I am writing a front end in realBasic that needs to be able to run on various backends, MySQL being the main one. All of the others have a boolean type of column. What is the general practice to mimic¹ a BOOLEAN field in MySQL? PS: I do not need NULL or date for example, I just need true or false, yes or no etc... Regards David Hefford Power On Solutions Web: http://www.poweron.com.au Email: [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
# of connected user
How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clients are different (i assume) Mustafa Yelmer Software Engineer +90 212 2128200-1228 [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: Configure prob with FreeBSD/Linuxthreads
So, my dear friends, could we conclude that Linux is a more appropriate platform for running MySQL on a multi-processed machine? I was desperate to try and compile MySQL 4.0.9-gamma on my FreeBSD 4.7-stable machine, which is dual processed. I managed to compile fine once, but it gave errors when executing the deamon. I found some instructions for compiling MySQL with linuxthreads on FreeBSD 4.x from one Jeremy Zawodny, at the website: http://jeremy.zawodny.com/blog/archives/000458.html However, my machine complains right at the begining of the configure run that: ... checking for gcc... cc checking for C compiler default output... configure: error: C compiler cannot create exec tables Which is very weird IMHO. I used the configure command found on the page I pasted above. Any ideas anyone? BTW, to any of you who know compiling inside out on *nix machines, what do the following mean: -O -pipe -march=pentiumpro -D__USE_UNIX98 -D_REENTRANT -llthread -llgcc_r -felide-constructors -fno-rtti -fno-exceptions Many thanks, from a n00b FreeBSD admin. Maximo Migliari. At 03:21 PM 30-01-03 -0500, you wrote: Because with native threads, enabling the second CPU (and thus locking MySQL to one thread, one process, -period-, because running another on another port isnt viable) makes the job take just over twice as long. This explains your point of view: I never tried to run MySQL on dual-processor machines. *nod*. On a single CPU, native threads gives pretty excellent performance, in both 4.7-R and 5.0-R. I haven't run a single CPU linuxthreads test yet (I think I'll go fire one off...) Absolutely. Most of FreeBSD's 4.x kernel functions are not reentrant: to solve the problem of data corruption if two or more cpu's access the same procedure, a global locking mechanism is implemented. What it means, in practice, is that if two processes calls the same kernel function, one has to wait. They are served sequentially. The mechanism worked surprising well for most applications, but not for MySQL. In MySQL, if I recall right, there's one process that forks many threads, one for every request. Threads are splitted to many cpus, but because they compete to access the same functions, some threads have to wait. This could explain why you experience halved performance. In FreeBSD 5.x all kernel functions are fully reentrant. They did a great job in many areas of the OS, often a complete rewrite to gain more performance and features. I've not tested FreeBSD 5.0 and MySQL yet, nor I plan to do it soon, because I'm happy with FreeBSD 4.x in my work. If you do, please let me (us) know. I have to say, this is the best explanation of why things work the way they do I've seen yet. Thank you. As far as 5.0, the box I'm testing on is running 5.0-R. Compiling with native threads gives near-identical performance to 4.7-R with native threads (however, there is a small performance increase in a couple steps of the job, which is nice to see. Since the hardware configuration did not change, I chalk this up to 5.0-R's rewrite affecting other parts of the equation). My assumption right now (and this is based on not having taken the time to peruse the code, so I'm likely wrong - ignore me if I am) is that MySQL says, OK, we're running on FreeBSD. Do we have more than one CPU present? Yes? OK, lock to one thread. If this is true, we are willing to disable this protective code (if feasible) and see what kind of performance/stability we get out of MySQL on 5.0-R with native threads running full bore, unrestricted. Again, this is just the ramblings of a madman (er, ok, the ramblings of a tired sysadmin :). If not, this project can't wait. I'll probably have to coerce the boss into building a separate db server from the others (which wouldn't be so bad) on Linux or Solaris. Multi-cpu support in Solaris is stable, is efficient, has many years of development and it's ready to use. There's probably a reason why MySQL AB develops MySQL on Solaris first. I wasn't aware that they developed on Solaris first, but I've had first-hand experience of Solaris multi-cpu support. It's -great-. I almost got a chance to replace an Oracle cluster with MySQL (because the support contracts are much cheaper :) in a previous life, but that life got the axe too soon. Again, thanks for that explanation. -j - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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,
mysql compile error
hi list, getting this with mysql-3.23.55 on 2 machines (on other it compiled): make all-am make[3]: Entering directory `/usr/src/mysql-3.23.55/include' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/usr/src/mysql-3.23.55/include' make[2]: Leaving directory `/usr/src/mysql-3.23.55/include' Making all in Docs make[2]: Entering directory `/usr/src/mysql-3.23.55/Docs' make all-am make[3]: Entering directory `/usr/src/mysql-3.23.55/Docs' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/usr/src/mysql-3.23.55/Docs' make[2]: Leaving directory `/usr/src/mysql-3.23.55/Docs' Making all in readline make[2]: Entering directory `/usr/src/mysql-3.23.55/readline' source='readline.c' object='readline.o' libtool=no \ depfile='.deps/readline.Po' tmpdepfile='.deps/readline.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f readline.c || echo './'`readline.c source='funmap.c' object='funmap.o' libtool=no \ depfile='.deps/funmap.Po' tmpdepfile='.deps/funmap.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f funmap.c || echo './'`funmap.c source='keymaps.c' object='keymaps.o' libtool=no \ depfile='.deps/keymaps.Po' tmpdepfile='.deps/keymaps.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f keymaps.c || echo './'`keymaps.c source='vi_mode.c' object='vi_mode.o' libtool=no \ depfile='.deps/vi_mode.Po' tmpdepfile='.deps/vi_mode.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f vi_mode.c || echo './'`vi_mode.c source='parens.c' object='parens.o' libtool=no \ depfile='.deps/parens.Po' tmpdepfile='.deps/parens.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f parens.c || echo './'`parens.c source='rltty.c' object='rltty.o' libtool=no \ depfile='.deps/rltty.Po' tmpdepfile='.deps/rltty.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f rltty.c || echo './'`rltty.c source='complete.c' object='complete.o' libtool=no \ depfile='.deps/complete.Po' tmpdepfile='.deps/complete.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f complete.c || echo './'`complete.c source='bind.c' object='bind.o' libtool=no \ depfile='.deps/bind.Po' tmpdepfile='.deps/bind.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f bind.c || echo './'`bind.c source='isearch.c' object='isearch.o' libtool=no \ depfile='.deps/isearch.Po' tmpdepfile='.deps/isearch.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f isearch.c || echo './'`isearch.c source='display.c' object='display.o' libtool=no \ depfile='.deps/display.Po' tmpdepfile='.deps/display.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f display.c || echo './'`display.c source='signals.c' object='signals.o' libtool=no \ depfile='.deps/signals.Po' tmpdepfile='.deps/signals.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f signals.c || echo './'`signals.c source='util.c' object='util.o' libtool=no \ depfile='.deps/util.Po' tmpdepfile='.deps/util.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f util.c || echo './'`util.c source='kill.c' object='kill.o' libtool=no \ depfile='.deps/kill.Po' tmpdepfile='.deps/kill.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f kill.c || echo './'`kill.c source='undo.c' object='undo.o' libtool=no \ depfile='.deps/undo.Po' tmpdepfile='.deps/undo.TPo' \ depmode=gcc /bin/sh ../depcomp \ gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I.. -I./../ include -I./.. -I..-O3 -DDBUG_OFF -c `test -f undo.c || echo './'`undo.c source='macro.c' object='macro.o' libtool=no \ depfile='.deps/macro.Po'
Re: Storage issue
* Keith C. Ivey [...] Jonas said the tables had 25 floats in each record, so the added integer ID and deletion flag would only occur 1/25 as often. There You are probably right. I focused on the 1 value/minute are stored part, and wondered why he would store a float for each field in a database... maybe average number of reads per field per second or similar... :) It is way more likely that your suggestion is correct. :) are 1,314,000,000 values but only 52,560,000 records, and the record size would be 25*4+4+1=105 or 25*8+4+1=205. The total size would then be 5256 * 105 = 5519 MB 5256 * 205 = 10775 MB (using ISO megabytes, 10**6, as opposed to mebibytes, 2**20). ISO? Is this new? I thought it only was an IEEE-supported IEC standard? URL: http://physics.nist.gov/cuu/Units/binary.html MB == 1024*1024, MiB == Men in Black... ;) -- Roger not much sql this time - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling 4.0.9-gamma on Windows
Hi all, I get this error when compiling MySQL 4.0.9-gamma on Windows .\debug\Strings.obj LINK : fatal error LNK1181: cannot open input file .\debug\Strings.obj Error executing link.exe. Am using VC++ 6.0 Any help you can offer would be appreciated. Thanks! Vikram - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
linux novice cannot resolve apache-php-mysql linkage 3.
dell 4100 256mb, 11gb hd, Redhat 8.0 grub-linux linux novice cannot resolve apache-php-mysql linkage 3. local closed system (No modem, no www access, no internet) big snip see linux novice cannot resolve apache-php-mysql linkage 2. for lengthy details I've installed RH at least 20 times, and will continue snip Thanks to Gary Every, David T-G, Alvaro Avello, Fred Stiening for replying to my request for information, however, the information in my email was not correct. I (re)installed RH8.0 and found that the command lists that I posted could not exist if this was to be the initial install of apache-php-mysql. The directories and folders are created in an order different from the one I implied in my email. I apologize for that. I will repost the results of my current attempt to install apache-php-mysql - good luck to me. Thanks for your patience dander - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: interface to python?
On Thu, Jan 30, 2003 at 09:48:16PM -0800, vishnu mahendra wrote: is there any simple ways to interface python with mysql if yes tell me the details how do we do it in windows and linux I never used Python, but this is very easy to find: http://www.python.org/ http://www.python.org/topics/database/ http://www.python.org/topics/database/modules.html http://sourceforge.net/projects/mysql-python Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating fulltext index
Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the number of columns by two and the index seemed to build just fine. I would like to make a suggestion though. I originally tried to create the fulltext index with more than 16 columns and received an error saying that I could have at most 16 columns in a fulltext index. It would be great if the error message could be changed to say 14 instead of 16. If that can't be done, a note in the manual discussing the limitation would be helpful. Just my 2 cents! Thanks, Duncan From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Hi! I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error? mysql alter table materials add fulltext title (title,variant_title,ss_title,term_1,term_2,term_3,term_4, term_5,abstract,notes,personal_name_1,personal_name_2, personal_name_3,personal_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) Too many columns. No more than 14 is allowed in FULLTEXT index in MySQL before 4.1, because MySQL adds two columns internally to each FULLTEXT index. In 4.1 it was fixed, but the way it was fixed cannot be backported to 4.0 :( Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User Accounts...
How can I create different user accounts for a table?. (I've just installed the MySQL, and the root just don't have a password yet..how can assign one? Thxs in advance, Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Syntax Help
Hi All, Can anyone help me get this query working in MySQL, this was created using Access, but it doesn't port well for MySQL syntax: SELECT b.id, p.part_code, p.product_type, p.description, po1.options, b.price, b.quantity, b.price*b.quantity AS total FROM (products AS p LEFT JOIN product_options AS po ON p.prod_id = po.prod_id) RIGHT JOIN (product_options AS po1 RIGHT JOIN (basket_header AS bh INNER JOIN basket AS b ON bh.basket_id = b.basket_id) ON po1.po_id = b.op_id) ON p.prod_id = b.prod_id GROUP BY b.id, p.part_code, p.product_type, p.description, po1.options, b.price, b.quantity, b.price*b.quantity, bh.basket_id, p.options HAVING (((bh.basket_id)=4)); Here is the error message MySQL reports: You have an error in your SQL syntax near '(product_options AS po1 RIGHT JOIN (basket_header AS bh INNER JOIN basket AS b O' at line 1 Any ideas to the correct syntax? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [ mysqlimport ]
You don't. you use the file as input to the mysql client. mysql file.sql Elby Vaz wrote: I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? Thanks, e. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: binary log not recording 4.0.9
If your application is opening one database, and then updating medic.sometable, the update will not be recorded in the bin file. sam wrote: I am trying to use replication with 4.0.9. Changes to the datbase are not being recorded in the bin file on the master for a DB called Medic when presented by an application but will if I setup a test table in the DB mysql and use the mysql client to insert/update. At this point I have no idea what to do. Should I sent this to bugs@mysql? Any ideas? sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timing
thanks. we are doing the data load today and will upgrade the MYODBC to 3.51 before we do it. This will be a good test as the load takes 6 hours on the current version. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:07 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: Re: timing Mary, The Production server has MYSQL 3.23 and an older version of MYODBC then I have. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Maybe this won't help too much, but I've experienced that in some cases MyODBC 2.50 is sooo much slower than MyODBC 3.51. An export I did from MS Access to MySQL (some 1.5 million records) took hours with 2.50, and only 3 minutes with 3.51. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Mary Stickney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:08 PM Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Character problems
Hi Maximo, Try this: add this to your HTML document meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 Hope it helps Ken - Original Message - From: Maximo Migliari [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 11:19 AM Subject: Character problems Platform: windows MySQL version: 4.0.9-gamma PHP version: 4.3.0 Connected through Command Prompt via MySQL client to local MySQL server. Output from a SELECT query: mysql select * from category; +++---+--+-+-- --+ | id | parent | name | num_elements | description | type | +++---+--+-+-- --+ | 1 | 0 | materias |0 | 1 | artigo | | 2 | 0 | artigos |0 | 2 | artigo | | 3 | 1 | Tipos de câncer |0 | 3 | artigo | | 4 | 1 | Crianças carentes |0 | 4 | artigo | | 5 | 3 | Leucemia |0 | 5 | artigo | | 6 | 3 | Câncer de pele|0 | 6 | artigo | | 7 | 3 | Notícias |0 | 7 | ultima | +++---+--+-+-- --+ 7 rows in set (0.00 sec) mysql exit Bye Note that for the name field, the characters ç, í, â, are all appearing correctly. Now when I select this information from PHP and print it as a webpage, this is what I get: f instead of â, ¡ instead of í ? instead of ç What's up? I used to do this before without any problems. I'm assuming this is some character encoding issue - however, I don't know if its in PHP or in MySQL the problem. Help! Maximo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Making Lin/Win share DataSource
JD, my answer may seem ridiculous, too, but with the following setup you should be able to use MySQL databases and tables both under Linux and Windows on the same machine. About the only thing you need is access to the MySQL data directory from both Linux and Windows. Regardless of the operating system, mysqladmin variables will show you where DATADIR is. Of course (though it may sound even more ridiculous), you have to have MySQL installed both under Linux and under Windows. Whether you've started mysqld or not, you can issue mysqld --print-defaults to find out the location of DATADIR. However, this will not show you DATADIR if it's not in my.cnf / my.ini. Now, let's say DATADIR is in /var/lib/mysql/ under Linux, and under Windows this is c:\mysql\data\ (I'm not informed how paths will look like when you share them between OS's). In this case, you would edit /etc/my.cnf under Linux and fill in: [mysqld] datadir=/var/lib/mysql And, under Windows, this would be the following in c:\winnt\my.ini (assuming you boot Win NT/2000/XP): [mysqld] datadir=c:\mysql\data Now, I suggest you start the MySQL server (both OS's) as follows: shell mysqld --standalone --console This will output a lot of start information, so you can find out what's going wrong at startup. HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 7:11 AM Subject: Making Lin/Win share DataSource Hallo list, this might sound ridiculous. But, because my computer is dual booting Linux/Windows, I'm looking for ways to put the datasource in windows D:\ or vfat, so that the data can be shared mutually by the two OS. But until now I still cannot do that. I have tried to: - change the owner to mysql; - change the /etc/my.cnf Well, does somebody out there do something like this already? Thank you. JD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Autoincrement : how does it work / how to reset it
Hi, I have been using autoincrement fields for some time but was wondering how does it work in some special situations. Ex. suppose I have an autoincrement field called num and the last one has value of 10. I delete the last on and insert a new one. Which value will it have ? 10 or 11 I read that if I issue a query delete * from table and delete from table I have diferent results (in regards to the auto increment field). Is this correct ? Thanks. PS. plese CC me directly since for some reason the messages from the list are taking a while to get in my mailbox. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: interface to python?
Hello, For windows check out Python from: www.ActiveState.com It comes with some nice additions. Also check out the Python Mysql interface (v2.xx) api. www.python.org/topics/database/ For windows the Rekall front end (Access like and an alternative to php) looks promising. www.thekompany.com The above are also for linux but I have not used them. steve www.rac4sql.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
Re: Question about Table_Options
Jonathan, The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # Oh, I stumbled over this one, too. Here's my explanation :) mysql CREATE TABLE autotest_myisam (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) TYPE=MyISAM AUTO_INCREMENT=100; Query OK, 0 rows affected (0.08 sec) mysql INSERT INTO autotest_myisam VALUES (NULL); Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM autotest_myisam; +-+ | id | +-+ | 100 | +-+ 1 row in set (0.02 sec) mysql CREATE TABLE autotest_InnoDB (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) TYPE=InnoDB AUTO_INCREMENT=100; Query OK, 0 rows affected (0.10 sec) mysql INSERT INTO autotest_InnoDB VALUES (NULL); Query OK, 1 row affected (0.07 sec) mysql SELECT * FROM autotest_InnoDB; ++ | id | ++ | 1 | ++ 1 row in set (0.00 sec) As you see, TYPE=MyISAM AND AUTO_INCREMENT=100 works, but TYPE=InnoDB AND AUTO_INCREMENT=100 does not work. But isn't it supposed to be 'xor' instead of 'or'? ;-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Jonathan Bedford [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 9:12 AM Subject: Question about Table_Options Hi When creating a table can you use multiple Table_Options? The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } or AUTO_INCREMENT = # . Thanks Jonathan - This mail sent through IMP: http://horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting auto increment start value
: Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran: : Hi all, : : I am creating a new table with an auto_increment primary key. : How do i tell mysql to start incrementing at a certain : value, let say : 1000 instead of 1? : : Thanks, : : MT : : SET INSERT_ID=1000 does it. Tabels have AUTO_INCREMENT option, which you will need to set while creating the table. In the following example id will start with 1000: CREATE TABLE test ( id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, ) AUTO_INCREMENT=1000; Good luck Sherzod - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, PHP and Javascript
Steve, this list is not the right place to ask JavaScript questions. Please check out an appropriate list at http://php.net/. But, anyway, it's possible to mix JS and PHP, no problem. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 9:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
Hi All Is it possible to mix javascript and PHP in the same script?? Client-side Javascript can be sent to the user along with your html. For Example: echo (HTMLHEAD\n); echo (SCRIPT TYPE=\text/javascript\\n); echo (!--\n; echo (function hello() {\n); echo ( alert('Hi');\n); echo (}\n); echo (// --\n); echo (/SCRIPT\n); and so on... The client is then sent: HTMLHEAD SCRIPT TYPE=\text/javascript\ !-- function hello() { alear('Hi'); } // -- /SCRIPT Is it possible to use JavaScript calls on the server side? Don't think so, but there is a Java extension to PhP that may help you if that's what you're after: http://www.php.net/manual/en/ref.java.php HTH, Josh I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
Hi Steve, Yes, it is possible to mix PHP and JavaScript, for example: var givemeaphpvalue = ?php echo $phpvalue; ?; I use PHP and Javascript together quite often. Regards, Kevin - Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 8:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
Hi Steve, You can definitely mix javascript and PHP in the same script so long as you follow the correct syntax for each language.There is no way out here really...if you want to include javascript in your scripts then you have to learn it:-) unless you want to hire someone to do it for you... Regards, Eric On Fri, 31 Jan 2003, Steve Davies wrote: Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql, PHP and Javascript
Is it possible to mix javascript and PHP in the same script?? Yes it is, but you have to remember that PHP is server side and Javascript is Client side. I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Have you thought of using CSS for rollovers? The newest browsers can do rollovers pretty good using CSS Ken Robinson mail2web - Check your email from the web at http://mail2web.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: Getting Images in and out of a Blob
You might find this helpful - I did. http://www.phpbuilder.com/columns/florian19991014.php3 Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, PHP and Javascript
Absoulutely. Since PHP is server-side you can write javascript dynamically on the fly which are then executed client-side. Here's a simple example: !-- yourpage.php-- script language=Javascript var today = '?php echo date(Y-m-d, time()); ?'; /script -Original Message- From: Steve Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 1:27 AM To: [EMAIL PROTECTED] Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(SQL) Count Distincts
I am trying to get a count of Distinct IP's from my homemade hit-log database (don't ask). The db is MySQL. I'm trying this: SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp), DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN '2003013000' AND '2003013100') GROUP BY Month(TimeStamp), DayOfMonth(TimeStamp) But it doesn't appear to be doing what I want. The Count per day is the same as it was when I didn't have DISTINCT ClientIP, in there, and I know from looking at the raw data that there are some duplicate ClientIP's in the data. The MySQL docs don't have an example (that I could find) of what I'm trying to do. What am I doing wrong? (besides not getting enough sleep) TIA, Tab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Syntax
Hi All, Can anyone help me get this query working in MySQL, this was created using Access, but it doesn't port well for MySQL syntax: SELECT basket.id, products.part_code, products.product_type, products.description, product_options_1.options, basket.price, basket.quantity, basket.price*basket.quantity AS total FROM (products LEFT JOIN product_options ON products.prod_id=product_options.prod_id) RIGHT JOIN (product_options AS product_options_1 RIGHT JOIN (basket_header INNER JOIN basket ON basket_header.basket_id=basket.basket_id) ON product_options_1.po_id=basket.op_id) ON products.prod_id=basket.prod_id GROUP BY basket.id, products.part_code, products.product_type, products.description, product_options_1.options, basket.price, basket.quantity, basket.price*basket.quantity, basket_header.basket_id, products.options HAVING (((basket_header.basket_id)=4)); Here is the error message MySQL reports: ERROR 1064: You have an error in your SQL syntax near '(product_options AS product_options_1 RIGHT JOIN (basket_header INNER JOIN baske' at line 9 Seems MySQL doesn't like the RIGHT JOIN syntax. Any ideas to the correct syntax? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL Syntax
Also, this might help to solve the problem, this is a graphical schema of the query from MS Access, to give you all a better idea of what I'm trying to accomplish... http://www.netsmith.ltd.uk/example.gif - Original Message - From: Kevin Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 3:46 PM Subject: SQL Syntax Hi All, Can anyone help me get this query working in MySQL, this was created using Access, but it doesn't port well for MySQL syntax: SELECT basket.id, products.part_code, products.product_type, products.description, product_options_1.options, basket.price, basket.quantity, basket.price*basket.quantity AS total FROM (products LEFT JOIN product_options ON products.prod_id=product_options.prod_id) RIGHT JOIN (product_options AS product_options_1 RIGHT JOIN (basket_header INNER JOIN basket ON basket_header.basket_id=basket.basket_id) ON product_options_1.po_id=basket.op_id) ON products.prod_id=basket.prod_id GROUP BY basket.id, products.part_code, products.product_type, products.description, product_options_1.options, basket.price, basket.quantity, basket.price*basket.quantity, basket_header.basket_id, products.options HAVING (((basket_header.basket_id)=4)); Here is the error message MySQL reports: ERROR 1064: You have an error in your SQL syntax near '(product_options AS product_options_1 RIGHT JOIN (basket_header INNER JOIN baske' at line 9 Seems MySQL doesn't like the RIGHT JOIN syntax. Any ideas to the correct syntax? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: interface to python?
At 21:48 -0800 1/30/03, vishnu mahendra wrote: is there any simple ways to interface python with mysql if yes tell me the details how do we do it in windows and linux Yes. You can find an article describing how to do it at: http://www.kitebird.com/articles/ You can find a bunch of scripts that use the Python interface at: http://www.kitebird.com/mysql-cookbook/ Download the recipes distribution, and look for the files that have a .py extension. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
Steve: On Fri, 31 Jan 2003 08:27:11 +, Steve Davies wrote: Is it possible to mix javascript and PHP in the same script?? Certainly. Exactly as HTML and PHP are intermingled in a document. I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Using PHP to enhance javascript's functionality doesn't eliminate the need to know javascript. Any help greatly appreciated Your inquiry will receive more detailed help on one of the lists at www.php.net. Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Difference between MySQL versions
Vikram, Can someone point me to amn (exhaustive) list of features in MySQL Max that are not present in MySQL Standard? Or any other documentation that lists the differences between the two? http://www.mysql.com/products/mysql/index.html (not too exhaustive, though) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Vikram Vaswani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 11:29 AM Subject: Difference between MySQL versions Hi there, Can someone point me to amn (exhaustive) list of features in MySQL Max that are not present in MySQL Standard? Or any other documentation that lists the differences between the two? Thanks in advance, Vikram -- Luke: I don't believe it! Yoda: That, is why you fail. --Star Wars: The Empire Strikes Back - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: interface to python?
* vishnu mahendra is there any simple ways to interface python with mysql URL: http://sourceforge.net/projects/mysql-python if yes tell me the details how do we do it in windows and linux You will find instructions on the sourceforge site. A small demo, low level API: import _mysql c = _mysql.connect() c.query('select * from test.test') res = c.store_result() res.describe() (('id', 3, 1, 11, 11, 0, 0), ('name', 253, 4, 30, 30, 0, 0), ('email', 253, 13, 80, 80, 0, 1)) res.fetch_row() (('1', 'test', '[EMAIL PROTECTED]'),) res.fetch_row() (('2', 'foo', '[EMAIL PROTECTED]'),) There is also a higher level API conforming to the Python Database API specification included in the distribution. URL: http://www.python.org/topics/database/DatabaseAPI-2.0.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
line breaks
Hi, From a web form I am collecting information to a table. On the form there is a textarea element storing to a text field on the mysql table. Since the textarea can hold the enter key, it's stored in to the field also, but when i try to call that cell and display it on the web page, i see that line breaks are ignored. But the sentences must be displayed as they are entered. - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, - do you have a shorter way to do this? 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
Error inserting data in MySQL 4.1
Description: For some reason the numeric fields in the middle ('sessionfid', 'ipfid') are not putting values in there even though it says it went through fine. mysql DESC phpss_log; ++--+---+--+-+-++ | Field | Type | Collation | Null | Key | Default | Extra | | ++--+---+--+-+-++ | id | int(10) unsigned | binary| | PRI | NULL| |auto_increment | | timestamp | datetime | latin1| | | -00-00 00:00:00 | | | | sessionfid | int(10) unsigned | binary| YES | | NULL| | | | accountfid | int(10) unsigned | binary| YES | | NULL| | | | ipfid | int(10) unsigned | binary| | | 0 | | | | module | varchar(64) | latin1| | | | | | | message| varchar(255) | latin1| | | | | | ++--+---+--+-+-++ 7 rows in set (0.00 sec) mysql INSERT INTO phpss_log ( `timestamp`, `sessionfid`, `accountfid`, `ipfid`, `module`, `message` ) VALUES ( '2003-01-31 12:07:51', '2', '0', '1', 'phpss', 'Successful user login' ); Query OK, 1 row affected (0.00 sec) mysql SELECT * FROM phpss_log; ++-+++---++---+ | id | timestamp | sessionfid | accountfid | ipfid | module | message | | ++-+++---++---+ | 1 | 2003-01-31 12:06:41 | 0 | 0 | 0 | phpss | Successful |user login | | 2 | 2003-01-31 12:07:51 | 0 | 0 | 0 | phpss | Successful |user login | | 3 | 2003-01-31 12:07:51 | 0 | 0 | 0 | phpss | Successful |user login | ++-+++---++---+ 3 rows in set (0.00 sec) Timothy M. Crider How-To-Repeat: Try to insert data Fix: Don't know of any fixes Submitter-Id: submitter ID Originator:root Organization: Timothy M. Crider MySQL support: [none | licence | email support | extended email support ] Synopsis: Unable to insert proper data in MySQL 4.1 Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.1.0-alpha (Source distribution) C compiler:gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) C++ compiler: g++ (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Environment: System: Linux towely 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Dec 13 06:53 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 18:50 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Dec 13 17:00 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--prefix=/usr/local/mysql' '--libexecdir=/usr/local/libexec' '--libdir=/usr/local/lib' '--includedir=/usr/local/include' '--enable-local-infile' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-username=mysql' '--with-vio' '--without-isam' '--with-openssl=/usr/local' '--without-innodb' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql CSV import
You van use the LOAD DATA INFILE statement Check this http://www.mysql.com/doc/en/LOAD_DATA.html for more information HTH Dobromir Velev [EMAIL PROTECTED] www.websitepulse.com - Original Message - From: Andrew [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 12:48 Subject: RE: sql CSV import Hi all I am trying to import a csv file from MySQL and keep getting an error on line one. Is there an alternative way to import a csv file other than using phpmyadmin? I exported the file from MySQL but can't import it back in, any ideas? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make command problem
I was trying to install mysql on a mac g4 following the instructions provided by the followin link http://www.mysql.com/doc/en/Quick_install.html but when I got to the make command I got the following error: [localhost:~/mysql-4.0.4-beta] erix% make make: Command not found. I also found out that the groupadd command has the same problem, I tried add group instead and it worked. Thank you for your time. Erix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Percentile calculations
I've had a look through the archives and cannot see a solution to this. I am wondering if there is a nicer way to do the following. I have a table where one of the columns contains a time period for an activity that I am logging. I need to grab the 95th percentile, when ordered by duration. I have two solutions so far, but processing time is important. Solution 1: Use perl to drag the (relevant) rows into an array, sorted by duration (either by the sql box, or by sorting the array), and then count the number of elements, and grab the (number of elements * .95) element. I moved away from this, to the following, as I don't want to pull every row to the client (there are millions of rows in the table)..: select count(*) from percentile where criteria; Work out 95% or this value. create temporary table percentile (id int unsigned auto_increment primary key, scantime decimal(20,10)); insert into percentile (scantime) select processingtime from emails where same criteria order by processingtime desc limit value from above; select min(scantime) from percentile; This appears to be quicker, aswell as saving me pulling all the rows. I don't need to pull all the rows, as the other calculations I need to do on the data specified by criteria is easily accomplished by a sum(processingtime) and avg(processingtime) -- I guess I was basically looking for perc(processingtime,95) or something, but don't appear to be able to fine it! Thanks in advance for any help/suggestions you may have. Karl This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.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, PHP and Javascript
Of course. Javascript is a client side scripting language and is run in the users browser, whereas PHP is run on the server. The javascript is just text to the PHP parser, like HTML. Javascript will allow you to do dynamic stuff, but if you are looking for aesthetics you would be better off learning style sheets. CSS is much more efficient than javascript. You can actually simulate buttons, borders and lots of other stuff by just using CSS. And if you get good at CSS, you can even create themes for your website. For instance, adding this simple code in the HEAD of your web page will cause links to change to a yellow background when the mouse is over the link. style type=text/css media=Screen a:hover {background-color: yellow}; /style That's a heck of a lot better than adding an onMouseOver event to every link. On Friday, January 31, 2003, at 03:27 AM, Steve Davies wrote: Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to insert an Image in a table with libmysqlclient and API C ?
Hi all, my problem is the following, it's possible to insert an image in a table with the libmysqlclient ? My language is C i'm working with GNU/Linux Best Regards, Stephane Wirtel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: TIMESTAMP field is updated unintentionally
Timestamp columns update automatically. http://www.mysql.com/doc/en/DATETIME.html Peter ^_^ -Original Message- From: Marco Deppe [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 6:18 AM To: [EMAIL PROTECTED] Subject: TIMESTAMP field is updated unintentionally Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql describe T_ORDH; --+--+-+++ Field |Type |Null |Key |Default |Extra --+--+-+++ PK_ID |int(10) unsigned | |PRI |NULL|auto_inc ERSTELL_DATUM |timestamp(14) |YES ||NULL| STATUS|smallint(5) unsigned | ||0 | If I do mysql update T_ORDH set STATUS=2 where PK_ID=26272; ERSTELL_DATUM is set to the current date. I know that a timestamp takes the current time, if set it to NULL, but since I'm not touching it, it shouldn't change, should it? A quick workaround is mysql update T_ORDH set STATUS=2, ERSTELL_DATUM=ERSTELL_DATUM - where PK_ID=26272; The big question: Is it a bug or a feature? (mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)) -- Best regards, Marco 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, PHP and Javascript
PHP is server side, javascript is client side, they do not interact with each other. PHP gets parsed by on the server before the page is rendered, javascript is interpreted by the browser. You can either have PHP generate the javascript or just put it in the page. Rollovers have nothing to do with backend programming. -Original Message- From: Steve Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 12:27 AM To: [EMAIL PROTECTED] Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
- Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 3:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? Short answer: Yes :) Longer explanation: Javascript is just for font end presentation, or formating.. Like HTML it doesnt effect the php or mysql php gets processed on the server.. JS gets processed on the client browser Brian I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fulltext Index
At 13:40 -0800 1/30/03, R. Hannes Niedner wrote: If I create a FULLTEXT index for 2 or more columns in a table will I be able to use it for a MATCH only against a single column (of the above) or do I have to create additional FULLTEXT indices for each of these columns? The latter. When you use MATCH, there must be a FULLTEXT index on exactly the columns named in the MATCH. Thanks/h sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: TIMESTAMP field is updated unintentionally
Hi, It is a feature, the first TIMESTAMP field is automatically updated each time you update the record. Check the manual for details: http://www.mysql.com/doc/en/DATETIME.html If you want mysql to automatically set it at creation time only, your workaround is OK. You can also convert ERSTELL_DATUM to DATETIME type and set is explicitely to NOW() when you insert a new record. Hope this helps -- Joseph Bueno Marco Deppe wrote: Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql describe T_ORDH; --+--+-+++ Field |Type |Null |Key |Default |Extra --+--+-+++ PK_ID |int(10) unsigned | |PRI |NULL|auto_inc ERSTELL_DATUM |timestamp(14) |YES ||NULL| STATUS|smallint(5) unsigned | ||0 | If I do mysql update T_ORDH set STATUS=2 where PK_ID=26272; ERSTELL_DATUM is set to the current date. I know that a timestamp takes the current time, if set it to NULL, but since I'm not touching it, it shouldn't change, should it? A quick workaround is mysql update T_ORDH set STATUS=2, ERSTELL_DATUM=ERSTELL_DATUM - where PK_ID=26272; The big question: Is it a bug or a feature? (mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php