chikuru
- Yakawedzera kugona kushandisa izwi rekuti "
FILTER Β»ine aggregate mabasa, izvo zvinoita kuti zvikwanise kudzikisira kufukidzwa kwedata rakagadziriswa neaggregate basa kune zvinyorwa chete zvinogutsa mamiriro akapihwa; - Iyo "ORDER BY" block inopa rutsigiro rwe "
NULLS KUTANGA "Uye"NULLS ROKUPEDZISIRA Β»kuona nzvimbo yezvinhu zvine kukosha kweNULL paunenge uchironga; - Murairo "
.pora Β»kudzoreredza zvirimo mumafaira akakuvadzwa kubva kudhatabhesi; - Mukuwedzera
UBI rutsigiro rwakawedzerwaindexing kutaura ; - PRAGMA index_info uye PRAGMA index_xinfo yakawedzerwa kuti ipe ruzivo pamusoro pekuchengetedza marongero ematafura akagadzirwa mu "VASISINA ROWID" modhi;
- Yakawedzerwa API
sqlite3_drop_modules() , iyo inobvumidza iwe kurambidza otomatiki kurodha kwematafura chaiwo kubva pachishandiso; - Iyo database schema parser yakashandurwa kuratidza chikanganiso kana mhando, zita, uye tbl_name makoramu musqlite_master tafura yakuvadzwa kana yakabatana isiri muwritable_schema modhi;
- Iyo PRAGMA function_list, PRAGMA module_list uye PRAGMA pragma_list mirairo inogoneswa nekusarudzika. Kuti uchinje maitiro ekuvaka ekutanga, unofanirwa kujekesa "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
- Pamashandisirwo-anotsanangurwa SQL mabasa, iyo SQLITE_DIRECTONLY mureza inokurudzirwa, iyo inobvumidza iwe kurambidza kushandiswa kweaya mabasa mukati mezvinokonzeresa uye maonero.
Source: opennet.ru