Remove sau Trim Primul sau Ultimul Pu�ini Characters �n�untru MySQL Baz� de date cu SQL

Alt util fibros func�ie �n�untru MySQL baz� de date is TRIM() care voin�� a voi �ntoarcere un text fibros dup� removing art.hot. meciuri leading sau trailing characters, de asemenea known as prefixes sau suffixes. S�u’ been described by MySQL reference as func�ie that �ntoarcere art.hot. fibros str cu tot remstr prefixes sau suffixes removed. Dac� nici unul de la specifiers BOTH, LEADING, sau TRAILING is a da, BOTH is a asigura. remstr is op�iune �i, dac� nu specified, perioad� e�ti removed.

Syntax de TRIM():

TRIMBOTH([{ | LEADING | TRAILING} [remstr] De la] str), TRIMremstr([ De la] str)

Pentru example:

SELECT TRIM(’ bar‘);

voin�� a voi �ntoarcere ‘ bar’ ( perioad� dropped).

SELECT TRIMLEADING( ‘x’ DE LA ‘xxxbarxxx’);

voin�� a voi �ntoarcere ‘barxxx’ ( unic leading x characters is removed).

SELECT TRIMBOTH( ‘x’ DE LA ‘xxxbarxxx’);

voin�� a voi �ntoarcere ‘ bar’ (leading �i trailing xs is dropped).

SELECT TRIMTRAILING( ‘xyz’ DE LA ‘barxxyz’);

voin�� a voi �ntoarcere ‘barx’ (trailing xyz is clar).

This func�ie is multi-byte �n siguran��. �i it a putea de asemenea a fi folosit cu alt SQL virgul� such as UPDATE la spre parfum modification update direct on baz� de date mas� date cu SQL declara�ie folosire unealt� such as phpMyAdmin.

import: Art.hot. pagin� is machine a traduce �i provided "as is" f�r� warranty. Machine traducere Mai a fi difficult la spre understand. A face pe plac la refer la spreorigine Englez anghinar� oric�nd posibil.

Rela�ii Anghinar�

• Cum la spre Afl� �i Replace Text �n�untru MySQL Baz� de date folosire SQL
• A verifica �i Optimize MySQL Baz� de date Automatically cu Crontab/Cron
• MySQL Baz� de date Performance Tuning Cel mai bun Practices Vizual Tutorial
• Enable Logging de Lent �ntrebare ( lent �ntrebare Log) �n�untru MySQL Baz� de date
• Cum la spre Remove �i Drop Datafiles de la Tablespace �n�untru Oracle Baz� de date
• Uninstall �i Remove Multiple Baz� de date Instances de Microsoft SQL A servi 2005
• Cum la spre Escape Characters �n�untru Oracle PL/SQL �ntrebare
• Oracle Baz� de date Link
• Oracle EXP-00091 Error C�nd Export Baz� de date
• Scimbare Oracle Baz� de date User Password

This intrare was post on Luni, Aprilie 23rd, 2007 la 502: pm �i is dosar josBaz� de date. Tu po�i a urma orice r�spuns la spre this intrare g�t art.hot.RSS 2.0 feed. Tu po�iplecare un r�spuns,sau trackback de la al t�u own site.