: Don't waste your time securing data that doesn't need
to
be secured.
So, what are your requirements?
On 12/23/2012 09:11 PM, Chad Vernon wrote:
Hi there,
I'm designing an animation studio database to track assets across
multiple
shows. My original design
buy one of your products!
Lesson learned: Don't waste your time securing data that doesn't need to
be secured.
So, what are your requirements?
On 12/23/2012 09:11 PM, Chad Vernon wrote:
Hi there,
I'm designing an animation studio database to track assets across multiple
shows. My
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
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
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: Friday, October 31, 2003 4:16 PM
Subject: Re: Hardware Raid and 2 Gig Limit
On Fri
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:
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 [EMAIL PROTECTED]
Sent: Friday, October 31, 2003 10:44 AM
Subject: Re: Hardware Raid and 2 Gig
[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. Offsite backups with huge amounts of data,
without spending a fortune.
We
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!
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
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
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
---
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' ?
--
MySQL General Mailing List
---
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, another represents 6-9,
and another represents 10-15, then you have the checkboxes add
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
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
Martin,
Thanks for the reply.
Good plan but at the moment my query is like (had to alter it
slightly
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
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 database about projects in a company, they all have a start
year and end
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
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:
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
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
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.
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
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 spending the entire day trying to figure out
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
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:
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
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/
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: Null, Extra
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
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
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
.
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-mail [EMAIL
39 matches
Mail list logo