ursitesion

Member for 10 years
Last seen more than a month ago

Summary

Reputation

2,071

2.1k
1.8k
1.5k

2020
2021
2022
2023

Top tag

mysql

Next privilege

2,500 Rep.

Create tag synonyms

Badges

7

32

45

Newest

Yearling

Next badge

0/1

Excavator

Questions

View all 46 questions

Score Activity Newest Views

61

Why use WHERE 1 or WHERE 1=1?

Dec 13, 2013

50

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

Dec 19, 2014

18

MySQL: Which join is better between left outer join and inner join

Aug 4, 2014

12

Is there any command to optimize all MySQL tables one by one automatically?

Apr 27, 2014

5

Difference between show status and show global status in mysql

Dec 3, 2013

Answers

Score Activity Newest

2

Unable to start mysql

Apr 22, 2014

2

How to determine if open_table_cache is set properly?

Nov 20, 2014

0

Trying to recover/import/transfer database from MySQL data dir

Dec 26, 2014

0

Large database - too much time spent opening and closing tables

Dec 12, 2013

Tags

View all 43 tags

mysql

2

Score

39

posts

mysql-5.1

2

Score

32

posts

linux

2

Score

11

posts

cache

2

Score

1

post

performance

0

Score

23

posts

Reputation

+20

MySQL: Which join is better between left outer join and inner join

+10

Is there any command to optimize all MySQL tables one by one automatically?

+20

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

+10

MySQL: fetch multiple global status and system variable in a single query

Badges

View all badges

7

gold badges

Famous Question

× 7

Oct 21, 2022

32

silver badges

Good Question

× 2

Apr 2, 2019
Yearling

× 10

Dec 3
Notable Question

× 20

Jan 13, 2021

45

bronze badges

Curious

Jul 2, 2014
Caucus

Aug 5, 2015
Tumbleweed

Dec 20, 2013

Accounts

View all 14 accounts

Database Administrators

2,071
7
32
45

997
6
17
27

988
2
15
26

333
1
2
5

111
5

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

31

upvotes

11

question votes

20

answer votes