Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql remove first character from string

UPDATE MyTable
SET MyColumn = RIGHT(MyColumn, LEN(MyColumn) - 1);
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle kill session by sql_id 
Sql :: setVal pgsql 
Sql :: postgres truncate with cascade 
Sql :: cursor in sql server 
Sql :: sql select roundup column 
Sql :: table infromation in sql server 
Sql :: sql comment header 
Sql :: rename table in mysql 
Sql :: oracle activate job 
Sql :: group by mysql and concatenate string 
Sql :: sql get table last modified time 
Sql :: mysql breakline on string 
Sql :: mssql get running queries 
Sql :: display total number of tables in mysql 
Sql :: inner join just one row 
Sql :: add column to table sql 
Sql :: conda install pymysql "windows" 
Sql :: create temporary table in mysql 
Sql :: woocommerce mysql price table 
Sql :: postgres list tables and row counts 
Sql :: get first 3 letters in sql 
Sql :: mysql one week ago 
Sql :: mysql query unique column 
Sql :: how to rename column in sql 
Sql :: oracle sql create view 
Sql :: t sql check column exists 
Sql :: show size database mysql 
Sql :: How to get todays date and current time in mysql 
Sql :: datetrunc 
Sql :: grant access on table in oracle 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =