Can't open...
Dear all, what is the meaning of Can't open file: 'products_description.MYI'. (errno: 145) in mysql? Regards, _DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Password
Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Last record
Dear all, How do I select the very last record in a column in MySQL database? Regards, DT - 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
Last record
Dear all, How do I select the very last record in a column in MySQL database? Regards, DT - 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
CDSISIS
Hello ! Is there anyway to convert CDS-ISIS data into MySQL? Looking forward to hearing from you. Regards, DT - 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
RedHat DB?!
Greetings ! What is RedHat Database? Is anybody using it? How is it? Better than MySQL? Looking forward to hearing from you. Regards, DT - 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 call to mysql
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 13:09 Subject: php call to mysql Modify your code as given below and see. It should work. DT I know this isn't a PHP mailing list, but maybe someone out there can help. This is my first mysql/php project, and I can't seem to get this call to mysql to work. I have other queries working, but it seems as though any time I try to make a call to one of my auto_increment IDs, either PHP or MySQL doesn't like the way I am querying it. Below is he part of the PHP script that is supposed to call the fields from my Cat table in my database. I am sure there are no problems with authentication to get the table or problems with which table it is selecting. ?php $result = mysql_query(select * from $table2); if ($result){ while ($row = mysql_fetch_array($result)) { $CatID=$row[Cat_ID]; $CatName=$row[CatName]; and so on. assuming your fields are CatName. print Cat ID: $row[\Cat_ID\]; print Cat Name: $row[\CatName\]; print Cat Description: $row[\CatDescribe\]; print BDelete?/b; print input type=checkbox name=\Cat_ID[]\ value=\\.$row[Cat_ID].\\ Yes, delete entry #.$row[\Cat_ID\].\; print BRBR\n\n; } mysql_free_result($result); } ? I also tried the above code, but I escaped out the underscores. Thanks a lot for your help. Sorry for the indirect mysql question. (PHP question) -Christian Evans - 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
Table query....
Greetings ! I have following tables in MySQL: TableItem idlist 1 Banana 2 Orange 3 Mango Other tables are: Banana, Orange, Mango Instead of selecting Table Banana directly I need to select it as select $TableItem.list where id=1 or something like that for editing or deleting items in Table Banana . I tried to do like this but doesn't work. Does it work somehow? Looking forward to hearing from you. Warm Regards, DT - 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 Query .......
Greetings! I have two talbes in MySQL, Table1 and Table2. Table1 iditem 1 apple 2 banana 3 orange Table2 iditem 1 shoes 2 suit 3 mango If I want to add a row/column from Table1 to Table2, is it possible? May be something like: insert into Table1 (item) values ((Table2.item) where Table2.id=3); Looking forward to hearing from you all. Warm Regards, DT - 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
AUTO INCREMENT Q U E S T I O N in MySQL
Greetings ! Suppose I have a table in MySQL Database: idName - 1 ABC 2 BBB 3 CAB like this id being auto_increment. If I delete all the three records and start with new then it starts from id 4, while I need it to be started from 1. Can anyone suggest, how can I achieve this? Looking forward to hear from you soon. Warm Regards, DT - 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
Q U E R Y
Greetings! I am using MySQL in RedHat 6.2 with PHP 4.0. I have a question on MySQL. Suppose I have two tables A and B in my database: Table A Name Score a45 b20 c75 d55 Table B NameScore a20 b9 c25 Now I need to subtract values of table B from table A and result should be like: Table C NameScore a25 b11 c50 d55 How can I do this? Looking forward to hearing from you. Warm Regards, Deependra B. Tandukar
Re: start mysql at startup
Dear Ngu, in rc.local add if [-x /path/to/mysqld]; then echo "MySQL started" /path/to/mysqld start if Warm Regards, Deependra B. Tandukar www.coremag.net/cvs/dt.htm Training and Networking Assistant ICOD/ICIMOD www.icimod.org Co-ordinator CORExpress The Only Native Computer Magazine of Nepal www.coremag.net +++ === - Original Message - From: "Brian Warn" [EMAIL PROTECTED] To: "Ngu Nguyen" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 11:24 PM Subject: Re: start mysql at startup I followed the instructions at the top of the mysql.server file and it works great for me: # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # Mysql daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 # based systems) and linked to /etc/rc3.d/S99mysql. When this is done # the mysql server will be started when the machine is started. -Brian - Original Message - From: "Ngu Nguyen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 10:24 AM Subject: start mysql at startup Hi, I just finished installing mysql, but the only way I can start mysql is using "./configure" or "./bin/safe_mysqld". In the documentation it tells me to use "mysql.server start" but this command doesn't work. I was wondering if anyone could tell me what I am doing wrong. I am also wondering how I could get mysql running at startup. I have no clue on how to do this at all. I'd really appreciate your help. Thanks, Ngu _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
I N S T A L L
Greetings ! I am using Windows2K and have php in it. I want to install MySQL also in my computer. How can I do this? I am using IIS. Looking forward to hearing from you. Warm Regards, Deependra B. Tandukar - 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--Install
Greetings! I am trying to compile MySQL in RedHat 6.0. what I did are: tar -xvzf mysql-3.23.33.tar.gz cd mysql-3.23.33 ./configure --prefix=/usr/local/mysql then it startx to work and inerrupt and says testing gcc working: no configure: error: installation or configure problem: c compiler can not create executables what should I do? I don't have gcc in my computer. Looking forward to hearing from you. warm regards, Deependra B. Tandukar http://www.coremag.net/cvs/dt.htm - 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: TCP_NODELAY is not used when compilation
Greetings! I am trying to compile MySQL in RedHat 6.0. what I did are: tar -xvzf mysql-3.23.33.tar.gz cd mysql-3.23.33 ./configure --prefix=/usr/local/mysql then it startx to work and inerrupt and says testing gcc working: no configure: error: installation or configure problem: c compiler can not create executables what should I do? I don't have gcc in my computer. Looking forward to hearing from you. warm regards, DT - 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