Re: How to copy file from an old server to reconstitute a database ?

2011-06-18 Thread leegold
hould be up and > running again. > > That's a 50,000ft overview of the process but unless you're having some > other more serious issues with the data then the previous steps should > get > you working again. > > A > > On Thu, Jun 16, 2011 at 6:50 PM, leegold w

How to copy file from an old server to reconstitute a database ?

2011-06-16 Thread leegold
Hi, I have a situation where the box with a mysql server will not boot. But I can boot it from a CD and browse the hard drive and I can mount partitions so files and data are accessible. I want to somehow take the Mysql DB structure and content, copy it, and move it to a bootable working unit. Nor

what is selectivity?

2006-06-23 Thread leegold
Reading about DBs I am seeing the term "selectivity". What does it mean? Seems like it has something to do with the distribution or pattern of data in tables(?) It's coming up in discussions about optimization... Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

technical lingo for search feature

2005-12-12 Thread leegold
Is there a tech term for this? User searches for "reviews" but the actual word is "review". So the search engine code searchs on bolth words and user gets the hit they want... What's this called? Is there a MYSQL implementation of this? Thanks -- MySQL General Mailing List For list archives: ht

RE: Newbie needs info!

2005-09-06 Thread leegold
On Tue, 6 Sep 2005 10:58:28 -0500, "John Trammell" <[EMAIL PROTECTED]> said: > The DuBois book is a good start: http://www.kitebird.com/mysql-book/ This might be too basic but it's really clear: http://www.w3schools.com/sql/default.asp > > > -Original Message- > > From: Jay Paulson [m

Re: newbee question

2005-08-27 Thread leegold
On Sat, 27 Aug 2005 19:43:57 +0100, [EMAIL PROTECTED] said: > Using mysql with php I have a database that has a unique value for the > user id. when people get delete off the list I want the unique numbers to > compact down so. > > user id 1 > user id 4 > user id 5 > user id 7 > user id 9 > user

Re: Combining several sum queries

2005-06-22 Thread leegold
On Wed, 22 Jun 2005 09:55:39 -0400, [EMAIL PROTECTED] said: > Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM: > > > On 6/22/05, David Kagiri wrote: > > > When i run the queries below they all work just fine > > > > > > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,

Re: mysql UNION

2005-06-04 Thread leegold
Couldn't you just test "page.php?cat=faq" with an if-then-else? Depending on what is the GET variable you then can change the SQL, easy w/PHP. On Sat, 04 Jun 2005 14:15:40 -0400, "Sebastian" <[EMAIL PROTECTED]> said: > i have a query with 3 union selects: > > SELECT id, 'news' AS type,

Re: book advice

2005-04-14 Thread leegold
> > Hi, > > > > I'm a newbie and looking for a book to help me learn mysql. I have come > > across a book called "Beginning MySQL" by Robert Sheldon and Geoff Moes. > > > > Can anyone recommend this book? Or, if not, what book can you recommend > > for > > a newbie. If there is a big college near

selecting fields with NULL

2005-03-29 Thread leegold
Hi, I understand that we should use "IS" instead of "=" for selecting fields with NULL. But then, shouldn't the statement below cause a syntax error? Please explain. select * from test2 where datecurrent=NULL; Thanks, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread leegold
On Wed, 23 Mar 2005 22:22:34 +, "Jessica Svensson" <[EMAIL PROTECTED]> said: > Hi that works fine only now if a user puts + in front of a word that word > becomes optional = OR? > What i would like is the search to work exactly like before only that it > defaults to AND instead of OR. > Almo

Useful Relevance with FullText Boolean Mode - help

2005-02-26 Thread leegold
Is there any way to make relevance when using boolean mode more useful? If not, are there plans in the future Fulltext development "todo" for making it useful? I'm thinking of just counting the keyword occurences in records with a PHP script somehow and using that to order the records. Or doing a

relevance with complex fulltext query

2005-02-21 Thread leegold
I want to have the query cited at the very bottom return a result sorted by FullText Relevance. I'm thinking I would modify each SELECT separately. For example maybe the first SELECT clause something like: SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`), MATCH (`keywords`.`keywor

addendum - certain content is causing an error with INSERT ....

2005-02-12 Thread leegold
I fixed it. But I'm not clear on why. The following code ie. taking the content and blatently putting the content through addslashes(): $descrip_field=addslashes($descrip_field); Fixed it. But the code: if (!get_magic_quotes_gpc()) { $descrip_field = mysql_real_escape_string($descrip_field);

certain content is causing an error with INSERT - please help

2005-02-12 Thread leegold
I'm ripping hair out, here's the problem...I'm trying to insert content cited below into a field and it's causing this error, ie. there's content i just cannot insert into the DB an it's causing the following error message: "You have an error in your SQL syntax; check the manual that corresponds t

ssh connecting with a mysql client I get: ERROR 2013

2005-02-03 Thread leegold
ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and trying connect via the ssh tunnel. I can connect with out the ssh w/mysqljog OK. It's a very nice client and would like to get this working. I have googled it but nothing s

add auto-increment field to fix table with no primary key - help

2005-01-30 Thread leegold
I have a table with no primary key. I would like to add a new auto-increment column field to each record - that would be the easiest way to remedy this. Eg. 1,2,3,4tagged onto each record successively. Is this possible with SQL? I also have PHP to use as well if needed. Thanks -- MySQL Gene

RE: disappearing data - please help!

2005-01-30 Thread leegold
> > From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] > > Sent: zondag 30 januari 2005 21:31 > > To: mysql@lists.mysql.com > > Subject: disappearing data - please help! > > > > What makes this all the more mysterious is that it happens > > intermittently. Sometimes when the script

Re: auto-increment question

2005-01-24 Thread leegold
Oh, myqldump automatically records the current auto-increment when it dumps in the .sql file... That explains it... On Mon, 24 Jan 2005 17:10:11 -0500, "leegold" <[EMAIL PROTECTED]> said: > > On Mon, 24 Jan 2005 12:34:38 +0200, "Gleb Paharenko" >

Re: auto-increment question

2005-01-24 Thread leegold
.wish I had more time to say more. But the updating mysteriousness is causing hair ripping... > > "leegold" <[EMAIL PROTECTED]> wrote: > > I have two different databases they both have an auto-increment PK field > > and while they are different databases with different nam

Re: auto-increment question

2005-01-23 Thread leegold
Now I'm confused the auto-increment number reverted back to one (1) after I truncated the tables in one of the DB's. I suppose as long as the number is unique within the objects I'm making selections, updates...ect in - who cares. On Sun, 23 Jan 2005 02:18:33 -0500, "leegol

auto-increment question

2005-01-22 Thread leegold
I have two different databases they both have an auto-increment PK field and while they are different databases with different names, they do have tables with the same names. What I find is that the auto-crement integer number remembers what it is across these databases. So if I insert in the 1st D

Re: Embedding MySQL in application, probably developed in C#

2005-01-20 Thread leegold
On Wed, 19 Jan 2005 21:28:05 -0800, "elizabeth baker" <[EMAIL PROTECTED]> said: > We are building an application for myths of the world. It started out in > Access, but when we decided to distribute it via CD to attendees at an > art retrospective (about myths of the world), we began looking for

repost w/code : can mysql work in Windows but not Solaris?

2005-01-15 Thread leegold
Is there any reason you can see why the fulltext php/mysql code below works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when put on a Solaris Server with php5 mysql 4.1.6 ? That is what happens...I'm suspicious of the accent characters in the code but I am not sure if there's any

Error message on Solaris server - help

2005-01-14 Thread leegold
Getting the following runtime error messages on a Solaris server, Mysql 4.1.7 PHP 5.0.1: I try to search and: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/labweb/htdocs/getit/search010.php on line 123 Warning: mysql_num_rows(): supplied argument i

Fulltext search question

2005-01-10 Thread leegold
Given a search string of 'NA&SD' my default Fulltext search doesn't find it. Wondered why? Is there a fix? Thanks for the help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FullText search question

2005-01-10 Thread leegold
Given a search string of 'NA&SD' my default Fulltext search doesn't find it. Wondered why? Is there a fix? Thanks for the help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: lock the tables

2005-01-08 Thread leegold
) > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County, Iowa > > -Original Message- > From: leegold > Sent: Saturday, January 08, 2005 3:39 AM > To: No name > Subject: lock the tables > > I'm going to have a php web form that po

lock the tables

2005-01-08 Thread leegold
I'm going to have a php web form that potentially many users will use to insert into a MYSQL DB, maybe they will try at the same time. Do I have to lock the tables that are being populated? Will a solution queue insert requests or just say I am busy? Thanks, Lee -- MySQL General Mailing List F

Fulltext search string less than 4 characters

2005-01-06 Thread leegold
I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link explaining how. Maybe UNIX help in general on his would be good as well. Thanks, Lee G. -- MySQL G

MySQL insert with PHPMyAdmin

2005-01-06 Thread leegold
Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data entry tool. I create a new record in a table and then fill in the fields with the field editing and insert abilities of PHPMyAdmin. For a remote user of course I'd escape any inserted strings with addslashes or m

Reccommend host w/recent MYQL version

2004-12-30 Thread leegold
Having a hard time finding a server/host who supports MYSQL 4.1.3 or above. Does anyone know and can recommend a host who offers this? Thanks, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP and MySQL

2004-11-25 Thread leegold
On Fri, 26 Nov 2004 05:44:00 +0100, "Danesh Daroui" <[EMAIL PROTECTED]> said: > Hi all, > > I have installed MySQL Server 4.1.7 on a Linux Fedora Core 3 machine. It > works great locally and remotely. This machine also supposed to act as a > web server by using Apache 2.0.52 and it works fine t

Re: ampersands in the database fields

2004-11-02 Thread leegold
27;m using SELECT from the command line. "&" is what's actually in the DB field. Should I UNencode & to give just "&" before before I insert?:P Thanks > a web interface may cause problems try to go into the plain command line mysql > client and see what

ampersands in the database fields

2004-11-02 Thread leegold
The subject title is a sedgeway into my question that may slightly of topic but I've asked many sources and don't have an answer yet so I ask it here. I have a text fields of html marked up content which I render via php. Looking at the rendered html page in a text editor I see that ampersands all

Re: mysql admin clients - But can I edit a column field?

2004-11-01 Thread leegold
On Tue, 2 Nov 2004 01:12:37 +0200, "Polyakov Dmitryi" <[EMAIL PROTECTED]> said: > Hello leegold, > for what OS? or you need just web-based app? > for win - MySQLFront > web-based - phpMyAdmin (PHP required) > Tuesday, November 2, 2004, 12:57:46 AM, you wrote: But

mysql admin clients

2004-11-01 Thread leegold
newbie question about mysql admin clients. What are some good ones? And importantly can they access and allow me to edit the db record fields themselves? eg. I see a mis-spelled word in a field - I could go in there and edit the field. Thanks, lee G> -- MySQL General Mailing List For list archiv

html links inside varchar and text fields

2004-10-27 Thread leegold
I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search, would pick them up - I realize that) and they have to render as clickable links when I output the fields via PHP. How would I do this? Is this more of a P

Union query help

2004-10-22 Thread leegold
Is this possible? Is it possible to have three queries in a UNION? Sorry about the PHP in there. I just wanted to know if this is allowed? If only the 1st two queries it works OK, add the 3rd and it breaks. How can I accomplish this? Thanks. Lee G. I'm using 4.1.3beta $result = mysql_query("(SELEC

How to remove an index

2004-10-18 Thread leegold
I want to remove the index I made below. I intend to then redo it because I forgot to add a third field. How do I remove this index? Alter...? Thanks. mysql> ALTER TABLE page -> ADD FULLTEXT (title), -> ADD FULLTEXT (descrip), -> ADD FULLTEXT (title, descrip); Query OK, 1 row af

Re: Can MySQL do this?

2004-10-16 Thread leegold
...snip > Is there a database generation system that would be able to handle this > task and generate a webpage as output? Try, AMP [Apache-MYSQL-PHP] See the tutorial, http://www.devarticles.com/c/a/Apache/Installing-PHP-under-Windows/ This tutorial is helpful. It's geared to MS Windows, s

RE: Fulltext Search help

2004-10-16 Thread leegold
On Fri, 15 Oct 2004 20:05:57 -0400, "leegold" <[EMAIL PROTECTED]> said: > > On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" ... But maybe there's a better way? I > wish I could do *searchstring* in Fulltext even if the speed was slow as >

RE: Fulltext Search help

2004-10-15 Thread leegold
On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" <[EMAIL PROTECTED]> said: > leegold <mailto:[EMAIL PROTECTED]> > on Friday, October 15, 2004 2:32 PM said: > > > I do fulltext search on "work". And AFAIK the search will not find > >

Fulltext Search help

2004-10-15 Thread leegold
I'm running into a limitation in the fulltext search though I think by defination a "fulltext" search will not - or even should not do this, but I'd like to implement this this functionality somehow, given in a text doc. the string: "Yesterday I was superduperworkingman at times." I do fulltex

Re: Querying form different tables and multiple records - help

2004-10-12 Thread leegold
On Tue, 12 Oct 2004 16:06:59 -0400, [EMAIL PROTECTED] said: > My response below Thank you for that comprehensive answer below - it helped me a lot. > > "leegold" <[EMAIL PROTECTED]> wrote on 10/12/2004 03:11:05 PM: > > > I have been trying to explain my

Querying form different tables and multiple records - help

2004-10-12 Thread leegold
I have been trying to explain my question, I'm trying to detail it as exactly as I can, I can not tell you how much this forum has helped with my project. I hope I am clear, he's some invaluable SQL i got from a poster here, it's what I'm currently playing with as my search/query[w/php]: $query =

Re: mysql_real_escape_string problem

2004-10-09 Thread leegold
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said: > At 23:18 -0400 10/9/04, leegold wrote: > >Seems like mysql_real_escape_string function is not working? > >mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32) > > >

mysql_real_escape_string problem

2004-10-09 Thread leegold
Seems like mysql_real_escape_string function is not working? mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32) "; echo addslashes( $originalstring ), ""; echo mysql_escape_string( $originalstring ), ""; echo mysql_real_escape_string( $originalstring ), ""; ?> Shows up in my browser as

Re: select/query from two tables

2004-10-08 Thread leegold
> > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > "leegold" <[EMAIL PROTECTED]> wrote on 10/08/2004 12:06:17 PM: > > > A popular question, how to select/query from two tables. I googled it > > but am h

select/query from two tables

2004-10-08 Thread leegold
A popular question, how to select/query from two tables. I googled it but am having trouble, wondered if anyone would answer this newbie question. Here's my existing (PHP) query: $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAIN

Fulltext user interface

2004-10-05 Thread leegold
Right now on a form I have the instructions below, I'm pretty comfortable with using PHP. I'm thinking of replacing the text below with some self-explainatory radio buttons. Is it as easy as just putting "+" in front of each word if "all words" would be checked. Or if the radio button "phrase" wa

special characters not inserting into database - help

2004-09-28 Thread leegold
Newbie type question: apostrophes ie. a ' single quote is not "getting into" the database fields. So if I entererd in a PHP/MYSQL web page entry field: Sally's Website. When I look directly into the column with the MYSQL cmdline I see: Sally s Website. Below are the code snips I'm using(I number

Re: newbie ALTER syntax help

2004-09-23 Thread leegold
On Thu, 23 Sep 2004 15:51:56 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said: > At 12:12 -0400 9/23/04, leegold wrote: > > alter table keywords change key_id page_id int(10) unsigned NOT NULL PK > > auto_increment; > >ERROR 1064 (42000): You have an error in

newbie ALTER syntax help

2004-09-23 Thread leegold
alter table keywords change key_id page_id int(10) unsigned NOT NULL PK auto_increment; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK auto_increment' at line 1 I'm trying to change the

Re: Mysql and PHP

2004-09-16 Thread leegold
On Thu, 16 Sep 2004 09:27:08 -0400, "John Nichel" <[EMAIL PROTECTED]> said: > nestor(earth) wrote: > > People, > > > > This more of a php mysql question. I have installed PHP ( 5.01) with > > Apache(1.31) and it runs. > > I have install Mysql (the latest as of last night) and it runs. My >

when to use backquote in SQL

2004-09-09 Thread leegold
Could anyone link me or explain the purposes of backquotes in an SQL statement. I tried searching the manual and googling it but couldn't find a simple explaination. ``` vs. "regular" single quotes'''. Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Rename a columkn

2004-09-08 Thread leegold
I sent a previous email w/the wrong subj. - sorry. The example below renames a col. But can I rename a col. w/out giving all that type spec. at the end of the statement below. I just want to rename, everything else stays the same. Thanks. mysql> ALTER TABLE search CHANGE Description PageDescripti

Re: Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread leegold
The example below renames a col. But can I rename a col. w/out giving all that type spec. at the end of the statement below. I just want to rename everything else stays the same. Thanks. mysql> ALTER TABLE search CHANGE Description PageDescription VARCHAR(255) NOT NULL; -- MySQL General Mailing

fulltext usage for specific keywords

2004-09-07 Thread leegold
I asked a ques, in a previous post but maybe I should simplify the question. Am I totallly crazy to use FullText for specific keyword searchs? Let's say I have a text data type field and I load it with keywords (text after all), the couldn't I just use a Fulltext index on that field then search for

db design - keyword fields

2004-09-05 Thread leegold
I'm sure this is a common and simple situation: say I have a title, url, description fields, assume they makeup a record in one table named book_info. Say for each of this table's records I also need a keywords field (of type text) and I'll use a fulltext index on this field. Great, now the user do

Select statement escaping characters question

2004-08-22 Thread leegold
Wondered in this example why $url_field apparently must be in quotes ie. escaped quotes? Since the whole php/mysql statement is quotes too wouldn't it interpolate correctly w/out added quotes? What's the idea behind it? I got this off of a a web tutorial. It's a varchar field. Thanks for helping w

html in a text field - good practice?

2004-08-18 Thread leegold
Question I have wondered about: Is it a good practice to put html in a text field, then (eg. via php) when the marked-up text renders in a user's browser it's good looking html. If not, then I'd just sandwitch field content in a when it's rendered. Though, seems like it would mess-up fulltext sear

Re: SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
be swapped, based on their > names. > > See the manual <http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html> for > the details on INSERT...SELECT. > > Michael > > leegold wrote: > > > On Mon, 16 Aug 2004 13:57:13 -0400, "Michael Stassen" > > <

Re: SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
il you answer that, no one can > provide a correct solution. > > Michael > > leegold wrote: > > > On Mon, 16 Aug 2004 12:39:32 -0400, [EMAIL PROTECTED] said: > > > >>Let me see if I can explain it a little betterIf you need to > >>move all 3 columns to the n

Re: SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
il you answer that, no one can > provide a correct solution. > > Michael > > leegold wrote: > > > On Mon, 16 Aug 2004 12:39:32 -0400, [EMAIL PROTECTED] said: > > > >>Let me see if I can explain it a little betterIf you need to > >>move all 3 columns to the n

Re: SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
On Mon, 16 Aug 2004 12:39:32 -0400, [EMAIL PROTECTED] said: > Let me see if I can explain it a little betterIf you need to move all > 3 columns to the new table but you only want *1* row where f2 and f3 have > a unique combination of values, how do you want to choose *which* value > of > f1

Re: SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
stinct will let only one through. > Are there other columns (beyond these 3) to move as well? Nope. Just 3 cols. Thanks > > Yours, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "leegold" <[EMAIL PROTECTED]> wrote on 08/16/

SQL question, SELECT DISTINCT

2004-08-16 Thread leegold
say I'm selecting distinct (non-duplicate) rows for insertion, insert into original_table select distinct * from new_table these tables have 3 fields/row. Per the above code all 3 fields are evaluated by "distict *" . But my question is: I want to ignore field1, therefore I only want to test

Re: Can connect with PHP to MYSQL

2004-08-13 Thread leegold
> user's password with the OLD_PASSWORD() function. > http://dev.mysql.com/doc/mysql/en/Encryption_functions.html > > Wes > > > > On Aug 13, 2004, at 9:48 AM, leegold wrote: > > > I can connect in the php by using 'root' and the root pw. But when I &

Can connect with PHP to MYSQL

2004-08-13 Thread leegold
I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what am I overlooking? Again putting the root user name and pw it'll work in php but not for sarah: the php mysql_pconnect("localhost",

Re: Changing Fulltext defaults in Win32

2004-08-11 Thread leegold
On Wed, 11 Aug 2004 20:29:54 +0300, "Cemal Dalar" <[EMAIL PROTECTED]> said: > put a line like below to your my.cnf file under [mysqld] section > > ft_min_word_len=2 I assume I should shutdown-restart MYSQL after I do that ? Thanks, Lee G. snip -- MySQL General Mailing List For list archi

Changing Fulltext defaults in Win32

2004-08-11 Thread leegold
I'm using MYSQL 4.x on Win2k. I want to change the default smallest word size from the default (4 chars I think) to 2chars. Any links, how-to's appreciated. Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

RE: Lucene with MYSQL

2004-07-29 Thread leegold
ncy" maybe w/a simple real-life example so I can see the contrast between the two searchs? Thanks very much, Lee G. > > Hope my 5 cents works to you :) > > Carlos Proal > > > Original Message Follows From: "leegold" <[EMAIL PROTECTED]> > To: [E

Lucene with MYSQL

2004-07-29 Thread leegold
Is it possible to use the Lucene fulltext search on a MYSQL database - say for text type fields? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fulltext boolean search results

2004-07-24 Thread leegold
4.02 is one of many primary keys. I suppose Fulltext is a natural language search and not the tool to use when searching for specific primary keys. I could regex user search input and if I see anything between a '-' or '.' that's less than 4 chars I could "" the who

Fulltext boolean search results

2004-07-24 Thread leegold
If I search on: BT-1034.06 I get returned: BT-1034.02 BT-1034.03 BT-1034.05 ... BT-1034.11 If I put in "" ie. "BT-1034.06" I only get BT-1034.06 returned. The BT- part seems irrelevant. But I don't understand the results. Why so many returned? Seems like 1034.06 w/out the "" is unique enough. Is

Re: subquery SQL help

2004-07-17 Thread leegold
I could not get the subquery to work, but the sql below did what I wanted:^) SELECT balloon_rec.* FROM `balloon_rec` LEFT JOIN `balloon_txt` USING (`access_no`) WHERE MATCH (`balloon_txt`.`access_no`,`balloon_txt`.`recs_txt`) AGAINST ('meteorology') On Sat, 17 Jul 2004 12:15:20 -0400

subquery SQL help

2004-07-17 Thread leegold
I tried what's below, seemed OK, so I replaced an "IN" for the "=" in the subquery below because of the subquery's error message. I thought w/"IN" I'd get three (3) records returned as expected. But when I tried "IN" I got my entire DB returned - I don't show that below - it kept scrolling so I ab

Re: Search one table, then display another table where keys match ?

2004-07-15 Thread leegold
On Wed, 14 Jul 2004 11:17:20 -0500, "Peter Brawley" <[EMAIL PROTECTED]> said: > Match() returns a graded "relevance rating", snip... > you are looking for, though what you're looking for isn't entirely clear > from your post. It'll do OK. I would like to suggest if there's a wish list to make

Search one table, then display another table where keys match ?

2004-07-14 Thread leegold
If you would entertain a MYSQL/PHP, hope not too off-topicIt's probably not difficult to solve - but you would be helping me with some SQL logic. The only way I can think of to explain what I want to do is to give you my working newbie MSQL/PHP code that I'm learning MYSQL/PHP with, and at a cert

Implementing full text searching - need recommendations

2004-07-12 Thread leegold
Please let me show you one (TEXT data-type) item example. You will see "Title_[ ... Author[ ...Resp_Org__[..." Obviously, I don't want those strings searchable, they are headings, but I do want the content to the right of them indexed and searchable. So looking at it - what should I put in

Re: Implementing full text searching - more questions

2004-07-12 Thread leegold
> Keep in mind that a major limitation of the mysql > fulltext engine is that it can't index more than 500 > characters which could be a major drawback for your > parametric data. Just some genral qiuestions, Does that mean the max. string that can be indexed and therefore searched on is 500

Re: editing all columns in a table

2004-07-08 Thread leegold
On Thu, 08 Jul 2004 21:12:01 -0400, "leegold" <[EMAIL PROTECTED]> said: > I have a situation were a table field item has a > situation like: \r\ndata\r\n. So an item's got > line breaks in there with it in the field and > it's screwing things up for me. H

editing all columns in a table

2004-07-08 Thread leegold
I have a situation were a table field item has a situation like: \r\ndata\r\n. So an item's got line breaks in there with it in the field and it's screwing things up for me. How do I do a global clean-up of this and remove all \r and \n for all of that col. in my table? If it was flat-file I'd run

mysqldump

2004-07-08 Thread leegold
Hi, Will mysqldump import the entire DB? Including tables and ALL the data in the tables? I assume I must "create" the DB on the target system *then* load or run the file created by mysqldump? Is there a tutorial on this - I get the feeling the man page does not have the "soup to nuts" solution.

Re: select and where clause - help

2004-07-06 Thread leegold
On Tue, 06 Jul 2004 23:24:13 -0400, [EMAIL PROTECTED] said: > from your output it's not really possible to tell, but i suspect that > there are spaces following (and/or possibly in front of) the > "BT-1034.02" value, which would cause your select to fail to find > anything. > > try: > > SEL

select and where clause - help

2004-07-06 Thread leegold
I am trying to get a select statement with "WHERE" to work and I can't seem to do it. Below find some output. I try a select w/WHERE by "book" but it doesn't work. Originally I tried in PHP and didn't work, so now I just want the MYSQL to work first, I could be overlooking something simple since I'

first record is skipped in select and shows up last

2004-07-06 Thread leegold
What would be the cause of the following situation? I do a select * from a table and sort by the pk. The first line/record is notably empty/not there, and content starts w/2nd record, and what should be the 1st record appears at the end after the what should be the very last record. But doing a li

Re: converting timestamps to US Date format

2004-07-05 Thread leegold
> > > Hi there, > > > > I am having trouble converting a timestamp from mySQL to the US Format > > mm/dd/. Can someone please help. I am also having trouble > > converting -mm-dd into a normal mm/dd/ format as well. A bit off-topic but, if you are able to use Perl anytime during