opinion - voating

2001-11-21 Thread Mamun Murtaza Sheriff
Dear All Any one have example Banking software written in PERL or PHP with MySql Database. if you have one mail me or provide me the URL of such software. Thanking you Mamun Murtaza Sheriff SDNP Bangladesh - Before posting,

query

2001-11-21 Thread Auri Net SAC
> Hi > > it is possible > > "select * from table where col1 <= now and col2>=now" > > where col1 and col2 are date type > > thnaks > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >ht

RE: opinion - voating

2001-11-21 Thread Auri Net SAC
Hi it is possible "select * from table where col1 <= now and col2>=now" where col1 and col2 are date type thnaks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

opinion - voating

2001-11-21 Thread Mamun Murtaza Sheriff
Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: replication setup

2001-11-21 Thread Arne Goetje
> > I've set up replication with a master and two slaves, all running > > 3.23.43, and it works like a charm. Except for... > > > > When the master goes down, the slave tries to reconnect after 60 > > seconds, but just once. > > That shouldn't be. I have the same problem here with the same versio

RE: does each database connect cause mysqld to fork?

2001-11-21 Thread Bennett Haselton
Do you mean processes instead of threads? (ps lists each *process* separately, along with its process ID, but doesn't list separate threads within each process. If mysqld handles each new connection by calling fork(), then I think fork() creates a new process, not a new thread.) -Be

RE: does each database connect cause mysqld to fork?

2001-11-21 Thread Quentin Bennett
Hi, >From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL PRO

does each database connect cause mysqld to fork?

2001-11-21 Thread Bennett Haselton
Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh->disconnect() in perl code), does that cause the number of running instances of mysqld to go down by one? The process list on

Re: possible to loop through increments when end reached?

2001-11-21 Thread Arjen G. Lentz
Hi Tom, - Original Message - From: "Tom Beidler" <[EMAIL PROTECTED]> > I have a database of sites for a grounds maintenance company. I want to flag > sites for service. Each site has a service order, 1-875. I want to keep 25 > sites flagged for service. Once a technician works on a site

possible to loop through increments when end reached?

2001-11-21 Thread Tom Beidler
I have a database of sites for a grounds maintenance company. I want to flag sites for service. Each site has a service order, 1-875. I want to keep 25 sites flagged for service. Once a technician works on a site and posts a service report, I set that sites flag to 'no' and would like to flag the

problem running mysql from the command line

2001-11-21 Thread Glenn Hirschowitz
I hope I'm not being really stupid, but this does not seem to work: mysql -h localhost -u xxx -p I get the command line usage error. It appears I can't use any other option if I use the -h. This works fine mysql -u xxx -p I'm running mysql version 3.23.43-nt Glenn --

How Does One Install MYSQL?

2001-11-21 Thread Joetheaxe
I tried following the directions that came with the book "mysql/php database applications". I am told that after installing mysql, one checks to make sure the installation was correct by invoking the mysql daemon (c:\mysql\bin>mysqld). That did nothing there is a piucture in the book that show

Re: MySQL and encryption

2001-11-21 Thread Ken Kinder
Monty, is this like a product you're selling? I would like more information, although I haven't gotten to this yet in my security sweep. On Wednesday 21 November 2001 06:27 am, Michael Widenius wrote: > Hi! > > > "Ken" == Ken Kinder <[EMAIL PROTECTED]> writes: > > > > Ken> I would like to k

Re: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
Thank you all for your suggestions. I used the /tmp directory on my ISP which has permissions to all and it work. Thanks, Sharaaz - Original Message - From: "Sharaaz Khan" <[EMAIL PROTECTED]> To: "Carsten H. Pedersen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 21

mysqlgui

2001-11-21 Thread Glenn English
RH7.2 When I run 1.7.5 either static or semi static, I get Can't connect to local MySQL server through socket " (111) Host name is "localhost" ("120.0.0.1" doesn't work either). I do have access rights - running as root. -- Glenn English [EMAIL PROTECTED]

Table Locking...

2001-11-21 Thread Ashley M. Kirchner
(PHP-DB folks, ignore this top question - unless you want to answer) Which type of DB/Table provides table locking while a process is altering data? I don't care for locking while using SELECTs, but I do need locking when something's being INSERTed or UPDATEd, so I won't get two process

Re: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
- Original Message - From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Sharaaz Khan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 1:52 PM Subject: RE: LOAD_FILE does not work > > I have been trying to load the textual contents of a file from my > > hard

Re: Migrating...

2001-11-21 Thread Ulf Bäckman
Hi. I had the same problem awhile back. What i did was just copy the db files to the linux server provided the mysql versions are exactly the same and the db structures are the same it works. Otherwise mysqldump and read it into the new db:) //Uffe Witness wrote: > > Hello. I am running a My

Re: Fw: LOAD_FILE does not work

2001-11-21 Thread Mike(mickalo)Blezien
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book <[EMAIL PROTECTED]> wrote: UPDATE Software SET Description = >>LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) >>WHERE ID = 9 >> >>You have to make sure that not only can mysql read the file, but it also has >>

Migrating...

2001-11-21 Thread Witness
Hello. I am running a MySQL server (3.23.43) on WinME, and another server (same version) on libc6 Linux. The server on WinME is a development server, or rather has been until now, and the Linux one is my production server. At this time the Linux one is completely empty with the exception of the d

Fw: LOAD_FILE does not work

2001-11-21 Thread Christopher Book
>>UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your se

parallel processing in mysql

2001-11-21 Thread another oracle dba
Does anyone know whether mysql supports parallel processing? I searched the documentation on mysql.com, but didn't find it mentioned thanks AOD __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocit

RE: LOAD_FILE does not work

2001-11-21 Thread Carsten H. Pedersen
> I have been trying to load the textual contents of a file from my > hard drive > space into a field (Description) of my mySQL table (Software) using the > follwing query. The query runs succfessfully How do you know that it's successful? What success/error codes (if any) are returned? > >

mysql-win

2001-11-21 Thread Darkyle .
i'm using mysql 3.23.43 on Windows 98 platform running on apache server 1.3.22 with php4 Sometimes (most often) this pc crashes (windows miracles) and if i was using mysql, i mean if i was logged in and moving data from my webpage, or if the winmysqladmin.exe was running, then after reboot, the u

Fw: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully, however, none of the contents are loaded into the field, in fact, the Description field is not updated

OS omissions from manual?

2001-11-21 Thread Kurt Tappe
Why does the MacOS X build of MySQL 3.23 include a "manual.html" that contains install instructions for only Linux and Windows? I'm stuck trying to figure out how to install this thing. MacOS has no "groupadd" command (due to the existence of the NetInfo system), so the manual install instruc

Re: Database Replication problem

2001-11-21 Thread Jim Lucas
Thanks for the reply. Jim - Original Message - From: "Rafal Jank" <[EMAIL PROTECTED]> To: "Jim Lucas" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 1:25 AM Subject: Re: Database Replication problem > Jim Lucas wrote: > > > > just wondering, when you star

indexing question

2001-11-21 Thread Daren Cotter
I am going to have a table called mail_queue, that is going to store the member id, the mailing id, and the date. Each time a new mailing is setup (usually daily), another 100,000 rows (one for each member) will be added to the table. When a member reads the mailing, that row will be removed from

Re: Fulltext performance

2001-11-21 Thread Sergei Golubchik
Hi! On Nov 21, Mike Hunt wrote: > > All we want is for something like > > SELECT * FROM book WHERE MATCH(author) AGAINST > ('stephen') AND MATCH(author) AGAINST ('king') LIMIT > 100 /* these queries are ALWAYS limited like this */, > a pretty normal kind of query, to return in an > acceptable

Mysql Lost

2001-11-21 Thread Luis
Hello all, I have just notice that the new Mysql3.23.44.rpm is different. I download the rpm installed it (rpm -ivh Mysql ) installed fine, started the mysql deamon but when i tried to set a passwd for root i could not find mysqladmin it tells me that its located /usr/bins/mysqla

Compile fails on raq2 (MIPS Linux)

2001-11-21 Thread shrub
>Description: Here's the error I get: make[3]: Entering directory `/home/sites/home/users/admin/mysql-3.23.44/sql' c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" -DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql\"" ../regex temp

MySQL-4 compile / configure error

2001-11-21 Thread dan
Towards the end of running the end of the configure script (./configure --prefix=/usr/local/mysql - and yes I know I can optimise better than this), I get: creating ./config.status creating Makefile sed: file conftest.s1 line 6: Unterminated `s' command creating os/Makefile sed: file conftest.s

Location in a text field?

2001-11-21 Thread Ber2
I'm new to the list, and I cannot find out whether this question has been asked before (I'm sure it is) I have a table called 'paragraph' and one called images: paragraph: id ; text ; author ; images: url; subscript; I want my PHP to insert a tag in a specified place in the text (like

RE: 0 Records Affected

2001-11-21 Thread Carsten H. Pedersen
> I am passing an SQL statement through to Mysql, in certain circumstances > (not very often), the information within the statement is the same as what > is in the database, therefore 0 records are affected. This is great from a > speed perspective, but I want to know that 0 records were affected

FLUSH TABLES

2001-11-21 Thread Jonathan Hilgeman
If I use a FLUSH TABLES command, what will happen to others that might be in the middle of using a table? I have a PHP application running on PHP 4.0.3 that doesn't seem to close tables properly, and I am constantly having trouble with the mySQL server crashing on me. I shut down the server, ra

Fulltext performance

2001-11-21 Thread Mike Hunt
We are having very serious performance issues (the client is angry, very angry) with full-text searches that return a large number of results. The problem is roughly as follows: we have a 2-million record database of books, a bit of a mess, each record is a mass of unstructured data. A search t

argument to --with-mysql option for PHP

2001-11-21 Thread Erik Price
Hello all, I have a question that might be better suited to the PHP community, but I thought that it was also relevant to the MySQL community (and I'm already on this mailing list!! :-) I am compiling PHP 4.0.6 as a dynamic module (apxs) for Apache 1.3.22 on my Darwin 1.4.1 system (Mac OS X 10.1

Question on Indexing

2001-11-21 Thread Manjeet Singh
Hi Group, I am using a database and want to index it for better performance. The datatypes for the coloums i am indexing(multicolumn indexing) are: varchar and timestamp I came to know that changing the datatype from varchar to char effects the performane a lot. I would like to know, has any bo

Re: Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Jerry
>>Why no have 3 tables: >>Members >>Data >>TheseMembersAreOld >>Members and Data are as you have them defined. TheseMembersAreOld >>contains only the Member_ID field. >>You then make the Member_ID field primary key on TheseMembersAreOld and >>Members. You can then perform a very fast joins. >H

[Installation of grant tables failed!]

2001-11-21 Thread root
Description: /usr/local/mysql/bin # cd .. # ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please con

Re: Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Thomas S. Iversen
> OldMembers > Memebers > Data Why no have 3 tables: Members Data TheseMembersAreOld Members and Data are as you have them defined. TheseMembersAreOld contains only the Member_ID field. You then make the Member_ID field primary key on TheseMembersAreOld and Members. You can then perform a very

Size of blobs?!

2001-11-21 Thread Sven Anders
Hello! How do I get the size of a blob? I want to do something like this: SELECT * FROM blob_table WHERE size(blob_column) > 1024; Best regards Sven -- --- >>> ANDURAS AG - solutions for the NET <<<>>> h

Re: Re: Can't Compile DBD::mysql (fwd)

2001-11-21 Thread Boyd Lynn Gerber
-- Forwarded message -- Date: 21 Nov 2001 18:17:22 - To: Boyd Lynn Gerber <[EMAIL PROTECTED]> Subject: Re: Re: Can't Compile DBD::mysql 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

Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Jerry
Hi there I need help :-)) If anybody could be so kind and help me... I have 3 tables: OldMembers Memebers Data In Data there is a field Member_ID. Now in this field all members bigger than 100.000 are old ones and must be taken from the OldMembers table (both tables are not using same data so

RE: Nusphere is spamming me

2001-11-21 Thread Britt Johnston
Thanks for taking the time to clarify the situation. It appears that my response did not however convince the judge or jury on this manner and I've been bannished from the list. Rather interesting development. Britt... > -Original Message- > From: Michael A. Peters [mailto:[EMAIL PROTE

Re: Running two servers on the same box

2001-11-21 Thread Joe Ellis
when you run mysqld, use: /path/to/one/mysqld --bind-address=10.0.0.10 /path/to/two/mysqld --bind-address=10.0.0.11 Guillaume Monfort wrote: > > Hello there, > > i would run two distinct mysql servers on the same > computer. i know it's possible using 2 differents ports > but it's not what i w

Re: insert/delete locking with innodb

2001-11-21 Thread Heikki Tuuri
Hi! >If I have a process inserting into an innodb table in 200 insert chunks. >i.e. it commits after every 200 inserts, must another process, which wants >to delete data from this table, wait for the next commit on the insert end? >If not is there any reason why my process is doing this. Do you

Re: innodb and use of indices

2001-11-21 Thread Heikki Tuuri
Hi! >On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: >> The way to defragment InnoDB tables, or tables in any database, is from time >> to time to dump and reimport them. That can give a significant performance >> boost. >> > >That is actually not entirely true. For MyISAM tables, one simply n

Running two servers on the same box

2001-11-21 Thread Guillaume Monfort
Hello there, i would run two distinct mysql servers on the same computer. i know it's possible using 2 differents ports but it's not what i want. the point is that i have 2 interfaces (2 IP's) and i wish to run on instance of mysql binded to say 10.0.0.10 and the other on to 10.0.0.11 of course,

Can't Compile DBD::mysql

2001-11-21 Thread Arp, Jo-An
All, I'm having the same problem as Jose. SCO 5.0.5, gcc 2.95.3, Pthreads 3.5 (skunkware's). Perl was compiled using gcc. Msql-Mysql-modules-1.2219 is what I'm trying to install, but can't. Make finds my libgcc.a, and libmysql

Re: Newbie query

2001-11-21 Thread Steve Meyers
Wait for 4.1, it will have multi-table updates in it. Until then, you'll have to use two separate queries. Steve On Wed, 2001-11-21 at 07:28, Charles Allen wrote: > Hi, > > A v. basic question from a mySql newbie: > > I want to update a table based on the contents of another table. The SQL I

Re: innodb and use of indices

2001-11-21 Thread Steve Meyers
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: > The way to defragment InnoDB tables, or tables in any database, is from time > to time to dump and reimport them. That can give a significant performance > boost. > That is actually not entirely true. For MyISAM tables, one simply needs to run

Re: a select n a regexp expression

2001-11-21 Thread David Devidal
thanks to you i notice a well algo ... for regex when i put [*! * is not interpreted as a special car ! wouah select ort from localite_ortsnamen where ort REGEXP "^([A-Za-z]|[0-9]|[*!æàâäåáãçéèêëîïìíñõôöòóøùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß&\\'\\>\\ (\\)\\,\\//\\. -])+$"; - Original Message - F

BUG install Solaris 2.8 (PC) 3.23.39 (Please read)

2001-11-21 Thread Jie Lin
I have downloaded MySql binary for Solaris 2.8 (PC) 3.23.39 from your web. After I installed, I found out that the file 'mysql_install_db' under scripts directory doesn't contain anything. The size of this file is zero. So basically, I couldn't initialize the user table in mysql database and get t

BUG install Solaris 2.8 (PC) 3.23.39 (Please read)

2001-11-21 Thread Jie Lin
I have downloaded MySql binary for Solaris 2.8 (PC) 3.23.39 from your web. After I installed, I found out that the file 'mysql_install_db' under scripts directory doesn't contain anything. The size of this file is zero. So basically, I couldn't initialize the user table in mysql database and get t

Re: HUGE Table Help

2001-11-21 Thread Russell King
From: "Kevin Smith" <[EMAIL PROTECTED]> > I'm "considering" making a huge table, by that I mean approx. 26 millions > records which will be static data, no updates, or deletes, etc. will be > performed on this table, only select statements. ... > At a guess the raw data may be in the region of 9G

RE: Newbie query

2001-11-21 Thread Charles Allen
I've now had an extended dig around this mailing list's archive, and it I conclude mySql can not perform this type of update directly. Instead I should create a temp table, select into the temp table and then use that to do a REPLACE INTO command. Can someone confirm my conclusion is correct? Th

RE: Delete Match Against

2001-11-21 Thread Karl J. Stubsjoen
"Wooohooo! that is the first bug i ever found!" Do I get any points : ) Karl www.excelbus.com ..opportunity knocking.. -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 6:33 AM To: Karl J. Stubsjoen Cc: MySql list Subject: Re: Del

Re: problem with security and user access

2001-11-21 Thread EdwardSPL
behrens wrote: > Ian Barwick wrote: > > > > > > > Have you flushed the privileges after changing the tables? > > > > FLUSH PRIVILEGES > > > > -- > > Ian Barwick - Developer - [EMAIL PROTECTED] > > akademie.de asp GmbH - http://www.akademie.de > > > > "To query tables in a MySQL database is more f

newbie question re: (re)starting MySQL

2001-11-21 Thread gx-inc
Just recently started seriously studying the "infernal trio" of Apache, MySQL & PHP and got off to a decent start, but for reasons unknown can no longer get MySQL to start up from the DOS prompt. I keep getting a "Can't initialize InnoDB as innodb_data_file_path is not set" message when I e

Re: localhost problem

2001-11-21 Thread Ferhat Can
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards - Origi

Re: localhost problem

2001-11-21 Thread jaab
On Wed, 21 Nov 2001, Pafo wrote: > am still getting the same message http://www.pafo.net/mysql5.gif Try without the password. As below, "mysql -u root". > > On Wed, 21 Nov 2001, Pafo wrote: > > > i still cant get pass this problem, i have now uninstalled PWS and still i cant >access > >

Re: problem with security and user access

2001-11-21 Thread behrens
Ian Barwick wrote: > > > Have you flushed the privileges after changing the tables? > > FLUSH PRIVILEGES > > -- > Ian Barwick - Developer - [EMAIL PROTECTED] > akademie.de asp GmbH - http://www.akademie.de > > "To query tables in a MySQL database is more fun than eating spam" yes i did countless

a select n a regexp expression

2001-11-21 Thread Giuseppe Maxia
>Hello, I'm always with my access to mysql port. >I noticve that access can dispaly a â but it s like a a. >So I make this query to select some specials row from my database : >select ort from localite_ortsnamen >where ort REGEXP "^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$"=0

Re: localhost problem

2001-11-21 Thread Pafo
am still getting the same message http://www.pafo.net/mysql5.gif regards pafo - Original Message - From: <[EMAIL PROTECTED]> To: "Pafo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 2:34 PM Subject: Re: localhost problem > On Wed, 21 Nov 2001, Pafo

Re: Nusphere is spamming me

2001-11-21 Thread Michael Widenius
Hi! > "Michael" == Michael A Peters <[EMAIL PROTECTED]> writes: Michael> I would like to offer my very deepet apologies. Michael> This is what happened- Michael> About a year ago or so (maybe longer) when NuSphere was new I tried their Michael> product and did not want to use my regular e-

AIX Binary Installation Problems

2001-11-21 Thread bollu
Hi dear mysql-users, Just to inform you that this solution still works (today the 21th november 2001). Just note that the address has changed to http://216.184.67.245/libz.a Regards, Cyrille mailto:[EMAIL PROTECTED] *

Re: Nusphere is spamming me

2001-11-21 Thread Michael Widenius
Hi! > "Sandeep" == Sandeep Murthy <[EMAIL PROTECTED]> writes: Sandeep> Have been spammed too by NuSphere earlier on.. so junked my earlier mail id Sandeep> and switched to the present one... Sandeep> let all the subscribers carry a vote to hv this spammer banned from this Sandeep> list...

Newbie query

2001-11-21 Thread Charles Allen
Hi, A v. basic question from a mySql newbie: I want to update a table based on the contents of another table. The SQL I am trying to execute is: "update servers set servers.responsecount=servers.responsecount+1 where servers.gameid = lastsnapshot.gameid;" ie: Increment a responsecount for rows

RE: synchronising mysql and access2k data

2001-11-21 Thread Todd Williamsen
Use myODBC to use an ODBC connection. If you are using a hosting provider on a Unix box, more than likely this will not work Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: dean browett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Novem

Re: problem with security and user access

2001-11-21 Thread Ian Barwick
On Wednesday 21 November 2001 10:10, behrens wrote: > after editing the tables below , i'm still not able to access the > Bisimis Database below > with the user behrens, just getting the errormessage below. > I've tried it with any combination of user/db/host but can't see the > supposed logic e

Re: MySQL JOIN syntax question

2001-11-21 Thread Ian Barwick
On Wednesday 21 November 2001 03:01, James O'Brien wrote: > I have been trying to perform a join with several tables and I am having no > joy. error messages would increase the understanding of exactly what joy you aren't having ;-) > Can some one send me a query (just a select * is fine) for th

Re: localhost problem

2001-11-21 Thread jaab
On Wed, 21 Nov 2001, Pafo wrote: > i still cant get pass this problem, i have now uninstalled PWS and still i cant >access > why why why why? http://www.pafo.net/mysql4.gif > i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal >firewall and > i am connected t

Re: Delete Match Against

2001-11-21 Thread Sergei Golubchik
Hi! On Nov 20, Karl J. Stubsjoen wrote: > Hello, > > I am trying to perform the following delete command: > delete from my_table where match(keywords,title,description) > against('this_word') > > When I perform a similar select and count with the above query, I come up > with 47 records found.

Re: localhost problem

2001-11-21 Thread Pafo
i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the in

a select n a regexp expression

2001-11-21 Thread David Devidal
Hello, I'm always with my access to mysql port. I noticve that access can dispaly a â but it s like a a. So I make this query to select some specials row from my database : select ort from localite_ortsnamen where ort REGEXP "^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$"=0; I

AIX Binary Installation Problems

2001-11-21 Thread bollu
Right, It seems to be good to be tried but your server is down I thing. -- Cyrille Bollu - Software Development Engineer AWTCE - Navigation Department Tel. +32 2 389 25 14 Fax. +32 2 389 12 13 mailto:[EMAIL PROTECTED] I haven't read through any of the MySQL ma

HUGE Table Help

2001-11-21 Thread Kevin Smith
Hi All, I'm "considering" making a huge table, by that I mean approx. 26 millions records which will be static data, no updates, or deletes, etc. will be performed on this table, only select statements. The schema on the table will be as follows.. The address fields will be 56 characters long an

Re: Query Execution Time Perl/DBD

2001-11-21 Thread Gordan Bobic
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote: > The obvious way to do this would be to get the time before and after the > execution and then make a simple diff (after - before) I guess that is how > the mysql client does it (butI'm not sure) > I do not think that mysql itself provid

Re: Query Execution Time Perl/DBD

2001-11-21 Thread Mike(mickalo)Blezien
Try something like this: my $start = (times)[0]; # start # do you query execution here # done my $end = (times)[0]; Time: [${\($end - $start)}] seconds to process\n"; mysql sql database >>On Wed, 21 Nov 2001 13:11:29 +0100, "Christian Andersson" <[EMAIL PROTECTED]> wrote: >>- Original Me

Re: innodb and use of indices

2001-11-21 Thread Heikki Tuuri
Hi! I forwarded the email to Monty if he has time to look at index usage. The speedup .43 -> .44 may be due to better optimization of SQL queries, or due to the table dumps and imports you made. The way to defragment InnoDB tables, or tables in any database, is from time to time to dump and rei

Re: Query Execution Time Perl/DBD

2001-11-21 Thread Christian Andersson
The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information.. how to get the time in Perl/DBD I do not kno

Re: localhost problem

2001-11-21 Thread Pafo
i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql3.gif regards pafo - Original Message - From: "Pafo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 3:58 AM Subject:

Bug when inserting a time with fraction

2001-11-21 Thread wedemeijer
>Description: I have a table 'spoken_text' with a field 'start_time'. When I do an INSERT (from within 'mysql') with a fractional part in the seconds field, SOMETIMES this inserted values is corrupted. >How-To-Repeat: tpdmmr% mysql -u vip -p vip En

synchronising mysql and access2k data

2001-11-21 Thread dean browett
Hi, Has anybody had experience of trying to synchronise an access 2000 db with a mysql db? If so could you enlighten me as to where I can get further information/drivers to enable me to do this. TIA Regards Dean - Before pos

Query Execution Time Perl/DBD

2001-11-21 Thread Gordan Bobic
Hi. How do I get the query execution time from Perl/DBD? MySQL client returns this in the console window. Is this value available through the Perl DBD interface? Thanks. Gordan - Before posting, please check: http://www.m

Re: MySQL and encryption

2001-11-21 Thread Michael Widenius
Hi! > "Ken" == Ken Kinder <[EMAIL PROTECTED]> writes: Ken> I would like to know if anyone has some advice on encrypting credit cards Ken> myself, as it's something I'm going to be needing to look into for my own Ken> purposes. We are working on a solution to this which will be availabl

SV: Is DATE NOT NULL DEFAULT NOW() legal??

2001-11-21 Thread Torgil Zechel
No, that is not legal. From the manual: "Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE." http://www.mysql.com/doc/C/R/CREATE_TABLE.html -Ursprungligt meddelande- F

MySQL on QNX6_10 (newest RTP)

2001-11-21 Thread Adrian Skupien
Hi. I'm ought to install QNX on my workstation. I know that there are binaries and compilable sources available. But what about MySQL and PHP? An alternative for MySQL would be pgSQL (bin and src available too), but PHP seems to be lost in the world of realtime operating systems for good. Can

Re: Database Replication problem

2001-11-21 Thread Rafal Jank
Jim Lucas wrote: > > just wondering, when you start the database replicating, the bin files start > counting > at .000 > > -bin.001 > -bin.002 > -bin.003 > ... > -bin.999 > > what happens when you reach .999? > > does it start over at .001 and over-write you initial files, or does it > continu

Is DATE NOT NULL DEFAULT NOW() legal??

2001-11-21 Thread Pete, Rose & Kristina
Hi there. I'm getting stuck on what seems only too simple to me: CREATE TABLE Waverley.MemberPrice ( PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, Price FLOAT(5,2) NOT NULL, ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1, CreatedDate DATE NOT NULL DEFAULT NOW(), DeA

problem with security and user access

2001-11-21 Thread behrens
after editing the tables below , i'm still not able to access the Bisimis Database below with the user behrens, just getting the errormessage below. I've tried it with any combination of user/db/host but can't see the supposed logic error i've made,i'm stuck,anyone there to help me? thanks

SV: Security of MySQL

2001-11-21 Thread Torgil Zechel
Chapter 4 in the manual is a good place to start! http://www.mysql.com/doc/M/y/MySQL_Database_Administration.html -Ursprungligt meddelande- Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 09:55 Till: [EMAIL PROTECTED] Amne: Security of MySQL Hello, My

Security of MySQL

2001-11-21 Thread EdwardSPL
Hello, My System is Linux Red Hat 6.2 and my MySQL is 3.23.41 ( *.tar.gz , sources package )... So, can you help me to set the security of the Database System ? The following compile and installation steps : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So,