Re: binary expansion?

adam nelson queried: > iPersonType is a list in the form of 1,2,4,8,16,32,64 > > so, let's suppose that szPersonType for 8 is lawyer and szPerson type > for 2 is redhead > > a value of iPersonType of 10 would mean redhead lawyer. > > I'd like a query that looks for lawyers (ie. iPerson type is an

Re: MySQL Connection error

But my program works fine and all those java code i used to connect to mysql is what i have been taught by my lecturer it works fine..only things is that i never leave my application up for more than a day and that when i discover this problem. Usually i restart tomcat and it works again but the

ASP and MySQL

I am having a problem inserting names with apostrophes into the MySQL database. I am using ASP as my front end with standard SQL statements to add, edit and delete records. I read the section in the manual on escape characters and have played around with many different variations trying to get i

Re: MySQL Connecyion error

At 20:23 -0800 3/26/02, Foo Yong Choon wrote: >i tried to catch the exception and recoonect to MySQL >server and it >dose not work, i also tried open and closing the >connection only when i need it and that does not work >too so i had to resort to not this alternative. anyway >thanks fr your solut

Re: Enforcing Column Types

Tino Didriksen queried: > I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5 > hashes are always 32 byte. > In other words, that's 1 byte wasted because it's VARCHAR. > > With 2500 entries and more on the way, that's at least 2500 byte wasted. 2500 bytes out of 82,500? Th

html to perl to mysql

Using apache 1.3.23 for win32 WinXp and Perl 5.6 and Mysql 3.23.44-nt The localhost test page by apache runs correctly The perl script runs from the command line, the Browser url line and just by clicking it in the dir. Trying to launch this perl-dbi script from the browser, all it d

Re: MySQL Connecyion error

i tried to catch the exception and recoonect to MySQL server and it dose not work, i also tried open and closing the connection only when i need it and that does not work too so i had to resort to not this alternative. anyway thanks fr your solution.. and how to make disable auto closing indefinat

Re: PHP, BLOB file, MySql and my web site

Thanx Maxim, I did try this in the past but the problem I had with the method is in terms of updated/deletion particularly when you delegate the job. Which means I can easily just delete the record in mysql but I have to manually look for the particular graphic to delete then it gets mesy when th

Re: MySQL Connecyion error

On Tue, 26 Mar 2002 18:44:54 -0800 (PST) Foo Yong Choon <[EMAIL PROTECTED]> wrote: > My application cannot connect to the database and > perform SQL qurey after usuualy after a day. > > I heard that mysql automatically close connection > after 8 hrs of inactivity. > > Hope u can email me how t

RE: MySQL Connecyion error

Why can't you just detect the connection failure and reconnect? > -Original Message- > From: Foo Yong Choon [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 7:45 PM > To: [EMAIL PROTECTED] > Subject: MySQL Connecyion error > > > My application cannot connect to the database a

Re: MySQL Connecyion error

At 18:44 -0800 3/26/02, Foo Yong Choon wrote: >My application cannot connect to the database and >perform SQL qurey after usuualy after a day. > >I heard that mysql automatically close connection >after 8 hrs of inactivity. > >Hope u can email me how to prevent the auto closing or >any alternative

MySQL Connecyion error

My application cannot connect to the database and perform SQL qurey after usuualy after a day. I heard that mysql automatically close connection after 8 hrs of inactivity. Hope u can email me how to prevent the auto closing or any alternative method. Thanks in advance! _

RE: Coldfusion,Mysql,Myodbc

Hi !! Sorry for the delayed response on this. > > Hi there . > I am new to Mysql.I have to access mysql from coldfusion..and we dont get > myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am > not able to compile the myODBC bit...its giving compilation problem..Any > sugge

Date Interval Grouping

Ok here's what I trying to do. I am trying to design a little browser/ip tracking page and I need an SQL statement that will allow me to group IPs that hit the site in 5 minute intervals (well I just want the interval thing to work cuz I'll prolly want to make this like 30 minutes or a full hour).

Re: load data infile question

At 20:41 + 3/26/02, Harpreet Kaur wrote: >I want to transfer data from a table in sql server to mysql. I use >C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c >-t \t -r \n >to write the data to a text file and then use >load data infile ‘/var/www/html/tblname.txt' i

temporary tables select

Hello mysql, I have strange problem: I create a temporary table (let's say temp_table) with one bigint(20) field. And then, when I try select * from temp_table in same session - mySQL says that this table doesnot exist.. But I cannot create one more in this session - mySQL says that this table

Re: Number of connections to mysql server

On Tue, 26 Mar 2002 22:45:18 -0300 "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]> wrote: > Hi, > > I have a client BD application that access a remote MYSQL server and its job > is 4-7hours long and it should be connected to the server all this time :( > My question is: how many simult

Re: [Newbie] MATCH and INDEX question (using a JOIN in a MATCH statement)

At 13:43 -0700 3/26/02, Dan Tappin wrote: >This is a follow-up to a MySQL keyword text search question I had answer a >few days ago. > >I have table 'main' which has two INT columns 'maincat' and 'subcat' which >hold an index number from to other tables maincat and subcat. These table >each hold

Re: Number of connections to mysql server

At 22:45 -0300 3/26/02, Edilson Vasconcelos de Melo Junior wrote: >Hi, > >I have a client BD application that access a remote MYSQL server and its job >is 4-7hours long and it should be connected to the server all this time :( Why is that a problem? >My question is: how many simultaneous connect

Number of connections to mysql server

Hi, I have a client BD application that access a remote MYSQL server and its job is 4-7hours long and it should be connected to the server all this time :( My question is: how many simultaneous connections the mysql server can handle? And what does happen when this limit is overstepped? Thank u

upgrade 3.22 to 3.23 or 4.0 version

Hi I'm trying to upgrade my MySQL 3.22 version to 3.23 or 4.0 version on Linux flatform, but I don't know the procedure. Could any one please tell me the procedure how to do it. And if I upgrade to the higher version do I lose any of my data. Thanks Swapna -

Re: PHP, BLOB file, MySql and my web site

Hello Tokunboh, I'm not saving any binary data in database, only saves relative (to webserver root) image paths there, and then just put them to tag. Wednesday, March 27, 2002, 3:05:35 AM, you wrote: OT> Hi All, OT> Can anyone guide me on how to list the content of mysql table or result of a

PHP, BLOB file, MySql and my web site

Hi All, Can anyone guide me on how to list the content of mysql table or result of a query that has a BLOB file in it on my web page. I am listing the result of the query OK now, but mysql query is listing the name of the graphic (image1.gif) file instead of the graphic itself. I am working on a

rdf utf-8 -> to mysql howto

Hi all, My purpose is to transform an rdf utf-8 file into sql for mysql. Data are both in french/english, in french there are stange caractere that doesnt render well (çèé...) What the output had to be ? Mysql only support latin1 ? I m lost in all that encodage ! Help me I dont know how to pa

MySQL client timezone

Hello 'mysql, Does anybody know is this possible to set some particular timezone for the session? ie: server is in GMT, but application needs time selected in GMT+3 Is there any universal way ? Thanx for any hint in advance -- Best regards, Maxim mailto:[EMAIL PROTECTE

RE: phpMyAdmin issue

The problem is PHP and IIS... IIS takes a lot to get it to work... I think you should ask sourceforge about it, not the mysql mailing list. This is a PHP issue not a mysql. -Original Message- From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 6:24 PM To:

phpMyAdmin issue

Hi I have got phpMyAdmin connecting to my server. When i open up index i can see on the left hand side my datbase and tables. And on the right of the page is the welcome page... Welcome to phpMyAdmin 2.2.5 MySQL 3.23.32 running on 136.201.105.3 as [EMAIL PROTECTED] phpMyAdmin <<.

Re: RSA encrypted strings - what data type?

Well, I screwed around with it. This is what I got ( just in case anybody cares.. ) ( this is in perl, using the Crypt::RSA module.. ) $password = "screwyou!"; # encrypts the 'password'... $cyphertext = $rsa->encrypt(Message=>$password, Key=>$pub); # now convert the RSA encrypted key to binar

RE: question about converting isam to myisam tables (shotcut!)

Hank Instead of dropping down to OS cp commands, insert the data from table TBL_FLAT to TBL_INDX. INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT; This will be valid in mysql. The insert will be fast since only one insert statement. Let the list know if this works for you. Or if your method is val

FW: Access break mode error

I actually posted this yesterday, but I think it got lost with the whole Oracle debacle. If anyone has experienced this your feedback would be greatlt appreciated. best regards, Aaron Occasionally with MyODBC, MySQL and Access I am getting an error when trying to close a window stating 'This a

Re: RSA encrypted strings - what data type?

> I'm trying to take a string ( In this case, a password ), and encrypt it > with RSA encryption via the perl module, Crypt::RSA. Later on, I want > to be able to pull the encrypted string back out and decrypt it. > > One of three things happens when I do this however. > > 1) Everything works fin

Re: Adding a Column to an existing table

At 02:32 PM 3/26/2002, you wrote: >Hi, I'm new to this list, hopefully, I can contribute some wisdom :) > >At the moment, I have to update a large database to be multi-company-ready, >so I basically have to add a Column "Company_ID" to nearly each table. > >What would be the easiest way to do this

Re: Report to Recipient(s)

On Tue, 26 Mar 2002 [EMAIL PROTECTED] wrote: > Date: Tue, 26 Mar 2002 16:39:05 -0500 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Report to Recipient(s) > > Incident Information:- > > Originator:[EMAIL PROTECTED] > Recipients:[EMAIL PROTECTED] > Subject: mysql Digest 26

Re: RSA encrypted strings - what data type?

On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote: > On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote: > > > > I'm trying to take a string ( In this case, a password ), and encrypt it > > with RSA encryption via the perl module, Crypt::RSA. Later on, I want > > to be able to pull the

question about converting isam to myisam tables (shotcut!)

Hello all, I'm in the process of building a new mysql db server box to migrate a database off an existing web server. The webserver is running mysql 3.22.29, and the new box is running 3.23. The two biggest tables are about 20 million records and the data and index files are each just over 1

Re: RSA encrypted strings - what data type?

On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote: > > I'm trying to take a string ( In this case, a password ), and encrypt it > with RSA encryption via the perl module, Crypt::RSA. Later on, I want > to be able to pull the encrypted string back out and decrypt it. Note that if you do thi

Re: binary expansion?

On Tuesday 26 March 2002 3:30 pm, adam nelson wrote: > It's been a while since I've done this, does anybody remember: > > > If I have 2 tables: > > tblPerson ( > iPersonID int > szPersonDesc varchar > iPersonType int > ) > > tblPersonType ( > iPersonType int > szPersonType varchar > ) > > iPersonT

Re: binary expansion?

From: adam nelson <[EMAIL PROTECTED]> > It's been a while since I've done this, does anybody remember: > I'd like a query that looks for lawyers... Have you thought about using an unsigned int and doing bitwise math? --- Rodney Broom Programmer: Desert.Net sql --

RSA encrypted strings - what data type?

Hi, I'm new to the list and I joined because I couldn't figure out the answer to this problem. I'm trying to take a string ( In this case, a password ), and encrypt it with RSA encryption via the perl module, Crypt::RSA. Later on, I want to be able to pull the encrypted string back out and decr

binary expansion?

It's been a while since I've done this, does anybody remember: If I have 2 tables: tblPerson ( iPersonID int szPersonDesc varchar iPersonType int ) tblPersonType ( iPersonType int szPersonType varchar ) iPersonType = iPersonType (foreign key between the 2 tables) iPersonType is a list in the

mysqlgui crash caused by infinite loop

>Description: mysqlgui crash caused by infinite loop in mysql_read_default_options because strcend never returns 0 >How-To-Repeat: >Fix: --- libmysql/libmysql.c.origThu Feb 14 18:30:17 2002 +++ libmysql/libmysql.c Tue Mar 19 15:52:49 2002 @@ -712,7 +712,7 @@ s

[OT] Re: BCP

On Tuesday 26 March 2002 2:56 pm, Harpreet Kaur wrote: > I am using > C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c > -t \t -r \n > > to create a text file from a sqlserver table . Th text file shows a tab > after every field except the last field. How can i get it to

BCP

I am using C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to create a text file from a sqlserver table . Th text file shows a tab after every field except the last field. How can i get it to put a tab even after the last field. Help is appreciated, re

Integrating MySQL with Flash or LiveMotion via Lasso

For those of you looking for assistance with building Web-based front-ends to MySQL using Macromedia Flash or Adobe LiveMotion, you may be interested in two tutorials authored by Jordan Chilcott (an independent Web developer) that were made available today. Details are available at

Report to Recipient(s)

Incident Information:- Originator:[EMAIL PROTECTED] Recipients:[EMAIL PROTECTED] Subject: mysql Digest 26 Mar 2002 21:04:43 - Issue 1818 Message from [EMAIL PROTECTED] was quarantined because it contained banned content.

RE: phpMyAdmin issue + looking for php/mysql websites

Read the documentation. Where is the mySQL database located? Is it on the web server or on another machine? If its on another machine then you put in the IP address. If its on the same machine as the Web Server, then put in localhost Get it? -Original Message- From: catriona grisewoo

FW: RE: phpMyAdmin issue + looking for php/mysql websites

> Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query Gaah.. > Hi, > > > I use PHP (cgi) with IIS and phpMyAdmin. The > > problem with the head

RE: phpMyAdmin issue + looking for php/mysql websites

Is there a reason why you are using IIS? I would disable IIS and run apache. That's what I did, IIS is way to difficult and unstable to install PHP as CGI or ISAPI Apache is easy to set up with PHP. Download Apache and run PHP from there. Make sure you disable ALL the IIS services -Ori

Re: Query causes Mysql to shut down

At 20:36 26/03/02 +, Richard Prangnell wrote: Hi! Please, Can you send me a test case ? Including the create table statement, some rows for to insert and the queries. Regards, Miguel >Dear sirs, > >I have a situation on my local Windows development platform that is causing >the mysql daemon

Re: query help

[For the spam-bot: Go away, you annoying little beast. You know I'm not posting spam so stop querying me about it and let's get back to the topic at hand; sql] On Sunday 03 February 2002 1:27 pm, Chuck Barnett wrote: > > Hi, I have a db field that holds the first and last name of a person.  I

RE: phpMyAdmin issue + looking for php/mysql websites

when im connecting to an online MySQL server do i just put in the server name ie 'orac'in the config file or do i need to put in its ip address etc with it ? --- "Hathaway, Scott L" <[EMAIL PROTECTED]> wrote: > I use PHP (cgi) with IIS and phpMyAdmin. The > problem with the header > function is j

RE: Impact of Free ORACLE

At 02:20 AM 3/26/2002 +, [EMAIL PROTECTED] wrote: >Here is what the MadProfessor needs to do: > >1. Contact you local Oracle Marketing Rep. He will set >you straight on licensing and pricing. > >2. Go read the Oracle9iAS Data Sheet. Notice that they >use Apache and throw in couple of their own

RE: phpMyAdmin issue + looking for php/mysql websites

Im not sure what way php is installed as it was already installed on the server here. How i got this message exactly was when i opened up MyphpMyAdmin after just installing it. I go to create a new datbase and thats when the error page comes up. Could it be i dont have the config file setup correc

[Newbie] MATCH and INDEX question (using a JOIN in a MATCHstatement)

This is a follow-up to a MySQL keyword text search question I had answer a few days ago. I have table 'main' which has two INT columns 'maincat' and 'subcat' which hold an index number from to other tables maincat and subcat. These table each hold descriptive names ('name') for each of the main

load data infile question

I want to transfer data from a table in sql server to mysql. I use C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to write the data to a text file and then use load data infile ‘/var/www/html/tblname.txt' into table tblname; It works fine for all the tabl

RE: phpMyAdmin issue + looking for php/mysql websites

I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ?> deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error

Re: query help

- Original Message - From: <[EMAIL PROTECTED]> To: "Chuck Barnett" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 2:09 PM Subject: Re: query help > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must in

mysql password

Hi, I have a table with username and password. The password is encrypted using mySQL's password function. But when I try to perform a match using PHP, e.g., $query = "select count(*) from auth where usrname='$logname' and usrpass=password('$logpass')"; $result = mysql_query($query) or exit ("C

Query causes Mysql to shut down

Dear sirs, I have a situation on my local Windows development platform that is causing the mysql daemon to shut down. I cannot recreate the problem on the web server, which is Linux. The error message (on Windows) is: MYSQLD-OPT caused an invalid page fault in module MYSQLD-OPT.EXE at 017f:0046

RE: phpMyAdmin issue + looking for php/mysql websites

> "The specified CGI application misbehaved by not > returning a complete set of HTTP headers. The headers > it did return are:" Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with

Re: SELECT w/LIKE on Swedish character ö finds ], why?

Hi Philip, before running your test next time try this: vi /etc/my.cnf insert into this file: [mysqld] default-character-set = swe7 then stop mysql (mysqladmin shutdown) and restart (safe_mysqld&) then try your test again. It worked fine for me. Ken > Philip Semanchuk wrote: > > > > H

phpMyAdmin issue + looking for php/mysql websites

when i try to create a database i get the message "The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:" I dont think i set up mySQL properly maybe ? Any ideas? ps does anywone know of a brilliant website for learning php an

RE: Adding a Column to an existing table

The easiest way to add a column is to get somebody else to do it. Seriously, Use the "ALTER TABLE TableName ADD COLUMN Company_id INT UNSIGNED NULL" command. This syntax may be found in the MySQL manual in 6.5.4 http://www.mysql.com/doc/A/L/ALTER_TABLE.html ,or page 428 if you have downloaded the

$basedir

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: mysql doesn't find symbolically linked directory >Description: mysqld_safe doesn't find sy

Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

On Tue, 26 Mar 2002, colin o wrote: > Same thing happens to me, > > i just use bin/safe_mysqld --user=root & > to start to server so that i can use mysql. > I don't know exactly why it happens though. > Possibly permissions?? It is better to run mysqld as a non-root user, such as mysql. > ---

Re: Adding a Column to an existing table

Run the following for each table: ALTER TABLE tableName ADD COLUMN Company_ID INT UNSIGNED NULL; Hope this helps. Ulrik Witschass wrote: >Hi, I'm new to this list, hopefully, I can contribute some wisdom :) > >At the moment, I have to update a large database to be multi-company-ready, >so I

RE: Adding a Column to an existing table

How are you determining the value to put in the Company_Id field? You can use phpMyAdmin to easily add a column with a default/no null setting to your tables to get you started. (It uses a MODIFY command I believe). If you have the logic for determining the values of Company_ID, you could do as y

Adding a Column to an existing table

Hi, I'm new to this list, hopefully, I can contribute some wisdom :) At the moment, I have to update a large database to be multi-company-ready, so I basically have to add a Column "Company_ID" to nearly each table. What would be the easiest way to do this? I already thought about running a "SE

RE: Trapping for no user input in a query

Kim, See the Pattern Matching section of the manual at: http://www.mysql.com/doc/P/a/Pattern_matching.html A "_" matches any single character, while a "%" acts as a wildcard match. -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:36 AM To:

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Same thing happens to me, i just use bin/safe_mysqld --user=root & to start to server so that i can use mysql. I don't know exactly why it happens though. Possibly permissions?? Colin --- Mike Yrabedra <[EMAIL PROTECTED]> wrote: > > What would cause this error to occur all of a > sudden? >

Single DB trying to replicate to itself?

RH 7.2. mysql-3.23.44 I have a single server running mysql. I have added one database I use. For some unknown reason, it appears that mysql is trying to replicate to something, failing and causing mysql to stop responding almost daily. /etc/my.cnf has no reference to any master/slave or replicati

mySQL System config ... jumbo db size

Any suggestions on how to pull off the following ... I'd like to setup a box to function primarily as a database server. Secondary functions will be running some java applications, basic apache web server. My intent is to use mySQL as the db behind a small web search engine. I'll certainly be g

RE: Importing Tables Data into MySQL from Access

I actually tried this just a few moments ago and it worked! But thanks! T. Edison jr. --- Andrew Hazen <[EMAIL PROTECTED]> wrote: > Print out a "documentation" of the Access database. > Use phpMyAdmin > interface to build the same table structures in > MySql. > > Export Access tables as comma

ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

What would cause this error to occur all of a sudden? ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Server: Mac OS X 10.1.3 > - > Before posting, please check: > http://www.mysql.co

Importing Tables Data into MySQL from Access

Hi, I'm looking to Import complete MS Access Table with Data into a MySQL Database. How can i do that? Especially if i have to do it for a site on the internet... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academ

RE: SELECT w/LIKE on Swedish character ö finds ], why?

> If I were to take a wild guess I would say that the lower 7 bits of ö > and ] match. Which would mean that this isn't really text, ie 7-bit > ASCII, but really BINARY data. Which means either you need "create > table simple (name varchar(255) BINARY NOT NULL);" or "create table > simple (name

RE: SELECT w/LIKE on Swedish character ö finds ], why?

THanks Makis, is this bug documented anywhere? > -Original Message- > From: savaidis [mailto:[EMAIL PROTECTED]] > Sent: den 26 mars 2002 18:04 > To: Philip Semanchuk; [EMAIL PROTECTED] > Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why? > > > I have the same problem with G

Re: SELECT w/LIKE on Swedish character ö finds ], why?

Philip Semanchuk wrote: > > Hi everyone, > I am having a little trouble with searching for Swedish characters. When I > SELECT using LIKE I get matches that I do not expect. I have created a > simple test case that is entirely reproduced below. To summarize, I insert > one row into a single-colum

RE: Impact of Free ORACLE

Geez, get a grip. You should've counted on the predictable, endless sarcasm that came as a reply to something that would've been pretty big news, NOT on only 1 or 2 people pointing out that you're wrong. Most critics here think that they will be the first or only person to reply, or believe their

RE: SELECT w/LIKE on Swedish character ö finds ], why?

I have the same problem with Greeks, it is a bug of MySQL. Try: 1) Create the fields of the table with BINARY option. 2) Use LIKE with BINARY option (slower) BINARY doesn't make the uppercase convertion. Makis > -Original Message- > From: Philip Semanchuk [mailto:[EMAIL PROTECTED]] > Se

SELECT w/LIKE on Swedish character ö finds ], why?

Hi everyone, I am having a little trouble with searching for Swedish characters. When I SELECT using LIKE I get matches that I do not expect. I have created a simple test case that is entirely reproduced below. To summarize, I insert one row into a single-column table that contains the right squar

RE: Enforcing Column Types

At 16:55 +0100 3/26/02, Roger Baklund wrote: >* Paul DuBois >> At 15:23 +0100 3/26/02, Tino Didriksen wrote: >> >Question about the CHAR to VARCHAR conversion of: >> >http://www.mysql.com/doc/S/i/Silent_column_changes.html >> > >> >Now, I can see the logic in changing most CHAR to VARCHAR if

RE: Enforcing Column Types

* Paul DuBois > At 15:23 +0100 3/26/02, Tino Didriksen wrote: > >Question about the CHAR to VARCHAR conversion of: > >http://www.mysql.com/doc/S/i/Silent_column_changes.html > > > >Now, I can see the logic in changing most CHAR to VARCHAR if > they are long > >and variable sized. > >I have a colum

Re: Enforcing Column Types

At 15:23 +0100 3/26/02, Tino Didriksen wrote: >Question about the CHAR to VARCHAR conversion of: >http://www.mysql.com/doc/S/i/Silent_column_changes.html > >Now, I can see the logic in changing most CHAR to VARCHAR if they are long >and variable sized. >I have a column that is VARCHAR(32). I use i

Re: Boolean Fulltext in 4.0.2 bug

Hi! On Mar 22, Alexander Belyaev wrote: > Hi, > > I know, many fulltext bugs fixed last two weeks, thanks! > But this nice mysql4 feature are critical for us, we plan to use it in many > projects... and we test it again and again... :) > > My test case: > http://www.graphit.ru/fulltext402.tar.

Re: Enforcing Column Types

On 26 Mar 2002, at 15:23, Tino Didriksen wrote: > I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5 > hashes are always 32 byte. In other words, that's 1 byte wasted because > it's VARCHAR. > > With 2500 entries and more on the way, that's at least 2500 byte wasted.

Re: MySQL C API documentation

Konstantin Osipov writes: > * Michael Widenius <[EMAIL PROTECTED]> [02/03/26 12:41]: > > > But, according to MYSQL C API documentation, 8.4.2, > >(http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview) > I have to do this: > > "An advantage of mysql_us

Re: mysql.server

All init.d daemons take one of two options. These are "start" and "stop". Init supplies the correct option when changiing run levels. Where the daemon resides varies among versions of UNIX/Linux. [EMAIL PROTECTED] wrote: >>Description: >> >regarding mysql.server daemon > >>How-To-Repeat: >> >

Enforcing Column Types

Question about the CHAR to VARCHAR conversion of: http://www.mysql.com/doc/S/i/Silent_column_changes.html Now, I can see the logic in changing most CHAR to VARCHAR if they are long and variable sized. I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5 hashes are always 32

Re: mysqlhotcopy

On Tue, 2002-03-26 at 07:24, Hans Kind wrote: > Dear Martin, > > I tried that option, but it returns a errono 24: > > ../bin/mysqlhotcopy -u username -p password --flushlog --allowold > --regexp='.*' /d1/terminal-a/mysql/ > 'mail' is an empty database > 'opt' is an empty database > 'oveas' is a

MySQL privileges

Felik, Tuesday, March 26, 2002, 10:11:31 AM, you wrote: FH> In MySQL, pls tell me which privileges should I grant FH> to every FH> user so they can change their password? They should have grant privilege but it's not right way giving access to MySQL privilege tables. You can read more about MySQ

First Question

Dennis, Tuesday, March 26, 2002, 2:12:43 PM, you wrote: DP> My boss told me I have three days of time to develop a php-website that DP> is capable to handle SQL-Requests into a database. DP> Problem is I don't have any experiences. DP> Now I have startet with compiling Apache with PHP support

eplication-bin.log binary corrupt ? help me !!!

Dicky, Wednesday, March 27, 2002, 12:45:20 AM, you wrote: DWP> mozart:/usr/local/mysql/data# mysqlbinlog /app/backup-replication/austria_replication.031 DWP> ERROR: Bad magic number; The file is probably not a MySQL binary log DWP> the beginning of this file is corupt ... how can i use/fix it

Multiple Search

delz, Tuesday, March 26, 2002, 5:15:51 AM, you wrote: d> How do i perform multiple search in mysql. For example I have a database d> running in a computer shop and I want to search for Monitors specifically d> purchased from 03/01/2002 to 03/31/2002. Can any one help me? SELECT * FROM your_tabl

Re: Re: MySQL replication

Thanx Shawn I also realised that you can use SHOW MASTER STATUS and SHOW SLAVE STATUS both will tell you where they are now. MASTER will tell you the size on the bin-log SLAVE will tell you where it is in the bin-log sql query -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Ouelle

Re: mysql/php on Win2000

i've got IIS (so i can do ASP), apache, php, mysql and darwin streaming server all running on a w2k box that i use for web dev. i've set the services to start manually and depending on what i'm doing for the day i'll start them up individually. all works, it's fast and rarely give me hassle - r

RE: Coldfusion,Mysql,Myodbc

On Tue, 26 Mar 2002, Xavier Prelat wrote: > Even if you are using the CFServer 5.0 you will not be able to edit any > MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL > ODBC on your server, then create any DSN you need using the ODBC Sources > tool (administrator tool o

Segmentation fault in MySQL database on Solaris2.8 for Intel.

Hi, After following the procedure on the web site for installing the MySQL database on Solaris machine we encountered Segmentation fault (during the Configuring mySQL for your machine step). Please help me with this. Regards, Prachi.

RE: Coldfusion,Mysql,Myodbc

Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL ODBC on your server, then create any DSN you need using the ODBC Sources tool (administrator tool on Win 2000). Once you created the DSN you want, the C

Re: Coldfusion,Mysql,Myodbc

On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: > > > > Hi there . > I am new to Mysql.I have to access mysql from coldfusion..and we dont get > myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am > not able to compile the myODBC bit...its giving compilation problem..Any >

  1   2   >