I have 3 tables that I want to put together. A video table with an image table with all users' videos, images of all users and a camera table. I have a list of all images and videos and solving them
With prefix_videos table (videoid, users have ID, Cameraid, Videosize, date, delete, videolength, videoname) Prefix_cameras table with prefix_images table (imageid, user id, cameraid, imagesize, date, deleted, imagename)
(Userid, cameraid, ...)
Before this I only gave the video table so this query had given me what I needed:
Prefix_videos.videoid, prefix_videos.videonam E, prefix_videos.videosize, prefix_videos Videodatetime, prefix_videos.videolength, prefix_cameras.cameraname using FROM prefix_videos INNER prefix_cameras (userid, cameraid) WHERE prefix_videos.deleted IS NULL and prefix_videos.userid = xxx ordered by prefix_videos.datetime DESC But now I am adding an image table
imageid / videoid, cameraid, imagesize / videosize, date (either from the image or video table), videoname / imagename
Because now I'm combining the image and video table to give a result, I'm not sure The In comes another inner join it here?
Here is the check for the other important part of the tap, the ability to order these entries through deleted entries and dates whether it comes from images or videos. Text after "
itemprop =" text ">
You can make two separate selections for video and image, and then make them one together with the union to bring dirty part you want after afaik way that
* (select prefix_videos.videoid, prefix_videos.videoname, prefix_videos.videosize, prefix_videos. videodatetime, prefix_videos.videolength, using Preefiks_vijheintr Preefiks_comrs from Prefix_cameras. Kamrenam (Ugraid, Kamerad) WHERE Preefiks_ijheks. deleted IS Null and Prefix_Easac.UserID = xxx ORDER Prefix_Vesak Select DASC Union prefix_images.imageid, prefix_images.imagename, prefix_images.imagesize, prefix_images.imagesdatetime, prefix_images.videolength, prefix_cameras.cameraname FROM prefix_images INNER includes prefix_cameras (userid, cameraid) WHERE prefix_images.deleted iS nULL and prefix_images.userid = xxx ordered by prefix_images.datetime DESC) order by 'mycolumn' or select imageid Select imageid as 'imageid / videoid' from / videoid, cameraid, imagesize / videosize, date (either from image or video table), videoname / imagename, cameraid, imagesize 'Imagesize / videosize' in the region, the date, as 'videoname / imagename' prefix_images where ... as select videoid the Union as 'imageid / videoid', cameraid, videosize 'imagesize / videosize' In the form of 'videoname / imagename' videoname imagename prefix_videos where, as the date, the temptable inner 'MyColumn', temptable.selected_column = whatever_your_table. By joining whatever_your_table on equal_column order
Posted by
Unknown
at
03:22
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
Unknown
View my complete profile
Blog Archive
►
2015
(1886)
►
September
(203)
►
August
(208)
►
July
(224)
►
June
(210)
►
May
(230)
►
April
(195)
►
March
(209)
►
February
(201)
►
January
(206)
►
2014
(2117)
►
September
(239)
►
August
(251)
►
July
(226)
►
June
(208)
►
May
(229)
►
April
(199)
►
March
(255)
►
February
(275)
►
January
(235)
►
2013
(2011)
►
September
(199)
►
August
(228)
►
July
(210)
►
June
(222)
►
May
(217)
►
April
(229)
►
March
(243)
►
February
(221)
►
January
(242)
▼
2012
(1993)
►
September
(227)
►
August
(235)
►
July
(225)
►
June
(206)
►
May
(221)
▼
April
(216)
ruby on rails - Sidekiq worker not able to write t...
c# - Calling SignalR client from webfarm -
Facebook app creating a second group -
android - Save bitmap to file -
php - How to detect position of mouse cursor in a ...
How do you make JQuery to load images on page load...
c - Optimizing the nested for loop -
php - How do I parse a specific json data response? -
java - How do I access instantiated WebSockets in ...
c# - Remove special characters from XmlCompiledTra...
Android Viewpager OutOfMemoryError Fragment -
objective c - objc object pointing -
c++ - Priority queue in reverse order -
node.js - Grunt.js output and write contents of fo...
objective c - Xcode whitespace screwed up on git r...
ios - difference between Hybrid and Hardware decod...
hadoop - What exactly does the double colon mean i...
Unit testing ServiceStack REST webservices -
c++ - why there is a integer overflow in this mult...
php - Passing data directly to client -
binary - How to implement a logical shift (to the ...
Pass PHP variable to Javascript at a specific point -
android - How do I change my package name after al...
Android;Body of ProgressDialog? -
Is there something similar to array[1:] in java? -
How to stop python pandas from adding "00:00:00" t...
eclipse - NoClassDefFoundError on Google App Engine -
im writing a plugin for a python app, find i can't...
javascript - How to get the inside json from json ...
email - PermError SPF Permanent Error: Too many DN...
java - GWT client debugging with Eclipse -
javascript - Node.js/Express: Prevent AJAX HTML sn...
node.js - SALT and HASH using pbkdf2 -
web services - how to get the 1 million-th click o...
Calling Java Function from XSLT gives "Could not c...
r - randomize or permuting values in a data.frame -
amazon web services - HTTP Live Streaming via AWS ...
html5 - My javascript (for randomizing css3 animat...
Printing variable values to console visual c++ win...
asp.net - How to Check RadioButtonList when Option...
Using city names to put marker on the map instead ...
java - Need Conceptual Help Rendering a Heat Map -
jquery - Divide percentage amongst text inputs -
meteorite - trouble with filepicker script loading...
javascript - Strange issue with jQuery .hide() -
sed - Auto file names using awk -
http - Passing basic auth username to a shell scri...
javascript - Change User-Agent of audio tag -
c# - End Program After MessageBox is Closed -
How to wrap objects printed by jQuery html() funct...
RAILS: Availability of Resource after booking over...
Backbone.js - model.save() not firing a PUT request -
highcharts - How to fill area between two serieses...
surfaceview - Android multuple camera preview -
javascript - Undefined index: action in
C:\wamp\ww...
android - Making AutoCompleteTextView Drop Down NO...
c# - Read message body (raw xml) from MSMQ using N...
git - Check status of local Python relative to rem...
jQuery using post for associative array -
Bootstrap js files per demo page? -
ruby - Algorithm for discretizing a surface -
Django partial update without form submission -
python - Character only maintains movement while m...
objective c - iOS code skipping over dispatch_async -
Magento 1.6.1: How To Get Tracking Number From Ord...
objective c - Convert date in format 2013-06-20T17...
android - How to Change a TextView with the values...
javascript - How do I give an unchecked checkbox v...
tkinter - odd behavior with '' callback -
Execute custom action after file upload completed ...
Java audio playing error -
java - How to access Struts 2 variables in jQuery -
java - Where is PSVM in a struts MVC-2 web applica...
maven - How can I find the error which causes a re...
sql - Left Excluding join not working -
what is a socket in "MySQL Enterprise Edition Subs...
c++ - How to get smallest variable with C++11 user...
ajax - getting an error while using window.locatio...
javascript - Get Name Of Array Object In JSON -
scripting - PHP script is having trouble sending e...
google app engine - adding appengine eclipse plugi...
java - JavaFX Location is not set error message -
How to start front facing camera in android Using ...
error handling - shell ksh function parameter cont...
vb.net - Connecting to DB through internet -
database - Caching on different record levels -
vba - ExcelVBA - HttpReq via MSXML2.XMLHTTP - fetc...
java - Push notification on window phone -
jsf 2 - How to refer to a bound component in a Dat...
css - Why won't these DIVs align correctly? -
c++ - print string to file , why extra bits? -
java - getResourceStream unable to load newly crea...
azure - Failing to load ServiceBus Assembly when d...
c++ - QDir::setCurrent vs QFileInfo:: -
ssl - Scons in Mongodb -
command prompt - ZSH variable substitution in adam...
language agnostic - Where did concept of yield key...
Translating Python 2 code to Python 3 -
java - Insert if not exists into table -
jquery - Smooth page scrolling implementation? -
►
March
(206)
►
February
(227)
►
January
(230)
►
2011
(1964)
►
September
(220)
►
August
(222)
►
July
(219)
►
June
(224)
►
May
(219)
►
April
(206)
►
March
(216)
►
February
(221)
►
January
(217)
►
2010
(1952)
►
September
(230)
►
August
(202)
►
July
(221)
►
June
(207)
►
May
(213)
►
April
(199)
►
March
(234)
►
February
(244)
►
January
(202)
Powered by Blogger.