Search
 
SCRIPT & CODE EXAMPLE
 

SQL

eliminar ultimo carcacter mysql

SELECT col
     , /* ANSI Syntax  */ SUBSTRING(col FROM 1 FOR CHAR_LENGTH(col) - 2) AS col_trimmed
     , /* MySQL Syntax */ SUBSTRING(col,     1,    CHAR_LENGTH(col) - 2) AS col_trimmed
FROM tbl
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql community server 
Sql :: sql delete where in 
Sql :: delete from IN subquery 
Sql :: mysql table schema 
Sql :: t-sql check if data exists 
Sql :: import mysql dump database command line linux 
Sql :: convert columns to rows in sql server 
Sql :: oracle sql generate list of days 
Sql :: sql select where 
Sql :: power query add row 
Sql :: date get month number sql 
Sql :: update select mysql 
Sql :: oracle sql average 
Sql :: postgres create multiple index 
Sql :: Assign value to variable inside Dynamic SQL 
Sql :: postgres extract date from timestamp 
Sql :: mysql datetime format 
Sql :: how to duplicate mysql table 
Sql :: find a column by name in a sql server table 
Sql :: SQL add a totals of differemt rows of the same id 
Sql :: oracle lock user 
Sql :: mysql:5.6 syntax create table 
Sql :: 1422: Explicit or implicit commit is not allowed in stored function or trigger 
Sql :: oracle undo tablespace list by user 
Sql :: alter table query in mysql 
Sql :: sql date with month and year only 
Sql :: sql server python connection 
Sql :: delete record mysql 
Sql :: having clause in sql 
Sql :: carbon mysql d m y to y-m-d 
ADD CONTENT
Topic
Content
Source link
Name
3+4 =