<div>
Can you give the expected result from your eg .data ?
</div>

Can you give the expected result from your eg .data ?

<div>
<div class="content wysiwyg-content">
Hi, 
 
I would like to request an assistant. 
 
I have the following mysql table and column : 
 
Table clientid 
========== 
column 1 : no 
column 2 : name 
column 3 : domain 
 
Table list 
========== 
column 1 : no 
column 2 : status 
column 3 : domain 
 
 
May i know how to do mysql query to list the domain that is not exist in the other column &quot;domain&quot; above ? 
 
eg of data : 
 
clientid.domain 
============ 
abc1.com 
abc2.com 
abc3.com 
 
list.domain 
========= 
xyz1.com 
xyz2.com 
abc1.com 
 
 
Appreciates any assistant. 
 
 

</div>
</div>

Hi,

I would like to request an assistant.

I have the following mysql table and column :

Table clientid
==========
column 1 : no
column 2 : name
column 3 : domain

Table list
==========
column 1 : no
column 2 : status
column 3 : domain


May i know how to do mysql query to list the domain that is not exist in the other column "domain" above ?

eg of data : 

clientid.domain
============
abc1.com
abc2.com
abc3.com

list.domain
=========
xyz1.com
xyz2.com
abc1.com


Appreciates any assistant.




How to create mysql NOT EXISTS statement ?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.