Hi Peter (and MySQL list),
On Wed, Jan 13, 2010 I (Ricardo Dias Marques) asked the following :
>>It would be convenient for me to get a list of those fields ordered by
>>field / column name.
... and on the same day, Peter Brawley
kindly replied:
> SELECT *
> FROM informat
g the wrong keywords for my searches).
So, I'm asking this: does anyone know a MySQL command to get this list
of fields sorted by field name? Or do you achieve this result by other
means (e.g: using some GUI tool, copying the list of fields to a text
file and sorting it, writing some scrip
e
"mysql_connect" result to that $db variable.
So, I think that you will solve your problem by changing your
"mysql_connect" line FROM the current form:
mysql_connect('biggie', 'user', 'password', 'test');
.. TO this one:
$db = mysql_connect(
Hi,
As usual, everything is heavilly dependant on your specific scenario.
Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
benefit from I/O (more, faster disks).
Regards,
Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
m UTF-8 back to ISO-8859-1? *Or* do you enter
directly as "root", as I'm doing now (to work around this issue)? *Or*
do you simply do NOT type accented characters directly in the MySQL
Monitor (that is, the command line mysql client)?
Thanks in advance for any info that you may
UTF-8"
LC_ALL=
My sshd_config file DOES have the following lines, at the end:
AcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES
AcceptEnv LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT
AcceptEnv LC_IDENTIFICATION LC_ALL
The SSH Daemon of the Linux Serv
Weiqi,
You can use the mysql web site. It's the best first tutorial for anyone.
http://dev.mysql.com/doc/refman/5.1/en/index.html
I don't know if you are Chinese or Japanese but there is versions in
this two languages. Have fun and welcome to MySQL world!
Regards,
Ricardo Conrado S
regards
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET Projetos e Sistemas
www.uranet.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the col_1 and col_2??
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET Projetos e Sistemas
www.uranet.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
28/07, Ricardo Conrado Serafim <[EMAIL PROTECTED]> wrote:
Hi,
I need to know if it's possible block things like store procedures,
triggers, etc in MySQL 5.0 using grant statement. Some users can't uses
this stuff.
If someone knows please help me.
Regards,
--
Ricardo Conrado Sera
Hi,
I need to know if it's possible block things like store procedures,
triggers, etc in MySQL 5.0 using grant statement. Some users can't uses
this stuff.
If someone knows please help me.
Regards,
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET Projetos e Sistemas
www.ura
IL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (Darwin)
iD8DBQFGVxxcgCgDHkdt5m8RAqTOAKCAdoL4JSjUzsKG1Y9/wdcTCeSdswCffwOy
YO0ALUVivjv7ZDFfXUAbn1M=
=J52W
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
r saying that Last can't be NULL
I hope that it helps
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET - www.uranet.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;"
shows that the auto_increment value is 2147483647.
This could lead to three paths: the problem would be somewhere in the
data, in the restore procedure or in the mysql engine itself.
I've analyzed the data by hand (all the ~10900 lines), and I am sure
that there isn't a single uid
ally
need a solution to this problem other than having
a huge leap in the uid values.
Thanks,
Ricardo Oliveira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
theless, I'll try it ASAP and I'll get back to you.
Thank you,
Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng_record && restore, drop the entire database:
-> data is OKAY, select results in no records above 11k, next insert
will have uid=2147483647
The table fits in about 1MB on disk, and its indexes fit in about 700kB.
Does anyone have a clue? Any help is highly appreciated.
Best of rega
o choose this. I installed the binary
freebsd package which is suppose to be very reliable to a quick start.
Thanks
--
Ricardo David Martins
_
AVISO
Esta mensagem (incluindo quaisquer anexos) pode
ning for almost 10 hours now. Do you have any
sugestions that might speed up the query? Do you think removing the
indexes will speed up things?
Thanks in advance for your help!
--Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
I've solved the problem starting the server using the
option --character-set=dos.
The side effect is that searches become
accent-sensitive.
Best wishes.
--- Ricardo <[EMAIL PROTECTED]> escreveu: > I have a
problem with SELECT DISTINCT if the target
> field contains s
But I think the collation set only applies to MySQL
4.1, doesn't it? I'm using MySQL 4.0.16.
I found no "character_set_server" system variable.
Only "character_set".
http://dev.mysql.com/doc/mysql/en/Charset-map.html
Thanks.
--- Jochem van Dieten <[EMAIL PROT
> Which collation are you using in MS SQL Server? And
> in MySQL?
>
> Jochem
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
__
Yahoo! Messenger - Fale com seus amigos online. Instale agora
The order should be:
fa
Fa
fá
Fá
fâ
Fâ
fã
Fã
As I get in MS-SQL Server.
> --- Victor Pendleton <[EMAIL PROTECTED]>
escreveu:
> It does not appear to respect the ascii values.
> Should the order be?
> fa
> fá
> fâ
> fã
> fa
> fá
> fâ
> fã
latin1
>--- Egor Egorov <[EMAIL PROTECTED]> escreveu:
> What is the character set of the data? What is the
> character set of MySQL server?
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net
> http://www.ensita.net/
- The sort order gets incorrect:
SELECT DISTINCT BINARY(MyField)
FROM MyTable
WHERE MyField LIKE 'f%'
ORDER BY MyField
+-+
| BINARY(MyField) |
+-+
| fa |
| Fâ |
| fá |
| Fa |
| fã |
| Fá
Thanks Mr. Pendleton.
But I cannot change the behaviour of the LIKE operator
and the ORDER BY clause, which are going to be
affected by both of your suggestions.
--- Victor Pendleton <[EMAIL PROTECTED]>
escreveu:
> Try
> SELECT DISTINCT BINARY(col)
> ...
> Or declare the column as binary
___
I have a problem with SELECT DISTINCT if the target
field contains special characters.
Example:
select MyField from MyTable
+--+
| MyField |
+--+
| fá |
| Fá |
| fa |
| Fa |
| fâ |
| Fâ |
| fã |
| Fã |
+--+
select dist
I have to copy some records from one table into the same table is it
posible?
my sql is like this:
INSERT INTO equipamento_componentes (cod_equipamento_componentes, cod_tipo,
numero, data_colocacao, cod_componente)
SELECT '', 'C', 65, NOW(), EQ.cod_componente
FROM equipamento_componentes EQ
WH
can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me an
example or point me to a link with documentation.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hi,
I'm having problems trying to figure which is the best way to solve a design
:
I'm designing a delivery program with php and mysql, and I'm having troubles
with some tables,
my problem is with the recipes, the recipes are divided into two tables one
with a recipe id and description the other
Mauro:
I was experencing the same problem in two different mysql setups
the first one is runing 3.23.36. the problem started after an up2date
with red hat.
Then i seted up a nother machine runing red hat 8 with mysql 5.23.53..
and the i found the same problemm..
Early this morning
Hi,
I added a table to my phpnuke database, all connections to this db
work perfectly, except this custom table, it gets data from a form.
Before I was using it just to show data was succesfully retrieved, and
it was working now I added these lines:
TIA,
Rick
-
Hi,
I'm having trouble trying to insert form data into a mysql db, the
thing is my client wants table data to be splitted, I mean some data
comes from the first form, and the rest from another form.
This is a portion of the php script.
// Add together proper fields to enter birth date
$fecha_na
Hi,
I'm developing a web application using mysqld as a localhost but
accessed from anywhere. My problem is simple, after entering form
data, and execute the php script, always returns an error I wrote in
case of unsuccesful connection to the db.
I did everything , create a user with many privile
.idéias.ual..
Idéias Pontual Desenvolvimento de Software Ltda.
Ricardo Striquer Soares
CEO e-business
Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862
Fax: +55 (41) 223-7865
Mr. Lucro : www
I have a problem, when I try to connect to the Data Base
[root@hvserver_tja bin]# mysql
bash: mysql:command not found
[root@hvserver_tja bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock'
(2)
[root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p
Enter pass
ild a correct select command?
thanks advanced.
sql,query
idéias.ual..
....
Idéias Pontual Desenvolvimento de Software Ltda.
Ricardo Striquer Soares
CEO e-business
Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862
Fax
ld a correct select command?
thanks advanced.
sql,query
idéias.ual..
....
Idéias Pontual Desenvolvimento de Software Ltda.
Ricardo Striquer Soares
CEO e-business
Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862
Fax
some experience with the enc/dec func which can
share?
thanks
this to bypass the the filter esql,query
idéias.ual..
Idéias Pontual Desenvolvimento de Software Ltda.
Ricardo Striquer Soares
CEO e-bussines
Fone: +55 (41) 322-937
i'd like to connect to mysql sgdb but not by a specific database, only
the sgdb, using java to send the command "show database" and them afther
that select a database listed and connect to that database.
i tried "jdbc:mysql://localhost:3306"
i tried "jdbc:mysql://localhost:3306/"
but those have
by what i have seen there is a 4.0 version of MySQL. Where can I find
more information about and even download a version of it ?!?!? Thanks.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Hi All,
where do I specify the remote hosts that are allowed to access port 3306? I
have made entries in the user table of the mysql db, but still cannot conect
from a remote machine. Thanks,
Ric.
_
Get your FREE download of MSN
Hi Can anybody recomend me a Mysql replication webpage with feedback ?
- Original Message -
From: "AJDIN BRANDIC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 12:35 PM
Subject: find mysql
> Hi,
>
> I have received mysql db files with extensions .frm, .ISD,
Hi,
I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql server
as root and trying to use a sample database from Paul Dubois book MySql, I ' ve got
the error 13, can't create directory/file ./samp_db/president.xxx.
The thing is I'm using an example DB, any help ? Wher
i am facing the same problem Kenneth explane above, can anyone tell me
what to do ?
PS: i tried to use the mysql port number as well
Kenneth Fleck wrote:
>
> Hi !
> I have a problem accessing a MySQL DB from a java-app. On commandline I
> can get in without problems with
>
> mysql -u -p
>
>
well well, as seen i brought the delphi and mysql power to built an
application wich i am installing myself in the client nowadays although
i'd like to make a more friendly installation pack in wich the client
does not need to install the mysql and afther that install the program,
i am using the i
Thank you.
But then how can mysql replication be used for high availability? If I
always rely on 1 master only, what happens if the master goes down?
I've tried two-way master-slave and I understand there are problems. :-(
On Wed, 18 Jul 2001, Warren van der Merwe wrote:
> Hi
up, how is it
supposed to work? Is it supposed to suddenly become a slave? Or does it
again come up as master and then server2 relinquishes its master status?
How can all of this be done automatically? It seems a little confusing to
me to have to have all this automatic switchi
up, how is it
supposed to work? Is it supposed to suddenly become a slave? Or does it
again come up as master and then server2 relinquishes its master status?
How can all of this be done automatically? It seems a little confusing to
me to have to have all this automatic switchi
como faço p/ desligar o servidor mysql remotamente?
estou usando win98 e o Mysql esta em uma maquina NT
falow
valeu
does enyone knows a GUI to use with mysql wich is verry friendly one?
thanks advanced.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
B
i installed some days ago the RedHat 7.1 with apache and the php4, since
that i have donne nothing in my system, tham i installed the mysql wich
works fine, i installed the php-mysql rpm packege, my php is version
4.0.4 and the packeg is for version 4.0.1, i dont know if is it but the
php and the
ola
como faço p/ mudar a data padrao do mysql??
ele esta como
-dd-mm
eu gostaria de mudar p/ dd-mm-
falow
valeu
i have recently installed the red hat 7.1 in my computer,
althought i
have not installed the mysql durring the os installations,
naw i
installed the mysql database but its giving me a socket
error like this:
/etc/rc.d/init.d/mysqld status
mysql dead but subsys locked
mysql
ERROR 2002: Can't con
hey
eu estou acessando um banco de dados do mysql via delphi usando o winzeos
meu chefe pediu p/ instalar na máquina dele p/ ele ver como está
(ainda nao terminei tudo) e eu nao consigo instalar
pois ele da erro na hora de executar a query
eu ja coloquei a libmysql.dll no pc e nada
alguem poderi
Olá
Tenho uma tabela que contem o nome do produto e a origem dele, sendo
IMP - importado
RJ \
SP |
AM | nacional
RS |
MG/
SP-CL \
RJ-CL | Empresas coligadas a nossa empresa
AM-CL /
O problema aqui é filtrar os nacionais junto com importado ou
nacionais com
coligadas
Tipo, como faço p/ re
Olá pessoal
É o seguinte
Eu tenho uma tabela A, B, C
A estrutura delas é a mesma
Tipo
AB
C
IdItem IdItem idItem
Quantidade Quantidade Quantidade
E u
em php
tenho um array tipo:
10,15,20
como faço p/ pegar separadamente
10
15
20
sendo q esse numero pode variar
tenho uma rotina em delphi q faz isso, porem estou com dificuldades p/
passar para php por causa da minha inexperiencia nesta linguagem
em delphi é assim:
x := 1;
i := 1;
repeat
offer any help in this area?
Thanks
Ricardo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
I sent this message in but have not received one single reply... :-(
-- Forwarded message --
Date: Thu, 25 Jan 2001 11:10:52 -0800 (PST)
From: Ricardo Kleemann <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Problem with replication. :-(
Hi,
I'm running linux, my
010125 11:09:20 Error reading packet from server: Could not find first
log (read_errno 0,server_errno=65535)
This just goes on and on. How can I remedy this??
Thanks
Ricardo
-
Before posting, please check:
http://www.mysq
61 matches
Mail list logo