ty, is much the same, dependent on the security requirements.
> > > Example:
> > > Security auditors claimed that the marketing product database was not
> > > secure.
> > > They said that it needed to be more secure.
> > > The CEO of the company asked a simple question
e said:
> "Whats the worst that could happen if an outsider gains access to this
> database?"
> Answer: "They might buy one of your products!"
> Lesson learned: Don't waste your time securing data that doesn't need to
> be secured.
>
> So, what a
Hello,
Would be grateful for any help!
I have a table like (in reality few more fields!!!):
Id Site Code Type of Job
What I want to do is make reports like:
Site Code Type of JobNumber of Jobs for this type and site
Number of jobs for this site
I've been asking around for awhile without a solution to this problem and thought I'd
post it here perhaps some one will know of a script that will help.
I need to have emails sunmitted to a database field but more to the point I need to
have the attachment stripped and added to MySQL. People wi
THanks everyone for all your help!
Steve
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "David T-G" <[EMAIL PROTECTED]>
Cc: "mysql users" <[EMAIL PROTECTED]>; "Steve Vernon"
<[EMAIL PROTECTED]>
Sent: Frida
ovatt" <[EMAIL PROTECTED]>
To: "Steve Vernon" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:17 PM
Subject: RE: Hardware Raid and 2 Gig Limit
> Hi
>
> We have a similar challenge
I looked into big tables for myself and everyone said
you need the raid option in MySQL. Now I'm not sure!
Thanks,
Steve
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Cc: "Steve Vernon" <
Hello,
Does the 2 Gig file size limit on Linux get broken when I have a hardware
raid controller?
My ISP says I don't need the raid option activated on MySQL.
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hello,
I have read and searched the internet, but I cannot find much on getting
mysql to return German and other languages months. Is there codes you use?
I really would prefer to use the English MySQL (if there is such a one) as I
don't know much German, and need the error messages in English!
Previously I've asked questions in reagrds to this matter and thought I had
resolved this issue only to discover that it is not working as thought.
I am trying to create a Friend's Online list that displays the number of
friends in a members friend's list, with the exception of when the other
p
ssage ---
From: gerald_clark <[EMAIL PROTECTED]>
To: vernon <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Sent: Mon, 23 Jun 2003 11:13:53 -0500
Subject: Re: SQL query - 3 tables - 3rd one conatins records to not display
> And what happens if you leave off the 'distinct'
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
penpals_fav.user_id = penpals_privmsgs_block.user_id
WHERE penpals_fa
OK so now I have something like this:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_privmsgs_block left join penpals_fav on
penpals_privmsgs_block.user_id
WHERE penpals_fav.f
I have a SQL query that needs to reference three different tables. I'm
creating an online buddy list of members who are online. I have all of this
functioning but am trying to also reference another table where the user is
being blocked, in which case I do not what the user's name to be shown in
nse?
-- Original Message ---
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "vernon" <[EMAIL PROTECTED]>,
Sent: Thu, 19 Jun 2003 12:57:20 -0600
Subject: RE: Complex SQL involving 10 checkboxes
> Well, if one checkbox represents ages 1-5, anot
I'm trying to setup a SQL statement that involes using 10 different
checkboxes. The checkboxes repersent age groups that I need to forward to an
SQL statement. What would be the easiest way to do this?
As I think this through I'm thinking I have to check it 1 and 2 are checked
and not 3-9 and
Hey all,
I'm using phpNewsAds and am wanting to store images in MySQL. I have this
working on my Red Hat 7.2 Box and am moving to a new server running Red Hat
7.3 and of course, after moving the database the images are not being
dispalyed. The database, however, is working.
I'm assuming that
Hiya,
Any help would be appreciated!
Due to various hardware requirements, on our exiting server space is a
problem not speed. I store a lot of details of members, and have worked out
that I will save space by storing lastname's, firstname's etc in a seperate
table.
e.g.
lastname
But don't blame me if the query is grossly inefficient!
>
> Nick Elliott
>
> - Original Message -
> From: "Steve Vernon" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 31, 2002 10:44 AM
> Subject: Re: Year Lists
>
>
y).
up to 2003
Ideally if a year does not have any projects it would not be listed.
Any more help would be great, or I could be wrong and you could have the
answer!
Steve
> On Tue, 2002-12-31 at 14:53, Steve Vernon wrote:
> > Hiya,
> > I have a datab
Hiya,
I have a database about projects in a company, they all have a start
year and end year. If the projects have not ended then they get a end year
of . I have made a SQL command, given a year, works out with projects
are running in that year.
The company I am doing this for, wants b
MySQL as the filter stupidly does not match SELECT
Hiya,
How do you get a disctinct value from one collumn only? I am basically
using it to construct a dynamic menu, and need the menu names at a level.
Items are in one table, like CATEGORY, SUBCATEGORY, SUBSUBCATEGORY,
PAGE, ID
I cou
Hiya,
Have you got a rough timescale as to when 4.1 will come out?
If not then is there a way to simulate Unicode in MySQL?
THanks,
Steve
XX
-
Before posting, please check:
http://www.mysql.com/manual.php
There is a mysql database with a user table in it.
Add a new user, then reload the database! Remember to password the password.
And it will work!
> I been tring to read the docs on the website, and tried looking it up, but
> i'm getting confused. I am trying to make a database and a user.
> to m
Hello,
I am working on a website for a client which is basically biological
database, and some have pictures, I am not allowed to give more out. It will
be stored in MySQL.
Basically the client says there are about 500 million different items of
data, which each holds about 10 small text f
Somehow MySQL got broke and by removing MySQL and reinstalling it, removing
the /var/lib/mysql folder and restaring MySQL put me back at the where it
was once I first configured MySQL.
Then I copied the database folders back to the folder, but I had changed the
password and forgot to change
Sorry all!
I have resolved the issue.
-- Forwarded Message ---
From: "Vernon Webb" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sun, 13 Oct 2002 17:18:16 -0500
Subject: Lost connection to MySQL server during query
After s
After spending the entire day trying to figure out what the you-know-what
has happended to MySQL on my box, and after throughly messing things up and
fixing them again it has come down to a final error message when trying to
access some databases (some mind you, not all):
Lost connection to My
I have been using MySQL for nearly a year now with no problems, until now. I
rebooted my box this morning and since rebooting I have had nothing but
trouble.
First off I have noticed (I never looked before because I had no need to,
but there is nothing in my "msqld.log" They are all 0k.
Seco
Does anyone know of a solution that would allow me to setup faxing into a
MySQL database, preferably GNU?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I'm having trouble with Apache dying after log rotation and have tracked
it down to the mssqladmin. When I try the:
/usr/sbin/logrotate -f /etc/logrotate.conf
I get the following error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost
I've recently upgraded to the newest version of php and since doing so
many of my pages no longer work when it comes to updating, for whatever
reason. I simply do not have the time to waste trying to figure out why
so I'm thinking of going back to the previous revision I had on the box.
I'm ru
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
updated in MySQL, records that updated fine before. Any ideas why or how
to fix?
Thanks
-
Why, if I have MySQL is the MySQLAdmin not on the box? Is
there something else I must install? I've downloaded the
rpm from the web site and installed. When it boots, MySQL
does come up and it says that it has started without
errors.
What am I missing?
Hey All!
Anyone know the difference between MySQL and PostgreSQL?
Are the both pretty much the same? So far I like MySQL, but
find that MS SQL is far greater, but only because it has
much more. Anyone have any comments on the matter?
-
Alright then!
> database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
I'm sorry if I'm bothering people, some times I get the
feeling that I am, so please let me know if I'm out of line.
So now I've figured out that I need to use the
skip-show-database option which I have added to the my.cnf
file under [mysqld]. When I do this now and log in using
MySQLGUI as a
I posted about this before and got nothing back so I guess I
should take it a step at a time.
I've granted a user ALL PRIVILEGES on a particular database
and when they log in using MySQLGUI they can see all the
databases on the server. Even though they can't do anything
with them, I would pre
I'm using the:
LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
which works just fine. Only problem is the date column
which is formatted as such "4/11/1970" comes out as "-
00-
00"
The date field is setup as Field: "s_date", Type: "date",
Null, "YES", Key: BLANK, Default: "Nul
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu they also see the other datab
SQL server.
Anyone have a clue on this one?
Thanks,
Vernon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
41 matches
Mail list logo
