爱玺玺

public function demo5(){

        //使用hasWhere根据article的条件查询（注：comment与article有关联），同时使用with把article查询出来：

        $list = Comment::hasWhere('article',[["title","like",&q

class Customer extends Validate

{

protected $rule = [

select * from a left join b on a.id=b.id

union

select * from a right join b on a.id=b.id

package test;

import java.io.IOException;

import java.net.URI;

import java.net.URISyntaxException;

import java.net.http.HttpClient;

import java.net.http.HttpRequest;

import java.net.http.HttpResponse;

package test;

import java.io.IOException;

import java.net.URI;

import java.net.URISyntaxException;

import java.net.http.HttpClient;

import java.net.http.HttpRequest;

import java.net.http.HttpResponse;

package test;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.WebElement;

import org.openqa.selenium.chrome.ChromeDriver;

public class Test7 {

SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('zsb_ctmmsg');

获取指定数据库所有表

SELECT * FROM his.sys.tables;

上面his是指定的数据库

获取所有数据库所有表

use his;

SELECT * FROM INFORMATION_SCHEMA.TABLES;

双击目录浏览