Lines Matching refs:id
69 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) NOT NULL UNIQUE)');
78 …$sql = 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int NULL, val VARCHAR(255) NULL)';
81 $sql = 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(255))';
89 var_dump($db->query('SELECT id, name FROM classtypes ORDER by id')->fetchAll(PDO::FETCH_COLUMN|PDO:…
97 $stmt = $db->prepare('SELECT id FROM classtypes WHERE name=:cname');
107 $stmt->bindColumn('id', $ctype);
118 $stmt = $db->prepare('INSERT INTO test VALUES(:id, :classtype, :val)');
119 $stmt->bindParam(':id', $idx);
162 …est.val AS val FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id')->fetchAll(PDO::FET…
171 …t LEFT JOIN classtypes ON test.classtype=classtypes.id WHERE (classtypes.id IS NULL OR classtypes.…
174 …t LEFT JOIN classtypes ON test.classtype=classtypes.id WHERE (classtypes.id IS NULL OR classtypes.…