leaving the list for now
hello all, I just want to thank everybody in the list for their help. I'm unsubscribing from the list for now. But I would definitely comeback as soon as I can. Thanks again for all the help. luie sql, query __ 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
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: 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: [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: 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
sample database
I'm trying to create a database system for our school and since 'm still new to MySQL, I'm wondering if there are any sample databases (student registration/enrollment information, employee payroll, etc.) published in the internet so that I can have some idea on how to go about developing our own. thanks in advance. regards, 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
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
