我有两个sql查询:
$query0=mysql_query("SELECT caseNumber FROM shipped_data WHERE palette='P0' AND shipInvoiceNumber='2011/229'");
$query1=mysql_query("SELECT caseNumber FROM shipped_data WHERE palette='P1' AND shipInvoiceNumber='2011/229'");
并使用下面的php脚本获取数据,
我有一张桌子,里面有关于电影的文章。每一篇文章都有一个标题,其中许多都有共同的短语。
我想对这些数据做一些分析,并提取这些常见的短语,并统计它们的用法。
下面是一个简单的例子:
Title
------------------------------------------------
John cannot connect to Asian number
The backup service cannot connect to the client
Mary cannot connect her laptop to the network
从这些数据中,我希望能够提取以下内容:
Phrase
例如,One mysql server machine A has One table called "tableA" under in a database called databaseA, another mysql server machine B has one table called "tableB" under in a database called databaseB.如何加入tableA和tableB?有什么好办法吗?