🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: es.comp.os.linux.programacion
Article #1100

Re: Mysql y acent�s

#1100
From: Oscar Garcia
Date: Thu, 11 May 2006 10:46
51 lines
2453 bytes
El 11 May 2006 03:33:57 -0700, cirudinezidane@gmail.com escribi�:
>Cuoteando no me deja. Voy a probar a exportar cepillarme la bbdd e
>importarla y me voy a instalar phpmyadmin.

�Porqu� no usas mysql (en l�nea de comandos)?

Para borrarla ser�a tan sencillo como:

....:~# mysql -p test
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3235 to server version:
4.0.24_Debian-10sarge1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE TABLE `ca��n` (id INT);
Query OK, 0 rows affected (0.02 sec)

mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| ca��n          |
+----------------+
1 row in set (0.00 sec)

mysql> DROP TABLE `ca��n`;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW TABLES;
Empty set (0.00 sec)

Primero he creado una tabla llamada ca��n (con tilde y con �).

Luego he mostrado las tablas (donde se observa que se ha creado
correctamente).

Posteriormente la borro (f�jate como siempre uso quoteo).

Finalmente listo las tablas, dici�ndome que no tengo ninguna :'(
(un minuto de silencio por la tabla vilmente eliminada).

>Saludos y muchas gracias

Otro saludo y muchas de nadas.

-- 
�scar Javier Garc�a Baudet
LinaresDigital
http://redstar.linaresdigital.com/
Technical Details
Message-ID: <g55662pf3kn676ngh4a8g1cepneebn4rqk@4ax.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!news.antakira.com!antonio.escomposlinux.org!cernicalo.escomposlinux.org!escomposlinux.org!not-for-mail
References: <1147338880.763090.259150@v46g2000cwv.googlegroups.com> <e94662d841u7tql6t0o6gn8q0nbtnhq2ka@4ax.com> <1147343637.754110.208440@i39g2000cwa.googlegroups.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: f86c8,8a65547284e5d687
X-Google-Attributes: gidf86c8,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!news.antakira.com!antonio.escomposlinux.org!cernicalo.escomposlinux.org!escomposlinux.org!not-for-mail
From: Oscar Garcia <redstarQUITARSPAM23@terra.es>
Newsgroups: es.comp.os.linux.programacion
Subject: Re: Mysql y acent�s
Date: Thu, 11 May 2006 12:46:14 +0200
Organization: Ecolnet
Lines: 51
Message-ID: <g55662pf3kn676ngh4a8g1cepneebn4rqk@4ax.com>
References: <1147338880.763090.259150@v46g2000cwv.googlegroups.com> <e94662d841u7tql6t0o6gn8q0nbtnhq2ka@4ax.com> <1147343637.754110.208440@i39g2000cwa.googlegroups.com>
NNTP-Posting-Host: 87.217.171.242
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: cormoran.emeteo.local 1147344363 31110 87.217.171.242 (11 May 2006 10:46:03 GMT)
X-Complaints-To: emeteo@escomposlinux.org
NNTP-Posting-Date: Thu, 11 May 2006 10:46:03 +0000 (UTC)
X-Newsreader: Forte Free Agent 2.0/32.652