Re: row count inconsistency

2007-02-21 Thread Marty Landman
T\n` if not $cur % 10 } print $line,"100537311\n" On 2/20/07, Steve Edberg <[EMAIL PROTECTED]> wrote: At 6:23 PM -0500 2/19/07, Marty Landman wrote: >Hi, > >I've got a very large table set up and have defined the id as >auto_increment. No r

row count inconsistency

2007-02-19 Thread Marty Landman
what might've happened to explain this? Marty -- Web Installed Formmail - http://face2interface.com/formINSTal/ Webmaster's BBS - http://bbs.face2interface.com/

Not getting matching records

2004-06-09 Thread Marty Smith
Has anyone seen a post on this issue? If not, can anyone offer any advice? I have a TBL of users and I have created a search screen where you can type in first or last name and it will retrieve the appropriate records. Here is the statement: "Select * from STUDENTS WHERE FName LIKE '%" .$_R

Select Problem

2004-06-08 Thread Marty Smith
Has anyone seen a post on this issue? If not, can anyone offer any advice? I have a TBL of users and I have created a search screen where you can type in first or last name and it will retrieve the appropriate records. Here is the statement: "Select * from STUDENTS WHERE FName LIKE '%" .$_R

Mac: Trouble linking library

2004-02-15 Thread Marty Ray
ton and picking different types such as "compiled" and "archive", but I still get errors. Anybody have any suggestions?" Thanks. Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Another beginner question

2004-02-12 Thread Marty Ray
Brace yourself for another beginner question... When I try to use the SHOW command (logged in as root) , I get an error: mysql> show databases; ERROR: No query specified Any suggestions? Thanks! Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
appreciate that! Regards and thanks to all, Marty Ray On Feb 12, 2004, at 4:43 PM, j.e.b. wrote: Marty Ray This should help you out - http://www.entropy.ch/software/macosx/mysql/ I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I cannot get it to start up. I first tried manu

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
line 274: 397 Broken pipe cat $fill_help_tables Installation of grant tables failed! I'm sure all this is boring and routine for all of you, but unix is still mostly Greek to me, although I am learning! Thanks Again, Marty Ray On Feb 12, 2004, at 5:37 PM, J.R. Bullington wrote:

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
n key constraint system tables created 040212 15:54:39 InnoDB: Started; log sequence number 0 0 040212 15:54:39 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040212 15:54:39 mysqld ended Hmmm... Marty Ray On Feb 12, 2004, at 4:56 PM, Michael Stasse

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
uter:/usr/local/mysql martyray$ --- Hope I didn't screw up too bad... 8) Thanks for your help. Marty Ray On Feb 12, 2004, at 4:35 PM, Brent Baisley wrote: I assume when you tried to start MySQL from the command line you used saf

Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" I then tried installing the automatic startup routine, restarted the computer and running mysql and I get the same message. Any suggestions? Thanks! Marty Ray -- MySQL Gene

Macintosh: Trouble with grant tables?

2004-02-07 Thread Marty Ray
gure out what else to do. Any suggestions? (take it easy on me, I'm fairly new to Unix) Thanks! Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FULLTEXT search - another question

2001-09-04 Thread Marty McCoy
; as part of a short description varchar column, and we would want the plus sign to be a significant part of the word, since we don't want to find to be just on "x-axis". Is there a way to change the word definitions, or am I going to have to add a [ ... like "

FULLTEXT search with hyphens in data

2001-08-22 Thread Marty McCoy
as a word delimiter or something like that. Is there a way to "escape" the hyphen, that is, make it a significant part of the search? Is there something that I could edit in myisam/ftdefs.h (or somewhere else) that would do what I would like? Thanks, Marty ---

DISSERTATION2 [VIRUSES STRIPPED]

2001-07-25 Thread Marty Bright
Hi! How are you? I send you this file in order to have your advice See you later. Thanks "MMS " made the following annotations on 07/25/01 21:49:44 -- [ALERT] -- Virus Manager: Viruses were detected in this message a

MySQLGUI Issue

2001-06-25 Thread Marty Bell
I am new to MySQL and this may be more of a training issue on my part than a problem. I can not seem to get the 'edit table' or 'create table' function to work. Not sure if I don't know the sequence of things to do or what. Please ad

Re: Mass upload

2001-04-12 Thread Marty Landman
duplicate keys, but this is easy to do. Marty Face 2 Interface Web Solutions Content Management Made SIMPL(tm) http://face2interface.com/Home/SIMPL.shtml - Before posting, please check: http://www.mysql.com/manual

Re: "Memo" Fields

2001-04-11 Thread Marty Landman
provides the 'blob' data type. The manual goes into details including limits and restrictions. Marty Face 2 Interface Web Solutions Content Management Made SIMPL(tm) http://face2interface.com/Home/SIMPL.shtml - Before p

UPDATE issues

2001-02-23 Thread Marty
;, size3='' where id=1" when i execute the query from the mysql shell, however, one row is matched but no changes are made and warnings are returned. My questions are: a) does it matter what order you attempt to update the fields in? b) is there a way to view wha

an issue with my UPDATE query

2001-02-23 Thread marty
7;, size3='' where id=1" when i execute the query from the mysql shell, however, one row is matched but no changes are made and warnings are returned. My questions are: a) does it matter what order you attempt to update the fields in? b) is there a way to view w