Click here to Skip to main content
15,435,939 members
Home / Discussions / Database
   

Database

 
GeneralRe: Open Office Database Pin
Bram van Kampen2-Jul-21 14:54
MemberBram van Kampen2-Jul-21 14:54 
QuestionSelect with pivot Pin
Ismael Oliveira 202119-Jun-21 18:25
MemberIsmael Oliveira 202119-Jun-21 18:25 
AnswerRe: Select with pivot Pin
CHill6023-Jun-21 4:50
mveCHill6023-Jun-21 4:50 
GeneralRe: Select with pivot !! Pin
User 1407655213-Jul-21 21:34
MemberUser 1407655213-Jul-21 21:34 
GeneralRe: Select with pivot !! Pin
CHill6014-Jul-21 3:50
mveCHill6014-Jul-21 3:50 
GeneralRe: Select with pivot !! Pin
User 1407655214-Jul-21 3:58
MemberUser 1407655214-Jul-21 3:58 
GeneralRe: Select with pivot !! Pin
CHill6014-Jul-21 4:09
mveCHill6014-Jul-21 4:09 
QuestionAbout MySQL table permission removal failed Pin
Member 1105472311-Jun-21 8:00
MemberMember 1105472311-Jun-21 8:00 
Hello:

My MySQL database version is 5.6.35 and I use InnoDB.

I want to remove the Delete and Drop Table permissions of the user U1 from the table T1 in the db1 database.
The operating instructions are as follows:

<pre lang="SQL">
Revoke delete,drop on db1.T1 from U1;


No error message appeared after execution.

But after execution, the user U1 can still use the DELETE command to delete the data row in the data table T1.
You can also use the DROP TABLE command to delete the data table T1.

Thanks for replying.
AnswerRe: About MySQL table permission removal failed Pin
Richard Deeming13-Jun-21 22:09
mveRichard Deeming13-Jun-21 22:09 
QuestionSandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani8-Jun-21 20:40
MemberMohammad Salmani8-Jun-21 20:40 
AnswerRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Richard MacCutchan8-Jun-21 21:55
mveRichard MacCutchan8-Jun-21 21:55 
AnswerRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp29-Jun-21 1:35
MemberSeeSharp29-Jun-21 1:35 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani9-Jun-21 3:08
MemberMohammad Salmani9-Jun-21 3:08 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp29-Jun-21 3:39
MemberSeeSharp29-Jun-21 3:39 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
David Mujica9-Jun-21 4:25
MemberDavid Mujica9-Jun-21 4:25 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mycroft Holmes9-Jun-21 12:36
professionalMycroft Holmes9-Jun-21 12:36 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp210-Jun-21 1:25
MemberSeeSharp210-Jun-21 1:25 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mycroft Holmes10-Jun-21 12:09
professionalMycroft Holmes10-Jun-21 12:09 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani10-Jun-21 21:53
MemberMohammad Salmani10-Jun-21 21:53 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp211-Jun-21 1:20
MemberSeeSharp211-Jun-21 1:20 
QuestionLoad JSON file from network location Pin
Member 144746073-Jun-21 7:36
MemberMember 144746073-Jun-21 7:36 
AnswerRe: Load JSON file from network location Pin
Member 144746073-Jun-21 8:42
MemberMember 144746073-Jun-21 8:42 
AnswerRe: Load JSON file from network location Pin
Mycroft Holmes3-Jun-21 12:15
professionalMycroft Holmes3-Jun-21 12:15 
QuestionSQL Server 2010, smalldatetime insert Pin
jkirkerx1-Jun-21 14:52
professionaljkirkerx1-Jun-21 14:52 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Mycroft Holmes1-Jun-21 21:31
professionalMycroft Holmes1-Jun-21 21:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.