User ReynierPM - Database Administrators Stack Exchange

bio	website	reynierpm.site90.com
	location	Caracas, Venezuela
	age	29
visits	member for	1 year, 2 months
	seen	Mar 21 at 20:41
stats	profile views	33

	345 reputation	bio	website	reynierpm.site90.com	visits	member for	1 year, 2 months
29 badges		location	Caracas, Venezuela		seen	Mar 21 at 20:41

1

vote

2

answers

76

views

Database and query optimizacion

mar 21 at 2:32 ReynierPM 345

1

vote

2

answers

76

views

How to get non repeat results

mysql join

feb 28 at 14:52 Phil 10.3k

1

vote

1

answer

75

views

How to get non-deleted messages for one user_id if the same user_id appears in two tables at same time?

mysql query

sep 26 at 1:09 Max Vernon 4,272

2

votes

1

answer

79

views

Count total where owner_user_id = some_value and deleted_by_owner = 0 or to_user_id = some_value and deleted_by_to = 0

mysql sql query mysql-5.5

sep 12 at 15:52 Max Vernon 4,272

1

vote

1

answer

129

views

Get and count all blog posts and all users that fits a LIKE condition (two sepparated queries)

mysql query mysql-5.5 query-performance

aug 27 at 22:00 wes.stueve 63

0

votes

0

answers

58

views

How to perform several operations at DB level

mysql mysql-5.5 functions

aug 27 at 13:45 ReynierPM 345

0

votes

1

answer

91

views

How to set unique columns combination

mysql database-design mysql-5.5 constraint

aug 23 at 13:36 ypercube 9,348

4

votes

1

answer

65

views

Will these queries return the same results?

mysql query mysql-5.5 query-performance

aug 19 at 1:56 Erwin Brandstetter 9,356

2

votes

1

answer

130

views

Need some help with this query get all status and their associated comments of me and all my friends

mysql query mysql-5.5 query-performance

aug 16 at 17:58 Mr.Brownstone 3,546

1

vote

1

answer

103

views

Several values from different tables

mysql mysql-5.5 query-performance

aug 14 at 19:46 ReynierPM 345

0

votes

1

answer

138

views

Is possible to optimize this query or it's already optimized?

mysql query mysql-5.5 query-performance

aug 13 at 22:20 HLGEM 2,341

1

vote

0

answers

86

views

Get all comment.message, status.message, users.* and profiles.* where users.user_id exists in friend.friend_id or friend.user_id

mysql query query-performance select

aug 13 at 18:34 ReynierPM 345

0

votes

1

answer

43

views

Why this query returns rows that I don't want to be there

mysql query select

aug 8 at 16:27 dezso 4,234

2

votes

1

answer

372

views

Extract some columns data from one table and insert into multiple tables

mysql query mysql-5.5 insert

jul 27 at 20:01 RolandoMySQLDBA 42.9k

3

votes

1

answer

131

views

Get profiles values where message.sender_user_id = profile.user_id

mysql sql query mysql-5.5 query-performance

jul 12 '12 at 22:20 Aaron Brown 2,596

2

votes

4

answers

325

views

One table with many rows or many tables with a few rows

mysql database-design performance database-recommendation

jun 20 '12 at 22:33 Rick James 1,529

1

vote

1

answer

36

views

Get wall_post and profile data for several users

mysql query query-performance

jun 6 '12 at 20:50 RolandoMySQLDBA 42.9k

2

votes

1

answer

24

views

Get the rows where id_user_rq exists in id_user_ap and viceversa

mysql query

jun 5 '12 at 20:40 RolandoMySQLDBA 42.9k

2

votes

1

answer

94

views

Get the id_user_app if not exists in id_user_rq

mysql query query-performance

jun 5 '12 at 20:34 RolandoMySQLDBA 42.9k

3

votes

3

answers

3

kviews

How to select/count rows where the same value exists in a column but not in other column all at the same table

mysql query subquery

may 17 '12 at 23:29 John DaCosta 370

2

votes

3

answers

139

views

How to get all non deleted messages from one user

mysql query mysql-5 query-performance

may 15 '12 at 15:13 RolandoMySQLDBA 42.9k

1

vote

2

answers

110

views

Why are my results returned twice?

mysql sql query query-performance

may 10 '12 at 20:24 jcho360 468

2

votes

1

answer

74

views

SELECT for values in a table

mysql query

may 9 '12 at 0:55 Erwin Brandstetter 9,356

2

votes

2

answers

439

views

Help with this SELECT in the same table

mysql query

may 9 '12 at 0:35 Erwin Brandstetter 9,356

3

votes

1

answer

95

views

Human relations between users

mysql database-design

apr 18 '12 at 17:06 Phil 10.3k

ReynierPM

25 Questions