Search
 
SCRIPT & CODE EXAMPLE
 

SQL

eliminate zero from integer mysql

  REPLACE('0349010330', '0', '');
Comment

mysql decimal remove trailing zeros

SELECT TRIM(`column_name`)+0 FROM `table_name`;
Comment

PREVIOUS NEXT
Code Example
Sql :: postgres select as csv 
Sql :: mariadb hours between two dates 
Sql :: create table split string function in sql server 
Sql :: restroe pg_dump example 
Sql :: mysql local password denied 
Sql :: copy value from one column to another postgres 
Sql :: in mysql workbench contnent not feching 
Sql :: do postgresql 
Sql :: how to drop a unique constraint in sql 
Sql :: how to insert multiple rows in sql 
Sql :: how to delete the rows with null values in mysql 
Sql :: postgresql get date now 
Sql :: sqlite get last 
Sql :: sql command to show all tables 
Sql :: drop sequence 
Sql :: update con select postgresql 
Sql :: sql select case when 
Sql :: count in sql and diff 
Sql :: how to check table name in current database sql 
Sql :: create table in sql server 
Sql :: postgres like case insensitive 
Sql :: how to change column name in mysql 
Sql :: mysql load sql from file 
Sql :: mysql auerries to find the name starting with vowel letter 
Sql :: null value in column violates not-null constraint 
Sql :: change column data type sql 
Sql :: sqlite insert or update 
Sql :: min max sql 
Sql :: sql select date add day 
Sql :: all tables and views oracle 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =