Click here to Skip to main content
15,506,762 members
Home / Discussions / Database
   

Database

 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 6:05
Jassim Rahma21-Nov-14 6:05 
GeneralRe: Problem reading null Pin
GuyThiebaut21-Nov-14 6:48
professionalGuyThiebaut21-Nov-14 6:48 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 9:02
Jassim Rahma21-Nov-14 9:02 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 6:17
Jassim Rahma21-Nov-14 6:17 
GeneralRe: Problem reading null Pin
Jörgen Andersson21-Nov-14 7:02
professionalJörgen Andersson21-Nov-14 7:02 
GeneralRe: Problem reading null Pin
GuyThiebaut21-Nov-14 5:45
professionalGuyThiebaut21-Nov-14 5:45 
AnswerRe: Problem reading null Pin
Smart00328-Nov-14 5:47
professionalSmart00328-Nov-14 5:47 
Questionmysql decimal fromat like ##.## Pin
Gilbert Consellado20-Nov-14 14:12
professionalGilbert Consellado20-Nov-14 14:12 
I have decimal(10,2) table column, is there way to format it like if you have 10.02 it will display 10.02 then if you 10.50 it will display 10.5.

It look like that format of .ToString("##.##") in c#.

BTW this is on MySQL.

I just want to omit the last zero of the decimal.

I will appreciate for any help will come.

modified 20-Nov-14 19:30pm.

AnswerRe: mysql decimal fromat like ##.## Pin
Richard Andrew x6420-Nov-14 16:47
professionalRichard Andrew x6420-Nov-14 16:47 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:46
professionalGilbert Consellado22-Nov-14 14:46 
AnswerRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra21-Nov-14 6:50
professionalShweta N Mishra21-Nov-14 6:50 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:43
professionalGilbert Consellado22-Nov-14 14:43 
GeneralRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra23-Nov-14 3:06
professionalShweta N Mishra23-Nov-14 3:06 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado24-Nov-14 13:47
professionalGilbert Consellado24-Nov-14 13:47 
QuestionProblem in Insering Long text in mysql from c# Pin
Ramachandra12720-Nov-14 8:09
Ramachandra12720-Nov-14 8:09 
GeneralRe: Problem in Insering Long text in mysql from c# Pin
PIEBALDconsult20-Nov-14 8:33
professionalPIEBALDconsult20-Nov-14 8:33 
QuestionSQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 0:44
miss78618-Nov-14 0:44 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 3:53
mveRichard Deeming18-Nov-14 3:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 4:53
miss78618-Nov-14 4:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 7:00
mveRichard Deeming18-Nov-14 7:00 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 11:41
professionalPhilLenoir18-Nov-14 11:41 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78620-Nov-14 2:45
miss78620-Nov-14 2:45 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir20-Nov-14 4:13
professionalPhilLenoir20-Nov-14 4:13 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 4:41
professionalPhilLenoir18-Nov-14 4:41 
Questionsuggest various tables for shopping site Pin
smart_vikas12-Nov-14 19:53
smart_vikas12-Nov-14 19:53 

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.