Reputation
433
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 3 16
Impact
~31k people reached

  • 0 posts edited
  • 3 helpful flags
  • 49 votes cast
2d
asked Error: This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table
2d
reviewed Approve INSERT/UPDATE in same query from previous SELECT with some singularities
2d
comment INSERT/UPDATE in same query from previous SELECT with some singularities
It works fine, so tested on MariaDB. thx
2d
accepted INSERT/UPDATE in same query from previous SELECT with some singularities
2d
comment INSERT/UPDATE in same query from previous SELECT with some singularities
Still not working for me, can you just edit your answer by adding the DELIMITERS part?
2d
comment INSERT/UPDATE in same query from previous SELECT with some singularities
I'm getting this error DECLARE vPOSICION INT DEFAULT 0; [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 while try to execute the query for create the function, any advice?
2d
comment INSERT/UPDATE in same query from previous SELECT with some singularities
This doesn't work I got this error: [Err] 1582 - Incorrect parameter count in the call to native function 'UCASE'
Jun
29
asked INSERT/UPDATE in same query from previous SELECT with some singularities
Jun
2
awarded  Popular Question
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