quick reference guide
hello all, anybody know where to find a quick reference guide for mysql commands/functions? TIA, luie __ www.edsamail.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: [PHP] MySQL question...not sure if this is the correct forum to ask.
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
| |
|ID No: 1234 |
|Name:_|
|Address: _|
|Status: Married |
| |
|Submit|
--
If I have this table...
_
|idnonameaddressstatus|
|-|
|1234Peter45 street Single|
|_|
Which means I only want to replace the status and the name and address remains the
same.
How do you test w/c entries in the form have new values and change only those entries
in the table?
Peter, this is basically what your asking, right?
I actually need to figure this one out myself so I would appreciate any info.
thanks...
luie
What about REPLACE?
http://www.mysql.com/doc/R/E/REPLACE.html
'REPLACE works exactly like INSERT, except that if an old record in the
table has the same value as a new record on a unique index, the old record
is deleted before the new record is inserted'
Hi,
Can the UPDATE statement have conditional check embedded in it? I
have a page that displays a record (in a FORM format) that the user can
change the information on each column. I want to check each column and
see which has been changed and update the table for entries that were
changed only.
for each column data {
if column is changed
then update;
else
do nothing;
}
Maybe I am making this too complicated than it needs and just go ahead
and update all of the columns regardless with the new values, regardless
they are actually different or not.
Thanks in advance,
-Peter
__
www.edsamail.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: MySQL will not run on Debian Linux version 2.4
or you can try... /usr/local/mysql# ./mysql start Christopher Thompson wrote: Prefix it with the path: /usr/local/mysql/mysqld start or whatever. On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote: Hi, I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When I try to run it to finish installation and set up users, i get the following error: /usr/local/mysql# mysql start su: mysql: command not found I have also tried running MySQL with the mysqld start, mysqld, and mysql commands and all of them result in the same message. If you can help me I will be very grateful. Thank You, Mark __ www.edsamail.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: Old Messages
yes. For two consecutive days I've been receiving messages as far back as a week ago. I just received 452 messages, 300+ from mysql dated 2-06-02 to 2-11-02. These are messages that I've already received from previous days. What's going on? luie sql Roger Baklund wrote: * Van Anyone else getting lists messages from several days, or longer ago? yes... -- Roger 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 __ www.edsamail.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
man pages for MySQL
Hello all, I'm just wondering, is there a man pages for MySQL? Like the one that we use in linux, executing *man ls*, for example, in the command line provides some detail on how to use the command. Is there a similar method for MySQL where we can execute *man grant*, for example? thanks... luie ___ What we do in life echoes in eternity. -- Maximus Desmus Meridius ___ __ www.edsamail.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: Access denied for user varlehti
LdS I'm experiencing the same problem. LdS But I sort of found a way around it (though I'm sure this is not really the right way). LdS When I remove the *password* for *root* and login again as root, I'm able to create new users using GRANT then flush priviliges. LdS Does this mean I have to indicate the password of root while using GRANT? LdS I can't find any info on this on the docs, please point us to where we can find the info for this. LdS thanks... Yes, using GRANT statment you can set password for user. Look at: http://www.mysql.com/doc/G/R/GRANT.html I still end up having a user with all privileges set to *N*, eventhough I created that user with mysql grant all privileges on dbase1.* to user1 identified by 'user1password'; What am I doing wrong? luie __ www.edsamail.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
can login only as root
hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using GRANT all to user1 identified by 'password';, but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm still unable to login as user1. hope somebody can shed some light on this. thanks in advance... luie __ www.edsamail.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
