Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1:3309 »Database: inlislite_v3
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:
Routines Documentation
There are no routines to display.
Name Action Type Returns
DROP PROCEDURE IF EXISTS `20newCollectionOpac` 20newCollectionOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `BrowseOpac` BrowseOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `GetWarningLoanDueDay` GetWarningLoanDueDay Edit Edit Execute Execute Export Export Drop Drop FUNCTION int(11)
DROP FUNCTION IF EXISTS `KATEGORY_UMUR` KATEGORY_UMUR Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(200)
DROP FUNCTION IF EXISTS `SPLIT_STR` SPLIT_STR Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(255)
DROP FUNCTION IF EXISTS `TO_MARC` TO_MARC Edit Edit Execute Execute Export Export Drop Drop FUNCTION text
DROP PROCEDURE IF EXISTS `TO_MARC` TO_MARC Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `countPencarianLanjutOpac1` countPencarianLanjutOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `countPencarianSederhanaOpac1` countPencarianSederhanaOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `countTelusurOpac1` countTelusurOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `detailCatalogOpac` detailCatalogOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `duplikat_katalog` duplikat_katalog Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `explode_table` explode_table Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedArticle` facedArticle Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedAuthorOpac1` facedAuthorOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedBahasaOpac1` facedBahasaOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedPublishLocationOpac1` facedPublishLocationOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedPublishYearOpac1` facedPublishYearOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedPublisherOpac1` facedPublisherOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `facedSubjectOpac1` facedSubjectOpac1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `getStatKlasSubjekKoleksiDibaca` getStatKlasSubjekKoleksiDibaca Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `getStatKlasSubjekKoleksiDipinjam` getStatKlasSubjekKoleksiDipinjam Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `get_koleksi_terimakasih` get_koleksi_terimakasih Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `get_next_no_pemijaman_id` get_next_no_pemijaman_id Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(20)
DROP PROCEDURE IF EXISTS `get_stat_jenis_pendidikan` get_stat_jenis_pendidikan Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `get_stat_jenis_pendidikan_bulan` get_stat_jenis_pendidikan_bulan Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `get_stat_jenis_pendidikan_tahun` get_stat_jenis_pendidikan_tahun Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `get_stat_kelas_subject_koleksi` get_stat_kelas_subject_koleksi Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `get_stat_range_umur` get_stat_range_umur Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `hasil35dec` hasil35dec Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(11)
DROP PROCEDURE IF EXISTS `insertTempLanjutArticle` insertTempLanjutArticle Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempLanjutArticle0` insertTempLanjutArticle0 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempLanjutOpac` insertTempLanjutOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempLanjutOpac0` insertTempLanjutOpac0 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempOpacSederhana` insertTempOpacSederhana Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempSederhanaArticle` insertTempSederhanaArticle Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempSederhanaOpac` insertTempSederhanaOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempSederhanaOpac0` insertTempSederhanaOpac0 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempSederhanaOpac123` insertTempSederhanaOpac123 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempTelusurArticle` insertTempTelusurArticle Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `insertTempTelusurOpac` insertTempTelusurOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `jaro_winkler_similarity` jaro_winkler_similarity Edit Edit Execute Execute Export Export Drop Drop FUNCTION float
DROP FUNCTION IF EXISTS `levenshtein` levenshtein Edit Edit Execute Execute Export Export Drop Drop FUNCTION int(11)
DROP FUNCTION IF EXISTS `levenshtein_ratio` levenshtein_ratio Edit Edit Execute Execute Export Export Drop Drop FUNCTION int(11)
DROP PROCEDURE IF EXISTS `marcCatalogOpac` marcCatalogOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `newCollectionOpac` newCollectionOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `pencarianLanjutLimitOpac` pencarianLanjutLimitOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `pencarianSederhanaOpacLimit1` pencarianSederhanaOpacLimit1 Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `regex_replace_master` regex_replace_master Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(1000)
DROP FUNCTION IF EXISTS `regexp_replace` regexp_replace Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(1000)
DROP PROCEDURE IF EXISTS `showCollectionOpac` showCollectionOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP PROCEDURE IF EXISTS `showKontenDigital` showKontenDigital Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `terbilang` terbilang Edit Edit Execute Execute Export Export Drop Drop FUNCTION varchar(5000)
DROP PROCEDURE IF EXISTS `topCollectionOpac` topCollectionOpac Edit Edit Execute Execute Export Export Drop Drop PROCEDURE
DROP FUNCTION IF EXISTS `umur` umur Edit Edit Execute Execute Export Export Drop Drop FUNCTION int(11)
With selected:With selected:
New
 Add routine Documentation