PHP SQLBuilder\Universal\Query CreateIndexQuery::create Examples

Programming Language: PHP

Namespace/Package Name: SQLBuilder\Universal\Query

Class/Type: CreateIndexQuery

Method/Function: create

Examples at hotexamples.com: 1

PHP SQLBuilder\Universal\Query CreateIndexQuery::create - 1 examples found. These are the top rated real world PHP examples of SQLBuilder\Universal\Query\CreateIndexQuery::create extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

on(3)

create(1)

fulltext(1)

spatial(1)

toSql(1)

unique(1)

using(1)

Example #1

Show file

File: CreateIndexQueryTest.php Project: Ruyka/SQLBuilder

 public function testCreateIndexFunctional()
 {
     // CREATE INDEX on tokens (substr(token), 0, 8)
     $q = new CreateIndexQuery();
     $q->create('idx_salary')->on('employees', ['substr(token)', 0, 8]);
     $this->assertSql('CREATE INDEX `idx_salary` ON `employees` (substr(token),0,8)', $q);
 }