You need to add an additional table, favorites.
It should have three columns:
favoriteID INT,
userID INT,
favoriteTypeID INT REFERENCES FavoriteType.
Plus the additional column for the rating, assuming it's associated with a
favorite.
Each row represents a single preference (this way users
Hi mysql users, mysql developers!
I have just started using mysql for a database project and I wonder that one
function is missing. I am using myphpadmin as utility. It is possible to
write a comment to each table, but it is not possible to write a comment to each
field. Why not? I think this
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
Or you can advise me of how to arrange my keys, or otherwise develop this
db?
From
Anish MAthew
India
Dear sir
i am using Linux 7.2 as my OS and having mysql version
3.36.
i am a novice learner of mysql though i am familiar
with Oracle and sybase. when i got to no the GNU
publice license and open
source technology i thought of learning mysql.
but i
did you also install the databases that are part of the mysql installation?
-Ll
on 8/11/02 5:59 AM, Anish Mathew, typed:
my sqlserver is not running
when i issue the command mysql
the response i got was cant connect to local mysql
server through socket /var/lib/mysql.sock (111)
Hi,
I'm sometimes experiencing in my application the commands out of sync; You
can't run this command now error.
According to the MySQL manuel, it means :
This can happen, for example, if you are using mysql_use_result() and try to
execute a new query before you have called mysql_free_result().
Description:
NET is defined on line 135 in myslq_com.h. When I include
mysql.h (for embedded mysql) I cannot compile a program which also includes
netwm_def.h, which defines a completely different NET.
How-To-Repeat:
Try to compile something that includes these two
Also, see what errors you are getting in mysql hostname.err file
Regards,
Bhavin.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, August 11, 2002 3:30 AM
Subject: Re: Mysql Problem Query
did you also install the databases that are part of
I want to securely store a value that is used as a password to log
someone into a Web application. I also want to be able to allow the
user to search for their email address and have their password sent
back to them (in readable form). Encrypt, MD5, and Password are
non-reversible and thus
An easier (and more secure) way, surely, is to use one-way encryption... and
if a user forgets his/her password, replace it with a random alphanumeric
string and mail that to them instead with instructions to change it to one
of their own choosing as soon as possible.
Mike
- Original
At 9:54 AM -0700 8/11/02, Mike Wexler wrote:
I would think that using the SQL shown would require a table scan,
meaning that each and every record in the visitors table must be
examined, the LoginPassword decoded and compared. There is also no
way to index this field. I do not think this is
At 9:25 -0700 8/11/02, Michael Collins wrote:
I want to securely store a value that is used as a password to log
someone into a Web application. I also want to be able to allow the
user to search for their email address and have their password sent
back to them (in readable form). Encrypt,
At 12:07 PM -0500 8/11/02, Paul DuBois wrote:
If you write the query like that, yes, it will use a complete scan.
But you could also use
... AND LoginPassword = ENCODE($PasswordEntered,'MySalt')
which doesn't perform a calculation on the LoginPassword column and thus
can use an index. This is
Hi.
On Sun 2002-08-11 at 12:07:47 -0500, [EMAIL PROTECTED] wrote:
At 9:25 -0700 8/11/02, Michael Collins wrote:
[...]
SELECT * FROM MYDB
WHERE EmailAddress=$EmailEntered AND
DECODE(LoginPassword,'MySalt')=$PasswordEntered
If you write the query like that, yes, it will use a complete
At 19:51 +0200 8/11/02, Benjamin Pflugmann wrote:
Hi.
On Sun 2002-08-11 at 12:07:47 -0500, [EMAIL PROTECTED] wrote:
At 9:25 -0700 8/11/02, Michael Collins wrote:
[...]
SELECT * FROM MYDB
WHERE EmailAddress=$EmailEntered AND
DECODE(LoginPassword,'MySalt')=$PasswordEntered
If you write
Hi.
I drag this a bit to off-topic here, but the answer below brings up a
question which bothered me for some time...
On Sun 2002-08-11 at 17:30:46 +0100, [EMAIL PROTECTED] wrote:
An easier (and more secure) way, surely, is to use one-way encryption... and
if a user forgets his/her password,
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Mike Hall [EMAIL PROTECTED]
Cc: Michael Collins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, August 11, 2002 7:05 PM
Subject: Re: [OT] assigning new passwords (was: Need reversible encryption
as string)
On Sun
At 8/11/2002, you wrote:
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
Or you can advise me of how to arrange my keys, or
I seem to have lost the mysql database tables.
I have other databases that work.
what is the best way to add the right tables to mysql
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello Dave,
Phew... what a situation! ;-)
You can always run mysql_install_db script on *NIX, but it clears your
existing permissions. On Windows you can do an xcopy for your mysql
database from the distribution package, but that doesn't save your
permissions, either.
First, though, make sure
I've never used a MySQL database before to create a dynamic website. I've
done it loads of times with Access and ASP but now I need some help on
developing firstly the database in a windows environment. Then I'll use PHP
to access the database but on a Linux or Unix server? Anyone out there know
on 8/11/02 2:47 PM, Pekka Saarinen, typed:
At 8/11/2002, you wrote:
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
At 8/11/2002, you wrote:
I believe that what you called intermediate table books are calling
table map, or something with the word map in it.
Hi Lloyd,
Books are nice to have (you can lie down to a sofa or sit in the loo with a
book), and what I started with (SAMS Teach Yourseft MySQL in 21
I have a query I'm trying to construct on a table which contains a title and
date of records. I want to sort the query so that records are listed by
title with the newest dates first--keeping the records with identical titles
together and order by date within the title groups.
For example:
Hello folks,
I'd need to re-install MySQL server on my RH 7.3 box. As I installed the
server from RPMs, I tried to update MySQL with rpm and -Uvh options. Results
were like this:
[root@pilotmedia root]# rpm -Uvh MySQL-3.23.51-1.i386.rpm
Preparing...
In the last episode (Aug 12), Ville Mattila said:
Hello folks,
I'd need to re-install MySQL server on my RH 7.3 box. As I installed the
server from RPMs, I tried to update MySQL with rpm and -Uvh options. Results
were like this:
[root@pilotmedia root]# rpm -Uvh MySQL-3.23.51-1.i386.rpm
Hi, friends:
I have just created a small web site with php/mysql. I do a query into one
of my tables whose .MYI=338K and .MYD=7.6M. I could only retrieve some
part of the data and then the browser just died there.
My query is select * from Forces. The primary key is combination of
several
Hi, friends:
I have just created a small web site with php/mysql. I do a query into one
of my tables whose .MYI=338K and .MYD=7.6M. I could only retrieve some
part of the data and then the browser just died there.
My query is select * from Forces. The primary key is combination of
several
In the last episode (Aug 12), duo fu said:
I have just created a small web site with php/mysql. I do a query
into one of my tables whose .MYI=338K and .MYD=7.6M. I could
only retrieve some part of the data and then the browser just died
there. My query is select * from Forces. The primary
Description:
Mysql crashed
How-To-Repeat:
Don't know how to reproduce - server running a busy site with multiple
concurrent clients. Impossible to tell which caused the crash, but I'll gather more
evidence (try --log) and follow up if I can find anything specific.
Fix:
is there a password file accessable from root for 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
On Sun, 11 Aug 2002 [EMAIL PROTECTED] wrote:
I have just started using mysql for a database project and I wonder that one
function is missing. I am using myphpadmin as utility. It is possible to
write a comment to each table, but it is not possible to write a comment to each
field. Why not? I
32 matches
Mail list logo