Please use the Apache issue tracking system for new NetBeans issues (https://issues.apache.org/jira/projects/NETBEANS0/issues) !!
Bug 199894 - Extend the Auto Complete for MYSQL to include Data Definition Statements
Extend the Auto Complete for MYSQL to include Data Definition Statements
Status: NEW
Product: db
Classification: Unclassified
Component: MySQL
-S1S-
All All
: P3 with 2 votes (vote)
: TBD
Assigned To: Libor Fischmeistr
issues@db
http://forums.netbeans.org/viewtopic....
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-07-05 09:46 UTC by azizur
Modified: 2015-06-16 13:57 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
:


Attachments
auto completion doesn't show for example "CREATE" (43.84 KB, image/jpeg)
2011-07-05 09:46 UTC, azizur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description azizur 2011-07-05 09:46:35 UTC
Created attachment 109233 [details]
auto completion doesn't show for example "CREATE"

We need to have full set of DDL for auto-complete for mySQL.

Currently we auto-complete support for Table and record level.

Here are a list of Data Definition Statements:

12.1.1. ALTER DATABASE Syntax
12.1.2. ALTER EVENT Syntax
12.1.3. ALTER LOGFILE GROUP Syntax
12.1.4. ALTER FUNCTION Syntax
12.1.5. ALTER PROCEDURE Syntax
12.1.6. ALTER SERVER Syntax
12.1.7. ALTER TABLE Syntax
12.1.8. ALTER TABLESPACE Syntax
12.1.9. ALTER VIEW Syntax
12.1.10. CREATE DATABASE Syntax
12.1.11. CREATE EVENT Syntax
12.1.12. The CREATE FUNCTION Statement
12.1.13. CREATE INDEX Syntax
12.1.14. CREATE LOGFILE GROUP Syntax
12.1.15. CREATE PROCEDURE and CREATE FUNCTION Syntax
12.1.16. CREATE SERVER Syntax
12.1.17. CREATE TABLE Syntax
12.1.18. CREATE TABLESPACE Syntax
12.1.19. CREATE TRIGGER Syntax
12.1.20. CREATE VIEW Syntax
12.1.21. DROP DATABASE Syntax
12.1.22. DROP EVENT Syntax
12.1.23. DROP FUNCTION Syntax
12.1.24. DROP INDEX Syntax
12.1.25. DROP LOGFILE GROUP Syntax
12.1.26. DROP PROCEDURE and DROP FUNCTION Syntax
12.1.27. DROP SERVER Syntax
12.1.28. DROP TABLE Syntax
12.1.29. DROP TABLESPACE Syntax
12.1.30. DROP TRIGGER Syntax
12.1.31. DROP VIEW Syntax
12.1.32. RENAME DATABASE Syntax
12.1.33. RENAME TABLE Syntax
12.1.34. TRUNCATE TABLE Syntax 

The number refers the MySQL 5.1 Reference Manual
Comment 1 vicente.bissoli 2015-06-16 13:57:55 UTC
Not only for mysql, but for all compilant databases.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo