On Fri, 2008-11-14 at 14:30 +, Mark Goodge wrote:
I wouldn't try to arbitrarily normalise the database for SQL
efficiency.
In a real-life situation, it's more important that the database
design
reflects your actual workflow and business requirements. Having a
field
that's empty 50%
On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
You can use the convert_tz function for this
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
_convert-tz
On 10/15/08 12:03 PM, Madan Thapa [EMAIL PROTECTED] wrote:
Hi,
Can we make adjustments in mysql
On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
On Fri, Oct 3, 2008 at 9:49 AM, Alex K [EMAIL PROTECTED] wrote:
Hello,
I have a table of a 1 million users. I want to add a flag called
delete if a user wants to delete his account. Note that this situation
does not happen a lot.
On Thu, 2008-09-18 at 09:58 +0100, Stut wrote:
Autonumber will accomplish that, so long as you don't delete any.
And
if you do, renumbering the bookings would cause more problems than
it
solved.
Autonumber has the possibility of gaps. When a record is insert, the
counter is
On Wed, 2008-09-17 at 23:29 +0100, Stut wrote:
On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
Our Japanese partners will notice and will ask. Similar things have
come up
before.
I want to be pro-active.
Notice what? Why would it be bad? What type of data are we dealing
with
On Thu, 2008-09-18 at 08:34 +1000, Res wrote:
Hi Peter,
On Wed, 17 Sep 2008, Peter Brawley wrote:
I'm looking at using the @ symbol
Don't. Restrict yourself to alphanums and '_'.
Thanks, but is there any technical reason where using @ might break
something? However if there's even
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code
in insert statements?
I have a client with a comments form that is being
bombarded with people inserting references to
their own sites, etc, and I need an effective way
to
On Thu, 2008-07-31 at 09:56 -0400, Jerry Schwartz wrote:
[JS] I added a dozen or so columns for a special purpose, and although MySQL
doesn't care I wanted them in a certain order that would be intuitive to a
user / programmer.
Why is a user looking at your database?
This is a security
On Thu, 2008-07-31 at 10:24 -0400, Jerry Schwartz wrote:
[JS] Users will have read-only access through MS Access, and have to filter
on various fields.
You're assuming that your users will never, ever be granted anything but
read-access to only the data they suppose to have, either by accident
On Thu, 2008-07-31 at 11:24 -0400, Perrin Harkins wrote:
On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz
[EMAIL PROTECTED] wrote:
Other than the fact that an ENUM can have many more values than a SET, is
there any particular reason to choose one over the other?
The only use for ENUM is to
On Thu, 2008-07-31 at 11:47 -0500, Chris W wrote:
My thought is you should develop an application that will give your
users the information they need with out direct access to the DB. My
thought is, if a user doesn't have a solid understanding of at least 1st
and 2nd normal form, and basic
On Wed, 2008-07-30 at 14:42 -0400, Jerry Schwartz wrote:
Is there any reasonable way of re-arranging the order of columns in a table
without losing their data? The best I could come up with was to copy the
table, empty it, and then do an INSERT . SELECT specifying the new order of
the fields.
On Mon, 2008-07-28 at 07:32 -0400, Gary Josack wrote:
Andrew Martin wrote:
Hello,
Is it permissible to order a clause such that the search term is the
first item (in the clause)?
standard:
field1 IN (123, 654, 789)
in question:
123 IN (field1, field2, field3)
I am
Why? Because it's Friday and I'm feeling silly :)
mysql SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
How can we normalize the tables? could you explain bit more?
Thanks,
Siva
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 million
On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote:
Hi all,
How do I get the file names from a certain directory in SQL?
SQL is designed to deal with RDBs, not the rest of the computer system.
I suggest you switch to a modern language such as Perl, Python, Ruby, or
even PHP. Each has a
On Thu, 2008-07-24 at 14:49 +0200, walter harms wrote:
hi list,
i have tables that look like this( 10.000 entries) :
id,
timestamp,
value
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab B where
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
my lines like these:
id title filed1
On Wed, 2008-07-23 at 12:10 -0400, [EMAIL PROTECTED] wrote:
Yes, sorry. I have a database that records ip of attacks on a customer
server, what I like to do get a count so that I can see what subnet is
doing the major of the attacks.
select ip from ipslimit 10;
19 matches
Mail list logo