EWAGW wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
No need for flames. I think the two are converging.
PostgreSQL started out with a
to get rid of this problem, i have even tried re-installing the entire database server, but no use plz. help me.
regards
mahesh
-
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
--
Brad Tilley
VT Athletics
Coordinator
I'd suggest you add a static route to the W2k clients just to see if
that corrects the problem... try this command:
route ADD ddd.ddd.ddd.ddd MASK mmm.mmm.mmm.mmm ggg.ggg.ggg.ggg
d = destination (the mysql DB server)
m = subnet mask (255.255.255.0 or whatever your route happens to be)
g =
Here's a simple python script that I use to do mysql backups. I wrote it
myself. It works great. Cron it to run however you like:
def db_backup():
import os, time
# Change db_list contents to reflect the names of your databases.
db_list =
Man rpm and read a bit about the *upgrade* option...
rpm -Uvh name-of-package
Larry Lowry wrote:
I'm running 4.1.1 on RH 9. I want to upgrade this
to 4.1.2. I'm using the rpm from the MySQL site.
If I just try to install it with rpm -i then I get a bunch
of errors about conflicting files from
Three tables:
computers (Describes computers)
users (Describes users)
comp-user-link (Links users to computers in a 1 user to many computers
relationship)
Could someone offer advice on how to construct a select statement to
show which users aren't in the comp-user-link table? Sort of the
,the solution depends on your primary keys.
SELECT u.*
FROM users u
LEFT OUTER JOIN
comp-user-link c
ON u.userID = c.userID
WHERE c.userID IS NULL
-Original Message-
From: Brad Tilley
To: [EMAIL PROTECTED]
Sent: 5/25/04 1:39 PM
Subject: Search for relationships that aren't present
Three tables
Victor Shawn,
Thanks for the select info and the relationship info. Both of your
examples worked.
The reason we designed a separate linking table is that we wanted to
always keep the computers separate from the users. A container of users
and a container of computers with a linking table
Ah yes, thank you Gerald.
I didn't understand this until now. I guess I should say that 'by
design' the linking table will never contain a null, but the left join
changes that. Thank you for pointing that out.
gerald_clark wrote:
Brad Tilley wrote:
I should better describe the tables
Hello Mysqlers,
I have a few small DB's (less than 10,000 entries per table) that track
computer inventory in a mid-sized organization. Currently, all of the tables
are MyISAM. Is there any compelling reason to convert these to InnoDB? We're
not having any performance or size issues...
On Sunday 11 April 2004 10:58 am, Saurabh Data wrote:
Dear Users
Can anyone in your own words clarify the difference between open source
and free software.
Many Thanks
Saurabh Data
This is off topic for this list, but I'll provide a quick answer.
Free software is software that's free to
On Saturday 10 April 2004 08:15 am, [EMAIL PROTECTED] wrote:
hi
I have redhat 7.2 running on my server with plesk
i forgot mysql password for user root
so i reset it by following way
services mysqld stop
safe_mysqld --skip-grant-tables
mysqladmin -u root fulsh-privileges password
Hello again,
Is there a way to do regex search are replace on all entries in a mysql field?
Or, a way to uppercase or lowercase all characters for all entries in a
filed? Some of the fields are varchars with numbers and letters. In my
particular case, I have a field of serial numbers some of
Hello again,
I have a form that users fill out and submit into a mysql database using php.
The problem I have is that there is only one unique field in the main
table... it's an int that's auto-incremented with each new entry. This works
fine unless the user accidentally submits the data
Hello again,
How do you make a field unique, but not have it as part of the primary key?
For example, I have a 'computers' table that has a 'comp_id' field that's the
primary key. It's an int that's auto-incremented with each new entry. The
same table has a 'comp_serial' field. I want this
On Tuesday 06 April 2004 16:31, dan wrote:
Uhm,
what are you talking about?!?
Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with Mysql on a linux
system and the file is over 60 GIGS in size!
maybe you meant 2 Tb? and if you did,
On Tuesday 06 April 2004 17:28, dan wrote:
nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.
it doesnt occur in vanilla distributions or any other
retail,
Hi again,
I became frustrated with a RH9 mysql server install so I removed it and
installed the latest stable from mysql.com on the machine. Things are working
much better now, but I'm having problems with 2 things:
I've tried to make the server start at boot by copying the mysql.server file
Hello,
I am a mysql newbie. Recently, I've been given the task of joining two tables
within the same DB into one table. Currently, the tables are named 'desktops'
and 'laptops'... ultimately, I would like one table named 'computers' Both
tables have the exact same fields... they fields even
...
...
...
But I got an error about duplicate field names. Any suggestions on how to
do
this?
Thanks,
Brad
--
Brad Tilley
Coordinator of Computer Services
311-D Cassell Coliseum
Phone: 540-231-7539
Cell: 540-998-5903
Fax: 540-231-3445
--
MySQL General Mailing List
For list archives: http
20 matches
Mail list logo