[Bug 157526] MySQL database names, table names and column names should be backticked

  • From:
  • To:
  • Subject: [Bug 157526] MySQL database names, table names and column names should be backticked
  • Date: Wed, 17 Jul 2013 22:16:54 +0000
  • Auto-submitted: auto-generated

https://netbeans.org/bugzilla/show_bug.cgi?id=157526


 changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #4 from 

 2013-07-17 22:16:54 UTC ---
The SQL identifier quote string is the double-quotation mark: "

I was writing that using it is a bad idea, if it is not needed and there might
be big behavioral changes in identifier handling in the DBMS. Then I
remembered, that I stumbled over code that realised that. 

Checked in netbeans 7.3 against a derby database:

1. Execute: create table "table" (id int, name varchar(255));
2. Right click on the newly created node "table" under the "Tables" node
3. select "View data"

You get this sql:

select * from APP."table";

This is the intended syntax. I'll asume this is similar handled for mysql (my
server is down, so can't check right now).

-- 
Configure bugmail: https://netbeans.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.


[Bug 157526] MySQL database names, table names and column names should be backticked

matthias42 07/17/2013

Project Features

About this Project

DB was started in November 2009, is owned by Antonin Nebuzelsky, and has 113 members.
By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20131025.e7cbc9d). © 2013, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
 
 
Close
loading
Please Confirm
Close