Finding missing ID
Hi, I have database that has grown in size, I want to see what ID files have been deleted. Is there a way or do I have to print out the list and find them myself? Is there a sql or query statement that will let me find them. Chuck Payne - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please confirm (conf#92c92eb943e40c0d6fb2262ddcc31bdc)
IMPORTANT INFORMATION! This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the Reply button and send this message back (you don't need to edit anything). Once this is done, no more confirmations will ne necessary. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMACION IMPORTANTE Este es un mensaje automatico. El mensaje que usted ha enviado (mostrado mas abajo) necesita su confirmacion antes de ser entregado. Para confirmar que usted ha enviado el mensaje, solo presione el boton de Reply y envie éste mensaje (no es necesario editar el mensaje). Una vez realizado esto, no se necesitarán mas confirmaciones. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAÇÃO IMPORTANTE Esta é uma mensagem automática A mensagem que você enviou (em anexo) requer confirmação antes de ser entregue. Para confirmar o envio basta pressionar o botão de Reply e enviar esta mensagem de volta (não é necessário editar). Uma vez que isto seja feito, novas confirmações não serão necessárias. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- WICHTIGE INFORMATION Dies ist eine automatisch generierte Antwort. Ihre Mail (unten angehaengt) muss vor der Zustellung an mich explizit bestaetigt werden. Um dies zu tun, beantworten Sie einfach diese Mail mit der Antworten oder Reply-Funktion Ihres Mailprogramms. Es sind keine Aenderungen am Text noetig. Dies ist die einzige Bestaetigung die Sie je an mich senden muessen; Ihre weiteren Nachrichten werden automatisch akzeptiert. Diese Massnahme dient der Bekaempfung von Spam. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMATION IMPORTANTE Ceci est un message automatique. Le message que vous avez envoye (dessous) demande confirmation avant qu'il puisse etre envoye Pour confirmer que vous avez bien envoye le message ci-dessous, simplement appuyez sur la touche Reply, et renvoyez ce message (Vous n'avez pas besoin d'editer quoique ce soit). Une fois que ceci est fait, vous n'avez pas besoin d'autre confirmations. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAZIONE IMPORTATE! Questo è un messaggio automatico. Il messaggio che hai spedito (allegato sotto) richiede una conferma prima che sia consegnato. Per confermare che sei tu che hai spedito il messaggio, basta cliccare il tasto Reply e rispedirlo nuovamente (non hai bisogno di scrivere nessuna altra informazione aggiuntiva). Fatto questo, nessuna altra conferma è richiesta. --- Original Message Follows --- Date: Mon, 30 Sep 2002 21:19:45 +0200 From: [EMAIL PROTECTED] To: Chuck Payne [EMAIL PROTECTED] Subject: Re: RE: Urgent!! 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 one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: What I read last year what it change pages, but it cool to know. I will let my client know. -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:14 PM To: Chuck Payne Cc: William R. Mussatto; Insanely Great; Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! Chuck Payne wrote: There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. Chilisoft ASP runs ASP natively on Linux; there is a PHP2ASP project that does translation (and is free) but requires more user-intervention on the programmer's part. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock This email account is protected by: Active Spam Killer (ASK) V2.0.2 - (C) 2001-2002 by Marco Paganini For more information, visit http://www.paganini.net/ask - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Basic RPM Installation
Did you install from the SuSE CD? If so then you have to tell YaST to start MySQL. You can start it from /etc/rc.d/mysql. If you want to use PHP you will need to tell YaST to install PHP for apache as well. SuSE has made running MySQL and PHP so easy by using YaST. Also run YaST to update PHP there been an update on 7.3. If you need any more help. Let me know I have used SuSE since 5.3 and I am currently on 8.0. Chuck Payne On 9/27/02 7:27 PM, DeNewbie [EMAIL PROTECTED] wrote: I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to install these RPM files. MySQL-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm MySQL-devel-3.23.52-1.i386.rpm They all installed successfully; Then from /usr/local I ran mysql_install_db and I got this; cords-orj86jfje:/usr/local # mysql_install_db Installing all prepared tables 020927 18:06:15 /usr/sbin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd / ; /usr/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Now at this point what do I do ?? I put in my passwords successfully but when I entered the safe_mysqld I got this; mike@cords-orj86jfje:/usr/bin safe_mysqld [1] 1759 mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission denied rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied Please remove it manually and start /usr/bin/safe_mysqld again mysqld daemon not started What do I do from here ??? Thanks, DeNewbie - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting into two tables...
Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry to ask, I have looked around to see if there any on the net or in my mysql and php books but this seems like a weird task. Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Null to a value...
Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reindex a table.
Well I am glad for the help :). I am get an old table clean up but need to re-index my table. I think there is on small problem. It's is ISAM table and not myISAM. Chuck Payne Magi Design and Support Mysql and sql - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Have A problem
Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design and Support. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A programming question
Hi, I would like to know if there is a way that I can pass on an information from a pull down menu into a sql query. Right now I have to right a PHP page for each piece I am wanting to pass on. Example I have a movie database and now if I want to see what is in my Anime Category that starts with A I have to create a page like this: Select * FROM database WHERE category = 'anime' AND title like 'A%' I know I have to do an array? Would it be like this? $category $letter Select * FROM database WHERE category = '$category' and title is like '$letter' But it get to the sql statement is where I am lost. Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date_Format
Hi, This might be a strange question, but can you do date_format when you do a myrow? Or does date_format as always have to be done in a sql statement? Does anyone have an easy of doing dates? Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi Dates
Ok, I guess I have to re-state what I needing help with. I have a database with three date fields. If I do a date_format for all three fields I get error. Example SELECT DATE_FORMAT(DATE1, '%M %D, %Y) as DATE1, DATE_FORMAT(DATE2, '%M %D, %Y) as DATE2, DATE_FORMAT(DATE3, '%M %D, %Y) as DATE3, Groom, Bride FROM DB1; Now I am using this sql statement in a PHP page. I want to see if you can do sql statement in $myrow, but don't think you can. So I want to know if there is an easy way to do dates. Thanks if you can help or will answer. Chuck Payne Magi Design - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MAC OS X Server
You can go this link and get MySQL in package form it works great... http://www.entropy.ch/software/MacOSx/mysql Hope this helps. Chuck Payne Magi Design and Support http://www.magidesign.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is the server down?
Is the mysql mail list down? sql - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need last 100 records...
Use Limit is one way On 6/25/02 12:19 PM, Mark S Lowe [EMAIL PROTECTED] wrote: Is there a nifty way to select just that last 100 records with MySQL? In Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this out with MySQL. Please advise! Thank you! Mark - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with PHP, but I know it MySQL
A friend of my who is a programmer helped me only after I gave up on the
mailing answering me. So it is fix now. I had to the following...
// This is the actor query
$sql = SELECT concat_ws(\ \, fname, lname)as actor FROM actormovie WHERE
title = '$title';
$result = mysql_query($sql);
$actor = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= A HREF='' . $actor . /ABR\n;
}
where you set $actor = , it needs to be $actors, then the while loop
should look like this;
$actors = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actors .= A HREF='' . $actor . /ABR\n;
}
then when putting the info in the table, in the cast part you want to put
$actors and not $actor. What is happening is that $actor is being reset
every time you go through the loop.
Thanks anyway, but I felt no was going to help me, since no answer after a
day.
Chuck
On 6/15/02 10:42 PM, Zak Greant [EMAIL PROTECTED] wrote:
On Sat, 2002-06-15 at 05:31, Chuck Payne wrote:
...
// Some where here it's not working.
$sql = SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title' ORDER by lname;
$result = mysql_query($sql);
print $sql;
$actor = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= A HREF='' . $actor . /ABR\n;
}
What am I doing working.
Hi Chuck,
What happens if you run the query in the mysql command line client?
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter column without dropping
If you aren't good with sql commands you could try one of the many gui interfaces that are out that, I use phpMysqlAdmin and Kmysqladmin (KDE) they work really great at alter tables. Chuck Payne On 6/14/02 6:51 PM, Peak Digital Productions [EMAIL PROTECTED] wrote: Thank you - I'd already looked there but somehow overlooked it. TGIF. Paul From: William R. Mussatto [EMAIL PROTECTED] Date: Fri, 14 Jun 2002 15:28:19 -0700 (PDT) To: Peak Digital Productions [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: alter column without dropping On Fri, 14 Jun 2002, Peak Digital Productions wrote: Date: Fri, 14 Jun 2002 16:33:05 -0600 From: Peak Digital Productions [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: alter column without dropping The data going into one of my mySQL columns has suddenly changed, so I need to change the parameters of the column. Currently, it is varchar(32), I need to change it to varchar(128). See alter table command in the docs. Can I do that without dropping the column? Thanks, Paul Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date format
If you have mutli-date fields, can you set one date format in mysql sql statement for all fields? I have 9 date fields, that like to have the same format. Also I don't want it to work fields that have -00-, can I tell not to show those? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do you create a join table?
Hi, This may be a stupid question how do you create a database with join tables in mysql? Chuck Payne - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A design question
Hi, I have a design question for mysql database that I am wanting to create a my movies collection. I was going to do as one-to-one database, but I see now that I need to do as a one-to-many. I have never done a one-to-many but I see that is the way to go. I guess then is can someone show me where I can see one-to-many example, and how you do sql statements? To make it clear, I know that I have to do table for the movie, basic information. Then a table for actor/actress. I know I need a field in both tables that are the same so they are related. I am sorry if I don't make sense, but my head is spinning with trying to understand on one-to-many works. Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is the Mysql list down?
I am just checking to see if the mysql server is down I haven't gotten any e-mails today? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Turning off innodb
Yes have to turn it off in my.conf -Original Message- From: Scott Olson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:47 PM To: [EMAIL PROTECTED] Subject: Turning off innodb Is it possible to turn off Innodb in MySQL 4.0 via the my.cnf file? Or command line params or something? I would like to be able to do this to since the device that MySQL is running on does not have the space available for the minimal 10Mb Innodb file. I realize I can probably do this be recompiling the source and not specificying the --with-innodb option. On Linux, RedHat 7.2 with the following RPMS. MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 MySQL-client-4.0.1-2 - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another question of Date.
Hi, I got a small problem I like to be able to read a DATE but I don't want to read the Year. I only want to read the month and the date. For example, I like to read the a Birthday Field to see who Bithday is today. Also like to be later be able to read that same field but this time the year so that I can see how old a person is. Is there any example on the net of this? Chuck Sql and MySql - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
Hi,
I got a small problem I like to be able to read a DATE but I don't want to
read the Year. I only want to read the month and the date. For example, I
like to read the a Birthday Field to see who Bithday is today. Also like
to
be later be able to read that same field but this time the year so that I
can see how old a person is. Is there any example on the net of this?
Chuck
Sql and MySql
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\
OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname
But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT. I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.
Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
Hi,
I got a small problem I like to be able to read a DATE but I don't want
to
read the Year. I only want to read the month and the date. For example,
I
like to read the a Birthday Field to see who Bithday is today. Also
like
to
be later be able to read that same field but this time the year so that
I
can see how old a person is. Is there any example on the net of this?
Chuck
Sql and MySql
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Sorry that second 2002 should be year. I don't want to change year to get it
to work.
Chuck
on 4/11/02 8:10 AM, Chuck PUP Payne at [EMAIL PROTECTED] wrote:
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\
OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname
But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT. I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.
Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
- 'Saturday October 1997'
mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
- '22:23:00'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
Hi,
I got a small problem I like to be able to read a DATE but I don't want
to
read the Year. I only want to read the month and the date. For example,
I
like to read the a Birthday Field to see who Bithday is today. Also
like
to
be later be able to read that same field but this time the year so that
I
can see how old a person is. Is there any example on the net of this?
Chuck
Sql and MySql
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date and Mysql...
Hi again... When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Another problem I am having with another statement. The following statement should list birthdays that are 7 days out but it not... SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Any clue why my SQL statement worked once are now not working? Thanks a head of time. Chuck Payne Magi Design and Support - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no subject
Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: no subject
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see anything because it was showing everything but now I am cool. Again everyone thanks. Chuck Payne On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote: SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Question...
Thanks, My book that I have been studying from, only show commands and no examples. MySQL web had want I wanted at the very top. I have finish my page now. Chuck on 4/6/02 11:46 PM, Georg Richter at [EMAIL PROTECTED] wrote: On Sunday, 7. April 2002 05:56, Chuck \PUP\ Payne wrote: Hi, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use less than in my statement with NOW(), or if it will work. http://www.mysql.com/doc/D/a/Date_and_time_functions.html There is a sample how to use TO_DAYS function. Regards Georg - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Question...
Hello again, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use less than in my statement with NOW(), or if it will work. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why doesn't % work?
Hi, I have set up a user call FooBar and I have set up the host that FooBar can access from %, but everytime I go to a different machine I get an error that FooBar can't access mysql from that machine IP address. Why isn't the wildcard (%) working? I am using 3.23.44 with mysql-max. Any clues would be great. Thanks. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein sql - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wildcard and users...
Hi, I am wondering is there a way to set up user that can log in from anyplace? I know I need to set this user up with the %(I hope this is the wildcard for) mysql. Thanks, Chuck Payne - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to a remote database file using IP address
You don't need samba you can do it from a command line... ...mysql -u user -h hostname or ip -p Sorry for the ... Thast is not part of the command just outexpress like to make things captial where they shouldn't be. Chuck on 3/23/02 10:02 AM, Paul Gilbert at [EMAIL PROTECTED] wrote: Hi Egor ! My question should have been like this ? I am running Apache, MySql and PHP on a Linux server. What I want to do is to open a MySql database that reside on a Windows2000 computer. I don't want to use Samba for security reason. In other words, every thing run's on Linux but the database itself is on the other box wich I can access thru it's IP address. I am not sure to be clear enough Thanks Paul Gilbert - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please, show me!
If you are using KDE, there a great gui mysql program called kmysqladmin, that you can download and install and have running within second, it comes all versions of Sues and a great guy to work with. I know that on the website there is a tar ball and a Red Hat version. Use google.com to find it. Chuck Payne Magi Design and Support On 3/21/02 10:44 AM, Victoria Reznichenko [EMAIL PROTECTED] wrote: Nguyen, Thursday, March 21, 2002, 5:53:08 AM, you wrote: NHN I am using Linux Red Hat 7.2 and I want to execute NHN mysqlgui. After I start this program, have a error is: NHN Can't connect to local mysql server through socket. NHN Please, show me a way to solve this problem. After starting MySQLGUI fill up the entries in Options dialog box and save them. How to fill entries read in the README file. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date and SQL statement
I need to do a search where I am looking at the table that has dates and I need to look only things that are 30 days or younger. Can so one show me a some SQL statements where you use , ? And the key for equal to or less? Chuck Payne Magi Design - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ID order...
Ok, strange question. I have delete some records and I have notice that ID's are no longer in order when I do a SQL statement. Why is that? What can I do put the records back into order? | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ID order...
Maybe. Just I have delete let say ID 63, 64 and when I added 74,75. They are place into the slot where 63, 64 were. So I read this in the ID list 61,62, 74, 75, 66, 67... I am trying to understand why it's placing 74 and 75 in the slots that were deleted. Is there a re-index command that will place them into the right order. Chuck on 3/19/02 1:00 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote: Yes it is a strange question.. MySQL result sets are in the order you asked in the query. IF you would like the result set to be in order by a field called ID then just add order by ID at the end of your query.. Is this what you were asking? If not , can you give more insights of what the query was returning before the deletion, and what it is returning now and what you'd like it to return? Thanks, Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 12:23 AM To: mysql lists.mysql.com Subject: ID order... Ok, strange question. I have delete some records and I have notice that ID's are no longer in order when I do a SQL statement. Why is that? What can I do put the records back into order? | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ID order...
Ok, here is a copy of my database and you will see what I am talking about... | 55 | j| programming | http://webdeveloper.earthweb.com/pagedev/webjs | Javascripts.com| | 56 | h| webdesign | http://www.htmlgoodies.com | HTML Goodies | | 57 | l| linux | http://lwn.net | Linux Weekly News | | 58 | l| linux | http://www.linuxstart.com | Linux Start| | 74 | b| beos| http://www.beosonline.com/index.php?seite=english | BeOS Online German Site | | 75 | b| beos| http://www.blueos.free.fr | BlueOS | | 62 | s| graphics| http://www.steeldolphin.com | Steel Dolphin Creative | | 63 | w| graphics| http://www.wacom.com/tips | Wacom Photoshop Tips...| | 64 | d| graphics| http://www.dvpa.org | Digital Video Prof. Assoc. | | 73 | o| beos| http://open-beos.sourceforge.net | Open BeOS | | 66 | p| graphics| http://www.photoshopcertification.com | NAPP's Practice Certification Exam | | 67 | d| graphics| http://deezin.com/ | The Graphic Design Resource Center | | 68 | p| graphics| http://www.photoshopseminars.com | Adobe Photoshop Seminar Tour...| | 69 | p| graphics| http://www.photoshopcafe.com | Photoshop Cafe | I deleted 59, 60, 61, 65. MySQL place 74 into 59 slot, 75 into 60, and 73 into 65. The SQL state I did was Select * from table_name; Just a simple command. So again why is it filling the deleted slot? Chuck on 3/19/02 1:00 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote: Yes it is a strange question.. MySQL result sets are in the order you asked in the query. IF you would like the result set to be in order by a field called ID then just add order by ID at the end of your query.. Is this what you were asking? If not , can you give more insights of what the query was returning before the deletion, and what it is returning now and what you'd like it to return? Thanks, Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 12:23 AM To: mysql lists.mysql.com Subject: ID order... Ok, strange question. I have delete some records and I have notice that ID's are no longer in order when I do a SQL statement. Why is that? What can I do put the records back into order? | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ID order...
Ok, but that still doesn't any why MySQL is filling the delete slot, I understand that I can do any SQL statement to put into the order I want. I guess what I am trying to wonder how it place a record into the table, does MySQL see that the slot is empty and then fills it with a new record? Chuck on 3/19/02 1:20 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote: Hi, Just add order by ID in your query it will give you the results in the way you'd like... Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:17 AM To: Gurhan Ozen; mysql lists.mysql.com Subject: Re: ID order... Ok, here is a copy of my database and you will see what I am talking about... | 55 | j| programming | http://webdeveloper.earthweb.com/pagedev/webjs | Javascripts.com| | 56 | h| webdesign | http://www.htmlgoodies.com | HTML Goodies | | 57 | l| linux | http://lwn.net | Linux Weekly News | | 58 | l| linux | http://www.linuxstart.com | Linux Start| | 74 | b| beos| http://www.beosonline.com/index.php?seite=english | BeOS Online German Site | | 75 | b| beos| http://www.blueos.free.fr | BlueOS | | 62 | s| graphics| http://www.steeldolphin.com | Steel Dolphin Creative | | 63 | w| graphics| http://www.wacom.com/tips | Wacom Photoshop Tips...| | 64 | d| graphics| http://www.dvpa.org | Digital Video Prof. Assoc. | | 73 | o| beos| http://open-beos.sourceforge.net | Open BeOS | | 66 | p| graphics| http://www.photoshopcertification.com | NAPP's Practice Certification Exam | | 67 | d| graphics| http://deezin.com/ | The Graphic Design Resource Center | | 68 | p| graphics| http://www.photoshopseminars.com | Adobe Photoshop Seminar Tour...| | 69 | p| graphics| http://www.photoshopcafe.com | Photoshop Cafe | I deleted 59, 60, 61, 65. MySQL place 74 into 59 slot, 75 into 60, and 73 into 65. The SQL state I did was Select * from table_name; Just a simple command. So again why is it filling the deleted slot? Chuck on 3/19/02 1:00 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote: Yes it is a strange question.. MySQL result sets are in the order you asked in the query. IF you would like the result set to be in order by a field called ID then just add order by ID at the end of your query.. Is this what you were asking? If not , can you give more insights of what the query was returning before the deletion, and what it is returning now and what you'd like it to return? Thanks, Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 12:23 AM To: mysql lists.mysql.com Subject: ID order... Ok, strange question. I have delete some records and I have notice that ID's are no longer in order when I do a SQL statement. Why is that? What can I do put the records back into order? | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
Ok, if never run it then you have to start once, if I remember right undex Red Hat, you have to go to /etc/rc.d/init.d and do this... ./mysql start that will start it Then you will need to set it up so it will start later. SuSE you have to start it once You will then need to set a password for mysql. I hope that helps. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Fortune for today -- Q: How many Zen masters does it take to screw in a light bulb? A: None. The Universe spins the bulb, and the Zen master stays out of the way. If mysql.sock doesn't exist, that is because the server is not running. I fought the same battle as Mark and ultimately downloaded and installed the RPM for 3.23.49a from MySQL in place of the copy that came with RH. The MySQL RPM installed and came up just like it says in the book. Saves a lot of hair and dain bramage. If the server process _is_ running, it may be useful to go through the section on binary installation and check those items to see if your RPM set everything up correctly. Don't bet on finding anything, but it doesn't take long to do these checks. http://www.mysql.com/doc/I/n/Installing_binary.html Regards, Doug Perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. -- Antoine de Saint Exup?ry On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: What I did was beat my brains out on the same exact problem. In the end I have no clue what I did to get it actually working. I had re-installed the mysql from the .tar.gz, I installed all the RPM's several times. Everytime, I fully rebooted the system, and finally I have to run safe_mysqld --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! Hi all, I got this error message when trying to connect to mysql at the shell command: Error 2002:Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock There is no mysql.sock in the /var/lib/mysql directory. Did I miss some thing in the mysql installation? Where could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help
Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.
Chuck Payne
Magi Design and Support
on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:
Thanks for the help. I got it working. I could connect to mysql from shell
command. Now I try to connect to mysql using perl. I installed the DBI::DBD
module for perl. I think the DBI::DBD also working since I don't see error
return running the following code:
#!/usr/bin/perl
use DBI;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql installation. Help!
Date: Sun, 10 Mar 2002 14:18:13 -0500
Ok, if never run it then you have to start once, if I remember right undex
Red Hat, you have to go to /etc/rc.d/init.d and do this...
./mysql start that will start it
Then you will need to set it up so it will start later. SuSE you have to
start it once
You will then need to set a password for mysql.
I hope that helps.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.
Fortune for today --
Q: How many Zen masters does it take to screw in a light bulb?
A: None. The Universe spins the bulb, and the Zen master stays out
of the way.
If mysql.sock doesn't exist, that is because the server is not running.
I fought the same battle as Mark and ultimately downloaded and installed
the
RPM for 3.23.49a from MySQL in place of
the copy that came with RH. The MySQL RPM installed and came up just
like it
says in the book. Saves a lot of hair
and dain bramage.
If the server process _is_ running, it may be useful to go through the
section
on binary installation and check those
items to see if your RPM set everything up correctly. Don't bet on
finding
anything, but it doesn't take long to do
these checks.
http://www.mysql.com/doc/I/n/Installing_binary.html
Regards,
Doug
Perfection is finally attained not when there is no longer anything to
add,
but when there is no longer anything to
take away. -- Antoine de Saint Exup?ry
On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
What I did was beat my brains out on the same exact problem. In the
end I
have no clue what I did to get it actually working. I had re-installed
the
mysql from the .tar.gz, I installed all the RPM's several times.
Everytime,
I fully rebooted the system, and finally I have to run
safe_mysqld --user=root
I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.
Mark
- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!
Hi all,
I got this error message when trying to connect to mysql at the shell
command:
Error 2002:Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock
There is no mysql.sock in the /var/lib/mysql directory. Did I miss
some
thing in the mysql installation? Where could I find the mysql.sock?
I
install mysql that came with redhat 7.2. Thank for the help.
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com
A stupid question...
Hi, I not a newie but I am not a pro at mysql either. I want to do a query by letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP. So can someone please so me the how. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Hartley's Second Law: Never sleep with anyone crazier than yourself. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
I want to sort my a letter in a set colomn. Let say I want to sort the colomn last_name http://www.myserver.com/mysort.php?Letter=A Like to create a link like A then sort only the last name ore what ever I want to sort by that letter. I hope that's helps. I can order by, but I can't so a sort like the example above. Chuck Payne Magi Design and Support on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote: At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote: Hi, I not a newie but I am not a pro at mysql either. I want to do a query by letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP. So can someone please so me the how. I'm not totally sure what your looking for. If you could elaborate a little I am sure that one of us could help you out. Cary - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
I want to sort by a letter in a colomn. Let say I want to sort the colomn last_name. I can do order by but I can do just the A's. http://www.myserver.com/mysort.php?Letter=A Like to create a link on a web A then sort only the last name are A. I hope that's helps. I can order by, but I can't so a sort like the example above. Chuck Payne Magi Design and Support on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote: At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote: Hi, I not a newie but I am not a pro at mysql either. I want to do a query by letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP. So can someone please so me the how. I'm not totally sure what your looking for. If you could elaborate a little I am sure that one of us could help you out. Cary - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql error .
You can't log as root because a password has been set. You need to log like this root@yourbox# mysql -u root -p It will then ask you for a password If you ever have to log onto another box use a -h hostname. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein on 3/9/02 12:58 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Can someone help and tell how can i fix this error . Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) Thanks . Carlos Arnt . -- Use o melhor sistema de busca da Internet Radar UOL - http://www.radaruol.com.br - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Mysql] Sorry for the reply.
You know I had wrote but my message was kick by mysql mail list server for spamming, I didn't mean too and I am sorry to everyone on the list. I was trying to express my thought on an e-mail. Again sorry for spamming, all I did was hit reply to all to the Blue World Announces Lasso vs PHP White Paper e-mail. Chuck PUP Payne Sr. System Administrator GDI Engineering, Inc. 2075-E West Park Place Blvd. Stone Mountain, GA 30087 - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deleting a Record
Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Deleting a Record
Thanks I have now five ways to try. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:43 AM To: Chuck PUP Payne; [EMAIL PROTECTED] Cc: PHP General Subject: Re: Deleting a Record At 7:46 -0500 3/6/02, Chuck \PUP\ Payne wrote: Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. Connect the conditions with AND: DELETE FROM tbl_name WHERE col1 = 'value1' AND col2 = 'value2' | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
