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
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 adjus
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 happe
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 incre
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? Howeve
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
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 w
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 ba
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 E
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 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 bre
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 field
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, field
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 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 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 g
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 milli
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;
> +-+-
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
> -
19 matches
Mail list logo
