Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 8227

A core SQL statement, SELECT retrieves data from one or more tables or other sources of row set data such as views or table-valued functions.

1
vote
2answers
I'm trying to running this query: SELECT * FROM (`default_users`) LEFT JOIN `default_profiles` ON `default_profiles`.`user_id` = `default_users`.`id` WHERE `default_users`.`group_id …
asked Aug 8 '12 by ReynierPM
2
votes
Yes @jon-seigel you're right and thanks for your suggestions didn't see it before :( I add some parentheses and now it works see the right query below: SELECT * FROM (default_users) LEFT JOIN …
answered Aug 8 '12 by ReynierPM
2
votes
0answers
', '05e9a0', 7, '127.0.0.1', 1, NULL, 1344890669, 1344891197, 'demo', NULL, NULL); I build this one: SELECT DISTINCT s.*, c.*, p.*, u.*, (SELECT f.friend_id FROM default_friend f WHERE (f.user_id = u.id … AND f.friend_id = 1 ) OR (f.friend_id=u.id AND f.user_id=1) LIMIT 1)) AS f_friend_id, (SELECT f.user_id FROM default_friend f WHERE (f.user_id = u.id AND f.friend_id = 1 ) OR (f.friend_id=u.id AND …
asked Aug 13 '12 by ReynierPM
0
votes
1answer
: SELECT u.id AS uid, u.username AS username, u.firstname AS ufirstname, u.lastname AS ulastname, u.email AS uemail, u.isactive AS uisactive, u.lastmodifieddate AS ulmd, t.id AS tid …
asked Sep 7 '15 by ReynierPM
3
votes
1answer
I need to update the row at pdone.targets so this is how the process should run: INSERT a new record on veevan.address_vod__c, then SELECT the current inserted row (the values) find the match on … pdone.targets and UPDATE columns UPDATE a record on veevan.address_vod__c, then SELECT the current updated row (the values) find the match on pdone.targets and UPDATE columns This is what I have so far …
asked Jul 13 '15 by ReynierPM