Import data

Hi All, I need to import about 30,000 data records from a text file into a MySQL database table, thru the LOAD DATA feature. The table in question will have a auto increment column, plus 5 other columns. Should I include a field in the text file to insert a value into the auto increment column,

Re: can't connect through socket using PHP script

On Fri, 27 Jul 2001 08:54:19 -0700 (PDT), Bryan Capitano <[EMAIL PROTECTED]> wrote: >>Usually this means your MySQL daemon, mysqld, is not started. Which OS are >>you using? Under RedHat Linux, you can get your mysqld running on init >>runlevels 3 and 5 (network services with and without X-wind

Re: MySQL Tests

On Thu, 26 Jul 2001 09:32:47 -0400, Cavo Vincent Civ AFRL/SNRT <[EMAIL PROTECTED]> wrote: >>I installed MySQL 3.23.40 on Linux 6.2 and am having trouble >>running the tests: >>Can't locate DBI.pm in @INC (@INC >>contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503 >>/usr/lib/perl5/sit

Re: Urgent Help needed for installing

>>> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired >with both the binary distro and source distro with no luck. The install seems to go >OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 >system. >>> >>> Please disregard thi

Re: Urgent Help needed for installing

On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: >>Source distributions don't really come with any table handler enabled >>by default, because there are no binaries included in the distribution. >>To see what options control the table handlers, run this command: >> >>

Urgent Help needed for installing

Hello All, >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with >both the binary distro and source distro with no luck. The install seems to go OK, >but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 >system. Please disregard this

Urgent Help needed for installing

Hello All, I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with both the binary distro and source distro with no luck. The install seems to go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. The main problem seems to be,

Re: Upgrade MySQL

Regarding the upgrading posting I posted, I must install the upgrade in the same data dir as the current version or else our customer WebHosting Manager browser interface will not work properly when access their database's . The current data dir install is /var/lib/mysql. Now when you install th

Re: Upgrade MySQL

I have one other question, does it make a difference where you put the tar.gz file on the server before you untar it for the install?? Does this have a bearing on the installation, when you using the binary install?? >On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wro

Re: Upgrade MySQL

Jeremy, Appreciate the info. I think we'll install the Mysql-Max and see how it goes. THX's >>On Thu, 19 Jul 2001 17:53:12 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >>The binary is known to be good (or at least known). It is a static >>binary built with a specific compiler, specific

Re: Upgrade MySQL

>>On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >>> Also it's been recommended to install with the Source instead of the >>> Binary. We want to enable BDB tables handlers also. >>> >>> Any suggestion would be much appreciated :) >> >>Use the MySQL-MAX binary fro

Upgrade MySQL

Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading

Upgrade MySQL

Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading

Enable BDB table handler

I have a client using MySQL 3.23.37. We wanted to use the Berkeley tables but for some reason they are disabled. when I do a show variables I get: have_bdb NO What is the best way to permanently enable the BDB type tables?? THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Th

Re: transactions

And Berkeley BDB tables! >>On Mon, 16 Jul 2001 10:04:41 -0500, "Cal Evans" <[EMAIL PROTECTED]> wrote: >>MySQL supports transactions if you are using either InnoDB or Gemini table >>types. >> >>Cal >>* >>* Cal Evans >>* Senior Internet Dreamer >>* http://www.calevans.com >>* >>- Original M

Re: transactions

On Mon, 16 Jul 2001 09:57:26 -0500, Pete Kuczynski <[EMAIL PROTECTED]> wrote: >>Can anyone tell me for shure if my version of mysql supports >>transactions. Version: 3.23.37 >> >>The bitbybit web site states that is does not, but someone told me that >>it does, help! We use, on a shared MySQL s

Re: MySQL Variables

>>On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: >> >>> Also if a /etc/my.cnf is going to be used, once it's >>>been created does the MySQL server need to be shutdown and restarted to >>>recognize the new my.cnf file?? >> >>Yes. is this the default location it look

MySQL Variables

when you do a mysqladmin variables, where exactly are these variables stored, and can they be changed. Also if a /etc/my.cnf is going to be used, once it's been created does the MySQL server need to be shutdown and restarted to recognize the new my.cnf file?? Again, Thx for the help :) Mike(mick

Database Backups

Hello All, We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We have about 30 customers who are currently using various dbs and was wondering if someone could recommend or has setup some sort of automated back up system for the db's. We use the mysqldump utility do bac

Re: Intalling MySQL

Paul, OK, I think it make sense now. Appreciate you clearing this up in my head atleast. THX's... >>>thanks for the info. So if I'm ready this correctly, I would log >>>into the server >>>under my UNIX account, not as root, do the install of the server/client Mysql, >>>create the new user/gro

Re: Intalling MySQL

Paul, thanks for the info. So if I'm ready this correctly, I would log into the server under my UNIX account, not as root, do the install of the server/client Mysql, create the new user/group, which would make me part of the new user/group, then start the server under this user/group. Is this cor

Intalling MySQL

Hello all, I'm a bit confused on this issue of installing MySQL and creating a separate user/group ownership. Now I've read thru many resources, and it recommends not installing MySQL as root, or is this incorrect?? Is it better to create the new user/groups, then install MySQL under these user/

Re: Multiple column value

ME, ADDR, CITY >>from t1,t2 where t1.mykey=t2.mykey and ID='IM34457' >> >>returns >> >>key1 IM34457 name1 addr1 city1 >>key2 IM34457 name2 addr2 city2 >>... >> >> >>MikeBlezien wrote: >> >>> Gerald, >>>

Re: Multiple column value

. >> >>t2 : mykey , ID >> >> >>Select * from t1,t2 where t1.mykey = t2.mykey and t2.ID="IM34485"; >> >>MikeBlezien wrote: >> >>> Hi All, >>> >>> Quick question. We need to store a multiple value in a table

Re: Multiple column value

erlotti" <[EMAIL PROTECTED]> wrote: >> >> >>select ID from TABLE_NAME where ID like '%value%' >> >>or I misunderstood the question. >> >>- >>Regards, >> >>Rod~ >> >>> -Original Messa

Multiple column value

Hi All, Quick question. We need to store a multiple value in a table column as we don't know how many values at the time of submission there could be. The column would be storing a group of values something like this: Column 'ID' IM34456,IM34485,IM34478 or it could be more or less. So if we p

Re: Php/MySQL Parse Error

That's the way should be, never enter your database access info directly into any type of script, be it PHP or Perl or what ever, store it in a separate file, no accessible separate file, then have the related script(s) call up the variables thru the PHP's include, or Perl's 'require' or 'use' ..

Re: Php/MySQL Parse Error

Joe, Are you assigning your database variables within the config.php file or directly into the mysql_connet(...); config.php: // database parameters // alter this as per your configuration $database="database_name"; $user = "username"; $pass = "password"; $hostname = "localhost"; >>On Tue, 10 J

Re: MySQL Connections

Erich, You need to create special "root" or "superuser" account so that you can connect from your PC. This will allow you full access from DBtools. This is what I had to do in order to make the connection. You'll need to log in as the 'root' or 'superuser' to execute your mysql client. %>mysql g

Assigning New Users

Hi All, When assigning new Users to various databases, and access settings, in order to have it take effect immediately, all that is needed is to do a FLUSH PRIVILEGES or does the MySQL server need to be restarted?? THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain

DB Tools - OT

If someone has been using the database browser tool, "DB Tools", I've got a few questions, if you could possibly contact me off the list, I'd appreciate it. :) THX Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that wor

MySQL restart.

Our Mysql server was shutdown with the mysqladmin -u XXX -p XXX shutdown and for some reason we can not restart it and can't make any connections to the Mysql server. This is on a FreeBSD server. what is the correct procedure to restart the Mysql server?? thanks, Mike(mickalo)Blezien =-=-=-=-

Re: MySQL binary/source

I assume this is the correct one to download then: mysql-3.23.39-pc-linux-gnu-i686.tar.gz >>"MikeBlezien" <[EMAIL PROTECTED]> writes: >>> >>> Thanks. Which files would I need to download then?? Just the RPM's or RPM's and >>> the ta

Re: MySQL binary/source

Thanks. Which files would I need to download then?? Just the RPM's or RPM's and the tarball binary? >>On Fri, 6 Jul 2001 16:41:05 +0300, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: Use our MySQL-Max binary as it contains InnoDB. Our binaries are built in the most optimial manner, a

MySQL binary/source

Hello All, Our company is going to be setting up on a dedicated server, so I am in the process of doing some "crash course" learning as a system admin. We are looking at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stable version w/InnoDB enabled. Now from the docs, it s

Re: Enhanced MySQL

thanks all, I guess it's time for new glasses! :) >>On Thu, 5 Jul 2001 22:51:56 -0400, "D'Arcy Rittich" <[EMAIL PROTECTED]> wrote: >>Try here: >> >>http://www.mysql.com/portal/distributions/html/index.html >> >>D'Arcy Ritt

Re: Enhanced MySQL

On Fri, 6 Jul 2001 08:27:11 +0300 (EEST), Michael Widenius <[EMAIL PROTECTED]> wrote: Michael, Strange, I went thru the entire portal section and couldn't find anything about this NuSphere's Enhanced MySQL. I just happen to notice the small banner on www.mysql.com home page. But thank for the i

Browser GUI

Hi All, I've been looking at alot of the GUI's offered at mysql.com, and was wondering if someone could recommend a good full MySQL administrator, for fully maintaining MySQL server/clients that is used thru the browser and not locally on a PC. thanks, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=

Enhanced MySQL

Hello All, Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/ Enhanced MySQL and what advantages, if any it may have. THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://ww

Can't connect

What is the recommended procedure to correct this error: "...Can't connect to local MySQL server through socket '/tmp/mysql.sock'.." We seem to encounter this error quiet often. THX, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Inter

MySQL on FreeBSD 4.1 OS

Hello all, We are looking at setting up on dedicated server with the FreeBSD 4.1 OS and was wonder how well MySQL has worked on this O/S. We would like to compile it with Innobase if possible. Appreciate any feedback, recommendations, pro/cons... etc.. THX Mike(mickalo)Blezien ===

Re: CHECK TABLE

On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber <[EMAIL PROTECTED]> wrote: it doesn't work on 3.23.32 either! >>Check table didn't exist in 3.22 >> >>Werner Stuerenburg wrote: >>> >>> Sorry, I don't understand from the manual how to use this >>> (running MySQL 3.22.32 on RedHat) >>> >>> I tr

Re: BerkleyDB and mysql and COMMIT

On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer <[EMAIL PROTECTED]> wrote: I don't believe BDB table handler support row-locking. I suggest looking at using Innobase tables handlers. >>Hi, >>I have the following configuration >> >>I have Linux >>I have compile mysql with the following co

Re: Date format problem

On Thu, 28 Jun 2001 21:49:57 +0200, "Sebastiaan J.A. Kamp" <[EMAIL PROTECTED]> wrote: if your using perl, heres a real simple way to format your date: my $date = "28/06/2001"; my($mn,$day,$yr) = split '/',$date; my $db_date = join('-',$yr,$mn,$day); # Your output should now be $db_date = 2001-0

Re: Date format problem

On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla <[EMAIL PROTECTED]> wrote: You would need to reformat the input date first, within your middleware, like Perl or PHP. Then you would be able to enter it into your db. >>Hi guys, does anyone help me with this simple thing ?? >> >>I have a date

Re: deleting data from a table

On Wed, 27 Jun 2001 16:06:36 -0500, "Mark Wakim" <[EMAIL PROTECTED]> wrote: Well depending how your tracking this person, and message related to him, I would image some sort of an ID value assigned to the poster would be the easiest means. something like: DELETE FROM table_posts WHERE userid =

Re: transactions

On Mon, 25 Jun 2001 07:42:39 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: Paul, appreciate the feedback, but my question wasn't in reference to the actual coding and how it's used, this I understand, I was referring to when a transaction is best used, in what type of a scenario. ;) TIA >>A

Re: deleting a table

On Sun, 24 Jun 2001 21:06:16 -0700 (PDT), ricky gonzalez <[EMAIL PROTECTED]> wrote: DROP TABLE table_name; >>Hi, I need to delete a table from a database. I >>looked through the manual, but it's not listed in the >>table of content. >> >>Thank you for your help. Mike(mickalo)Blezien

Re: Good book for MySQL and Perl DBI?

On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen <[EMAIL PROTECTED]> wrote: Chris, 2 of the best, Paul Dubois's "New Riders MySQL", which covers MySQL, SQL very well, and Perl w/DBI, and PHP and C. The Perl w/DBI is a bit outdated now tho. Programming with Perl DBI is an excellent resource

transactions

Hello All, I'm current working on project, converting a flatfile system, to use MySQL, which supports transactions w/Innobase tables. My questions is, as I'm sure many have coded using transaction w/Perl and DBI. I understand that there as some draw backs to using transactions when not necessary,

Re: Transaction Support in MySQL

On Fri, 22 Jun 2001 15:17:18 -0700, "Alberni-dot-Net Tech Mailing Lists" <[EMAIL PROTECTED]> wrote: >>What sort of support for transactions and table/record locking is there in MySQL >right now? I had heard that only table locking was supported, and limited support >for transactions. we've

Re: insert

On Fri, 22 Jun 2001 11:28:19 -0500, "Cal Evans" <[EMAIL PROTECTED]> wrote: If your using Perl w/DBI, you may want to check out the use of place holders and bind_columns. Create your create your insert statement outside the loop, then do the execute() within the loop using placeholders or bind_

Re: How can I know the version of mysql running on Linux (RedHat 6.2)

On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi <[EMAIL PROTECTED]> wrote: SELECT VERSION(); >>te: Mon, 18 Jun 2001 20:19:20 -0300 (EST) >> >> How can I know the version of mysql running on Linux (RedHat 6.2) >> >> >>thanks, >> >>Augusto Mike(mickalo)Blezien =

Re: Display error but continue script

On Sat, 16 Jun 2001 14:33:44 -0500 (CDT), Don Read <[EMAIL PROTECTED]> wrote: A heck of alot easier with Perl!(Just my opinion) :) Just disable RaiseError and enable PrintError when using DBI >> >>On 16-Jun-01 Dawn H wrote: >>> How do I make an error display, but still continue the script? Th

REF - Lost connection to MySQL server during query

Just wanted to add: it always loses connection when uptime=180 it restarts every 180 seconds?? the uptime count starts again at 0, so does the query count. >>Hello All, >> >>I frequently get this error message. >>Seems it has to do with number of open tables bigger than 10?? >>Do I have a bad

Lost connection to MySQL server during query

Hello All, I frequently get this error message. Seems it has to do with number of open tables bigger than 10?? Do I have a bad setup?? please verify my setup file at the end. I think I exaggerated the memory, it only uses 4 Megabytes anyway. bash-2.01$ mysqladmin -i 5 status

Re: Mysql SELECT command

On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali <[EMAIL PROTECTED]> wrote: Well as they say, "...if all else fails, RTFM.." :) Or pick up Paul Dubois's book on MySQL. >>Can somebody please point me to the good resourse of learning mysql's >>SELECT command on the Internet? >> >>Thanks, >> >>

Re: Field length problem!

On Mon, 11 Jun 2001 17:15:09 +0200, "Simon Abolnar" <[EMAIL PROTECTED]> wrote: What kind of data type is the column in questions?? VAR, CHAR,...etc.?? >>Hello! >> >>When I add record in database everything works OK. When I modify data in database >using >>RS.Update >>function everything work

Re: Another PHP/MySQL question

On Sun, 10 Jun 2001 19:13:01 -0700, "Vladimir Kravtsov" <[EMAIL PROTECTED]> wrote: >> >> >> >>>connectdb(); >>mysql_select_db(xtopsites); >>$validated=1; >>$sql = "select id, siteurl, sitename, from sitesats where validated = "$validated""; >//

Re: need help for a "simple" request

On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel <[EMAIL PROTECTED]> wrote: subselects are not currently supported with MySQL. >>Hi, >> >>I have some problems with the following SQL request that I process with phpMyAdmin : >>select * from TABLE2 where FIELD not in (select FIELD from TABLE

Re: Best Column Type for Currency Calculations

On Tue, 05 Jun 2001 12:53:50 -0500 (CDT), Don Read <[EMAIL PROTECTED]> wrote: We use DECIMAL(X,X) for all our currency related data columns, works perfectly. Usually DECIMAL(9,2) seems to work the best. >> >>On 05-Jun-01 Aaron Clausen wrote: >>> I've been having some problems with currency cal

Re: Recommedations

;>documentation >>mailing list support >> >>for a very robust PERL shopping cart program go to http://akopia.com/ - >>this is what minivend finally morphed to - after being purchased by >>RedHat. >> >>Both of these carts work with several dbs including mysql

Recommedations

Hello All, I hoping someone on the list maybe able to offer some recommendations on a good MySQL backend database shopping cart with advance search features. One of our client's has "out-grown" their current cart, which using DBM data files. And it would cost too much to port it MySQL. They prefe

timestamp column

Hello All, I need to create a database table with a timestamp column data type, but I don't what it to change each time the row is updated. How can you prevent the timestamp column from changing each time it's updated. thanks, Mike(mickalo)Blezien Thund

Re: port default

On Tue, 22 May 2001 11:15:24 -0700 (PDT), sj c <[EMAIL PROTECTED]> wrote: >>Hi, what is the default port to listen to on MySQL? >> I believe it's 3306. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http:/

Re: Using "where xxxx in (select ...... )"

On Tue, 8 May 2001 22:38:52 +0100, "green jon" <[EMAIL PROTECTED]> wrote: MySQL currently does not support sub select queries >>Hello, >> >>I have recently converted my Java Servlets to run against mySQL where previously I >was using Microsoft Access. I use Tomcat and have swapped drivers et

Re: Alternate Resource??

On Tue, 1 May 2001 09:43:47 -0400 (EDT), Shawn Cummings <[EMAIL PROTECTED]> wrote: >> >>I'm looking for an online message forum or mailing list that deals with >>Perl/mySQL. Most of the sites I've found are outdated and unused. >> >>Any pointers greatly appreciated. check out DevShed at http:

Re: ID numbers: auto-increment or sequences ?

On Wed, 11 Apr 2001 14:42:47 +0200, Gunnar von Boehn <[EMAIL PROTECTED]> wrote: with MySQL 3.23+ you can now assign the auto_increment start value, when creating the table: AUTO_INCREMENT = 1 >>For identification of each record in our database >>we use an 'autovalue'-column. >>It see

Re: Setting up FULLTEXT table

On Tue, 10 Apr 2001 01:05:47 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote: Ok, I kind of thought that might be it, but wasn't sure. Thanks for you assistance. >>> Then how come I keep getting these results when setting a test table. Am I >>> missing something here?? >>> >>> Create the

Re: Setting up FULLTEXT table

'VE'); Run queries: QUERY1: SELECT title FROM bus_search WHERE MATCH(title,keywords) AGAINST('car deals') 0 rows returned -- QUERY2: EXPLAIN SELECT title FROM bus_search WHERE MATCH(title,keywords) AGAINST('car deals') Comment Impossible WHERE noticed after re

Setting up FULLTEXT table

I posted a couple problems regarding the use of the FULLTEXT indexing and a search query problem, but never got any responses. So maybe some one may shed some lite on setting up a table with the FULLTEXT index. I've read thru the MySQL docs on this and it's not real clear. When setting up a table

Re: Search Query

Hello All, Just to add some additional info to our problem. If I do a simple query: select * from bus_search where match(title,keywords) against('Best Car Deals') I get nothing! and its there! Is it possible the table is not set up properly?? Or I'm I wishing something here?? Table Info: CRE

Search Query,

I posted a question regarding a search query we are trying to get to work, and was hoping someone can tell why this query doesn't work. It should return results as all the search criteria is there in the tables( for test purposes) QUERY: SELECT bi.bus_name,bi.address,bl.city,bl.state, bl.zipcode,

Search Query

Hello All, I have been trying to figure out why the below query doesn't quiet produce the results we are looking for. I was hoping some one maybe able to shed some lite on why QUERY #3 returns the wrong results. If addition information is needed, please feel free to respond privately, off the li

Math calculations

Hi all, We are modifying one of our db tables to include two fields, 'votes' and 'tally' for allowing to display a "rating" system. The 'votes' column will be a running total of all votes, the 'tally' will be a column to hold the 'votes' values. Example, if a person submits a vote of 3(with a ra

Math calculations

Hi all, We are modifying one of our db tables to include two fields, 'votes' and 'tally' for allowing to display a "rating" system. The 'votes' column will be a running total of all votes, the 'tally' will be a column to hold the 'votes' values. Example, if a person submits a vote of 3(with a ra

Re: ---- Virus Detected ----

On Sun, 1 Apr 2001 04:07:35 +0330, "Hamid Hashemi Golpayegani" <[EMAIL PROTECTED]> wrote: I think everyone is getting bombarded with this virus message. I gotten 3 of the already! >>I am getting this warning also and I have installed Norton Antivirus 2001 >>with the lastest update and sure that

Re: How to have faster select?

On Sat, 31 Mar 2001 12:39:59 -0800 (PST), Chai-Hup Chen <[EMAIL PROTECTED]> wrote: I think if you take a look at the MySQL docs on FULLTEXT it'll explain it alot better then I probably could. http://www.mysql.com/doc/M/y/MySQL_full-text_search.html >> Thanks a lot, the select is much faster

Re: How to have faster select?

On Sat, 31 Mar 2001 11:46:54 -0800 (PST), Chai-Hup Chen <[EMAIL PROTECTED]> wrote: Try this: SELECT count(*) FROM Books WHERE MATCH Title AGAINST 'cisco' We use a FULLTEXT index search in a couple of our table for business referral searches, and it works like a charm! Hope this helps >>Hi,

Re: to upper case function

On Tue, 27 Mar 2001 11:22:20 -0600, Zhu George-CZZ010 <[EMAIL PROTECTED]> wrote: I believe it's upper(col_name) >>There's a function in SQL to convert strings to upper case (sounds like to_upper()? >), I don't have the reference book at hand, does anyone know the syntax or that >function? >

Re: inserting into mysql database in linux using C

On Sun, 25 Mar 2001 12:56:15 -0800 (PST), john lin <[EMAIL PROTECTED]> wrote: John, I'm not a 'C' programmer, but I think you need to enclose your VALUE with single quotes for a literal value: VALUES('test') Atleast in Perl, it' done that way. >>I am a senior in Polytechnic University work

Re: Case Sensitive??

ame)= upper('whater I am searching >>for'); >> >>Cal >>http://www.calevans.com >> >> >>-Original Message- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED]]On Behalf >>Of MikeBlezien >>Sent: Thursday, March 22,

Re: Case Sensitive??

On Thu, 22 Mar 2001 22:27:06 +, Jordan Elver <[EMAIL PROTECTED]> wrote: Ignore this post! My fault, we had something coded wrong in the script.! It works fine now. My apologies to the list! :( >>If you add BINARY to the column it WILL make it case sensitive. >> >>On Thursday 22 March 2001 2

Case Sensitive??

Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", a

Re: replace qeustion

On Wed, 21 Mar 2001 14:59:38 -, "soon chee keong" <[EMAIL PROTECTED]> wrote: A very basic UPDATE will do the trick. UPDATE Table_1 SET C = '20' WHERE C = '9' >>Table_1 >> >>- >> A B C >>- >> 1018 9 >> 4 3 1 >>-

Build Search Query - STUMPED!!

Hello All, MySQL version 3.23.33 I was hoping someone maybe able to offer some suggestion on a search query I've been working for a day or so, but seems to be getting no where fast! I've attached the tables and test inserts I'm working with. This is for a business referral search where people s

Build Search Query - STUMPED!! - REFERRAL.SQL (0/1)

Hello All, MySQL version 3.23.33 I was hoping someone maybe able to offer some suggestion on a search query I've been working for a day or so, but seems to be getting no where fast! I've attached the tables and test inserts I'm working with. This is for a business referral search where people s

Build Search Query - STUMPED!! - REFERRAL.SQL (1/1)

# # Table structure for table 'bus_info' # CREATE TABLE bus_info ( info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment, bus_name varchar(100) DEFAULT '' NOT NULL , contact_fname varchar(20) DEFAULT '' NOT NULL , contact_lname varchar(20) DEFAULT '' NOT NULL , refer_by int(8))

Re: 2 Tables

On Sat, 17 Mar 2001 22:04:37 +0100, "Denis Mettler" <[EMAIL PROTECTED]> wrote: Denis, Can't you tie the table 1 id and the table 2 category_id together?? Or are this going to be different?? If they are going to be different, I would suggest then create a "linking" table to link table 1 to table

Re: Seaching Keywords column

On Sat, 10 Mar 2001 14:24:18 -0500, "Tac/Smokescreen Action Network" <[EMAIL PROTECTED]> wrote: Would you happen to have an example?? I did look at the FULL TEXT search, but I'm not sure this would work in our situation,... but we maybe able to adapt to it. TIA, >>Of course, the other way to

Seaching Keywords column

Hello All, We have a table where keywords will be entered into a column (searchwords), up to 3 unique keywords. Then this column will be used in a keywords search tied to a Category(a Category has to be selected). The table will have a category column: category. Basically when a search is done, i

Re: Converting tables to MyISAM

On Fri, 9 Mar 2001 18:41:46 -0500, "Tac/Smokescreen Action Network" <[EMAIL PROTECTED]> wrote: >> >>I've searched the MySQL manual and can't figure out how to convert one (or >>all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to >>3.23). >> >>I think there's a way to do it

Appointment Book

Hello All, Apologize for the slightly off topic. but was wondering if any one on list knows of either a freeware or commercial program for setting up and maintaining Appointments. This is for a golf club that would like to set up a MySQL database for golfer to register and reserver tee-off times.

Re: Default values

On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen <[EMAIL PROTECTED]> wrote: Thanks Fred, >>INSERT INTO referral >> VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]'); >> >> >>But an INSERT like this: This is where I was making the mistake! It works fine now. I was inserting an blank empt

Re: Default values

On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark" <[EMAIL PROTECTED]> wrote: Gerald, >>Try giving a number instead of a string as a default for an int. >> Not sure I follow, it is a number?? >>"MikeBlezien" wrote: >>> >>>

Default values

Hello All, I've created a table(using MySQL 3.23.33), using default values: DROP TABLE IF EXISTS referral; CREATE TABLE referral ( refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, refer_fname varchar(20) DEFAULT '' NOT NULL, refer_lname varchar(20) DEFAULT '' NOT NULL, refer_email varchar

Re: Limiting to specific field value of type float

On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway <[EMAIL PROTECTED]> wrote: Try using DECIMAL, this works best for monetary values in my experience. >>I'm having some trouble with the following: >> >>I have a sample table that has one record where price == 123.54, however >> >>select * from gp

phpMyAdmin equivalent

Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien ===

Re: TXT to MySQL DB

On Mon, 5 Mar 2001 16:28:56 +0900, "Cho Bum Rae" <[EMAIL PROTECTED]> wrote: check into the LOAD DATA, this should handle it for you. Manual: http://www.mysql.com/doc/L/O/LOAD_DATA.html >>Do you know how to import TXT file into mysql DB? >>Because of big size txt file, I cannot input data int

Keyword search string

Greetings, I have a table that has a column where search keywords are entered. column searchwords word1 word2 word3 ..etc Now when this column is queried for a search, I'm wonder how is the best way to evaluate matching the keywords. In the SELECT query, would I get better results if I use:

  1   2   >