Reputation
417
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 3 15
Newest
 Critic
Impact
~29k people reached

  • 0 posts edited
  • 3 helpful flags
  • 44 votes cast
May
22
asked Need some help building a query to get info from several tables
May
22
accepted How to insert UNIQUE IDs values from several tables into events table
May
22
comment How to insert UNIQUE IDs values from several tables into events table
I have no experience with scripts or stored procedures, can you add that also to your answer? Right now I am trying to get this done from PHP side using a script and doing multiple queries
May
22
asked How to insert UNIQUE IDs values from several tables into events table
May
21
comment Function for generate a huge and possible random relationship between tables
Excellent answer, many thanks, works perfectly
May
21
accepted Function for generate a huge and possible random relationship between tables
May
21
comment Function for generate a huge and possible random relationship between tables
Lets said ~2000
May
21
comment Function for generate a huge and possible random relationship between tables
Lets said 100 relations, but would be better if I can made a COUNT first and then use that result for max to add
May
21
comment Function for generate a huge and possible random relationship between tables
Yes, this is the idea and if I can get real rows id (from media and emails tables) better
May
21
asked Function for generate a huge and possible random relationship between tables
Apr
26
comment How to enable queries logs in MariaDB
I have added SHOW command output to the main post but still not having that file, see the output of tail command: tailf /var/log/mysql/mysql-general.log result tailf: cannot stat "/var/log/mysql/mysql-general.log": No such file or directory
Apr
26
revised How to enable queries logs in MariaDB
added 9450 characters in body
Apr
25
comment How to enable queries logs in MariaDB
Nop, there is nothing at that path, even mysql directory isn't created under /var/ logs. Yes, there is a /etc/my.cnf` with this content: [client-server] # include all files from the config directory !includedir /etc/my.cnf.d1, how do I see the arguments? Yes I have restarted MariaDB and even the whole server
Apr
24
asked How to enable queries logs in MariaDB
Apr
7
comment Query MongoDB collection and find rows from 7 days ago
What if I can't change the data type right now? Any workaround?
Apr
7
comment Query MongoDB collection and find rows from 7 days ago
nothing just got the same error once and once, take a look here
Apr
7
comment Query MongoDB collection and find rows from 7 days ago
It's give me some JSON validation error: We encountered an error while parsing your JSON. Please check your syntax (e.g. ensure you are using double quotes around both your field names and values) and try again. I have doble quoted share_date_2 but still the same, why?
Apr
7
comment Query MongoDB collection and find rows from 7 days ago
@John nothing atm, still reading docs but without success
Apr
7
asked Query MongoDB collection and find rows from 7 days ago
Apr
7
accepted Get rows where lastLoginTimestamp is in last 7 days