方法名不区分大小写
A SAME TO B
<?php // SELECT * FROM `test` a $select = Asf\Db::QBS(); $select ->cols() ->from('test', 'a');
<?php use Asf\Db; // INSERT INTO `test` SET `user` = ? [BVALUES] lisi2 $insert = Db::QBI(); $insert->table('test')->set('user', 'lisi2'); // INSERT IGNORE INTO `test` SET `user` = ? [BVALUES] lisi2 $insert = Db::QBI(true); $insert->table('test')->set('user', 'lisi2');
<?php // UPDATE `test` SET `user` = ? where `pass` like ? [BVALUES] lisi2, %11111% $update = Asf\Db::QBU(); $update->table('test')->set('user', 'lisi2')->like('pass', '%11111%');
<?php // DELETE `test` WHERE `user` = ? AND `pass` like ? [BVALUES] lisi2, %11111% $delete = Asf\Db::QBD(); $delete->from('test')->where('user', 'lisi2')->like('pass', '%11111%');