Hi,
I have a situation where I need clients to connect to a proxy server and to
then determine which MySQL server to forward their connection to based on
the username supplied. Does anyone know if this is possible using
mysql-proxy with Lua? Or by any other means?
Thanks.
REW
have indexed the column, but i am wondering if i should create a
couple of int columns that would be day of week, week of year and
month and query against these instead.
would love you opinions
thanks
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello,
currently i have the following table structure
CREATE TABLE users (
uname varchar(20) NOT NULL default '',
passwd varchar(15) NOT NULL default '',
fname varchar(25) NOT NULL default '',
lname varchar(40) NOT NULL default '',
dir varchar(28) NOT NULL default '',
pict varchar(50) NOT
On 8/14/06, Dan Buettner [EMAIL PROTECTED] wrote:
Randy, it's possible your indexes are sadly out of date, or corrupted somehow.
Can you post the output of
EXPLAIN select * from gallery_object where dir = 'dirname';
as well as of
EXPLAIN select * from gallery_object
where parent_id = 1
and dir
in the previous message returned
immediately
Thanks
Randy
Randy,
Then it could have been index corruption. You could do a back up
of the table and then run a Repair Table on it (or MyISAMChk) and then
Optimize it.
See http://dev.mysql.com/doc/refman/5.0/en/repair.html
Mike
Mike
Hello,
I have a table (see below) that has 111599 records in it.
When i do a query like select * from gallery_object where dir = 'dirname'
this query takes a very long time and while the query is going on it
locks the entire table so no one else can query it
yet a query like
select * from
Hello,
Not sure if i can do this.
I have a table with a datetime column
I would like to do group by a day of the month.
if i do something like
select count(*) from MTracking where mallarea=1001 group by timeofclick
every one is listed because time.
So is this possible?
Thanks
Randy
.
Do you really want to drop the 'billmax' database [y/N] y
Database billmax dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
to the old way of separate inserts
for each row?
Thanks
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to see ?
In the mysql variables. In 5 days I have 11885 aborted_clients. I assume
this is probably pretty high?
Thanks for any more help
Randy
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 3:27 PM
To: mysql@lists.mysql.com
Subject
Hello,
My log file is getting filled with these.
Can someone tell me what these mean?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication
directory I have a file called millhouse.unitnet.com.err
My main db is unitnet
It appears this is a good link that I received from GLEB
http://dev.mysql.com/doc/mysql/en/communication-errors.html
I am going down that path right now
Thanks
Randy
-Original Message-
From: [EMAIL PROTECTED
Hello,
My log file is getting filled with these. How do i start debugging this?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication
Thanks for all your help
FYI, I had to add this to the my.cfg
set-variable= max_allowed_packet=16M
Randy
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 16, 2004 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: moving DB from one box
That part that confuses me is in the script /etc/rc.d/init.d/mysqld
(I put in some debug echos to see where it is exiting)
When I run the startup it print 2
But I am not failure with /usr/bin/my_print_defaults
Thanks for any help!
Randy
==SNIP
Sorry,
When I do the mysql dbname oldbox.sql
I get the error message
It creates mysqldump dbname -h oldbox oldbox.sql fine
Thanks
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 15, 2004 11:25 PM
To: Randy Paries; [EMAIL PROTECTED]
Subject
hello,
I have built a new DB box.
Orig db is mysqld Ver 3.23.58
New DB is mysqld Ver 4.0.20
I want to move the data from one box to another.
I have a couple of really large tables with longtext fields. This data is a
bunch of HTML
My plan was to do a mysqldump dbname -h oldbox oldbox.sql
then
doesn't act any differently no matter
which way you do it.
Randy Clamons
Systems Programming
Astro-auction.com
Original Message
From: Rhino [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Date: Tue, Nov-23-2004 10:25 AM
Subject: Re
Hello,
I am building a new linux box , just to be an mysql server
I have a couple of questions.
1) would it be better to go brandnew with a single processor or like a quad
p4 that's a year or two old.
2) I am going to running raid 5, so I assume that I should run scsi drives?
3) my database
provide you with any other information?
Thanks!
Randy
Here is output from Show Slave Status \G
mysql show slave status \G
*** 1. row ***
Slave_IO_State: Waiting for master to send event
Master_Host: localhost
Randy Johnson [EMAIL PROTECTED] wrote:
I have mysql master and mysql slave on same machine running
separately.
I have master and slave setup.
I was able to do the LOAD DATA FROM MASTER;
to get the data but the data does not replicate after that. =20
Looking at the info below can
Does this table say that mysql 3.23.33 and up is not compatible to replicate
to a mysql 5.0 slave?
Thanks!
Randy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 12:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Replication Issue
Randy
Here is the url sorry:
http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 2:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Replication Issue
Does this table say that mysql
recently, but it seems likely that if you add the
,3,3 to the second rs.Open statement your app will behave properly.
Randy Clamons
Systems Programming
Astro-auction.com
Original Message
From: J.R. Bullington [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED
or UPDATE a single row.
You might get better results from this list if you include your table structure and
your queries along with your question.
Randy Clamons
Systems Programming
Astro-auction.com
Original Message
From: Danny Willis [EMAIL PROTECTED]
To: [EMAIL
back, but if I try to do
SELECT * FROM community_files WHERE MATCH (description) AGAINST ('bird' );
I get nothing back
I am running mysqld Ver 3.23.58 on rh9
Thanks for any help
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
to get these rows a group at a time?
There is also could be where clauses
Thanks for any direction
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question.
1)there will never be more than two columns
2)the majority of articles will only be one column
Does a majority of two empty text fields out way the penalty of a join with
a Column table
Do empty text columns take up much room?
Thanks for any help
randy
smime.p7s
Description: S/MIME
Apologies for what is a pitifully simple question from someone who has
just started using MySQL 4.0. I've looked in the documentation and
elsewhere, but can't find the exact syntax for adding comments to
columns when creating a table. My attempts at guessing the syntax so far
have failed.
not install everything?
This is a working db
Thanks for any suggestions
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
i have a simple query
select u.*,p.* from users u, profiles p
where u.uname = p.uname
and u.level != 0
Is there any tricks to make this use an index. If i do level=0 is uses an
index , but != does not.
--
MySQL General Mailing List
For list archives:
Hello
I have a number of servers.
I have one running RH7.3 with mysql-3.23.56-1.73
one running RH9 with mysql-3.23.58-1.9
My question is when i do a ps -ef
on RH7.3 a get a number of /usr/libexec/mysqld
on RH9 i only get one.
can someone please explain why. does RH9 display thread
the switch by searching the MySQL documentation at
their site.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oh, and one other thing, you have to create the passwords AFTER you use
the switch! That was probably obvious to you but it took me a while to
figure out.
Randy
Randy Chrismon wrote:
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root
one and Table 2
if the value in table one is not in table 2 then display the number to the screen?
Can somebody show me what the sql statement would look like?
Thanks
Randy
SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo)
;
On Wed, 2004-01-21 at 15:26, Randy Johnson wrote:
This example is simplified. I hope you understand
Each table has one field called ID which is an integer and is the
primary key
Table 1
List
string... not the null \N. In fact,
I'm not sure I can even change this
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the one. There is nothing
particularly unique or unusual about the one record if failed on
except that it was one of the newer documents.
Thanks for the thoughts.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
transactions which, I believe, releases any locks up
to that point. I've increased lock_wait_timeout to 75 (what is a
reasonable higher end limit for this?) but still get the error. I'm
using v.4.0.16 on a RH 9.0 box. Any thoughts on what might be
happening here?
Thanks.
Randy
--
MySQL General Mailing List
. In addition, I
had
already updated 26,000 records so I can't figure out what's wrong
with
this one particular record.
Any thoughts appreciated.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question is, how can this be done?
Any and all help appreciated.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with LotusScript so as to verify that I'm doing this right; but I
have
a strong suspicion that this is an ODBC issue.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of the connection object, etc. etc.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Randy Chrismon wrote:
Kim G. Pedersen wrote:
BUT
just a little hint , u sure it not ur _ (underscore) in table name
which
is a kind of wildcard that give u trouble ??
This raises an interesting question. I wrote earlier about troubles
with mismatch field count and missing field errors. I
in one query and to order
by
the 10 or so products I'm interested in.
MySQL is 4.0.12.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Any help would be appreciated.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the AS400?
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, or web site devoted to SQL questions --
particularly the dialect of SQL spoken by MySQL?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
clause on
the end of the update. Am I right that I can't do this??
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one comes from?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote:
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one
.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
frequent server gone away errors. At the same time,
using the console on my laptop but accessing the very same MySQL server
over the network, I have no such problems. That seems precisely
bass-ackwards to me! ;-)
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I'm not clear on this. What happens to duplicates under the following
scenario?
MyISAM table with either (or both!) a primary key or a unique index.
Alter table my_table disable keys.
Import 200K records.
Alter table my_table enable keys.
But it turns out there are duplicate records. Does MySQL
[EMAIL PROTECTED] wrote:
how to delete rows which table1.field=table2.field
thanks
delete t1 from t1,t2 where t1.field=t2.field
at least, that's how I read the manual. Works for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
/mysql to it then permanently mount it as
/var/lib/mysql? Or is MySQL somehow going to know that the
/var/lib/mysql it's looking at now isn't the one it was looking at an
hour ago? Of course, I would have mysql shut down while I pull these
shenanigans.
Thanks.
Randy
--
MySQL General Mailing List
Tried to do a load of data from a file in my home directory on Linux.
Got this message:
ERROR 13: Can't get stat of
'/home/rchrismon/mysql/ArchiveEC02-Invoices.txt' (Errcode: 13)
What does this mean and what can I do about it?
Thanks
Randy
--
MySQL General Mailing List
For list archives: http
by copying the subdir and changing the path in my.cnf? (I forget
what the my.cnf option is, but I'll find it.) Somehow, that sounds
too
easy...
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've been searching the Lotus site and have gotten kind of lost. Does
anybody have any experience using Lotus Notes as a front end to a MySQL
database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I
barking up the wrong tree?
Thanks.
Randy
--
MySQL General Mailing List
For list
I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use
--force (or is it --nodeps, I can never remember) because MySQL wants
libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question
(coming from that other world) why aren't these dependencies 0.9.6,
or
greater, instead of being
, that is the
question.
Thanks and apologies again for the long post.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that if I send it all to an outfile, I have a readable report? This
is
just an example of the kinds of things I'd like to be able to get a
handle on through some sort of reference.
Thanks,
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I need to know which id is not present in the other table.
Stefan:
A left join should do it:
select t1.id from t1 left join t2 on t1.id=t2.id where t2.id is null
I learned this from this mailing list about two weeks ago.
HTH.
Randy
--
MySQL General Mailing List
For list archives: http
and to the remote 4.0.15 database WITHOUT using --protocol=TCP. I CANNOT connect the command line to the remote 4.1.0 database without using --protocol=TCP. Passwords are required for root and user IDs in all cases.
Very strange.
Randy
--
MySQL General Mailing List
For list archives: http
Response should have been to problem connecting to 4.1.0
Sorry about that.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0.15 database. Trying to connect to the 4.1.0 database yields the same upgrade-your-client error message I get with the command line if I leave off the ---protocol=TCP option.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
This irritating rather than life-threatening: I can connect to the
MySQL database on my Linux box, from my Win2K box, using the command
line environment just fine:
c:mysql --protocol=TCP -h host_name -u my_name -p mysql
No matter what I try, however, I can't connect using MySQLCC. I
always
get
which also happens to be a 4.0.15 setup on a Win2K desktop. So,
I guess it's one of those things where it's both fish and fowl.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-- although show index says it
was.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
field? Do I include a first field with \N? If
the MySQL table has 20 columns with the first being the
autoincrement,
can my load file be only 19 columns?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
, a C compiler, and learn how to use them to get an
OBCD driver that will work with our server?
Thanks
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Is their an environment variable that
would do this? This is starting to make me look bad...
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just loaded about 125,000 records, each containing about 30 columns
into an empty, newly created, mysql table. It took 56 minutes. Isn't
that a little long?
The table design was driven, in part, by an existing reporting
application. The data to populate the table is being exported from
Lotus
For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
: 16374 Deleted: 0 Skipped: 0 Warnings: 69
mysql show warnings;
Empty set (0.00 sec)
What am I doing wrong that I can't find out what the 69 warnings are?
I'm using 4.1.0 alpha.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
of data to the list or
directly to Egor?
Thanks for the help.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks around here. The
second
form is too
contain as a value?
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-leading.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a field with NULL in it and a field with a
zero-length () string in it.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NULL.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
haven't had time to figure out how to
get one system to talk to the other.
HTH.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm having a hard
time believing it's a connection time-out.
Any thoughts?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---BeginMessage---
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check the
It looks like my MYI file was seriously corrupted, beyond myisamchk
being able to do a thing with it. Has anyone seen this before on
Solaris 8? Fortunately the data was trashable but when this hits
production it wont always be.
Thanks..
Randy
On Wed, 2003-06-18 at 21:46, Nils Valentin wrote
software was built with gcc 3.2.2,
again, on solaris 8. If anyone's got any suggestions let me know!
Thanks! Unfortunately I'm gonna have to restart this sooner than later.
:/
-Randy
Swiss American Securities Inc. MMS sasiny.com made the following
annotations on 06/18/03 10:04:42
' ODBC performance? It's possible that I might get better performance by turning off logging, which I'll try Monday, but I doubt it.
I assume that the preferred C++ interface to MySQL is not built on top of ODBC, and thus has much better performance. Is this correct?
Many thanks!
Randy T. Merkel
is the first
example project name | primary name | alternate name .all on
the same row. Is this achieved by an outer join? If so, can somone give me
a syntax example or point me to some good reading online?
- Original Message -
From: David Gilmour [EMAIL PROTECTED]
To: Randy
here's my table syntax:
create table Projects
( PjID int unsigned auto_increment not null primary key,
PjNumber varchar(40) not null,
PjName tinytext not null,
PjDesc tinytext,
PJEcd varchar(30),
PJCost varchar(30),
LastUpdate char(30)
);
create table Managers
( MgrID int
Can someone please tell me what is wrong with this function? I can't for
the life of me see an error. But, for some reason I keep getting the
following error:
PARSE ERROR: parse error, unexpected $ in
d:\web.root\xx_db\inc\functions1.inc on line 28
function is:
function dtb_qry_tbl_dsp($qry,
Can someone please tell me what's wrong with the following code? This info
is inside a function that I defined. One of the arguments that I pass the
function is the actual query. Based on the info that I know is loaded in
the database (it's a development database...there are only 2 rows of
Unfortunately this goes well beyond the scope of my original question.
Although the inputs that you all have provided thus far have been a very
good read, I still don't grasp the concept of defining a relationship. Is
it simply referring to a primary key in a field other than the one where the
I think I've firmed my theoritical understanding of relationships enough
to be dangerous. Now for the logical parthow do you actually define a
relationship in mysql? For instance...
table movies
columns (movie id(pk) , movie title , year filmed)
table directors
columns (director
Thanks to those who replied. It wasn't clear to me that that was the case,
based on the docs. I'll submit a doc change request to make sure that's
more clear to the next person.
Gracias,
Randy
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My
office currently keeps track of our projects via an excel spreadsheet. We
keep such info as project costing, status, points oif contact, name,
description, number, last updated, etc... What I want to do is merge all
that
Will,
Do you have a user/host pair for the client in the user table within the
mysql database?? It's not good enough just to have a user, the host has
to be setup too.
I cannot connect from my Windows machine to the MySQL database running
on
the Linux server.
I have tried several different
1 - 100 of 166 matches
Mail list logo