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 ca
Hi,
This is a problem of the sort that is starting to make me a little
supersituous. I am using mySQL various versions, one of which is 4.01 max on
FreeBSD 4.5 stable, DBI 1.30 and I believe the latest DBD::mysql module.
Well the weird thing that is happening is that on this particular machine
wh
I am not very sure I understand the questionbut maybe column type 'enum'
is what you are looking for.
- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 9:43 PM
Subject: MySQL database design, one column, 10 entries?
>
> I a
I am creating several tables in MySQL and linking via primary keys. I am held
up on one issue, for one row in one table i have a column 'favorites' where i
want to hold up to 10 unique entries, how do i implement this?
userTable
userId varchar(20)
name varchar(30)
email varchar(40)
preferen
mysql.sock file doesn't exist in the /var/lib/mysql directory. Stop and
restart mysql server.
Regards,
Bhavin.
- Original Message -
From: "samratsam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 4:28 AM
Subject: ERROR 2002: Can't connect to local MySQL serve
-Original Message-
From: William dw [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 5:34 PM
To: Mysql
Subject: FW: Error: 7 - Error on rename ... (Errcode: 13)
Error code 13 = Permission denied.
Check your permissions :)
-Original Message-
From: David yahoo [mailto:
I'm getting this in 3.23 on OS X.
As near as I can figure out when I used this installer disk from open osx it
reset my drive permissions to read only excepting anything in my specific
user folder (including desktop).
I'm stuck here too so any help would be appreciated.
Brian Loomis
From: "Dav
Hi all,
While trying to upgrade a table struture i get the following error :
ALTER TABLE Prefixtest_T_Stories ADD COLUMN IndexDisplay char(1) default 'Y'
>>>
Error: 7 - Error on rename of '.\testbase\Prefixtest_t_stories.MYI' to
'.\testbase\#sql2-118-3.MYI' (Errcode: 13)
I m running a mysql 401
try using "localhost".
you have to set the hostname in the install script.
on 8/10/02 1:08 PM, Alex Pilson, typed:
> I am installing a new MySQL installation on a new Xserve and I am
> getting this message;
>
> [xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db
> Sorry, the host
>From: david [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 10, 2002 1:42 PM
>Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding
a postfix to my USE request?
>
>Why is mysql adding a postfix to my USE request? I know that test.test
>doesn't exist, i don't want it to, i'
What are you trying to do here?
MySQL is giving this error because the table 'test' does not exist in the
'test' database. Are you mistaking database for tables? I think perhaps you
need to take a look more carefully at the manual about creating tables.
Mike
- Original Message -
From:
Why is mysql adding a postfix to my USE request? I know that test.test
doesn't exist, i don't want it to, i'm not asking for anything.anything why
will it append this suffix to my request?
mysql> show databases;
+--+
| Database |
+--+
| mysql|
| test |
+--+
2 row
Hi, Jerry,
Here's your simplified form:
Here is the page "addcontacts.php":
It would be a good idea too, of course, to add some error-checking in there.
Plenty of documentation on that stuff at http://php.net .
Good luck!
Jed
On the threshold of genius, JeRRy w
Hi,
In Win32 distribution version of MySQL(ver 4.x) , mysql.dll don't have entry
point for mysql_ssl_clear().
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
I am installing a new MySQL installation on a new Xserve and I am
getting this message;
[xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db
Sorry, the host 'xserve' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve thi
Chris,
A pointer is a type of shark! Just like them, this suggestion has sharp
teeth too - change the time_in value to 11:45 and see what I mean...
This topic was discussed one week ago ("Time Calculations") - see archives
(to save you that, I'll forward you a copy privately (list doesn't like
a
Hi,
I would like to create a members area on my site,
using mySQL for the database to hold usernames and
passwords to login to the area.
I need to know the following if anyone can help
please.
- What code would I need to make a login page form
that has username and password? (lets say the table
Hi,
I am trying to setup a PHP form to send to mySQL
database. I know how to connect to mySQL but need
help getting the information in the form to update
into the mySQL database.
I have the following table called contacts, I'd like
the form to have the following fields.
firstName
lastName
emai
Thanks for the quick response. The times are stored in TIME format. If I
do the following:
SELECT *, time_out-time_in as job_time from time_sheet;
the job_time column gives me the right time, but is not formatted, for
example:
time_in = 11:00
time_out = 13:15
job_time= 21500
Any pointers?
>>> Alexander Burbello<[EMAIL PROTECTED]> Wrote:
>>>
Hi,
>>
>>how can I lock only one row in the table?
>>
>>What table type I have to use to lock?
If you use MyISAM table (default table on MySQL 3.23.x) you can't
use InnoDB table for enabling row level locking,
BTW it's default table for MySQL
Hello Christopher,
> I need to ask for some help and I can't find anything in the manuals. I
> am writing a php based app that as one of it's functions keeps an
> employee time sheet. The times are stored in a mysql database with 2
> columns - time_in and time_out. What I need to do is subtract t
Hello,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times are stored in a mysql database with 2
columns - time_in and time_out. What I need to do is subtract these to
columns
Steven,
I have forwarded this to the build master of MySQL AB. I too noticed that
the mysqld.sym file did not work in the
mysql-4.0.2-alpha-pc-linux-gnu-i686
.tar.gz distro, but did not realize that the .sym file was totally empty.
The .sym file works in the .rpm distro, but unfortunately that
Hello,
Using MysqlTool v0.94 on Netscape Communicator 4.79 to access MySQL
vers 3.23.49 on FreeBSD 4.x
Suddenly starting returning
Please enable cookies. Multi-user MysqlTool
uses cookies to store encrypted connection information.
Browser has "Accept all cookies" set.
why do i get an erro like
"ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)"
what could be wrong with this error
please send me the reason for it and also
how do i overcome this problem
regards
samratsam
Get Your Private, Free E-mail from In
Obiajulu,
Please refer to previous response and the as yet unanswered question within.
> I have the following values in my db table:
> Id. regdate
> 001040-1467
> 011910-2002
> 021700-1789
> 031550-2002
> 041600-1700
> 051900-2000
> .
Gloria
> > in a database on adjunct faculty.
> > Well, I set my table up withalphnumeric codes and most stats software
> > want those mutliple choices as numbers.
=which is why most people design to enter such data as number codes (1~5)
rather than alpha.
> > So I need to change the things alre
On Fri, 9 Aug 2002, Thomas Seifert wrote:
> On Thu, 8 Aug 2002 03:02:40 -0700
> Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>
>
> > > btw:
> > > I did a quick benchmark with mysql4 and its query caching running with
> > > innodb.
> > > Quite impressive, the app run with double the number of pages
28 matches
Mail list logo
