![]() Any hints or help in the right direction would be great. So in summary I am not sure how to run these queries in series and to have the results be returned on separate lines. I would like to run these two queries (in series) and get results in a table that might look like: Which returns the following results in a table: This always sorts the column in an ascending order. I would like to run that query again with only one change to the data(the variable): In the content view of a table, I can click a column header to sort by that column. Which returns results in a table that look like this:ĭAM | Product_Vendor_Count | Detail_Vendor_Count | Total | Select Field128, COUNT(Field167) as Detail_Image_Count from file inner join keyword1 on file.FileID = keyword1.FileID inner join path on file.PathID = path.PathIDĪnd (keyword1.Field167 like CONCAT("%", "%") or keyword1.Field32 like CONCAT("%", "%")) and keyword1.Field128 = "Detail Image")Īnd (keyword1.Field167 like CONCAT("%", "%") or keyword1.Field32 like CONCAT("%", "%")) and keyword1.Field128 = "Detail Image"ĪND (FROM_UNIXTIME(CreateDate) between '' AND ''))) OR (path.Path like CONCAT("%/", "/%") and file.Online=1 and file.Dir =0 and keyword1.Field28 like "%Vendor%"Īnd (keyword1.Field167 like CONCAT("%", "%") or keyword1.Field32 like CONCAT("%", "%")) and keyword1.Field128 = "Product Image"ĪND (FROM_UNIXTIME(CreateDate) between '' AND '')) Where (path.Path like CONCAT("%/", "/%") and file.Online=1 and file.Dir =0 and keyword1.Field28 like "%Vendor%"Īnd (keyword1.Field167 like CONCAT("%", "%") or keyword1.Field32 like CONCAT("%", "%")) and keyword1.Field128 = "Product Image") (select Field128, COUNT(Field167) as Product_Vendor_Count fromįile inner join keyword1 on file.FileID = keyword1.FileID inner join path on file.PathID = path.PathID (select Product_Vendor_Count, SUM(Product_Vendor_Count) as Total from If still in doubt, use the 32-bit version. Mac OS X is fairly bitness-agnostic, so either should work. Otherwise (Core 2 Duo, Xeon, i3, i5, i7, anything else), you have a 64-bit CPU. If you have a Core Duo processor, you have a 32-bit CPU. Select as DAM, Product_Vendor_Count, SUM( Total - Product_Vendor_Count) as Detail_Vendor_Count, Total from Go to the Apple Menu and select 'About this Mac'. Ideally I could build a large multiple query that would return all of the results on separate lines. I currently have the following query that I would like to execute and then change some of the data and execute again. My question is around how to execute multiple queries and return the results on separate lines. I am a very novice MySQL user and utilize the Sequel Pro application for OS X to run queries against a MySQL database v.5.1.30.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |