a question...
Guys, I have been fighting with mysql trying to get it to only show every after the last dot(.) on a ip. for example instead geting 10.0.0.0 only get 10.0.0 But what every I try doesn't work. Can someone pls point to a web page where I can learn how to do it, of explain it here. Thanks. Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a question...
Yes, sorry. I have a database that records ip of attacks on a customer server, what I like to do get a count so that I can see what subnet is doing the major of the attacks. select ip from ipslimit 10; +-+---+ | ip | count(ip) | +-+---+ | 83.117.196.206 | 1 | | 85.17.109.28| 1 | | 125.138.96.19 | 1 | | 89.110.148.253 | 1 | | 192.168.105.10 | 1 | | 200.170.124.72 | 1 | | 201.116.98.214 | 1 | | 202.168.255.226 | 1 | | 203.89.243.158 | 1 | | 210.245.207.217 | 1 | +-+---+ 10 rows in set (0.00 sec) On Wed, Jul 23, 2008 at 11:45 AM, [EMAIL PROTECTED] wrote: Guys, I have been fighting with mysql trying to get it to only show every after the last dot(.) on a ip. for example instead geting 10.0.0.0 only get 10.0.0 As pulled from a database row? Sorry, I didn't quite understand your email. -- /Daniel P. Brown Better prices on dedicated servers: Intel 2.4GHz/60GB/512MB/2TB $49.99/mo. Intel 3.06GHz/80GB/1GB/2TB $59.99/mo. Dedicated servers, VPS, and hosting from $2.50/mo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a question..
Thanks Glyn, What you have given me works. I have taken it so now I get anything greater that one select substring_index(ip,'.',3), count(*) from ips group by 1 having count(*) 1 order by 2 desc limit 10; +---+--+ | substring_index(ip,'.',3) | count(*) | +---+--+ | 216.235.158 | 3 | | 218.1.65| 2 | | 202.222.30 | 2 | | 66.232.140 | 2 | | 203.172.244 | 2 | | 61.146.178 | 2 | | 66.221.68 | 2 | | 200.62.177 | 2 | | 89.41.196 | 2 | | 193.221.125 | 2 | +---+--+ 10 rows in set (0.01 sec) Again, thanks everyone... I think you're after the SUBSTRING_INDEX(str,delim,count) function, so (I've not tried this): select substring_index(ip,'.',3) from ipslimit 10; --- On Wed, 23/7/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: a question... To: Daniel Brown [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], mysql@lists.mysql.com Date: Wednesday, 23 July, 2008, 5:10 PM Yes, sorry. I have a database that records ip of attacks on a customer server, what I like to do get a count so that I can see what subnet is doing the major of the attacks. select ip from ipslimit 10; +-+---+ | ip | count(ip) | +-+---+ | 83.117.196.206 | 1 | | 85.17.109.28| 1 | | 125.138.96.19 | 1 | | 89.110.148.253 | 1 | | 192.168.105.10 | 1 | | 200.170.124.72 | 1 | | 201.116.98.214 | 1 | | 202.168.255.226 | 1 | | 203.89.243.158 | 1 | | 210.245.207.217 | 1 | +-+---+ 10 rows in set (0.00 sec) On Wed, Jul 23, 2008 at 11:45 AM, [EMAIL PROTECTED] wrote: Guys, I have been fighting with mysql trying to get it to only show every after the last dot(.) on a ip. for example instead geting 10.0.0.0 only get 10.0.0 As pulled from a database row? Sorry, I didn't quite understand your email. -- /Daniel P. Brown Better prices on dedicated servers: Intel 2.4GHz/60GB/512MB/2TB $49.99/mo. Intel 3.06GHz/80GB/1GB/2TB $59.99/mo. Dedicated servers, VPS, and hosting from $2.50/mo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamcheck
Hi, I am currently using SuSE and like to be able use myisamcheck when start up mysql. Is there a command that I can added to my init.d script that would do that. Thanks, Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
schem help...
Hi, I need some help. I got a 161 tables that I am trying to create schem on, the problem is I can get any of my boxes to show you know +---+ | | +---+ Here is the command I am doing my -Ae show tables; | while read a ; do my -Ae desc $a; echo myfile.txt ; done what I get the desc with out the boxes. Can someone help me? I need the box because I am going to cut these tables out so I can map out the relatation to them. Thanks, Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to repair a table,
hi, I got a table where the myi isn't able to re be read. I tried to run myisam but it give an error about the index. Do I need to drop the table? Can it be repaired? Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Output to a file
Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy `/tmp/my_toys` But I get an error. Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld vs. mysql-max
Hey, I got a box that is dying, it is currently running MySQL-Max, I want to move the DB from it to a box that is running just plain jane MySQL, what will happen and will it work. I know, strange but I am not sure what the Max does. Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Formatting Date to make counts easy.
Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format. Here the sql statement I am doing now. select count(*), date from my_db group by date; Thanks, for any help you can give me. Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Formatting Date to make counts easy.
Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting. Payne Sameer wrote: Payne wrote: Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format. Here the sql statement I am doing now. select count(*), date from my_db group by date; Thanks, for any help you can give me. Payne select count(*), DATE_FORMAT(some_date, '%Y-%m-%d') from some_table group by DATE_FORMAT(some_date, '%Y-%m-%d'); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Special Character translation with export help needed
Is this the wrong list to ask this on? If so can someone suggest a better list? Am I missing something in my analysis of my problem? Did I not include enough info? Could it be a problem with perl scripts? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 8, 2005, at 3:24 AM, Boysenberry Payne wrote: I tried using `mysqldump $log -v -Q -c --set-charset --default-character-set=utf8 --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick $db_name -r $bk_file 21` and I still get -- MySQL dump 10.9 -- -- Host: localhostDatabase: -- -- -- Server version 4.1.14-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `access` -- DROP TABLE IF EXISTS `access`; CREATE TABLE `access` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I need it to output to utf8 as I've said in my previous post. How come --default-character-set=utf8 didn't change it? Internally it's stored as utf8 and I've read mysqldump outputs to utf8 as default. Yet I'm seeing latin1. What gives? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 7, 2005, at 9:33 PM, Boysenberry Payne wrote: I think the problem is mysqldump uses this: DEFAULT CHARSET=latin1 with --set-charset How can I get it to use utf8? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote: I'm having difficulty getting certain special characters to stay the same when I export databases. Here are some of the examples: View of data from phpMyAdmin: Habitat is a “what you see is what you getâ€? or “WYSIWYGâ€? View from table dump via phpMyAdmin export: Habitat is a √¢‚Ǩ≈ìwhat you see is what you get√¢‚Ǩ? or √¢‚Ǩ≈ìWYSIWYG√¢‚Ǩ? View from table dump via mysqldump: Habitat is a √ɬ¢√¢‚Äö¬¨√Ö‚Äúwhat you see is what you get√ɬ¢√¢‚Äö¬¨? or √ɬ¢√¢‚Äö¬¨√Ö‚ÄúWYSIWYG√ɬ¢√¢‚Äö¬¨? The view of the data via phpMyAdmin seems to be the closest to what I need. The special characters are created by flash then saved in the mysql ( 4.1.13 ) database. Now I'm moving them to a different mysql ( 4.1.14 ) database. Is there a better way to swap databases that will prevent the special characters from being translated? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Special Character translation with export help needed
I figured out that it wasn't really the special characters that were the issue, but the addslashes function in php with the html tags. I just got rid of the back slashes and all is good. Sorry for the noise... Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 8, 2005, at 4:57 PM, Boysenberry Payne wrote: Is this the wrong list to ask this on? If so can someone suggest a better list? Am I missing something in my analysis of my problem? Did I not include enough info? Could it be a problem with perl scripts? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 8, 2005, at 3:24 AM, Boysenberry Payne wrote: I tried using `mysqldump $log -v -Q -c --set-charset --default-character-set=utf8 --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick $db_name -r $bk_file 21` and I still get -- MySQL dump 10.9 -- -- Host: localhostDatabase: -- -- -- Server version 4.1.14-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `access` -- DROP TABLE IF EXISTS `access`; CREATE TABLE `access` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I need it to output to utf8 as I've said in my previous post. How come --default-character-set=utf8 didn't change it? Internally it's stored as utf8 and I've read mysqldump outputs to utf8 as default. Yet I'm seeing latin1. What gives? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 7, 2005, at 9:33 PM, Boysenberry Payne wrote: I think the problem is mysqldump uses this: DEFAULT CHARSET=latin1 with --set-charset How can I get it to use utf8? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote: I'm having difficulty getting certain special characters to stay the same when I export databases. Here are some of the examples: View of data from phpMyAdmin: Habitat is a “what you see is what you getâ€? or “WYSIWYGâ€? View from table dump via phpMyAdmin export: Habitat is a √¢‚Ǩ≈ìwhat you see is what you get√¢‚Ǩ? or √¢‚Ǩ≈ìWYSIWYG√¢‚Ǩ? View from table dump via mysqldump: Habitat is a √ɬ¢√¢‚Äö¬¨√Ö‚Äúwhat you see is what you get√ɬ¢√¢‚Äö¬¨? or √ɬ¢√¢‚Äö¬¨√Ö‚ÄúWYSIWYG√ɬ¢√¢‚Äö¬¨? The view of the data via phpMyAdmin seems to be the closest to what I need. The special characters are created by flash then saved in the mysql ( 4.1.13 ) database. Now I'm moving them to a different mysql ( 4.1.14 ) database. Is there a better way to swap databases that will prevent the special characters from being translated? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Special Character translation with export help needed
I'm having difficulty getting certain special characters to stay the same when I export databases. Here are some of the examples: View of data from phpMyAdmin: Habitat is a “what you see is what you getâ€? or “WYSIWYGâ€? View from table dump via phpMyAdmin export: Habitat is a √¢‚Ǩ≈ìwhat you see is what you get√¢‚Ǩ? or √¢‚Ǩ≈ìWYSIWYG√¢‚Ǩ? View from table dump via mysqldump: Habitat is a √ɬ¢√¢‚Äö¬¨√Ö‚Äúwhat you see is what you get√ɬ¢√¢‚Äö¬¨? or √ɬ¢√¢‚Äö¬¨√Ö‚ÄúWYSIWYG√ɬ¢√¢‚Äö¬¨? The view of the data via phpMyAdmin seems to be the closest to what I need. The special characters are created by flash then saved in the mysql ( 4.1.13 ) database. Now I'm moving them to a different mysql ( 4.1.14 ) database. Is there a better way to swap databases that will prevent the special characters from being translated? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Special Character translation with export help needed
I think the problem is mysqldump uses this: DEFAULT CHARSET=latin1 with --set-charset How can I get it to use utf8? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote: I'm having difficulty getting certain special characters to stay the same when I export databases. Here are some of the examples: View of data from phpMyAdmin: Habitat is a “what you see is what you getâ€? or “WYSIWYGâ€? View from table dump via phpMyAdmin export: Habitat is a √¢‚Ǩ≈ìwhat you see is what you get√¢‚Ǩ? or √¢‚Ǩ≈ìWYSIWYG√¢‚Ǩ? View from table dump via mysqldump: Habitat is a √ɬ¢√¢‚Äö¬¨√Ö‚Äúwhat you see is what you get√ɬ¢√¢‚Äö¬¨? or √ɬ¢√¢‚Äö¬¨√Ö‚ÄúWYSIWYG√ɬ¢√¢‚Äö¬¨? The view of the data via phpMyAdmin seems to be the closest to what I need. The special characters are created by flash then saved in the mysql ( 4.1.13 ) database. Now I'm moving them to a different mysql ( 4.1.14 ) database. Is there a better way to swap databases that will prevent the special characters from being translated? Thanks, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RAND ()
Hi, I have been playing around with RAND(). It works very well if I do a sql statement with mysql, but I having problem using with mysql statement with php. When a person calls on the page, the same output is always view. How can I get RAND() work with php. sorry for the php, stuff. Thanks for any help you can give. Payne ? $db = mysql_connect(127.0.0.0,fred,mrbill); mysql_select_db(links,$db); $result = mysql_query(SELECT url FROM sponsors order by rand() LIMIT 1, $db); if ($myrow = mysql_fetch_array($result)) { echotable width='500' border='0' cellspacing='0' cellpadding='0'; do { printf(trtd%s/td/tr\n,$myrow[url]); } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no message of day today; } echo /table ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql 5.0
Has 4.0 Been offical release, I thought it was still in Beta? -Original Message- From: Josh Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: Re: MySql 5.0 When can we expect a release of 5.0 with stored procedure functionality in MySQL? Sincerely, Joshua Wilson Software Engineer SOSystems Corporation [EMAIL PROTECTED] 801-222-0200 'Whoever controls your thoughts, controls your actions.' - 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
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
Get the total of a feild
Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. 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
Please confirm (conf#3609bdcf19fdd5aadddc58b8665f2e25)
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: Tue, 1 Oct 2002 23:38:34 +0200 From: [EMAIL PROTECTED] To: Chuck Payne [EMAIL PROTECTED] Subject: Re: How many days out... 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: Hi, I am having problems get how many days out an invoice is. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support 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
How many days out...
Hi, I am having problems get how many days out an invoice is from mysql. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql, 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
How to get the number of days an invoice was submitted.
Hi, I am having problems get how many days out an invoice is. I have try this sql statement. SELECT NOW()-submmitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was submmitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql,query - 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: Urgent!!
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. But hey that my 2 Cents. Chuck Payne Magi -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:29 PM To: Insanely Great Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 - 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 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
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: FileMaker Pro Schema Export?
Question are you want to take your data from Filemaker to Excel? Because what I had to do was re-create the tables in MySQL then out putting the data to cvs table. Making sure the data was divide by a command, then I use mysqladmin or you can use phpMyAdmin import it into you MySQL. If that what you are doing. I might be able to help a little. Chuck Payne Magi Design and Support Account Protect by ASK! -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 2:52 PM To: Jan Steinman Cc: [EMAIL PROTECTED] Subject: Re: FileMaker Pro Schema Export? I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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: 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
Insert into multi-tables
Hi, I have a question. I have two tables that I want to post data too. Is there a way to do a sql statement that lets me post data two tables at the same time? 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
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
RE: Goodday
'mysql' there need to be a better filter. Yes, We get this letter 20 times a weeks. I will forward this on to the FBI to add to their list. -Original Message- From: Clive Smart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:55 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Goodday How did this get past the filters? Ocita Gabriel wrote: Attn: mysql , My name is Ocita G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since the demise of this our customer, I personally has watched with keen interest to see the next of kin but all has proved abortive as no one has come to claim his funds of usd.20.5 m, [twenty million five hundred thousand united states dollars] which has been with my branch for a very long time. On this note, I decided to seek for whom his name shall be used as the next of kin as no one has come up to be the next of kin. And the banking ethics here does not allow such money to stay more than Six years, because money will be recalled to the bank treasury as unclaimed after this period. In view of this I got your contact through a trade journal after realizing that your name and country is similar to the deceased. I will give you 25% of the total. Upon the receipt of your response, I will send you by fax or e-mail the application, bank's fax number and the next step to take. I will not fail to bring to your notice that this business is hitch free and that you should not entertain any fear as all modalities for fund transfer can be finalized within five banking days, after you apply to the bank as a relation to the deceased. When you receive this letter. Kindly send me an e-mail signifying Your decision including your private Tel/Fax numbers for quick communication. Respectfully submitted, Ocita G. - 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 . -- | _ __ ___ | | | |/ / ___/ __ \/ ___| Clive W. Smart | | | | / / /__/ /_/ / / R D Director | | | |/|/ / ___/ __ |\_ \WEBServ a div. | | | / /__/ /_/ /__/ /of Melange Hold | | |_/|_//_//ERV [EMAIL PROTECTED] | || | Tel: +27 11 372-9800 Fax: +27 11 372-9801 | || - 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
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: Data Entry for a Newbie
I would buy a book called PHP Essentials. www.thickbook.com I used it to learn how to write an html/php interface to my databases and i use it all the time now. It takes a bit of work to get the interfaces built but the book is really easy to follow and understand. seth -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 9:13 AM To: Mysql Subject: Data Entry for a Newbie At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - 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: 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
RE: AW: mysql wont start on SUSE
In SuSE you should be able to start the MySQL server by: rcmysql start or rcmysql restart rcmysql is a symlink to the /etc/init.d directory -Original Message- From: John Macloy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 2:26 AM To: [EMAIL PROTECTED] Subject: AW: AW: mysql wont start on SUSE I noticed that my Server works with [mysql] user = root and than start with mysqld but when I tried to start with the runlevel editor it doesn't works. Perhaps a other Person in this list no the answer? The mysql_install_db create two folders in the var/lib/mysql pfad. The folder are mysql and test. In mysql are the table definitions for passwords etc. If I solve the problem I will write you an Email John -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 18:54 An: John Macloy Betreff: Re: AW: mysql wont start on SUSE Thanks John I've added that line, but no luck. Yes, I've done the mysql_install_db, which worked OK. I am baffled. Stupid question: mysql_install_db is run only once to set up default DBs??? Jacques John Macloy wrote: Yes, I have go to my.cnf and write [mysqld] user=root then start the server with mysqld. This works on my computer, but I'm not sure if the right way cause the the server shouldn't use with the user root but for a test it's ok. Have you already started the script mysql_install_db? It's necessary. Macloy -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 15:28 An: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.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 - 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 -- ___ Dr Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.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 - 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 wont start on SUSE
Have you went into YaST and turn it on? I won't run until you do so. You can start it yourself as well; /etc/rc.d/mysql start Chuck Payne On Monday, July 1, 2002, at 09:47 AM, Cal Evans wrote: What's your log file say? * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Jacques Steyn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:28 AM To: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.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 mysql-unsubscribe- [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 mysql-unsubscribe- [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 wont start on SUSE
SuSE 8 and for that matter all version of SuSE MySQl doesn't run until you use YaST to turn it. That why it's not starting. You can start it your by the following command; /etc/rc.d/mysql start If there is no problem with mysql you should see this mysqld done By going into YaST2/YaST and telling it to start mysql it will start it from boot up. For more help with SuSE and start up daemons feel free to write me ok. This isn't really mysql fault, it the way SuSE control things. Chuck Payne Magi Design and Support SuSE user from the past 5 years. On Monday, July 1, 2002, at 10:34 AM, Egor Egorov wrote: Jacques, Monday, July 01, 2002, 4:28:25 PM, you wrote: JS Anybody had a problem with MySQL that does not start on SUSE 8 with default JS installation? JS If yes, what was the problem? What do you mean does not start? If you get any error please provide more info. Check also you host_name.err file in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 mysql-unsubscribe- [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
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
Problem with PHP, but I know it MySQL
Hi, I am working on a movie database I have two database that I am calling from but the problem I am having when I ask it to go and fetch all the movies with the same title, it stops and only shows one. Here is a basic layout... if($videoid) { $result = mysql_query(SELECT * FROM library WHERE videoid=$videoid,$db); $myrow = mysql_fetch_array($result); // The Myrows $title = $myrow[title]; $videoid = $myrow[videoid]; $catergory = $myrow[catergory]; $appraisal = $myrow[appraisal]; // 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. 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
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
RE: DBD::MySQL Help!!
I had the same problem too. If you go to CPAN and then go to DBD::Mysql, click on the ftp site to Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one instead, it should work. Worked like a charm for me - on RedHat. Megan Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed -- - - t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module
Re: mm.mysql.jdbc-1.2c and applets
Signing the applet will allow the applet to make the connection. The user of the applet will have to accept and install the certificate use to sign the applet. - Original Message - From: "Carfield Yim" [EMAIL PROTECTED] To: "Paulo Mora de Freitas" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 8:35 AM Subject: Re: mm.mysql.jdbc-1.2c and applets Applet don't allow bulid new socket connection, which will do when you make a connection from applet to database. The solution is writing a servlet to let applet call it. On Wed, 17 Jan 2001, Paulo Mora de Freitas wrote: Dear All, Could someone help me to access my mysql database from an applet with mm.mysql.jdbc-1.2c? The problem is that when trying to access a mysql database from an applet using Netscape it get an AppletSecurityException (described at end of this message). But the mm.mysql.jdbc-1.2c documentation says that "it allows Java developers to make connections to MySQL servers from both Java applications and applets", so I don't understand what is wrong. The same piece of code works nice if running as an application. Cheers, Paulo Mora de Freitas. Nestacape error message: netscape.security.AppletSecurityException: security.Couldn't connect to 'aldebaran.in2p3.fr' with origin from 'local-classpath-classes'. at netscape.security.AppletSecurity.checkConnect(AppletSecurity.java:776) at java.lang.SecurityManager.checkConnect(SecurityManager.java:718) at java.net.InetAddress.getAllByName0(InetAddress.java:457) at java.net.InetAddress.getByName(InetAddress.java:367) at java.net.Socket.init(Socket.java:123) * at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.init(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:90) at java.sql.DriverManager.getConnection(DriverManager.java:146) at SimpleApplet.paint(SimpleApplet.java:50) at java.awt.Component.dispatchEventImpl(Component.java:1734) at java.awt.Container.dispatchEventImpl(Container.java:946) at java.awt.Component.dispatchEvent(Component.java:1715) at java.awt.EventDispatchThread$EventPump.dispatchEvents(EventDispatchThread.ja va:83) at java.awt.EventDispatchThread.run(EventDispatchThread.java:135) at netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(DerivedAppl etFrame.java:911) SQLException: Cannot connect to MySQL server on aldebaran.in2p3.fr:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (netscape.security.AppletSecurityException) SQLState: 08S01 VendorError: 0 - 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