mysql语句生成_PHP实现的通过参数生成MYSQL语句类完整实例

最新推荐文章于 2021-03-25 15:22:48 发布
最新推荐文章于 2021-03-25 15:22:48 发布
阅读量135 收藏
点赞数
文章标签： mysql语句生成
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35843569/article/details/113465539
版权

本文实例讲述了PHP实现的通过参数生成MYSQL语句类。分享给大家供大家参考，具体如下：

这个类可以通过指定的表和字段参数创建SELECT ,INSERT , UPDATE 和 DELETE 语句。

这个类可以创建SQL语句的WHERE条件，像LIKE的查询语句，使用LEFT JOIN和ORDER 语句

/* *******************************************************************

Example file

This example shows how to use the MyLibSQLGen class

The example is based on the following MySQL table:

CREATE TABLE customer (

id int(10) unsigned NOT NULL auto_increment,

name varchar(60) NOT NULL default '',

address varchar(60) NOT NULL default '',

city varchar(60) NOT NULL default '',

PRIMARY KEY (cust_id)

) TYPE=MyISAM;

******************************************************************* */

require_once ( " class_mylib_SQLGen-1.0.php " );

$fields = Array ( " name " , " address " , " city " );

$values = Array ( " Fadjar " , " Resultmang Raya Street " , " Jakarta " );

$tables = Array ( " customer " );

echo " Result Generate Insert
" ;

$object = new MyLibSQLGen();

$object -> clear_all_assign(); // to refresh all property but it no need when first time execute

$object -> setFields( $fields );

$object -> setValues( $values );

$object -> setTables( $tables );

if ( ! $object -> getInsertSQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

echo " Result Generate Update
" ;

$fields = Array ( " name " , " address " , " city " );

$values = Array ( " Fadjar " , " Resultmang Raya Street " , " Jakarta " );

$tables = Array ( " customer " );

$id = 1 ;

$conditions [ 0 ][ " condition " ] = " id='$id' " ;

$conditions [ 0 ][ " connection " ] = "" ;

$object -> clear_all_assign();

$object -> setFields( $fields );

$object -> setValues( $values );

$object -> setTables( $tables );

$object -> setConditions( $conditions );

if ( ! $object -> getUpdateSQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

echo " Result Generate Delete
" ;

$tables = Array ( " customer " );

$conditions [ 0 ][ " condition " ] = " id='1' " ;

$conditions [ 0 ][ " connection " ] = " OR " ;

$conditions [ 1 ][ " condition " ] = " id='2' " ;

$conditions [ 1 ][ " connection " ] = " OR " ;

$conditions [ 2 ][ " condition " ] = " id='4' " ;

$conditions [ 2 ][ " connection " ] = "" ;

$object -> clear_all_assign();

$object -> setTables( $tables );

$object -> setConditions( $conditions );

if ( ! $object -> getDeleteSQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

echo " Result Generate List
" ;

$fields = Array ( " id " , " name " , " address " , " city " );

$tables = Array ( " customer " );

$id = 1 ;

$conditions [ 0 ][ " condition " ] = " id='$id' " ;

$conditions [ 0 ][ " connection " ] = "" ;

$object -> clear_all_assign();

$object -> setFields( $fields );

$object -> setTables( $tables );

$object -> setConditions( $conditions );

if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

echo " Result Generate List with search on all fields
" ;

$fields = Array ( " id " , " name " , " address " , " city " );

$tables = Array ( " customer " );

$id = 1 ;

$search = " Fadjar Nurswanto " ;

$object -> clear_all_assign();

$object -> setFields( $fields );

$object -> setTables( $tables );

$object -> setSearch( $search );

if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

echo " Result Generate List with search on some fields
" ;

$fields = Array ( " id " , " name " , " address " , " city " );

$tables = Array ( " customer " );

$id = 1 ;

$search = Array (

" name " => " Fadjar Nurswanto " ,

" address " => " Tomang Raya "

);

$object -> clear_all_assign();

$object -> setFields( $fields );

$object -> setTables( $tables );

$object -> setSearch( $search );

if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}

else { $sql = $object -> Result; echo $sql . "
" ;}

?>

类代码：

/*

Created By : Fadjar Nurswanto

DATE : 2006-08-02

PRODUCTNAME : class MyLibSQLGen

PRODUCTVERSION : 1.0.0

DESCRIPTION : class yang berfungsi untuk menggenerate SQL

DENPENCIES :

*/

class MyLibSQLGen

{

var $Result ;

var $Tables = Array ();

var $Values = Array ();

var $Fields = Array ();

var $Conditions = Array ();

var $Condition ;

var $LeftJoin = Array ();

var $Search ;

var $Sort = " ASC " ;

var $Order ;

var $Error ;

function MyLibSQLGen(){}

function BuildCondition()

{

$funct = " BuildCondition " ;

$className = get_class ( $this );

$conditions = $this -> getConditions();

if ( ! $conditions ){ $this -> dbgDone( $funct ); return true ;}

if ( ! is_array ( $conditions ))

{

$this -> Error = " $className::$funct Variable conditions not Array " ;

return ;

}

for ( $i = 0 ; $i < count ( $conditions ); $i ++ )

{

$this -> Condition .= $conditions [ $i ][ " condition " ] . " " . $conditions [ $i ][ " connection " ] . " " ;

}

return true ;

}

function BuildLeftJoin()

{

$funct = " BuildLeftJoin " ;

$className = get_class ( $this );

if ( ! $this -> getLeftJoin()){ $this -> Error = " $className::$funct Property LeftJoin was empty " ; return ;}

$LeftJoinVars = $this -> getLeftJoin();

$hasil = false ;

foreach ( $LeftJoinVars as $LeftJoinVar )

{

@ $hasil .= " LEFT JOIN " . $LeftJoinVar [ " table " ];

foreach ( $LeftJoinVar [ " on " ] as $var )

{

@ $condvar .= $var [ " condition " ] . " " . $var [ " connection " ] . " " ;

}

$hasil .= " ON ( " . $condvar . " ) " ;

unset ( $condvar );

}

$this -> ResultLeftJoin = $hasil ;

return true ;

}

function BuildOrder()

{

$funct = " BuildOrder " ;

$className = get_class ( $this );

if ( ! $this -> getOrder()){ $this -> Error = " $className::$funct Property Order was empty " ; return ;}

if ( ! $this -> getFields()){ $this -> Error = " $className::$funct Property Fields was empty " ; return ;}

$Fields = $this -> getFields();

$Orders = $this -> getOrder();

if ( ereg ( " , " , $Orders )){ $Orders = explode ( " , " , $Order );}

if ( ! is_array ( $Orders )){ $Orders = Array ( $Orders );}

foreach ( $Orders as $Order )

{

if ( ! is_numeric ( $Order )){ $this -> Error = " $className::$funct Property Order not Numeric " ; return ;}

if ( $Order > count ( $this -> Fields)){ $this -> Error = " $className::$funct Max value of property Sort is " . count ( $this -> Fields); return ;}

@ $xorder .= $Fields [ $Order ] . " , " ;

}

$this -> ResultOrder = " ORDER BY " . substr ( $xorder , 0 ,- 1 );

return true ;

}

function BuildSearch()

{

$funct = " BuildSearch " ;

$className = get_class ( $this );

if ( ! $this -> getSearch()){ $this -> Error = " $className::$funct Property Search was empty " ; return ;}

if ( ! $this -> getFields()){ $this -> Error = " $className::$funct Property Fields was empty " ; return ;}

$Fields = $this -> getFields();

$xvalue = $this -> getSearch();

if ( is_array ( $xvalue ))

{

foreach ( $Fields as $field )

{

if (@ $xvalue [ $field ])

{

$Values = explode ( " " , $xvalue [ $field ]);

foreach ( $Values as $Value )

{

@ $hasil .= $field . " LIKE '% " . $Value . " %' OR " ;

}

if ( $hasil )

{

@ $hasil_final .= " ( " . substr ( $hasil , 0 ,- 4 ) . " ) AND " ;

unset ( $hasil );

}

}

}

$hasil = $hasil_final ;

}

else

{

foreach ( $Fields as $field )

{

$Values = explode ( " " , $xvalue );

foreach ( $Values as $Value )

{

@ $hasil .= $field . " LIKE '% " . $Value . " %' OR " ;

}

}

}

$this -> ResultSearch = substr ( $hasil , 0 ,- 4 );

return true ;

}

function clear_all_assign()

{

$this -> Result = null ;

$this -> ResultSearch = null ;

$this -> ResultLeftJoin = null ;

$this -> Result = null ;

$this -> Tables = Array ();

$this -> Values = Array ();

$this -> Fields = Array ();

$this -> Conditions = Array ();

$this -> Condition = null ;

$this -> LeftJoin = Array ();

$this -> Sort = " ASC " ;

$this -> Order = null ;

$this -> Search = null ;

$this -> fieldSQL = null ;

$this -> valueSQL = null ;

$this -> partSQL = null ;

$this -> Error = null ;

return true ;

}

function CombineFieldValue( $manual = false )

{

$funct = " CombineFieldsPostVar " ;

$className = get_class ( $this );

$fields = $this -> getFields();

$values = $this -> getValues();

if ( ! is_array ( $fields ))

{

$this -> Error = " $className::$funct Variable fields not Array " ;

return ;

}

if ( ! is_array ( $values ))

{

$this -> Error = " $className::$funct Variable values not Array " ;

return ;

}

if ( count ( $fields ) != count ( $values ))

{

$this -> Error = " $className::$funct Count of fields and values not match " ;

return ;

}

for ( $i = 0 ; $i < count ( $fields ); $i ++ )

{

@ $this -> fieldSQL .= $fields [ $i ] . " , " ;

if ( $fields [ $i ] == " pwd " || $fields [ $i ] == " password " || $fields [ $i ] == " pwd " )

{

@ $this -> valueSQL .= " password(' " . $values [ $i ] . " '), " ;

@ $this -> partSQL .= $fields [ $i ] . " =password(' " . $values [ $i ] . " '), " ;

}

else

{

if ( is_numeric ( $values [ $i ]))

{

@ $this -> valueSQL .= $values [ $i ] . " , " ;

@ $this -> partSQL .= $fields [ $i ] . " = " . $values [ $i ] . " , " ;

}

else

{

@ $this -> valueSQL .= " ' " . $values [ $i ] . " ', " ;

@ $this -> partSQL .= $fields [ $i ] . " =' " . $values [ $i ] . " ', " ;

}

}

}

$this -> fieldSQL = substr ( $this -> fieldSQL , 0 ,- 1 );

$this -> valueSQL = substr ( $this -> valueSQL , 0 ,- 1 );

$this -> partSQL = substr ( $this -> partSQL , 0 ,- 1 );

return true ;

}

function getDeleteSQL()

{

$funct = " getDeleteSQL " ;

$className = get_class ( $this );

$Tables = $this -> getTables();

if ( ! $Tables || ! count ( $Tables ))

{

$this -> dbgFailed( $funct );

$this -> Error = " $className::$funct Table was empty " ;

return ;

}

for ( $i = 0 ; $i < count ( $Tables ); $i ++ )

{

@ $Table .= $Tables [ $i ] . " , " ;

}

$Table = substr ( $Table , 0 ,- 1 );

$sql = " DELETE FROM " . $Table ;

if ( $this -> getConditions())

{

if ( ! $this -> BuildCondition()){ $this -> dbgFailed( $funct ); return ;}

$sql .= " WHERE " . $this -> getCondition();

}

$this -> Result = $sql ;

return true ;

}

function getInsertSQL()

{

$funct = " getInsertSQL " ;

$className = get_class ( $this );

if ( ! $this -> getValues()){ $this -> Error = " $className::$funct Property Values was empty " ; return ;}

if ( ! $this -> getFields()){ $this -> Error = " $className::$funct Property Fields was empty " ; return ;}

if ( ! $this -> getTables()){ $this -> Error = " $className::$funct Property Tables was empty " ; return ;}

if ( ! $this -> CombineFieldValue()){ $this -> dbgFailed( $funct ); return ;}

$Tables = $this -> getTables();

$sql = " INSERT INTO " . $Tables [ 0 ] . " ( " . $this -> fieldSQL . " ) VALUES ( " . $this -> valueSQL . " ) " ;

$this -> Result = $sql ;

return true ;

}

function getUpdateSQL()

{

$funct = " getUpdateSQL " ;

$className = get_class ( $this );

if ( ! $this -> getValues()){ $this -> Error = " $className::$funct Property Values was empty " ; return ;}

if ( ! $this -> getFields()){ $this -> Error = " $className::$funct Property Fields was empty " ; return ;}

if ( ! $this -> getTables()){ $this -> Error = " $className::$funct Property Tables was empty " ; return ;}

if ( ! $this -> CombineFieldValue()){ $this -> dbgFailed( $funct ); return ;}

if ( ! $this -> BuildCondition()){ $this -> dbgFailed( $funct ); return ;}

$Tables = $this -> getTables();

$sql = " UPDATE " . $Tables [ 0 ] . " SET " . $this -> partSQL . " WHERE " . $this -> getCondition();

$this -> Result = $sql ;

return true ;

}

function getQuerySQL()

{

$funct = " getQuerySQL " ;

$className = get_class ( $this );

if ( ! $this -> getFields()){ $this -> Error = " $className::$funct Property Fields was empty " ; return ;}

if ( ! $this -> getTables()){ $this -> Error = " $className::$funct Property Tables was empty " ; return ;}

$Fields = $this -> getFields();

$Tables = $this -> getTables();

foreach ( $Fields as $Field ){@ $sql_raw .= $Field . " , " ;}

foreach ( $Tables as $Table ){@ $sql_table .= $Table . " , " ;}

$this -> Result = " SELECT " . substr ( $sql_raw , 0 ,- 1 ) . " FROM " . substr ( $sql_table , 0 ,- 1 );

if ( $this -> getLeftJoin())

{

if ( ! $this -> BuildLeftJoins()){ $this -> dbgFailed( $funct ); return ;}

$this -> Result .= " " . $this -> ResultLeftJoin;

}

if ( $this -> getConditions())

{

if ( ! $this -> BuildCondition()){ $this -> dbgFailed( $funct ); return ;}

$this -> Result .= " WHERE ( " . $this -> Condition . " ) " ;

}

if ( $this -> getSearch())

{

if ( ! $this -> BuildSearch()){ $this -> dbgFailed( $funct ); return ;}

if ( $this -> ResultSearch)

{

if ( eregi ( " WHERE " , $this -> Result)){ $this -> Result .= " AND " . $this -> ResultSearch;}

else { $this -> Result .= " WHERE " . $this -> ResultSearch;}

}

}

if ( $this -> getOrder())

{

if ( ! $this -> BuildOrder()){ $this -> dbgFailed( $funct ); return ;}

$this -> Result .= " " . $this -> ResultOrder;

}

if ( $this -> getSort())

{

if (@ $this -> ResultOrder)

{

$this -> Result .= " " . $this -> getSort();

}

}

return true ;

}

function getCondition(){ return @ $this -> Condition;}

function getConditions(){ if ( count (@ $this -> Conditions) && is_array (@ $this -> Conditions)){ return @ $this -> Conditions;}}

function getFields(){ if ( count (@ $this -> Fields) && is_array (@ $this -> Fields)){ return @ $this -> Fields;}}

function getLeftJoin(){ if ( count (@ $this -> LeftJoin) && is_array (@ $this -> LeftJoin)){ return @ $this -> LeftJoin;}}

function getOrder(){ return @ $this -> Order;}

function getSearch(){ return @ $this -> Search;}

function getSort(){ return @ $this -> Sort ;}

function getTables(){ if ( count (@ $this -> Tables) && is_array (@ $this -> Tables)){ return @ $this -> Tables;}}

function getValues(){ if ( count (@ $this -> Values) && is_array (@ $this -> Values)){ return @ $this -> Values;}}

function setCondition( $input ){ $this -> Condition = $input ;}

function setConditions( $input )

{

if ( is_array ( $input )){ $this -> Conditions = $input ;}

else { $this -> Error = get_class ( $this ) . " ::setConditions Parameter input not array " ; return ;}

}

function setFields( $input )

{

if ( is_array ( $input )){ $this -> Fields = $input ;}

else { $this -> Error = get_class ( $this ) . " ::setFields Parameter input not array " ; return ;}

}

function setLeftJoin( $input )

{

if ( is_array ( $input )){ $this -> LeftJoin = $input ;}

else { $this -> Error = get_class ( $this ) . " ::setFields Parameter input not array " ; return ;}

}

function setOrder( $input ){ $this -> Order = $input ;}

function setSearch( $input ){ $this -> Search = $input ;}

function setSort( $input ){ $this -> Sort = $input ;}

function setTables( $input )

{

if ( is_array ( $input )){ $this -> Tables = $input ;}

else { $this -> Error = get_class ( $this ) . " ::setTables Parameter input not array " ; return ;}

}

function setValues( $input )

{

if ( is_array ( $input )){ $this -> Values = $input ;}

else { $this -> Error = get_class ( $this ) . " ::setValues Parameter input not array " ; return ;}

}

}

?>

希望本文所述对大家PHP程序设计有所帮助。

知行晓政
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql语句生成器
05-11
用于易语言方便查询语句用的 可以很方便的写句子
php+生成mysql+语句,PHP实例：PHP通过参数来生成MYSQL语句类
weixin_33249666的博客
03-24 103
php/* *******************************************************************Example fileThis example shows how to use the MyLibSQLGen classThe example is based on the following MySQL table:CREATE TABLE c...
php mysql 语句生成工具,php 之批量生成 mysql 语句 注释
weixin_28455801的博客
03-25 92
{parent::__construct();/*加载项*/$this->load->model('Convers', 'conv');}/**/*** 获取所有数据*/public functionceshi(){//获取所有的账户信息$result=$this->conv->getAdmininfo();//获取所有的专家信息$result11=$this->co...
PHP实现的通过参数生成MYSQL语句类完整实例
10-22
主要介绍了PHP实现的通过参数生成MYSQL语句类,结合完整实例形式分析了生成MYSQL语句类的实现与使用技巧,需要的朋友可以参考下
PHP创建MySQL并引入后执行sql语句
weixin_30878361的博客
12-25 238
一：创建sql.php文件 <?php function sqlMethod($sql){ $servername = "localhost"; $username = "root"; $password = "root";// 创建连接 $conn = mysqli_connect($servername, $username, $password);...
PHP实例开发源码—通过参数生成MYSQL语句的PHP类.zip
11-23
这个"PHP实例开发源码—通过参数生成MYSQL语句的PHP类.zip"的资源提供了一个实用的方法，它允许开发者创建一个PHP类，该类可以自动生成符合需求的MySQL查询语句。这种做法提高了代码的可读性和可维护性，同时也减少...
PHP实例开发源码-通过参数生成MYSQL语句的PHP类 v1.4.zip
10-19
PHP实例开发源码—通过参数生成MYSQL语句的PHP类 v1.4.zip PHP实例开发源码—通过参数生成MYSQL语句的PHP类 v1.4.zip PHP实例开发源码—通过参数生成MYSQL语句的PHP类 v1.4.zip
基于PHP的通过参数生成MYSQL语句的PHP类v1.4源码.zip
最新发布
10-21
这个名为"基于PHP的通过参数生成MYSQL语句的PHP类v1.4源码.zip"的压缩包文件，其核心内容是提供了一个PHP类，用于帮助开发者更方便、安全地构建MySQL查询语句。在Web开发中，这种动态生成SQL语句的能力非常关键，...
php复杂的MYSQL原生语句编写
柚子哥哥i的博客
08-08 360
在此之前我发出了一个疑问： php框架中的方法与原生sql语句的区别？ php框架中的方法最终也是要被框架解析成sql语句来执行的，如果使用原生的sql效率会高一些，但是失去了一些灵活性和安全性（比如框架在解析的时候可能会对数据做安全性检查，唯一性检查等等，这就是使用框架的好处） 下面说说各种各样的sql编写吧 1，有A(id,sex, par, cl, c2)、B(id,age,c1,c...
mysql 生成类_封装的 mysql类， 和sql语句生成类
weixin_36290220的博客
01-27 80
host = $server['host'];$this->user = $server['user'];$this->pwd = $server['pwd'];$this->port = $server['port'];$this->dbname = $server['dbname'];$this->connect();}//End of functionpubl...
mysql&oracle;语句自动生成工具
06-10
解压之后安装使用，内部是mysql和oracle数据库生成工具，可以生成sql语句，连接查询。解压之后安装使用，内部是mysql和oracle数据库生成工具，可以生成sql语句，连接查询
sql语句生成器
04-06
sql语句生成器，自动生成sql语句。
php mysql代码生成_6个强大的PHP/Mysql代码生成器介绍
weixin_29467373的博客
01-19 115
用PHP和MYSQL编写一个数据库应用程序都会花费很多时间和精力 - 你要设计HTML格式，编写查询，执行验证 错误处理，测试应用程序等大量工作。一般来说，用PHP和MYSQL编写一个数据库应用程序都会花费很多时间和精力 - 你要设计HTML格式，编写查询，执行验证/错误处理，测试应用程序等大量工作。不过如果你使用PHP代码生成器，您可以节省您大量的时间并降低开发成本。目前主流代码生成器基本都是基...
mysql语句生成技巧
最帅程序猿的博客
01-03 258
mysql语句生成技巧 查询 学生的学号、姓名和选课的课程名和成绩 1）分析操作，80%查询，20%增删改 select 2）把展示的数据使用别名的方式呈现在select后面 select s.sid,s.sname,c.cname,sc.score 3）确定有还是没有的问题 如果有的问题，使用内连接或者外链接 如果没有的问题，使用外链接 使用连接罗列select后面字段所属的...
mysql数据字典自动生成语句
大牧关东
12-05 1653
mysql自动生成数据结构的语句(gym_%需替换成自己的表名前缀)： select distinct  a.TABLE_NAME as '表名', a.COLUMN_NAME as '字段名', a.COLUMN_COMMENT as '注释', a.COLUMN_TYPE as '类型长度', case when a.IS_NULLABLE='yes' then '√'else '
MySQL通过SQL语句生成实体类,spring boot整合mybatis+mysql自动生成实体类和sql语句
weixin_39630855的博客
03-24 322
首先，在pom.xml中配置generator 插件所对应的配置文件 ${basedir}/src/main/resources/generator/generatorConfig.xml 接下来是所需要的generatorConfig.xml,项目中位置如下： generatorConfig.xml文件内容如下：1 2 34 5 6 7 9 10 11 ...
mysql语句生成在线_在线数据库表(sql语句)生成java实体类工具
weixin_32310195的博客
01-19 2395
相信每个做java开发的读者，都接触过SQL建表语句，尤其是在项目开发初期，因为数据库是项目的基石。在现代项目开发中，出现了许多ORM框架，通过简单的实体映射，即可实现与数据库的交互，然而我们最初设计的一定是数据库表结构，而不是实体类。实体类仅仅是对底层数据结构的有损压缩，它仅仅是数据载体，不具备数据归档能力。因此，很多时候，我们需要将原始的SQL建表语句转换成java实体类，这项工作看似简单，但...
json数据自动生成MySQL建表语句
刺客python
09-14 4808
#_*_coding:utf-8_*_ #author: cike #date: 18-9-13 import pymysql.cursors connection = pymysql.connect(host='localhost', port = 3306, user='roo...
PowerDesinger生成mysql语句
观山是山
06-14 1488
今天跟着大牛学了一招，PowerDesinger生成mysql语句，赶紧记下来，省的过些时候忘记。 要想探知其是如何实现的，对于初级选手难度颇大，首先不得深入学习powerdesinger，深入了解mysql，这些空闲时间去探知。 逻辑表建立之后首先利用tools将其转化为物理表 tools>Generate Physical Data Model如图： 然后上方便多了一个Databa
MySQL基础查询语句详解与实例
MySQL查询语句是数据库管理的核心组成部分，它支持数据的检索、更新和管理。本文档提供了对MySQL查询语句的基本介绍...通过掌握这些基础和高级查询技巧，您可以有效地管理和操作MySQL数据库，实现各种数据操作和分析。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值