Re: SET field=field+1 no longer works?

I no longer have the original post in my inbox, I had a problem with fetchmail which downloaded all the messages a couple hundred times, so i did a mass delete. All you should have to do is wrap the statement in () like: UPDATE table name SET field=(field+1) WHERE where clause This will

many field insert

Hi, I have to insert data to table which has many fields (252 fields). This table was successful update by the LOAD DATA infile. But when I generate SQL statement with from VB, SQL statment length got more than 1000 byte. I was try many time to re-check SQL syntax but I still can not

mysqlbug

rcastro, Wednesday, February 27, 2002, 12:28:01 AM, you wrote: r Hi! r My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem r installing MySQL is next: r I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/; r i've follow all the steps that

Re: insert into with sub select

I've been having this problem as well, which results from mySQL not allowing you to select and insert from the same table at the same time. This restriction makes some sense even in your case- mySQL wants to insert each row as it finds it in the select, but then that might change what results the

Help! Optimizing a multi-word search

Problem: 1. in a phone book, a single field may contain several words, e.g. District 52 Police Station. 2. The query for this record may contain some or all of these words, but not necessarily in that order, e.g. Police district 52. 3. Searching for all of the query words can be done in many

Re: Help Optimizing a multi-word search

On Wednesday 27 February 2002 07:47 am, Jeff Kilbride wrote: - I'm going to be implementing a keyword search pretty soon myself, so I'd like to see you solve this. :) Me too! :-) What about doing some sort of prefix indexing, instead of indexing the

Re: SET field=field+1 no longer works?

Hi Tyler, Apologies for the absence/delay. Pleased to hear that the problem is solved. It does raise the question though - if it failed in PHP (etc) how did you manage to get it to work in MySQL-client? If an UPDATE flat refuses to go (which didn't seem to be the case here), then the first

Re: running mysql w/php..

Hi Floyd, Hi.. Can anyone tell me some good places to look for sample snips, tutorials or other assistance specifically for making PHP and mySQL cooperate. Running mysql queries using php syntax. Mysql talks about mysql queries, etc. and php talks about php functions, etc. but I'm

Re: SET field=field+1 no longer works?

Stewart, All you should have to do is wrap the statement in () like: UPDATE table name SET field=(field+1) WHERE where clause I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html). Where did you find the requirement for parentheses? Do you have live code where UPDATE works

Re: Temporary Tables

You have written the following: I understand the principles but WHEN should they be used or considered ?? Any help appreciated tia John sql,query - Before posting, please check: http://www.mysql.com/manual.php

Wrong sorting order using cp1257 character set.

Description: There are a few errors in characters sorting order in sql/share/charsets/cp1257.conf file. Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly. But accoding Lithuanian standart LST 1285:1993 (if you interested :) character 0xE0 should be between 0x61 (a) and 0x62 (b),

.net

Has anyone tried to use the Mysql++ api with visual C++.net? Thanks, Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: insert into with sub select

Hi Rob, You're right for my problem. I'll hope this solution to be fixed in MySQL someday. thanks anyway. Sommai At 10:28 27/2/2002 +, Rob wrote: I've been having this problem as well, which results from mySQL not allowing you to select and insert from the same table at the same

character set

Michal, Wednesday, February 27, 2002, 11:41:14 AM, you wrote: MD Hello, MD is possible to change encoding (character set) while conecting to MD mysql from php ?? (In postgre is SET client_encoding = 'latin2'). Character set is set when mysqld is started. If you want to use different character

Chinese support at MySQL

Joey, Wednesday, February 27, 2002, 3:26:26 AM, you wrote: JF Dear all, JF How to make MySQL with Chinese Big5 support? Thanks. You should set big5 character set, look at: http://www.mysql.com/doc/C/h/Character_sets.html -- For technical support contracts, goto

Re: Table Creation Question

Davis, Charles M writes: Hello, I downloaded the beta version of MySQLGUI and was unable to perform any table creation. Is this feature currently not supported? Thanks, Charles Charles Davis Member Engineering Staff, Data Analysis Systems Lockheed Martin - Naval Electronics

Re: VC++ .net

Joshua Angolano writes: Has anyone tried to use Mysql++ with Microsoft Visual C++ .NET? Better yet, has anyone had any luck and how? Thanks for your help, Josh No, but it could be tried out .. If you have that VC++ version, you can try it. -- Regards, __ ___ ___

Re: mysql php - while loops

Craig, [BTW there is a set of PHP lists, including PHP-DB - mentioned because 'purists' sometimes object to 'PHP questions'!?] The following lists 12 items from a fruits table. $results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits); while ($data =

Re: mysql on redhat instalation problem

hello edna and brian, your life savers! thank you for getting back to me. i've done the chown and chmod which went well! then i typed: mysql_install_db this then said 'installing all prepared tables' and a message saying: /usr/sbin/mysqld: Shutdown Complete after that the default kind of

Re: insert into with sub select

Hi rob, I have another question but still in this solution. How did you delete data which different in 2 table? Sommai At 10:28 27/2/2002 +, Rob wrote: I've been having this problem as well, which results from mySQL not allowing you to select and insert from the same table at the

Re: Temporary Tables

John, You have written the following: I understand the principles but WHEN should they be used or considered ?? Any help appreciated Something of an assumption here that we're all able to recollect an earlier post? Hope I'm on the right wavelength. I use temporary tables to get over the

.net

I have tried to use the Mysql++ api with visual C++ .net. It would not even compile the library. Has anyone had any luck with this?? Maybe there is some setting that I missed?? Are there any plans to update Mysql++ to work with visual C++.net?? Thanks, Josh

RE: Can somebody help me with round (columna,columnb) ?

* Doug Thompson Roger: I found using variables to work as expected with 3.23.43 and Win98. I was unable to duplicate your changing outputs. I was using a 3.23.30-gamma win2k. mysql select @a:=digits,number,round(number,@a) from testme; ++--+--+ |

Re: Wrong sorting order using cp1257 character set.

[EMAIL PROTECTED] writes: Description: There are a few errors in characters sorting order in sql/share/charsets/cp1257.conf file. Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly. But accoding Lithuanian standart LST 1285:1993 (if you interested :) character 0xE0 should

Re: .net

Joshua Angolano writes: Has anyone tried to use the Mysql++ api with visual C++.net? Thanks, Josh As far as I know, no. But it is worth a try if you have VC++.net. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL

Re: .net

Joshua Angolano writes: I have tried to use the Mysql++ api with visual C++ .net. It would not even compile the library. Has anyone had any luck with this?? Maybe there is some setting that I missed?? Are there any plans to update Mysql++ to work with visual C++.net?? Thanks,

Sum function question

Hi, I have a table like this Key Field-1 A string1 A string2 A string3 B string1 B string 2 I want to create a query to get the following result (only one line by key field): A - string1,string2,string3 B - string1,string2 I try to

NULL Values in mysqldump

This is probably an easy one for someone... Is here an easy way NOT to have a mysqldump data file that includes /N when the column is a NULL ? Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data file for al the NULL VALUES. Scripting a global cut or strip out

Japanese alpha sorting?

Paul, Wednesday, February 27, 2002, 4:47:46 AM, you wrote: PW Hi, PW I wish to alphabetically sort data retrieved from MySQL using JSP for PW web a page. The data will be stored in Japanese. I understand there are PW multiple alphabets/dialects in Japanese with a large number of characters

Fixing corrupted table

Hi. I am running MySQL 3.22.30, and am having trouble repairing a corrupted table with isamchk. Everything that I've tried either doesn't work, or wipes out all the data. Here's what I've tried so far: *** isamchk -d guestbook ISAM file: guestbook Data records: 79764 Deleted

mysqlhotcopy Problems with Databases/Tables with minus or blanks in name

Description: When using mysqlhotcopy for database backups, it fails to backup a Database or Table with a minus (-) or blanks in its name, for example when using mydb.user-table, mydb.user table, my db.usertable or my-db.usertable and says You have an error in your SQL Syntax How-To-Repeat:

Client installation by itself?

Is it possible to install just the mysql client software for NT? The only client distributions I can find include the mysql server as well. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting,

OT: Please Somebody can explain me what this message means??? Fw: ezmlm warning

Sorry for the length of this message, but, I don´t understand what it means, and why it says my address will be removed from the list without explanation. thanx - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 12:58 AM Subject: ezmlm

Re: Sum function question

Hi Javier, Hi, I have a table like this Key Field-1 A string1 A string2 A string3 B string1 B string 2 I want to create a query to get the following result (only one line by key field): A - string1,string2,string3 B -

many field insert

Sommai, Wednesday, February 27, 2002, 11:29:30 AM, you wrote: SF Hi, SF I have to insert data to table which has many fields (252 fields). This SF table was successful update by the LOAD DATA infile. But when I generate SF SQL statement with from VB, SQL statment length got more than

php - apache compilation

Oladejo, Wednesday, February 27, 2002, 3:04:05 AM, you wrote: Oeoen Hi All, Oeoen I am trying to compile php with mysql and apache into it, however during the Oeoen ./configure, I keep getting Invalid Apache directory - unable to find Oeoen httpd.h under /usr/include/apache, even though that is

Re: NULL Values in mysqldump

On 27 Feb 2002, at 8:18, Baines, Dominic wrote: If you immediately use the dump, this is fine if it is to be used with MySQL but if you want to port it to another RDBMS the /N for a NULL causes some 'issues'. If you don't care about the difference between NULL and the empty string or 0, why

RE: NuSphere v. MySQL 4

Please be careful of reading only half of the story, unfortunately the article in question only talks about -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 3:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: NuSphere v.

Re: Client installation by itself?

I asked this question as well some time back and got the standard answer 'READ THE MANUAL'. However, I still never found the answer to my question, so when I get closer to deployment, I am going to experiment. I am thinking that only MyODBC installation is required on the client and

Changed localhost?

All of a sudden Apache and MySQL are not running correctly under Windows 98. It appears that somehow localhost was changed from 127.0.0.1 to something else. Could the fact that I NOW have a 24/7cable connection to the Net cause the problem? Thanks! Anthony Rodriguez ([EMAIL PROTECTED])

Re: replication issue

David, I am seeing the exact same thing on some Solaris boxen. My database sees a couple of updates every minute or two; and show slave status on the slave always appears to lag behind the master. The data in my tables lag as well as I've done some rudimentary checksumming and have found

mysql installation on linux(RH7.2)

hi i downloaded mysql rpms from mysql.com tried to install them on linux. when i use the command rpm -i mysqlpackname in shell it says error:can't get exclusive lock on /var/lib/rpm/packages error:can't open packages database in /var/lib/rpm what shall i do. later i managed to install it using

RE: NULL Values in mysqldump

There is a huge difference between a NULL and NOT NULL and an empty string and it would be handled in the table definition statements of the 'new' RDBMS usually with a default column setting. However, in this case the MySQL columns values are NULL the problem (if it is one) is that /N does not

RE: Changed localhost?

Hi, Localhost is always associated to at least 127.0.0.1 IP, however you can add as many IP adresses as you want to your machine by using TCP/IP properties window in your control panel. As long as you add IP adresses (reference them in tcp/ip layer) your apache will handle the HTTP request. It

RE: Can somebody help me with round (columna,columnb) ?

On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote: * Doug Thompson I found using variables to work as expected with 3.23.43 and Win98. I was unable to duplicate your changing outputs. I was using a 3.23.30-gamma win2k. mysql select @a:=digits,number,round(number,@a) from testme;

RE: NULL Values in mysqldump

On 27 Feb 2002, at 10:31, Baines, Dominic wrote: However, in this case the MySQL columns values are NULL the problem (if it is one) is that /N does not mean NULL in other RDBMS and you have to craft a method of converting or parsing the data either at load or pre-load to another format to

Changed localhost?

Anthony, Wednesday, February 27, 2002, 4:58:09 PM, you wrote: AR All of a sudden Apache and MySQL are not running correctly under Windows 98. AR It appears that somehow localhost was changed from 127.0.0.1 to something else. No, localhost is 127.0.0.1 What type of error did you recieve? AR

Client installation by itself?

Carl, Wednesday, February 27, 2002, 4:16:51 PM, you wrote: CM Is it possible to install just the mysql client software for NT? The only CM client distributions I can find include the mysql server as well. Take a look at MySQLGUI and MyCC. You can find them at:

order by date error!!!

Hi, I've noticed this problem, even if I don't know if it's really a mysql problem: if I store a date in standard format, in a date field, all kinds of ordering are OK. But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to order the new format

Query Problem...

Hi, I am using MySQL 3.22.32 and are trying to accomplish the following (without going into too much detail, this is an example of the exact situation)... 1) I have two tables: a) User table containing: UserID, FullName b) Project table containing: ProjectID, ProjectManagerID and

www-mysql package

Dear all. Has anyone practice in www-mysql package ? I've installed apache, www-mysql. And so ? What next. Marek Wysmulek. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

perl mysql DBI::db question

i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, GEN1 line 2. i

RE: order by date error!!!

But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to order the new format incorrectly, because I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!! I normally do this: SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as

Re: order by date error!!!

Wakan [EMAIL PROTECTED] wrote: But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to order the new format incorrectly, because I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!! What can you say about this? Can you give

core dump in clients in MYSQL 3.23.49 using groups

Description: When using groups in 3.23.49, client dumps core. This bug sounds to be new (it does not appear in 3.23.41) How-To-Repeat: Just compile a little C client (you can also dump cores with DBI perl module) : % cat bug.c #include mysql/mysql.h #include stdio.h int main(void) { MYSQL

Re: perl mysql DBI::db question

Try moving your $dbh-disconnect call after it prints out the fetchrow_array() my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array(); if($debug_state) { print S: $t_user,$t_password,$t_prefs\n; } $dbh-disconnect(); If your using an older version of DBI, like 1.13 or .14

Re: order by date error!!!

Hi, Wakan wrote : Hi, I've noticed this problem, even if I don't know if it's really a mysql problem: if I store a date in standard format, in a date field, all kinds of ordering are OK. But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to

Re: perl mysql DBI::db question

On Wed, 27 Feb 2002 10:40:21 -0600, nickg [EMAIL PROTECTED] wrote: You need to tell the handler you are finished with your statement, this will free resources, etc.. http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish $sql_check-finish; EXTREMELY out-dated! MySQL Version: 3.21.X

RE: NuSphere v. MySQL 4

Please be careful of reading only half of the story, unfortunately the article in question only talks about half of the issues. See http://www.nusphere.com/releases/index.htm for more information and related documents. Britt... -Original Message- From: Tyler Longren [mailto:[EMAIL

Re: perl mysql DBI::db question

i am using the older v1.19 DBI. i looked at that line and it should not cause a problem. the values are stored, even after the handle is destroyed or the connection closed. the error is complaining that i should destroy statement handles or call finish. thanks for the respones. - Original

Re: Query Problem...

Hi Ash, I am using MySQL 3.22.32 and are trying to accomplish the following (without going into too much detail, this is an example of the exact situation)... 1) I have two tables: a) User table containing: UserID, FullName b) Project table containing: ProjectID, ProjectManagerID and

Re: mysql installation on linux(RH7.2)

nagendra prasad [EMAIL PROTECTED] writes: hi i downloaded mysql rpms from mysql.com tried to install them on linux. when i use the command rpm -i mysqlpackname in shell it says error:can't get exclusive lock on /var/lib/rpm/packages error:can't open packages database in /var/lib/rpm

Re: BIIIG problem with some of the records

Hi Edward, [I've put this back on the list - others will be able to share their wisdom/you might not have to wait so long for me to get around to a reply!] My first thought is that you have a neat system of encoding the link data being stored in MySQL. I assume this is preceded by some sort

RE: Client installation by itself?

Hi, -Original Message- From: Scalper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:53 AM To: [EMAIL PROTECTED] Subject: Re: Client installation by itself? I asked this question as well some time back and got the standard answer 'READ THE MANUAL'. However,

SQL

Hi, I'm using MySQL for the first time and have been trying to solve this basic SQL problem for 2 days... I have tried everything from using JOINs to local variables, searching in www.mysql.com and Paul DuBois MySQL book (Great book!), but failed to do this in a single SQL query has

Re: MySQL Server cluster?

can MySQL run as cluster under the platform of IBM AS/400 also?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Query Problem...

Hi, Thanks for the reply. An example of the record output I was after is... ProjectIDProjectOwnerProjectManager A12345 Bob Smith John Smith from tables: User - UserIdFullName 1Bob Smith 2John Smith Project - ProjectId

Re: select takes a very long time

Alfredo Cole [EMAIL PROTECTED] wrote: select tr.*,ma.nombre from cbtran as tr, cbma as ma where tr.empresa='1' and tr.mes='1' and tr.anio='2002' and concat(ma.empresa,ma.clase,ma.tipo,ma.mayor,ma.grupo,ma.costo,ma.cuenta,ma.subcuenta)=concat(tr.empresa,tr.cuenta) order by tr.anio,

Datawarehousing

Hi there , I read your thread discussion Jan and it is certainly very interesting to me. There are though a couple of areas where I would (oh shit you wrote this email in 1999, I hope you are still there anyway ..) be rather skeptical, and these are: Facts: - An average DW will contain an

RE: SQL

Hi Miguel, As far as I know (I'm no expert), this can't be done in a single MySQL query. The following link shows how you can do it using a temporary table: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#exam ple-Maximum-column-group-row Alternatively, if you are using

Order by on Alphnumeric

sql,query Good Day, I have a varchar field which contains alphanumeric data. I want to be able to order this field by only the numeric values in the field. help!! Rick - Before posting, please check:

Re: replication issue

It would appear that the apparent lagging/slave processes not working (yet telling me they are up) was due to having two slaves set to the same server-id. I will know as more time passes. On Wed, Feb 27, 2002 at 09:27:04AM -0600, Michael Douglass said: David, I am seeing the exact same

Re: flexible foreign keys?

InnoDB doesn't support the CASCADE functionality of foreign keys, so it's possible deleting the key from the parent table won't have any effect on existing transactions in the child. It may only prevent new records from being inserted with that key -- which is essentially what you want. Most DBs

RE: Order by on Alphnumeric

select * from table where strcol REGEXP ^[[:digit:]]+$ order by strcol Regards Dan -Original Message- From: Prospect'In [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 11:31 a.m. To: [EMAIL PROTECTED] Subject: Order by on Alphnumeric sql,query Good

Re: flexible foreign keys?

When I try to delete a row from the parent table and the key is in use in the child table, I get: ERROR 1217: Cannot delete a parent row: a foreign key constraint fails So it doesn't cascade and delete rows in the child table (assuming I am interpreting cascade on delete correctly), but it

help: can't get anonymous access configured

Hi All, I want to make my publicDB available for anonymous access from everywhere and spend hours and hours reading the manuals and FAQ's and searching the web, but can't make it work. After deleting all entries in mysql.user apart from root@localhost: grant select on publicDB.* to johan;

Re: php - apache compilation

Thanx Vic, Are you saying I have to recompile apache as well before reconfiguring PHP. Thanx Toks - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 9:54 AM Subject: php - apache compilation Oladejo,

HELP - Admin Removed mysql.host

Hi, I think that one of the admins on my MySQL 3.23.38 server somehow removed mysql.host when he was cleaning out old databases, I get the error: 020227 15:21:46 mysqld started 020227 15:21:46 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist 020227 15:21:46 mysqld ended If I re-run

Re: MySQLdMax crashed (for unknown reasons), please help

Jonathan, the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48. Please upgrade to 3.23.49a. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

PHP Security Update

From the PHP home page: PHP Security Update [27-Feb-2002] Due to a security issue found in all versions of PHP (including 3.x and 4.x), a new version of PHP has been released. Details about the security issue are available at http://security.e-matters.de/advisories/012002.html. All users of PHP

FULLTEXT error?

Error SQL-query: CREATE TABLE quotes ( id int(9) NOT NULL auto_increment, author varchar(255), content text, PRIMARY KEY (id), UNIQUE KEY id (id), FULLTEXT KEY author (author,content) )

Myisamchk can't repair table help help help

Arrrggghhh! This is definitely a problem! Can't access table White in mysql 4.0.1: table is read-only. why? because it's corrupt! Try to fix: takes a long time (about an hour) and seems to work. But it's still corrupt and read-only: [root@db1 elenco4_fb02]# myisamchk White; Checking

Starting mysqld fails

Hi, I downloaded the tarball for the latest RH binaries of Mysql 3.23.49a. I installed it according to the INSTALL-BINARY file included with the package. When I tried to run mysql according to the same file it crashed giving no explanation. I have tried the suggestions listed on the website

Re: I heard that MySQL 4.01 supports Views?

At 16:31 -0500 2/27/02, Stephen Cox wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion. Stephen Cox Web Development, Webmaster [EMAIL PROTECTED] -

LOAD DATA LOCAL INFILE in Alpha 3.23.49

Description: LOAD DATA LOCAL INFILE ... leads to 'The used command is not allowed with this MySQL version' This happens regardless of whether I have a local-infile= 1 in my /etc/my.cnf. In neither case does the local-infile variable show up with SHOW VARIABLES. How-To-Repeat: Fix:

Re: I heard that MySQL 4.01 supports Views?

At 17:09 -0500 2/27/02, Anthony W. Marino wrote: On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion. Can't you just say NO or just don't respond? Sure. But why

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 05:16 pm, you wrote: At 17:09 -0500 2/27/02, Anthony W. Marino wrote: On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion.

Re: Query Problem...

Hi Ash, I have tried all sorts of joins and statements without much success... I can obtain one name or both names if they are the same... but not different names together in the one record. =how about some example code showing what you are doing? At the very least it gives me a 'starting

RE: Query Problem...

* asherh An example of the record output I was after is... ProjectIDProjectOwnerProjectManager A12345 Bob Smith John Smith from tables: User - UserIdFullName 1Bob Smith 2John Smith Project - ProjectIdProjectOwner

RE: I heard that MySQL 4.01 supports Views?

We shoudn't stifle interest in this list. We should offer guidance and direction and thus help them help themselves (ie; Please follow the yellowbrick road...) I don't think that was his intent... It's just that this is in the .sig for the list... snip

Re: FULLTEXT error?

Doug, Can quite see why you have id as a key twice, but... This worked first time for me (3.23.40-nt). Regards, =dn Error SQL-query: CREATE TABLE quotes ( id int(9) NOT NULL auto_increment, author varchar(255), content text,

Re: Myisamchk can't repair table help help help

Steve Rapaport wrote: Arrrggghhh! This is definitely a problem! Can't access table White in mysql 4.0.1: table is read-only. why? because it's corrupt! Try to fix: takes a long time (about an hour) and seems to work. But it's still corrupt and read-only: [cut] [root@db1

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 05:16 pm, you wrote: At 17:09 -0500 2/27/02, Anthony W. Marino wrote: On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the

ignore words in full text indexes

Hi all, I m using mysql 4.01 alpha I read in the doc : MySQL uses a very simple parser to split text into words. A ``word'' is any sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in the stopword list or just too short (3 characters or less) is ignored. My queries let

RE: ignore words in full text indexes

David, I think the nominal minimum word length is 4 so 'fiat' will not be indexed. This can be modified however. regards, Dan -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 12:28 p.m. To: [EMAIL PROTECTED] Subject: ignore words in

heap tables and slow index query

server version: 3.23.47 mysql create table myhits ( - libid int unsigned not null, - begin bigint unsigned not null, - end bigint unsigned not null, - index(libid), - index(begin), - index(end) - ) type = heap; Query OK, 0 rows affected (0.00 sec) [ insert statement

MySQL-3.23.49-1.src.rpm does not build under RedHat Linux 6.2

I see binaries are now shipping with vwesrion 3.23.49a. Have sources been changed since 3.23.49? I'm asking since I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails like this: [..snip...] creating libmysqlclient.la (cd .libs rm -f

Re: Problem with Insert

Hi- Problem: Having trouble inserting text files longer than a few lines into MySQL although short ones go in fine. I'm using a form in HTML to get a value for $abstract... form method=POST action=abstract_submit.php textarea name=abstract rows=20 cols=70/textarea /form I am then using PHP

Re: ignore words in full text indexes

Hi! On Feb 28, David yahoo wrote: Hi all, I m using mysql 4.01 alpha I read in the doc : MySQL uses a very simple parser to split text into words. A ``word'' is any sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in the stopword list or just too short (3

Re: Query Problem...

Thanks guys, works a treat. Yip, it was the Alias thing... interesting. - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: asherh [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:39 PM Subject: RE: Query Problem... * asherh An example of the

  1   2   >