Hi, I need some help with an insert issue.
I have two tables, organizations and contacts.
Every contact relates back to an organization
Organizations has org_id, org_name, and org_address, etc
Contacts has contact_id, contact_name, contact_address and a foreign key
called c_org_id.
contact_id
I asked a question earlier about how to handle lookup tables, I think this
is a little more clear as to what I was trying to ask.
if I want to relate a contact to an organization, I know I can create a
table that contains contact_ids and org_ids.
But, how do I enter that information gracefully,
Whats the goal with the Data? If it is graphing it then go with MRTG
with RRDtool, which will keep about 550 days of SNMP data and produce
graphs
displaying a daily, weekly, monthly and yearly timeframe... Could do
1500 devices with probably less than 10 Gigs of space...
You could then load the
Hi all. I am needing to do a backup of two smalldatabases, both live on
the same server and under the same Mysql binary installation...
I would like to back them up, dump them into a file(s), make my move,
install the same database, and then restore/load this dumped
information
back into the new
Unix or Linux..
Mojtaba Faridzad [EMAIL PROTECTED] 09/24/03
03:10PM
Hi,
I wrote some queries to check the speed. If the client and server both
are
windows NT, retrieving large number of records is very slow but when
the
client is windows 98 and server is NT, it works almost 20 times
faster.
Hi all. I am trying to build a small simple database for a lending library.
Basically, I have a table of resources to be lended out, and a table that will store a
user's name and what they have borrowed.
My problem is that we may have more than one copy of a given resource say a book.
So I
Question for everyone, I have a database with about 30-60 days worth of information.
Much of it numerical.
Can and should I use SQL to run quereis that will return me the high/low and average
for the time frame, as well as standard deviation,
or should I just get all of the info into an array
Not to be too picky, but the version I downloaded didn't have a table of contents in
the .pdf file.
The older version did. It was very handy for quickly narrowing down a topic and
getting close to what you were interested in...
Sergei Golubchik [EMAIL PROTECTED] 07/28/03 10:55AM
Hi!
On Jul
Hello. How can I set up a table that allows multiple file attachments per record.
Basically, if I have a table of clients, and I want to add or remove attached files
for a client, I dont want to have to create a set number of blobcolumns ahead of time,
so is there a way to dynamically add more
I have a large SQL file that contains a bunch of create table statements...
How do I get mysql to read in this file and process the sql.
I am not thinking load data infile because it isn't text...
Please
Thanks all, I had to use the use database name as well as put the password in the
first line and that worked...
Paul DuBois [EMAIL PROTECTED] 07/18/03 02:59PM
At 14:44 -0500 7/18/03, Taylor Lewick wrote:
I have a large SQL file that contains a bunch of create table statements...
How do I get
Yes and think before you type, I may have to consider using another database.
That shows real maturity. First of all if you are really that important of a customer
and have the ability to influence your organizations database useage decisions, and if
this really angered you off that bad, then
Hi all. I did a delete query on an InnoDB table where items were older than a certain
date.
That worked fine, and it told me that some 30,000 objects had been deleted.
i did a commit, and then decided to delete a few more by changing the date parameter.
Now the query just hangs, and when I do a
Does anyone have some simple sample code using php to access a mySQL database?
Could you post it or send someit to me please?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
gotcha, thanks, which manual is that?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
[EMAIL PROTECTED] 06/24/02 01:39PM
in the php manual in the section of functions about mysql, it has a few
examples.
SNIP
, but I thought everyoen would enjoy
a DBI refresher...Any ideas?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
to be pretty useful or more restrictive, or
both, useful but restrictive?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
I dont think the types of tables will really help you, because as I understand it
mySQL doesnt yet have stored procs, views, and sub-selects, regardless of table type...
I may be wrong though...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking
I am missing something fairly obvious, but Im not sure what it is.
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
What priviledge does a user need in order to be able to execute the load data infile
command in mysql..? is it FILE?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
didnt see much in the mysql manual about these priviledges
Thank you,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
for mysql, if I have a text file that has the date as 5/17/2002, is there a way I can
translate that to mysql's version of the date, i.e. 2002-05-17?
With Load Data as well?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath
Hi. I am wanting to create an Innodb databse. I am using mysql 4.0 on unix.
Could someone send me a sample configuration file of thier /etc/.my.cnf?
I've looked at the documentation, but I always enjoy looking at something from a real
system...
Thanks,
Taylor
Taylor Lewick
Unix System
combine a delete statement with my original query...?
here is my query, which works..
select distinct table1.ticker_name
from table1 LEFT JOIN on table2 on (table1.ticker_name = table2.ticker_name)
where table2.ticker_name IS NULL;
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis
Regarding mysql...
1) Are primary keys and foreign keys by default indexes for a table?
2) Do I have to use a special data other than float to allow for negative numbers,
i.e. I want to be able to enter -1.76 and be able to later do math against that
number...
Thanks,
Taylor
Taylor Lewick
Can you login to mysql from a perl script by passing it an encrypted password..?
Taylor...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
From my sql How can I see what the types of tables I have are.. i.e. how do I verify
if a table is an ISAM, HEAP, InnoDB...
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System
I am trying to build mysql-4.0.1 from the source...
When it gets to libtool it is having problems finding gcc... How can I cahnge the
path to the full path of the gcc compiler?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath
?
if (!passwd)
{
passwd=mysql-options.password;
#ifndef DONT_USE_MYSQL_PWD
if (!passwd)
passwd=getenv(MYSQL_PWD); /* get it from environment (haenke) */
#endif
}
The next line that then errored was...
if ((env = getenv(MYSQL_UNIX_PORT)))
Taylor Lewick
Unix System Administrator
Fortis
= localhost, port =0, uid = NULL, pwd = NULL
.my.cnf file looks like...
[client]
user=root
password=passwd
Any ideas or anything blatenly obvious as to what is wrong?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where
I looked through the documentation, and I see how to start the dbase/server, but how
do I stop it.. Just kill the mysql daemon?
Thanks
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
Has anyone installed the mysql 4.0 HP-UX binary (10.20) on an 11.00 box? If so did it
work okay...?
What about builing from the source on 11.00? Any big issues I should be aware of?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking
--disable-shared
The only thing I can think of, is I think HP has a problem with some code that uses
geteuid and seteuid. I remember reading something along those lines...??
Anyone have any clues?
Thanks,
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted
I have created a .my.cnf file in my home directory. When I start mysql as that user,
it should read that file automatically correct?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
Please Note
The information in this E-mail message is legally privileged
36 matches
Mail list logo