lookup tables, populating automatically

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, i

Database Insert Help

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 an

Fwd: Re: DB Design

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

Backup, move, restore..?

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 d

Re: mySQL is slow with TCP/IP !!!

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 f

Library database help

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 thou

Re: MySQL 4.0.14: Manual

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!

mysql queries with numbers

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 vi

Re: read in a .sql file

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 crea

read in a .sql file

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 No

Multiple fiel attachments per record

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 f

RE: What's up with this GATOR crap?

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

Delete from InnoDB

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

Re: mysql php question

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 functio

mysql php question

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

mysql perl query question

Sorry if this belongs more on the perl users list, 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. S

mysql auto_increment question

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

Re: data warehousing

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. Se

privilege problem

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

mysql load data question

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

mysql priviledges question

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

mysql query question

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

mysql InnoDB .my.cnf help

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 S

date question

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. Seekin

Mysql Load Data question

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

table type airline?

>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..." "Yo

Re: mysql login question

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

mysql index question

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

DBI connect (help)

ord); DBI->trace(9); outputs the following imp_dbh->mysql_dr_connect: host = 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

Re: building mysql-4.0.1 (libtool question)

(!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 Syst

building mysql-4.0.1 (libtool question)

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 Tel

builidng mysql-4.0.1-alpha

ith-named-thread-libs=-ldce --with-lib-ccflags=-fpic --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 Administrato

Mysql 4.0

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. Se

shutting down mysql

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

table structure question

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 i

.my.cnf question

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