turn $2000.00 into $1600.00 in 14 days

2001-02-01 Thread llspo445se
New Concept in Gifting! Join A Team Of 6 And 7 Figure Earners The sole purpose of this Activity is to enable us to bless more people and to change lives by helping others receive gifts, which will enable the receiver to share their blessings with others! * Gift $2000 to prosper over $16,000

Re: Data Modeling

2001-02-01 Thread John Dean
Hi Hopefully, we plan to include Dezign for Databases in our new GUI client, but this is not yet embedded in stone. At 23:54 01/02/2001 -0500, Michael Lépine wrote: >I've tried searching the archives, but I haven't seen a direct question >about an open source tool or freely available application

Re: state: reading from net

2001-02-01 Thread Jeremy D. Zawodny
On Fri, Feb 02, 2001 at 08:12:23AM +0100, Manfred Meier wrote: > Hello, > > does anybody know what "Reading from net" means in the "State" > column of the output of mysqladmin processlist? I've always assumed that it means "I'm reading data from the network". Jeremy -- Jeremy D. Zawodny, <[EMAI

Install My-SQL on an NT

2001-02-01 Thread Lars-Olof Albertson
Hello, I am new to the list and new to My-SQL. I want to test My-SQL on my NT, but have trubble to get it to work. I have downloaded the shareware release of MySQL for Win32 and installed it. According to the manual I should use "C:\mysql\bin\mysqld-nt" to start the server, but there is no file

RV: Where is file mysql.sock?

2001-02-01 Thread Iago Sineiro
-Mensaje original- De: Iago Sineiro [mailto:[EMAIL PROTECTED]] Enviado el: jueves 1 de febrero de 2001 14:09 Para: mysql list Asunto: Where is file mysql.sock? Hi all. I want to know where is file mysql.sock. I ask it because I change the my.cnf configuration file placed in /etc direc

Re: [CGI] Gas Prices

2001-02-01 Thread Johannes Pretorius
Around here it is R3.62 a LITER that would be 45c USD a LITER.. we kinda think that is expensive too :L) Johannes SA Rolf Hopkins wrote: > Geez, it's gone up to 90c now?!?!?! I've been away too long!!! Talk about > expensive gas. I thought it was only meant to rise about 10c with the GST. >

state: reading from net

2001-02-01 Thread Manfred Meier
Hello, does anybody know what "Reading from net" means in the "State" column of the output of mysqladmin processlist? Thank you Manfred Meier [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Linux limited to 256 connections by default?

2001-02-01 Thread Matthias Urlichs
Hi, There's one other problem to be aware of. Currently, MySQL uses "fd_set" data structures in a few places. GLIBC 2.1 has __FD_SETSIZE hardwired to 1024. This means that any use of a file descriptor >1023 WILL cause data corruption or crashes. Somebody please change MySQL to only use malloc'e

Re: Large text searches

2001-02-01 Thread Matthias Urlichs
Hi, Sander Pilon: > FULLTEXT indexes are about 95% of the size of the table, and they can > perform quite well or very slow, depending on what you do. > For my use (a trouble-ticket database), they behaved extremely poorly, unfortunately. The tickets frequently are over a MByte in size, which r

Fwd: MySQL problem

2001-02-01 Thread Danny
-When you deleted the rpm version of mysql did you use the rpm command to dlete mysql? - What version of mysql are you trying to install? - Maybe, look at deleteing all the current mysql rpm with the rpm command and try it without the --no-deps option. - Or install a prevous version of mysql?

Re: MyODBC Error

2001-02-01 Thread Miguel Angel Solórzano
At 12:23 02/02/2001 +0800, Li Sze wrote: Hi, Try to use the variables below in your my.cnf file: [mysqld] set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M Set the values according with your necessities and read in the MySQL Manual the item Tuning server parameters. Regar

test (Please Ignore)

2001-02-01 Thread Ralf R. Kotowski
Sorry, reconfiguring e-mail server, didn't have anything else had hand to test. Once again I'm sorry Ralf R. Kotowski Jones Unlimited, Inc. - Do you Jones? We've got your flix!

CHEAP COMPUTERS!!

2001-02-01 Thread bob smith
.. http://www.impristine.com/stuff.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]>

Re: read-only tables

2001-02-01 Thread Jeremy D. Zawodny
On Fri, Feb 02, 2001 at 12:11:07AM -0800, Matthew Halliday wrote: > > I have a database that I finally got connected to my newly installed > MySQL, I've had a bad week, however I can't add information to the > tables, it says they are read only! How can I fix this? I've check > the manual but I a

Re: read-only tables

2001-02-01 Thread Danny
Hello Thats probably you username in user table has given you only SELECT prilvages (Select_priv) You can log in as root in mysql and UPDATE the user table to give you INSERT, DELETE privlages Refer to any sql book on the syntax of UPDATE On Fri, 02 Feb 2001, Matthew Halliday wrote: > I have

Re: Data Modeling

2001-02-01 Thread Danny
For UNIX users (eg BSD, linux) there is something called dia which allows you to draw ERDs But, I assume you are looking something more like a RAD tool rather than a simple program that allows you to draw UML, ERD's etc. However, if you are intersted in dia and using Linux you can find the rpm

Re: showing users

2001-02-01 Thread arvin u. cada
yeah! it rocks, thanks a lot :) At 05:50 AM 2/2/01 +0100, Benjamin Pflugmann wrote: >Hi. > >Don't know if there is a better method, but one is to run (by a user with >root privileges): > >mysql> SELECT user, host FROM mysq.user ORDER BY user, host; > >Bye, > > Benjamin. > > >On Fri, Feb

read-only tables

2001-02-01 Thread Matthew Halliday
I have a database that I finally got connected to my newly installed MySQL, I've had a bad week, however I can't add information to the tables, it says they are read only! How can I fix this? I've check the manual but I am really new to SQL and linux. -matthew --

Data Modeling

2001-02-01 Thread Michael Lépine
I've tried searching the archives, but I haven't seen a direct question about an open source tool or freely available application that could be used to model a relational database schema. Some of my friends use Sybase's Power Designer or ERwin, but these are very expensive (at least for me) tools.

Re: mySQL IS winning

2001-02-01 Thread Jeremy D. Zawodny
On Fri, Feb 02, 2001 at 11:06:14AM +0800, Rolf Hopkins wrote: > > Well, even so, if you are going to make a profit from it, you should > purchase some sort of support, right? and it really isn't that > expensive, either. I won't argue with that. :-) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Tec

Re: showing users

2001-02-01 Thread Benjamin Pflugmann
Hi. Don't know if there is a better method, but one is to run (by a user with root privileges): mysql> SELECT user, host FROM mysq.user ORDER BY user, host; Bye, Benjamin. On Fri, Feb 02, 2001 at 11:17:36AM +0800, [EMAIL PROTECTED] wrote: > hi listers, > > just wanted to know the c

MyODBC Error

2001-02-01 Thread Li Sze
Hi, I'm using SQLPutData and SQLParamData to insert data into the database. It works fine with data files smaller than 1MB. However, I get the following error for the last call to SQLParamData when the data file is more than 1MB. I have no idea what the following error means. I would really appre

Missing rows from select statements on heap table type

2001-02-01 Thread Christopher L. Everett
I upgraded from 3.23.27-beta to 3.23.32 after seeing bugfixes on intermediate versions. However the problems are continuing: Mod_perl DBI/DBD::mysql queries are failing to return rows that I know exist. It could be DBI/DBD::Mysql, but just in case I have some questions: - Are there known pr

showing users

2001-02-01 Thread arvin u. cada
hi listers, just wanted to know the command for checking the list of usernames allowed to connect to a mysql server. any help would be greatly appreciated. thanks, - Before posting, please check: http://www.mysql.com/manua

Re: RE:mySQL is winning

2001-02-01 Thread David Xu
Mysql supports many platforms while ORACLE not, does ORACLE support my lovely FreeBSD box? Regards, David Xu - Original Message - From: "Fowler, J.T." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 11:17 PM Subject: RE:mySQL is winning > My

Re: mySQL IS winning

2001-02-01 Thread Rolf Hopkins
Well, even so, if you are going to make a profit from it, you should purchase some sort of support, right? and it really isn't that expensive, either. - Original Message - From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: "Brad Christensen" <[EMAIL

where is libmysqlclient.so.6 ?

2001-02-01 Thread Abby Jiang
Note: forwarded message attached. = Abby __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Hi, I installed the MySQL on my Red Hat6.2. I can start the server. But when my cgi program

Re: mySQL IS winning

2001-02-01 Thread Billy Harvey
> If you are going to make a profit using MySQL then you need to > purchase a license. No you don't. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: mySQL IS winning

2001-02-01 Thread Jeremy D. Zawodny
On Fri, Feb 02, 2001 at 10:11:49AM +0800, Rolf Hopkins wrote: > > That also depends on your definition of *PRODUCTION* status. If you > are going to make a profit using MySQL then you need to purchase a > license. Not if you use the GPL versions. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Techni

MyODBC Error

2001-02-01 Thread Li Sze
Hi, I'm using SQLPutData and SQLParamData to insert data into the database. It works fine with data files smaller than 1MB. However, I get the following error for the last call to SQLParamData when the data file is more than 1MB. I have no idea what the following error means. I would really ap

Re: Incorrect data returned by REGEXP or RLIKE

2001-02-01 Thread Paul DuBois
>On Thu, Feb 01, 2001 at 07:09:26PM -0600, Paul DuBois wrote: >> >> Ah, argh. This happens because REGEXP was changed to be case insensitive >> as of MySQL 3.23.4. > >Why? > >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 328-7878Fax: (408)

where is libmysqlclient.so.6 ?

2001-02-01 Thread Abby Jiang
Hi, I installed the MySQL on my Red Hat6.2. I can start the server. But when my cgi program connects to the database, I got message saying that libmysqlclient.so.6 was not found. What should I do to get it? Thanks! Abby = Abby __ Get personal

RE: Severe problem in handling timestamp column type

2001-02-01 Thread Scott Gerhardt
MySQL always updates the first timestamp column on update, regardless. > -Original Message- > From: Alex Dusty [mailto:[EMAIL PROTECTED]] > Sent: February 1, 2001 7:28 PM > To: [EMAIL PROTECTED] > Subject: Severe problem in handling timestamp column type > > > >Description: > There is a

Re: [CGI] Gas Prices

2001-02-01 Thread Rolf Hopkins
Geez, it's gone up to 90c now?!?!?! I've been away too long!!! Talk about expensive gas. I thought it was only meant to rise about 10c with the GST. - Original Message - From: "Solomon Sokolovsky" <[EMAIL PROTECTED]> To: "Marko Sarunac" <[EMAIL PROTECTED]>; "Redvers Davies" <[EMAIL P

Re: Incorrect data returned by REGEXP or RLIKE

2001-02-01 Thread Jeremy D. Zawodny
On Thu, Feb 01, 2001 at 07:09:26PM -0600, Paul DuBois wrote: > > Ah, argh. This happens because REGEXP was changed to be case insensitive > as of MySQL 3.23.4. Why? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cel

Replication configuration (One Replication with 2 Masters)

2001-02-01 Thread Toxik - Martial Rioux
Hi, I try to configure one replication(R1) with 2 master server(M1 and M2). R1 <-- M1 (table1) <-- M2 (table2) First, it's possible with actual Mysql version (3.23.32)? The configuration on R1 Server is similar to $mysql_path/bin/mysqld -b $mysql_path \ --datadir=$mysql_path/data/r1 \ --us

INSERT DELAYED and FULLTEXT and locking problems

2001-02-01 Thread Steven Roussey
Hi all, I was curious if anyone has been experiencing problems with INSERT DELAYED lately. At the moment, it seems to limited to INSERT DELAYED and tables with a FULLTEXT index. After a while, a lock on table prevents any normal INSERTS or SELECTS (this behavior may require doing both normal and

Re: CASE..END not working in ORDER BY clause?

2001-02-01 Thread Bob Hall
>hi there! > >it seems logical to me that using CASE...END in an ORDER BY clause ought >to work. i can set up a CASE statement in a SELECT: > >SELECT CASE test.ID WHERE 1 THEN 2 WHERE 2 THEN 1 END AS c > >and i get the expected output. however, if i then try to move the whole >case statement int

Re: Buffer overflow found in MySQL (SELECT statement)

2001-02-01 Thread Benjamin Pflugmann
Hello. Thank you for your contribution, but this issue has already been discussed on this list (see the archive) and a fix is available (since 3.23.21). Bye, Benjamin. On Fri, Feb 02, 2001 at 01:23:26AM +0300, [EMAIL PROTECTED] wrote: > >From Beyond-Security's SecuriTeam.com(The info

Re: Linux limited to 256 connections by default?

2001-02-01 Thread Benjamin Pflugmann
Hi. On Thu, Feb 01, 2001 at 01:33:06PM -0800, [EMAIL PROTECTED] wrote: > > I was under the impression ulimit controlled this, but someone just told me > that by default, the linux kernel only supports 256 simultaneous > connections, thus MySQL is limitd to 256 connections unless running on a > m

Building 3.23

2001-02-01 Thread Geoff Coffey
Ok, I have decided to try to get 3.23.32 built but I have a problem. I'm building on Mac OS X Public Beta (Darwin) and the docs say it should recognize this platform and work easily. It does configure, build and install without a hitch, but it won't run. I'm configuring it to install in /usr/loca

Troubles running mysql applications

2001-02-01 Thread Tom Cruickshank
Hello, I've encountered a very strange problem in regard to the mysql applications on my machine. When I try running certain files (ex. mysql_setpermission) it keeps telling me "No such file or directory". The file is chmod to 755 so there really should be no excuse. Has this ever happened

Re: Incorrect data returned by REGEXP or RLIKE

2001-02-01 Thread Paul DuBois
At 11:57 AM + 2/1/01, Dave Cave wrote: >I have been running the 'menagerie' tutorial from the mySQL manual and sure >enough SELECT * FROM pet WHERE name REGEXP "[wW]"; returns Claws, Bowser and >Whistler. However, when I run SELECT * FROM pet WHERE name REGEXP "[w]"; (or >[W]) I still get the

Re: mySQL IS winning

2001-02-01 Thread Rolf Hopkins
That also depends on your definition of *PRODUCTION* status. If you are going to make a profit using MySQL then you need to purchase a license. - Original Message - From: "Brad Christensen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Dickson Alastair T" <[EMAIL PROTECTED]>; "Christoph

NEVERMIND:Re: SLOW QUERY

2001-02-01 Thread Richard Reina
I figured out the problem. As it turns out I was including a table in the FROM that I was not even getting data from. After making that correction the query now takes less than 1 second. MySQL ROCKS! [EMAIL PROTECTED] wrote: > > I know its a huge query but its taking about 90 seconds. Can an

Re: subqueries / nested queries

2001-02-01 Thread Benjamin Pflugmann
Hi. For many sub-queries, there exists a one-query work-around. Most of the rest, you can work-around with some commands. And then, there are a few around which one has to work in application. There is a section in the manual about how to handle the lack of sub-queries, which explains the most

Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))

2001-02-01 Thread Benjamin Pflugmann
Hi. On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > Would you please offer me something please ? > > > From: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > (10055)) > > > > > > Description: > > I am con

RE: [CGI] Gas Prices

2001-02-01 Thread Solomon Sokolovsky
Here in Australia 90 cents (AUSD)per litre thats about 58 cents USD. We consider this very expensive! -Original Message- From: Marko Sarunac [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:55 AM To: Redvers Davies Cc: mySQL Mailing List Subject: Re: [CGI] Gas Prices And

RE: Severe problem in handling timestamp column type

2001-02-01 Thread Quentin Bennett
Hi, If you read the manual, you would see that that is exactly what timestamp is for. Regards Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 February 2001 14:32 To: [EMAIL PROTECTED] Subject: Severe problem in handling timestamp column typ

Re: Database/table encryption

2001-02-01 Thread Rolf Hopkins
If your client is that paranoid, you could always set up a separate internal LAN with no connection to the outside world. That's what my previous company did. - Original Message - From: "Sergei Golubchik" <[EMAIL PROTECTED]> To: "msquared" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Se

subqueries / nested queries

2001-02-01 Thread terence
I understand that MySQL does not support subqueries or nested queries. Is there a simple workaround or do I have to do a number of queries and manipulate them outside of MySQL? I am using PHP for server side code. Where can I look for answers? Terence

Re: Severe problem in handling timestamp column type

2001-02-01 Thread Paul DuBois
At 12:31 AM -0100 2/2/01, [EMAIL PROTECTED] wrote: > >Description: >There is a _severe_ problem when dealing with "timestamp" column: if I update >a column, also other columns are affected! I enclose a sample script to >show the problem > >>How-To-Repeat: >create table a(t1 timestamp, t2 timestam

Re: Large text searches

2001-02-01 Thread Geoff Coffey
on 2/1/01 4:05 PM, Sander Pilon at [EMAIL PROTECTED] wrote: > >> on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: >> >>> Making search engines is not a trivial thing, but this may be an >>> aproach... >> >> I appreciate all the replies. In my original post I also asked about the

Severe problem in handling timestamp column type

2001-02-01 Thread alexdusty
>Description: There is a _severe_ problem when dealing with "timestamp" column: if I update a column, also other columns are affected! I enclose a sample script to show the problem >How-To-Repeat: create table a(t1 timestamp, t2 timestamp); insert into a values("2001-01-20","1999-03-04"); select

Severe problem in handling timestamp column type

2001-02-01 Thread Alex Dusty
>Description: There is a _severe_ problem when dealing with "timestamp" column: if I update a column, also other columns are affected! I enclose a sample script to show the problem >How-To-Repeat: create table a(t1 timestamp, t2 timestamp); insert into a values("2001-01-20","1999-03-04"); select

Re: [CGI] Gas Prices

2001-02-01 Thread Alexander Skwar
So sprach pstapley am Thu, Feb 01, 2001 at 12:22:11PM -0700: > BFE Rapid City, SD 1.58 Okay, we know now that gas is extremely cheap in the US :] Germany: 2.039 DM / liter -> US$ 0.981 / liter -> ~ US$ 3 / gal I really did not know that it is THAT expensive in UK. Alexander Skwar -- How to qu

Re: Idea: Automated server tuning?

2001-02-01 Thread Jeremy D. Zawodny
On Thu, Feb 01, 2001 at 01:34:03PM +, Basil Hussain wrote: > > In the light of my recent experiences with tuning my MySQL server, I > had a few ideas about how getting optimum performance from your > MySQL server could be made a little easier for everyone. Agreed. Better documentation and ex

OT? ER Design for Mac

2001-02-01 Thread tlr7425
anyone know any ER Design tools for Macintosh? - 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 PROT

RE: duplicating rows

2001-02-01 Thread indrek siitan
Hi, > Table 1 is called: active_users > Table 2 is called: deleted_users > > When "joe_smith" wishes to be deleted, I want to remove his entry > from the active_users table, and place it into the delete_users > table, with exactly the same information. INSERT INTO deleted_users SELECT * FROM

Re: duplicating rows

2001-02-01 Thread Steve Ruby
Aaron Williams wrote: > > Hello list, > > After searching the documentation on the site, as well as the archives, I > have yet to find the answer to this question. If I have overlooked it > somewhere, just point me in the right direction. > > The question: > > I have two tables, set up exactly

RE: Large text searches

2001-02-01 Thread Sander Pilon
> on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: > > > Making search engines is not a trivial thing, but this may be an > > aproach... > > I appreciate all the replies. In my original post I also asked about the > FULL TEXT index type. If I may ask again, has anyone had any > expe

Buffer overflow found in MySQL (SELECT statement)

2001-02-01 Thread Rus
>From Beyond-Security's SecuriTeam.com(The information has been provided by Tharbad): A security vulnerability in MySQL, a database management system, has been discovered. This vulnerability allows remote attackers to crash by issuing a SELECT statement containing a large amount of characters.

ERROR IN JSP AND TWZ1

2001-02-01 Thread Jaya Thakar(ASI 2001)
hello Can anybody tell me that if JSP(tomcat) implementation of jdk1.2.2 and twz1 Jdbc driver work together. -- jaya It's time to stop comparing yourself to other people. They are no better

Re: GUI for Linux mySQL

2001-02-01 Thread Mikel King
Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: > Is there a GUI for mySQL that will run on either linu

Re: mySQL 3.23.32 memory optimization ....

2001-02-01 Thread Michael Widenius
Hi! > "Marcello" == Marcello Giovagnoli <[EMAIL PROTECTED]> writes: Marcello> Hi Monty, >> Why do you need to retrieve so many rows to the client? Can't you use >> LIMIT to restrict the number of result rows? Marcello> The point is that the program scans the entire table and process each

Linux limited to 256 connections by default?

2001-02-01 Thread Chuck Carson
I was under the impression ulimit controlled this, but someone just told me that by default, the linux kernel only supports 256 simultaneous connections, thus MySQL is limitd to 256 connections unless running on a modified kernel. This does not sound right to me so I thought I would ask here. We

Re: Chinese encoding full text index

2001-02-01 Thread Sergei Golubchik
Hi! On Feb 02, [EMAIL PROTECTED] wrote: > Hi! > > I really need a search engine that can make my users able to do a free text search >in my MySQL database. I have 800 records, so a query like > > SELECT * FROM table WHERE content LIKE '%searchtext%' > > goes really slow. > > I wonder

Server error: Segmentation fault

2001-02-01 Thread Andres Valenciano
Hi, I am trying to run a MySQL (3.23.32) in a SuSe Linux 6.4 Server (2.2.14-SMP) But every time I try to run mysql.server start it throws and infinite number of this messages: Number of processes running now: 2 mysqld process hanging, pid XX - killed mysqld process hanging, pid YY - killed 010

Re: Antwort: mySQL is winning

2001-02-01 Thread Fábio Ottolini
One thing that I have learned on the corporate market is that huge companies prefer to pay huge amounts of money than to bet on a product that is new and almost for free. Quality in this case is secondary and what happens behind the scenes is what is taken into consideration. An IT Director doesn'

Re: Linux limited to 256 connections by default?

2001-02-01 Thread Andrei Cojocaru
well I believe this has to do with the file descriptors, but I use RH 7.0 and you can change the file descriptor max under /proc/sys/fs/file-max and inode-max On Thu, 1 Feb 2001, Chuck Carson wrote: > > I was under the impression ulimit controlled this, but someone just told me > that by defaul

Re: _slow_ index generation

2001-02-01 Thread Sergei Golubchik
Hi! On Jan 30, Sheer El-Showk wrote: > Please cc [EMAIL PROTECTED] on any response, I'm on the list but I filter to > a file, thanks. > > Can someone (maybe with some MySQL-innards code experience) please explain > this problem: > > Generating an index on the first character of a varchar(70) o

Re: Database/table encryption

2001-02-01 Thread Sergei Golubchik
Hi! On Feb 01, Tõnu Samuel wrote: > msquared wrote: > > > > I'm working for a company that has a paranoid client, and the client wants > > their database to be 'secure'. > > > > By 'secure' they mean that even if someone gains root access on the > > server, the data in the database can't be com

Re: Mysql and security?

2001-02-01 Thread Sergei Golubchik
Hi! On Feb 01, Nicolas GREGOIRE wrote: > msquared a ecrit : > > > Perhaps you want to distribute a CD full of databases, and people buy > > access to specific databases. access = password > > IMHO, this method can't protect the content of the CD. > > Hace a closer look : > - you have read acc

Re: duplicating rows

2001-02-01 Thread Gerald L. Clark
It is in the manual. Approximately ( Don;t have manual in front of me ): insert into deleted_users select from active_users where user_name = "joe_smith"; delete from active_users where user_name = "joe_smith"; Aaron Williams wrote: > > Hello list, > > After searching the documentation on th

Re: duplicating rows

2001-02-01 Thread Aaron Williams
>Can be done in two steps, but not in one: > >insert into deleted_users select * from active_where where username='joe'; >delete form active_users where username='joe'; > >what you mention about usernames not being unique in the deleted_users >table is >not a problem as long as you don't have a p

Re: query optimization suggestion

2001-02-01 Thread Dan Nelson
In the last episode (Feb 01), Michael Griffith said: > CREATE TABLE test( > userID int, # (non-unique) > testID int, # (non-unique) > PRIMARY key(testid,userid) > ); > > Suppose this table is populated with 1,000,000 rows. Then do this: > > DELETE FROM test WHERE userID= AND

mysqld hanging -- HELP

2001-02-01 Thread Alex Tapia
I've been using MySql for a few months now with no problem whatsoever. All of a sudden it stopped working, it just hangs upon startup. There are no error messages or any messages for that matter. I was using the stable version 3.22 and I tried upgrading to 3.23 (STABLE), but the same thing happe

Re: Binary data

2001-02-01 Thread Peter Szekszardi
Hi Barry, I do not know what do you use for feeding your database, but in Perl you shoud use the DBI module, and insert the binary data through bindings. use DBI; use strict; ... my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die "$DBI::errstr\n";

duplicating rows

2001-02-01 Thread Aaron Williams
Hello list, After searching the documentation on the site, as well as the archives, I have yet to find the answer to this question. If I have overlooked it somewhere, just point me in the right direction. The question: I have two tables, set up exactly the same, except the names of the tables

Re: Large text searches

2001-02-01 Thread Geoff Coffey
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: > Making search engines is not a trivial thing, but this may be an > aproach... I appreciate all the replies. In my original post I also asked about the FULL TEXT index type. If I may ask again, has anyone had any experience with thi

Re: query optimization suggestion

2001-02-01 Thread Michael Griffith
> Shouldn't the first query have parenthesis? As in: > DELETE FROM test WHERE userID=X AND (testID<20 OR > testID>80); > Even if it works the other way, parenthesis make it more clear what > you're trying to accomplish. > -Angela Actually, yes. Sorry about the poor example. My point

Re: Large text searches

2001-02-01 Thread Carsten Gehling
From: "Geoff Coffey" <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 5:25 PM > I am in the process of migrating a site built with FileMaker Pro to MySQL > and PHP mostly because filemaker's web capabilities are too limiting. In one > situation, we have a database of about 20,000 rows that

Chinese encoding full text index

2001-02-01 Thread layout
Hi! I really need a search engine that can make my users able to do a free text search in my MySQL database. I have 800 records, so a query like SELECT * FROM table WHERE content LIKE '%searchtext%' goes really slow. I wonder if MySQL support Chinese encoding full text index?

Re: query optimization suggestion

2001-02-01 Thread Angela
Shouldn't the first query have parenthesis? As in: DELETE FROM test WHERE userID=X AND (testID<20 OR testID>80); Even if it works the other way, parenthesis make it more clear what you're trying to accomplish. -Angela Michael Griffith wrote: > > When using mySQL I've learned to avoid

Re: Large text searches

2001-02-01 Thread Gonzalo Aguilar
Geoff Coffey wrote: > > I am new here... > > I am in the process of migrating a site built with FileMaker Pro to MySQL > and PHP mostly because filemaker's web capabilities are too limiting. In one > situation, we have a database of about 20,000 rows that contains two text > columns. One is the

Web site developed with perl, html using mySQl as the backend

2001-02-01 Thread Mike Podlesny
Hi all just wanted some professional opinions on my web site located at http://www.IWantYourStuff.com I developed the site using HTML (of course) with Perl scripts accessing a mySQL database. If anyone would like to comment on it or make any suggestions please drop me a line. Thanks.

query optimization suggestion

2001-02-01 Thread Michael Griffith
When using mySQL I've learned to avoid OR in any queries as much as possible . Almost always this causes a major speed decrease. Consider this table: CREATE TABLE test( userID int, # (non-unique) testID int, # (non-unique) PRIMARY key(testid,userid) ); Suppose this table is popul

you can tell

2001-02-01 Thread john1
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API programe which catched from the MySQL tutorial, it chokes at the end of compile process . the programe is as follows: #include #include #define def_host_name NULL #define def_user_name NULL #define def

Re: Load Balancing.

2001-02-01 Thread Nathan Cook
I have read on replication, just recently. What I could gather from the manual: The replication creates an exact mirror of a database on another server using a parent server to a daughter server method. Which brings up two issues: How long is the lag? How could I use this to load balance? My

Re: c and mysql

2001-02-01 Thread Paul DuBois
On Thu, Feb 01, 2001 at 05:29:02PM -0200, Jader Wallauer wrote: > Where can i get an exemple of connection using c with mysql! > for gcc with freebsd OS. > tkz! > []'s Jader 1) Any of the C clients in a MySQL source distribution: mysql, mysqladmin, mysqlshow, etc. 2) http://www.mysql.com/Download

Fw: [CGI] Gas Prices

2001-02-01 Thread René Tegel
- Original Message - From: "René Tegel" <[EMAIL PROTECTED]> To: "Redvers Davies" <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 7:17 PM Subject: Re: [CGI] Gas Prices > This sure would be a reason for microsoft to distribute less cd's and more > pre-installed os's due to 'increase

Re: [CGI] Gas Prices

2001-02-01 Thread pstapley
BFE Rapid City, SD 1.58 - Original Message - From: "Angela" <[EMAIL PROTECTED]> To: "Redvers Davies" <[EMAIL PROTECTED]> Cc: "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 10:54 AM Subject: Re: [CGI] Gas Prices > I think I'd be buying one of those hybrid cars

Re: c and mysql

2001-02-01 Thread Ryan Wahle
In the manual. www.mysql.com On 01 Feb 2001 17:29:02 -0200, Jader Wallauer wrote: > Where can i get an exemple of connection using c with mysql! > for gcc with freebsd OS. > tkz! > []'s Jader - Before posting, please check:

RE: c and mysql

2001-02-01 Thread The Tilghman
Download the manual and turn to Chapter 22. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From: Jader Wallauer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 01, 2001 13:29 > > Where can i get an exemp

Re: Large text searches

2001-02-01 Thread Angela
What if, when the business is added, there are a certain number of textboxes, I'll use 10 as an example, and for that business you can put in up to 10 phrases that someone might search for that business with. Then you don't need to put any other phrases in the database, just single words. This w

Error running makefile

2001-02-01 Thread John Markunas
Hi Attempting to make nysql-3.23.32 on a DEC alpha Tru64 box. Keep getting error /install-dir/lib/mysql ( no such file or directory ). Anybody seen this before ? Thank You John Markunas - Before posting, please check

Re: RE:mySQL is winning

2001-02-01 Thread John Jensen
I have no problem with paying for good software or good services; that deserves payment. I just hate to pay for something, only to find it doesn't do what I need it to do, the warrantee is worthless, and getting tech support is like pulling teeth. Argh! Basic business practice should be taught

Re: myODBC question

2001-02-01 Thread John Jensen
Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case), and

Re: mySQL IS winning

2001-02-01 Thread John Cichy
On Thursday 01 February 2001 11:43, Dickson Alastair T wrote: > > >But you still have to buy the ORACLE software right? > > Nope. I got my Enterprise Edition Oracle8i free. > > The *support and training* is paid for (ooouch, very expensive), > unlike mysql (free and from "the horses mouth") > > :

RE: mySQL IS winning

2001-02-01 Thread Brad Christensen
Having worked with Oracle products for several years, their licensing policy is essentially as follows: Development licenses are generally free, as is indicated below with the individual who got his *free* copy of Oracle. However, as soon as a system moves to *PRODUCTION* status, the database mu

  1   2   3   >