Okay, I think I'm -almost- there:
I have these tables:
tracks
albums
artists
Each with an id MEDIUMINT NOT NULL PRIMARY KEY and a track, album, or artist
column.
Then I have 2 linking tables, albums=tracks, tracks=artists, these are:
albums_tracks
tracks_artists
Each of these has all MEDIUMINT
Never mind... Spotted this after I sent the post!
This:
SELECT dates.date, tracks.track, albums.album, artists.artist
FROM dates, tracks, albums, artists, albums_tracks, tracks_artists,
ex_playlist_tb
WHERE example_playlist.id = dates.id
AND example_playlist.track_id = tracks.id
AND tracks.id =
- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 8:45 PM
Subject: Deleting from multiple tables
I am using MySQL with a PHP front end. Is there a better way to delete
from multiple tables than the following?
I am thinking of running a web based survey in which
the data from each participant's responses go into a
single row in a table. Some of the responses (around
10) are free text so I will be using text/blobs to
store them. There are about 35 columns in the table in
all (out of which 10 are text).
Hi!
I want to create a table, using a select statement to fill it.
Iam using a Database called Listeria_monocytogenes_EGD_int:
From that I want to select the following: There is a table in which a
code-hitcode pair is stored. I want to select a additional value
(funcat) to each code and
Hi
I'm new with mySQl and I'm experiencing problems when using it with
myODBC (my OS is W2000).
I developped a short program which uses myODBC to insert and
retrieves values from a mySql table. The problem I have is : When I
send,threw myODBC,
a query such that:
insert into table1
Hello, all!
I'm working on some perl script and have problem connecting to mysql
server.
The problem is: it's ok if connecting to localhost, but can't connect
to other server.
Example:
### RDB.pm
require RErrorHandler;
require RHash;
require DBI;
package RDB;
@ISA=qw{ RHash };
my
Hello,
i'm running mysqld-max ver 3.23.49. When i see the
process status (ps), there are 10 processes running of
mysqld. is this fine or something wrong???
Thanks!
Ritu Singla
Everything you always wanted to know about
Here's one way. Assumes that cust/item pairs are unique.
select cust, sum((item='12a')+2*(item='13a')) as IND from transfile
group by cust having IND=1;
Alternatively, you could build a temporary table with cust's who ordered
13a,
the use a left join.
From: Smith, Mike [EMAIL PROTECTED]
To:
You have written the following:
[snip]
I have a file(transfile) that has 2 fields(cust# and item#)
CUST# ITEM#
1 '12a'
1 '13a'
2 '12a'
3 '13a'
4 '15a'
If I want to select customers that have ordered item '12a' but not '13a'
How can I do this?
SELECT CUST#, ITEM#
FROM table
Ritu,
Thursday, May 23, 2002, 5:04:29 PM, you wrote:
RS REALFROM: Ritu Singla [EMAIL PROTECTED]
RS HOUR: 2002052320
RS hello,
RS i'm trying to install mysql-max...using binaryver 3.23.49
RS i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB
RS table options::
RS
Eugene,
Thursday, May 23, 2002, 4:42:57 PM, you wrote:
EM Victoria
EM Thanks for the quick response. If I enter what you provided using a 'dos'
EM command, I get Access is denied.
Check your permissions! If you get any error you should include full
error message! Besides, if you use user name
Anil,
Thursday, May 23, 2002, 8:30:33 PM, you wrote:
AG when i try to read a table using query
AG select * from table name
AG it shows following error:
AG cant open file:'anil.MYD'.(errno: 145)
AG y such an error can come!!
AG earlier it was fine.
# perror 145
Error code 145: Unknown error
Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
saraswathy,
Friday, May 24, 2002, 5:21:27 AM, you wrote:
ss Can anybody help me? is there any other specific command instead order by ID
ss DESC to select all the record from table where the ID is the last ID.The ID
ss is autoincrement.
ss Record is like this:-
ss ID name gender
ss 1 a
Dear Hoa,
RE I have the mysql server running. I can't connect to it though. It
reads,
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'.
-
Stop it, (either mysqld or mysql), then start again. On my servers, the
mysql startup script is in
Description:
I used mysqldump to create an SQL file containing a dump of all databases on
the server, including all tables and data (using --all-databases). However,
when I tried to restore from this file, the mysql command line tool reported
errors. I guessed that this was due to the
Dear MySQL Wizards,
I discovered a solution that works to resolve this problem. :-)
Here are the steps I took.
--
1. At the O/S, I copied the three MySQL files to a new name, a_copy.
2. I used mySQLman to delete an index and then to recreate it. I did this
because the
Hello
Forgive me for being a little naive but.
I am trying to load a table with a text file using the load data infile
command in mysql. I can do it if I place the
text file in the db directory, but I want it to reside in a different dir. I
am getting the error 13: Can't get stat on
did you supply the /full/path/to/the/file/ ?
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Newbie--Easy data loading question
Hello
Forgive me for being a little naive but.
I
yes. I tried all of these methods:
1) //dir1//dir2//file
2) /dir1/dir2/file
running load from file dir using:
./file
.//file
I also check the file permissions and it is all read/write.
I can't remember if I tried to run it using mysqls root yet...that would be
the next step, but I prefer not to
I just got ViewPoint, which generates web based graphical stats for firewall
use. It collects syslog data, and it stores the data in mySQL. These web
based stats only display data for one day at a time (you get to choose your
day), and does not serve my needs, so I want to get into the data that
I figured it out but I'm a bit confused as to why it happened.
I'm running the load as user1. The file resides at /home/user1/data/filename
Permissions:
filename 666
data 777
user1 700
I had to change permissions on user1 to 777 in order for it to work. If I'm
logged in as that user, why would I
Hi,
I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
password is required for access.
Both GRANT and REVOKE give errors saying Table 'User' is read only. A text
search in the manual for read only did not yield anything.
Is this an OS attribute that should be dealt with
On Wednesday 22 May 2002 18:44, Dave Watkins wrote:
At 16:02 22/05/2002 +0800, Patrick Hsieh wrote:
Hello list,
I am expecting to have 30,000 http clients visting my website at the
same time. To meet the HA requirement, we use dual firewall, dual
Layer-4 switch and multiple web
25 matches
Mail list logo