SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
'Insert handler must be a callback or IIdentityInsert instance'
1
  • /Source/Squid/MySql/Impl/Connectors/Objects/Primary/Insert/AbstractInsertHandler.php
'SHOW TABLES'
1
  • /Source/Squid/MySql/Impl/Command/CmdDB.php
"SHOW CREATE TABLE `$table`"
1
  • /Source/Squid/MySql/Impl/Command/CmdDB.php
'SELECT DATABASE()'
1
  • /Source/Squid/MySql/Impl/Command/CmdDB.php
'SELECT GET_LOCK(?, ?)'
1
  • /Source/Squid/MySql/Impl/Command/CmdLock.php
'DELETE FROM ' . $this->getPart(CmdDelete::PART_FROM) . ' ' . Assembly::appendWhere($this->getPart(CmdDelete::PART_WHERE), true) . Assembly::appendOrderBy($this->getPart(CmdDelete::PART_ORDER_BY)) . Assembly::append('LIMIT', $this->getPart(CmdDelete::PART_LIMIT))
1
  • /Source/Squid/MySql/Impl/Command/CmdDelete.php
'SELECT LAST_INSERT_ID()'
1
  • /Source/Squid/MySql/Impl/Command/CmdController.php
'UPDATE ' . ($this->getPart(CmdUpdate::PART_IGNORE) ? 'IGNORE ' : '') . $this->getPart(CmdUpdate::PART_TABLE) . ' ' . Assembly::appendSet($this->getPart(CmdUpdate::PART_SET), true) . Assembly::appendWhere($this->getPart(CmdUpdate::PART_WHERE), true) . Assembly::appendOrderBy($this->getPart(CmdUpdate::PART_ORDER_BY)) . Assembly::appendLimit($this->getPart(CmdUpdate::PART_LIMIT), $this->getBind(CmdUpdate::PART_LIMIT))
1
  • /Source/Squid/MySql/Impl/Command/CmdUpdate.php
'INSERT ' . ($this->getPart(CmdInsert::PART_IGNORE) ? 'IGNORE ' : '') . 'INTO `' . $this->getPart(CmdInsert::PART_INTO) . '` '
1
  • /Source/Squid/MySql/Impl/Command/CmdInsert.php
"SELECT EXISTS ($sql)"
1
  • /Source/Squid/MySql/Impl/Command/CmdDirect.php
"SELECT COUNT(*) FROM ($sql) as _sub_"
1
  • /Source/Squid/MySql/Impl/Command/CmdDirect.php
'SELECT ' . ($this->getPart(CmdSelect::PART_DISTINCT) ? 'DISTINCT ' : '') . Assembly::appendDirectly(($this->getPart(CmdSelect::PART_COLUMNS) ?: array('*')), ',')
1
  • /Source/Squid/MySql/Impl/Command/CmdSelect.php