Posts by Robson Martins Lopes • 1 point

• -4

  votes

  2

  answers

  1017

  views

  A: Prevent DROP TABLE

  Often those who have advanced knowledge think they no longer need to research! CREATE TRIGGER [Trg_notDropTable] ON DATABASE FOR DROP_TABLE AS BEGIN SET NOCOUNT ON; DECLARE @data XML; DECLARE…

  sql database sqlite sqlite3 permissions

  answered 5 years, 7 months ago Robson Martins Lopes 1

• -2

  votes

  1

  answer

  119

  views

  A: group per SQL query

  The correct thing would be for you to have the following structure.. post category post1 categoria1 post1 categoria2 post2 categoria1 post2 categoria3 then you could easily list the distinct…

  mysql sql

  answered 7 years, 4 months ago Robson Martins Lopes 1