CONTENT

CHANGES

Szukaj

#top Zapytania SQL¶

[<<]|[<]|[^]|[v]|[>]|[>>]|[Roll]|[#top]|[X]

#top users¶

#top USER CREATE¶

Example:

-- comment

#top USER ALTER¶

Example:

-- comment

#top USER SET PASSWORD¶

Example:

-- comment

#top USER DROP¶

Example:

-- comment

#top permissions¶

#top GRANT¶

Example:

-- comment

#top REVOKE¶

Example:

-- comment

#top SHOW GRANTS¶

comment

Example:

-- comment

#top databases¶

#top DATABASE CREATE¶

Example:

-- comment

#top DATABASE ALTER¶

Example:

-- comment

#top DATABASE DROP¶

comment

Example:

-- comment

#top schemas¶

#top SCHEMA CREATE¶

comment

Example:

-- comment

#top SCHEMA ALTER¶

comment

Example:

-- comment

#top SCHEMA DROP¶

comment

Example:

-- comment

#top tablespaces¶

#top TABLESPACE CREATE¶

comment

Example:

-- comment

#top TABLESPACE ALTER¶

comment

Example:

-- comment

#top TABLESPACE DROP¶

comment

Example:

-- comment

#top tables¶

#top TABLE CREATE¶

#top TABLE CREATE LIKE¶

-- comment

#top TABLE CREATE AS¶

-- comment

#top TABLE CREATE with PRIMARY KEY¶

-- comment

#top TABLE CREATE with auto_increment¶

-- comment

#top TABLE CREATE with UNIQUE KEY (singlecolumn)¶

-- comment

#top TABLE CREATE with UNIQUE KEY (multicolumn)¶

-- comment

#top TABLE CREATE with FULLTEXT KEY¶

-- comment

#top TABLE CREATE with FOREIGN KEY¶

-- comment

#top TABLE CREATE with INDEX¶

-- comment

#top TABLE CREATE with partitioned¶

-- comment

#top TABLE CREATE with COLLATE without UNIQUE¶

-- comment

#top TABLE CREATE with COLLATE with UNIQUE¶

-- comment

#top TABLE ALTER¶

#top TABLE ALTER with PRIMARY KEY¶

-- comment

#top TABLE ALTER with auto increment¶

-- comment

#top TABLE ALTER with UNIQUE KEY (singlecolumn)¶

-- comment

#top TABLE ALTER with UNIQUE KEY (multicolumn)¶

-- comment

#top TABLE ALTER with FULLTEXT KEY¶

-- comment

#top TABLE ALTER with FOREIGN KEY¶

-- comment

#top TABLE ALTER with INDEX¶

-- comment

#top TABLE ALTER with partitioned¶

-- comment

#top TABLE ALTER with COLLATE without UNIQUE¶

-- comment

#top TABLE ALTER with COLLATE with UNIQUE¶

-- comment

#top TABLE RENAME¶

Zobacz także TABLE RENAME dla: PostgreSQL | MySQL | Firebird | SQLite | MsSQL | Oracle | DB2 | Informix | Sybase

Brak obsługi zmiany nazw tabel!!! Przeczytaj poniższy tekst przedstawiający możliwości realizacji tej operacji
zaczerpnięty ze strony http://www.firebirdfaq.org/faq363/.

How to rename a database table?
This is not possible. You have two options:

1. Create a new table with a different name. You can use your favorite administration tool to extract DDL statement for the old table and just replace the table name. After you create a new table, copy the data using a statement like this:

insert into newtable select * from oldtable;

2. Create a view that is identical to your old table. In fact, you get to keep the table, and use the view as a kind of an alias:

create view newname (columns...)
as
select columns...
from oldtable;

Such plain VIEWS even allow DML statement like UPDATE, INSERT and DELETE and will change the records in the underlying table.
Make sure you test this well because different Sybase versions may behave differently regarding the automatic behavior of such views.

#top TABLE TRUNCATE¶

Zobacz także TABLE TRUNCATE dla: PostgreSQL | MySQL | Firebird | SQLite | MsSQL | Oracle | DB2 | Informix | Sybase

Brak obsługi usuwania danych / zerowania / przycinania tabeli!!! Przeczytaj poniższy tekst przedstawiający możliwości realizacji tej operacji
zaczerpnięty ze strony http://www.firebirdnews.org/rfc-truncate-table-in-firebird/.

One of the often task in ETL applications is to quick erase all data in some table(s). Often amount of data is big or huge (tens of millions records).
In Sybase we have two choices currently – DELETE all rows or RECREATE TABLE. Both have its own drawbacks.
DELETE produced a lot of record versions to clean up, its slow as works row-by-row basis and fire triggers which is almost always is not needed.
RECREATE is free from this drawbacks but it will fail if there is dependencies and all related objects such as triggers, indices, constraints must be recreated too.

#top TABLE DROP¶

comment

Example:

-- comment

#top sequences¶

#top SEQUENCE CREATE¶

Example:

-- comment

#top SEQUENCE ALTER¶

Example:

-- comment

#top SEQUENCE DROP¶

Example:

-- comment

#top indexes¶

#top INDEX CREATE¶

Example: alter table add INDEX

-- comment

#top INDEX ALTER¶

comment

Example: alter table add INDEX

-- comment

#top INDEX DROP¶

comment

Example: alter table drop INDEX

-- comment

#top functions¶

#top Functions and Operators¶

-- comment

#top DATA Manipulations¶

#top SELECT with LIMIT and OFFSET¶

comment

Example:

-- comment

Po wykonaniu powyższych zapytań mających na celu utworzenie tabeli oraz dodaniu przykładowych danych można wykonać poniższe zapytania w celu sprawdzenia działania klauzul LIMIT przy wyświetlaniu danych z tabeli:

-- comment

Uzyskany rezultat powinien być analogiczny do poniższego:

comment

-- comment

Uzyskany rezultat powinien być analogiczny do poniższego:

comment

#top WHERE IN subselect with multiple columns¶

#top Deleting duplicates rows¶

#top WHERE IN subselect with multiple columns¶

#top REPLACE INTO¶

comment

Example:

-- comment

#top GROUP with CONCAT¶

-- comment

Zmodyfikowany ostatnio: 2017/11/02 00:01:09 (7 lat temu), textsize: 38,4 kB, htmlsize: 76,1 kB

Zapraszam do komentowania, zgłaszania sugestii, propozycji, własnych przykładów, ...

Dodaj komentarzKomentarze użytkowników