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; > ++--+--+ >

.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: 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

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 th

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 we

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 (

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: 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 Electronic

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 https://order.mysql.

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 characte

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

.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 archiv

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),

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 (t

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

Stewart, > All you should have to do is wrap the statement in () like: > UPDATE SET field=(field+1) WHERE 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 with parentheses, but

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 > fi

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 'ch

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 > e

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 way

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

character set

Hello, is possible to change encoding (character set) while conecting to mysql from php ?? (In postgre is SET client_encoding = 'latin2'). Thank you. Lampa aka Michal - Before posting, please check: http://www.mysql.com/ma

running mysql w/php..

Floyd, Wednesday, February 27, 2002, 2:31:56 AM, you wrote: FB> Hi.. Can anyone tell me some good places to look for sample snips, FB> tutorials or other assistance specifically for making PHP and mySQL FB> cooperate. Running mysql queries using php syntax. Mysql talks about FB> mysql queries,

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

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 i

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 SET field=(field+1) WHERE This will work fine from PHP using s

<    1   2