RE: Count syntax

Thanks to all. > -Original Message- > From: Michael Dykman [mailto:[EMAIL PROTECTED] > Sent: September 28, 2007 1:36 PM > To: Beauford > Cc: mysql@lists.mysql.com > Subject: Re: Count syntax > > 1 means that 1 will be added to the sum if the condition >

RE: Count syntax

Thanks - it works, but what does the 1 and 0 do in this - SUM(IF(supportertype = 'L', 1, 0)) > -Original Message- > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > Sent: September 28, 2007 1:00 PM > To: Beauford > Cc: mysql@lists.mysql.com > Subject: Re: Coun

Count syntax

Hi, I have the following line of code and I keep getting wrong results from it. Can someone let me know what I'm doing wrong here. I just can't quite figure out the syntax that I need. select count(*) as numrows, count(supportertype) as leadcar from registrar where supportertype = 'L'; What I wa

RE: Scheduled events

> > I have been trying for days to find a simple command in > MySQL where I > > can automatically delete records based on some criteria after a > > certain timeframe. > > > > I found this in the MySQL manual, but I guess it only works with > > version 5.1+. Unfortunately the version I need thi

Scheduled events

Hi, I have been trying for days to find a simple command in MySQL where I can automatically delete records based on some criteria after a certain timeframe. I found this in the MySQL manual, but I guess it only works with version 5.1+. Unfortunately the version I need this to work on is 4.1, and

RE: Windows - logging into MySQL

99% right on target (1% because not enough information was given) and can help on every version of db out there. Don't start a flame war because your feelings were hurt. Grow up. J.R. -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 6:05 P

RE: Windows - logging into MySQL

some information in another response as to the problems with later versions etc. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 5:57 PM To: Beauford; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into

RE: Windows - logging into MySQL

ng an external database so not sure why this is. Thanks to all that posted legitimate answers. SGreen can biteme however. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:08 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into

RE: Windows - logging into MySQL

y own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2

Windows - logging into MySQL

I just installed MySQL 3.23 (the only one I could get to work) and I find that I can log into the server just by typing mysql at the DOS prompt. Ho do make it so you have to use a user name and password to get in. Thanks Running on Win2k Advance Server. -- MySQL General Mailing List For list

RE: Problem with tables

ubject: Re: Problem with tables; You need to do desc spamdata; NOT desc id. Aman Raheja Beauford wrote: >Hi, > >I'm trying to create a table using the commands below, and everything >seems to work and the table is there - I just can's access any of the >fields. This h

Problem with tables;

Just some updated info on this. It appears everything is there and working. I can update the table, do queries on the table, etc. - the only thing I can't do is a 'desc whatever' I still get the 1146 error. Thanks -Original Message- From: Beauford [mailto:[EMAIL P

Problem with tables;

Hi, I'm trying to create a table using the commands below, and everything seems to work and the table is there - I just can's access any of the fields. This happens on both my Windows and Linux versions of MySQL. Any help is appreciated. Note, I have 8 other databases that I created with no proble

Searh question

If I have a database with various dates in it, how can I search for all instances of the same date. Note that I do not know what the dates are (or how many there will be) so the search can't be hardcoded. These dates will be added based on user input from a website. Is there some kind of comparis

Help. Not sure my other email got through!

Not sure my other email got through, so here it is again, with an updated description of the problem. Hi, I have a database with 3 names in it. In each of these names is 5 categories that have numbers in them. I want to be able to do a select and total these numbers for each name, and then sort

Help, Not sure my other email got through!

Not sure my other email got through, so here it is again, with an updated description. Hi, I have a database with 3 names in it. In each of these names is 5 categories that have numbers in them. I want to be able to do a select and total these numbers for each name, and then sort them in descen

Linux Mysql vs Windows Mysql

Hi, I just installed MySQL and PHP on Windows XP and have a question. I created a test database on Windows (exactly the same as the test one I use in Linux) and copied a test PHP script which accesses Mysql and displays some information. On Linux it works perfectly, but on Windows I get the follow

Automatically totalling columns.

Hi, I have two tables, one with peoples names in it and one with data associated to these people. What I need to do is to be able to automatically total certain items in the data table that correspond with a name in the first table and then update the name table.. i.e. This is a crude example, bu

Duplicating a table question

These spam filters are really annoying. It's hard to get an answer to my question when my message gets bounced 'cause it doesn't have MySQL or query in the message. In any event, Is there a way to duplicate a complete table. I am making some modifications and don't want to use the working table

Re: Load Data Infile command

Try this when your logging into mysql, not when starting mysql. This works for me on Linux. mysql --local-infile=1 -u username-p - Original Message - From: "Jon Bertsch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 12:02 PM Subject: Load Data Infile comman

Displaying output from MySQL

Hi, Not sure if this is a PHP of a MySQL question, so I am sending it to both groups. Basically I have a list of numbers with two decimal places in the MySQL database, but I only want to display some of them with the decimal points. i.e. 70 (not 70.00) 87 51.5 46.75 12 29 5.5 -1 45 I know it's

Re: Select * From table where name Like 'help'; Help

One That's the One There are also other words that contain the word one, like stone and anyone. I want to be able to run a search that will just show the first 3 by typing in the word One ('one' would result in the string not found'). Beauford ---

Re: Select * From table where name Like 'help'; Help

"where name like binary '$var'". It's jury rigged, but works the way I need it to work for the most part. Thanks for your suggestions. - Original Message - From: "Andy Bakun" <[EMAIL PROTECTED]> To: "Beauford.2003" <[EMAIL PROTECT

Re: Select * From table where name Like 'help'; Help

ater and Your On Third. The only thing I could do is to add a space after $var, but them partial searches won't be found. i.e. searching for beaufor will not find beauford. Until I can find a better way, one of these will suffice. Thanks for your correction as I did miss the space thing.

Re: Select * From table where name Like 'help'; Help

at http://www.mysql.com/doc/en/Regexp.html, but it does not cover this. - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Beauford.2003" <[EMAIL PROTECTED]> Cc: "Robert Citek" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL

Re: Select * From table where name Like 'help'; Help

t; <[EMAIL PROTECTED]> To: "Beauford.2003" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 8:16 PM Subject: Re: Select * From table where name Like 'help'; Help > > Try the REGEXP modifier. For example: >

Select * From table where name Like 'help'; Help

into a few snags. If I search for the word - One - I want to see: Another One One Day One on One Your The One But not: Fashioned Stone Everyone Also, and maybe part of the solution - is there a way for the search to be case sensitive. TIA Beauford

Re: LOAD DATA command

If your using a Linux machine try using this when logging on to mysql: mysql --local-infile=1 -u username -p Not sure about Windows. There is apparently a security issue with this so it is not enable by default. Can't remember where I read this, but the above works for me. Bea

Fw: Thanks

searches easier. Thanks again, Beauford - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Re: Table setup question

Thanks for the help, but I just can't grasp the concept (I'm not even sure I have my table layouts the way they should be to have this work). I'll have to look into this further, but for the time being the way I have it is working. Beauford - Original Message - From

Re: Table setup question

album name and song title for song ID # 1 above). Sorry if this is long, I just wanted to make sure there is enough info. TIA Beauford - Original Message - From: "Adolfo Bello" <[EMAIL PROTECTED]> To: "'Beauford.2003'" <[EMAIL PROTECTED]>; <[E

Join help.

Hi, Is there a good tutorial somewhere on the join command. No matter what I do it just doesn't work. Obviously I'm doing something wrong, but the MySQL manual just doesn't help at all. TIA - Before posting, please check: h

Re: Select, mysql_fetch_array, PHP question

Alex, That's it - I have a if (mysql_fetch_row($result)) before the while loop. I've changed it slightly and now it works fine. The little things are always the ones that get you. Thanks - Original Message - From: "Alex Pukinskis" <[EMAIL PROTECTED]> T

Re: Select, mysql_fetch_array, PHP question (sorry - typo in my original email)

Sorry, where it says echo $item should have read echo $line['item']; Simply a typo, but the problem is still the same. Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and there are three of th

Re: Table setup question

DL, Yep, I see what your saying. In my application it may work fine, but in larger applications where things may change, it would be easier to do it with the 3 tables. Thanks - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Beauford.2003" &l

Select, mysql_fetch_array, PHP question

Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and there are three of them, the query works and displays the information, but if there is only one item the query works but doesn't display the

Re: Table setup question

with the album title, and one that is used for the song title). The difference between what you have said and what I have is that I have duplicated the actual song titles instead of a pointer to the song title This way I have eliminated one table. Thanks again, Beauford - Original Message

Table setup question

trying to get a handle on all of it. My way works, but I'm sure there has to be a better way. Any thoughts are appreciated. TIA, Beauford - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Update help

Hi, I'm trying to update a table from my webpage but not having much luck, although it works from the command line. Obviously I am missing something and would appreciate any help. Also. Is there a good tutorial or help page for Mysql. I find the one at www.mysql.com not very helpful. TIA The co

Scrolling Databases

Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy

RE: Errors stating Mysql server

4096 Nov 9 05:39 var/ TIA -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: November 9, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: re: Errors stating Mysql server Beauford, Saturday, November 09, 2002, 8:27:58 AM, you wrote: B>

Errors stating Mysql server

s are still there. Is there not a simple easy way to do this. This is really ridiculous. TIA 021108 21:18:11 mysqld started /usr/local/mysql/libexec/mysqld: File './beauford-bin.009' not found (Errcode: 13) 021108 21:18:11 Could not use beauford-bin for logging (error 13) 021108 21:18

Question re: Displaying data on a website.

I have a website using PHP and MySQL and having a problem. This is what I have: $db = mysql_connect("1.1.1.1","name","password"); mysql_select_db("database"); $query = "SELECT title, artist FROM songlist WHERE songlist.songid=1"; $result = mysql_query($query) or die("Query failed"); Then I have