Re: mySQL Problem

Greetings, Steve.
In reply to Your message dated Friday, November 9, 2007, 13:05:21,

As far as field names is a strings, You can use any given name, even in
Your
local encoding, and You can use spaces too.

no, it's an alias for an object really. but, yes, you can name it whatever
you wish. there is plenty of documentation in *every* db about avoiding such
conventions, esp. reserved words as dbo names, like the plague.

Then you don't need the quotes - which, BTW, are a MySQL extension to
the SQL standard and won't work on any other RDBMS I'm familiar with.

MS SQL Server use square brackets in the same way.

so, you admit that mssql uses something DIFFERENT and PARTICULAR to alias?
you realize that your code becomes TIED to that db until you rewrite every
query to fit the NEXT db you want to use, don't you?

MS SQL uses different addressing schema anyway.
I always keep query sting templates in separate file, like localization
templates.
And I store them as constants to avoid modification at the time of script
execution.
So moving to different database is not a great issue. Smaller than
localization process.


--
Sincerely Yours, AnrDaemon <anrdaemon@xxxxxxxxxxx>

.

Relevant Pages

  • ANNOUNCE - Muldis::DB v0.0.0 released, in p5+p6
    ... I am pleased to announce the release of Muldis::DB version 0.0.0 for Perl 5 on CPAN. ... If you want to read all the Muldis::DB documentation that exists now, I recommend doing so in this order: ... Muldis::DB implements a D language as defined by Hugh Darwen and Chris Date, and presents a superior interface for working with the relational model of data, contrasted with SQL. ...
    (perl.dbi.users)
  • Re: Generating SQL
    ... > Scanning a bunch of column descripter classes for column ... a data dictionary documented in code - the value object class. ... > language that is uglier and/or less documented than SQL. ... > cannot find the documentation for your custom query API, ...
    (comp.object)
  • RE: Microsoft Jet SQL Reference
    ... The entire Jet 4.0 SQL Reference is on your hard drive in the following ... > I'm quite challenged by the CONSTRAINT clause documentation. ... > CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes ...
    (microsoft.public.access.queries)
  • Re: An efficient way to read data from excel
    ... Do you have some URLs for SQL documentation specific to this task? ... Administrator Drivers tab on my computer? ...
    (microsoft.public.scripting.wsh)
  • Re: Scanned Doc to OCR to Indexed SQL DB
    ... I'd suggest looking into SQL Server's full-text search capabilities. ... There's quite decent documentation in SQL Books Online. ... and uploading them to the their website. ...
    (microsoft.public.dotnet.framework.adonet)