Regular Expressions: REGEXP_LIKE

Regular Expressions: REGEXP_LIKE

MySQL :: MySQL 5.5 Reference Manual :: 11.7 Date and Time Functions

• DATE_FORMAT(date,format)
  Formats the date value according to the format string.
  The following specifiers may be used in the format string. The “%” character is required before format specifier characters.
  

  Specifier	Description
  %a	Abbreviated weekday name (Sun..Sat)
  %b	Abbreviated month name (Jan..Dec)
  %c	Month, numeric (0..12)
  %D	Day of the month with English suffix (0th, 1st, 2nd, 3rd, …)
  %d	Day of the month, numeric (00..31)
  %e	Day of the month, numeric (0..31)
  %f	Microseconds (000000..999999)
  %H	Hour (00..23)
  %h	Hour (01..12)
  %I	Hour (01..12)
  %i	Minutes, numeric (00..59)
  %j	Day of year (001..366)
  %k	Hour (0..23)
  %l	Hour (1..12)
  %M	Month name (January..December)
  %m	Month, numeric (00..12)
  %p	AM or PM
  %r	Time, 12-hour (hh:mm:ss followed by AM or PM)
  %S	Seconds (00..59)
  %s	Seconds (00..59)
  %T	Time, 24-hour (hh:mm:ss)
  %U	Week (00..53), where Sunday is the first day of the week
  %u	Week (00..53), where Monday is the first day of the week
  %V	Week (01..53), where Sunday is the first day of the week; used with %X
  %v	Week (01..53), where Monday is the first day of the week; used with %x
  %W	Weekday name (Sunday..Saturday)
  %w	Day of the week (0=Sunday..6=Saturday)
  %X	Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V
  %x	Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v
  %Y	Year, numeric, four digits
  %y	Year, numeric (two digits)
  %%	A literal “%” character
  %x	x, for any “x” not listed above

  Ranges for the month and day specifiers begin with zero due to the fact that MySQL permits the storing of incomplete dates such as '2014-00-00'.
  The language used for day and month names and abbreviations is controlled by the value of the lc_time_names system variable (Section 9.7, “MySQL Server Locale Support”).
  DATE_FORMAT() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ASCII characters.
  

  mysql> SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');
         -> 'Sunday October 2009'
  mysql> SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');
         -> '22:23:00'
  mysql> SELECT DATE_FORMAT('1900-10-04 22:23:00',
     ->                 '%D %y %a %d %m %b %j');
         -> '4th 00 Thu 04 10 Oct 277'
  mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00',
     ->                 '%H %k %I %r %T %S %w');
         -> '22 22 10 10:23:00 PM 22:23:00 00 6'
  mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V');
         -> '1998 52'
  mysql> SELECT DATE_FORMAT('2006-06-00', '%d');
         -> '00'

Sending Non-ASCII Text to MySQL in UTF8 Encoding

Sending Non-ASCII Text to MySQL in UTF8 Encoding


Puurrfffff !! "Onomatopeya de saturacion"
Necesito tiempo para entenderlo y traducirlo...

Reset mysql root password on Windows ( Metodo infalible)

Tras muchos quebraderos de cabeza tras olvidar la clave root del mysql en mi máquina local, por fin he descubierto como hacerlo sin problemas...

Muchos sitios web, hablan de instrucciones por linea de comandos, etc...
Todos estos métodos que he probado, siempre fallan, por alguna propiedad de nuestro servidor mysql... que causa un error e impide ejecutar las tareas que nos dictan..

Existe un método infalible.
Muchos habréis probado a desinstalar el mysql server, viendo con horror en la nueva instalación, como os pide el password antiguo una y otra vez...

Pues bien en Windows 7 existe una carpeta llamada ProgramData, que en otros windows estará en users/user/appdata o alguna ruta parecida...
borra la carpeta de mysql y reinstala tu mysql.. Problema resuelto.

Diréis vaya cosa...
Pues me da igual... este apunte es para mi!
ya que cada vez que olvido el password del root de mysql, pierdo 5 horas en volver a ponerme a funcionar.

ea!