This week's book giveaway is in the Java 9 forum.
We're giving away four copies of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications and have Sander Mak & Paul Bakker on-line!
See this thread for details.
Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to use sensitive keyword in mysql table  RSS feed

 
t sathya narayana
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
CREATE TABLE customer(ID int, Name varchar(72) SENSITIVE, Address varchar(120) SENSITIVE);

when i'm creating like as above it gives error in mysql. How to use sensitive keyword in mqsql.

i want to separate private and public columns from a table in coding part.
 
Tony Docherty
Bartender
Posts: 3270
82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Cross posted here

Please BeForthrightWhenCrossPostingToOtherSites (← click).
 
Paul Clapham
Sheriff
Posts: 22681
43
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I googled to find out what that "sensitive" keyword was supposed to do, but all I found was articles about whether various aspects of SQL were case-sensitive or not. So could you explain what its purpose is, and perhaps point to a database where it means something?
 
Amit Ghorpade
Bartender
Posts: 2856
10
Fedora Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
t sathya narayana wrote:i want to separate private and public columns from a table in coding part.


Never heard anything like that before. Could you please elaborate on what private and public columns mean.
 
Campbell Ritchie
Marshal
Posts: 56193
171
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This would fit better in our databases forum: moving.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 37382
531
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Per your cross post, I see that you read about the "sensitive" keyword in this paper. That paper is for a database prototype, not a real mysql database. It talks about using that keyword for encryption. Databases allow you to encrypt passwords. Is that what you are going for? If not, what are you trying to accomplish?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!