Where is the mysqladmin?

Hi there, I have just installed the mySQL 3.23 and don't know nothing about it yet. When I installed it there was a message telling me to change the mySQl root user's password with the command mysqladmin, but I don't have this file on my computer. Do I need to install something else? I have instal

where is the mysqladmin?

Hi there, I'm have just installed mySQL and I'm completelly new at it. When it was installed it showed a message telling me to change the mySQL root user's password using the mysqladmin, but I don't have this file. I installed the mySQL 3.23 using the rpm file on a computer runing Linux. So, do I

RE: Where is the mysqladmin?

SION.rpm package for use > mysqladmin. Also you could > need MySQL-shared-VERSION.rpm for shared libraries > needed for use MySQL with > other programs and MySQL-devel-VERSION.rpm if you > need include files for > develop applications using MySQL. > > Iago. > > &

RE: Where is the mysqladmin?

53a Client programs > (MySQL-client-VERSION.rpm) > MySQL 3.23.53a Libraries and Header files for > development > (MySQL-devel-VERSION.rpm) > MySQL 3.23.53a Client shared libraries > (MySQL-shared-VERSION.rpm) > > Iago.

How to execute sql commands from a file?

Hi there, is there a way to execute sql commands from a file? What would be the syntax to do it? I was trying mysql> @theFile, but it doesn't work. Thanks, Andre __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhostin

Questions about the load data?

Hi there, I want to load a file where the values of the columns are separated by one or more tab ( \t ) characters. Is it possible to configure the "load data" to accept an unkwnon number of tabs separating these values? And how can I coment one of these lines? I know that in Oracle I can use "--"

Which port?

Hi, does the mySQL always use the same port and which port would it be? Is it configured in a file? Thanks Andre __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ ---

How to join two tables?

Hi there, I would like to know, if it's possible in the mysql to use two tables as if they were one and have an index that would use columns of these two tables? Thanks, Andre __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site h

How to query a varchar column's value staring with a string?

Hi there, how can I query all the values starting with 'test'? I tried the following query, but it didn't work select * from theTable where ( ( theColumn || '%' ) like 'test' ); Thanks, Andre mySQL __ Do you Yahoo!? HotJobs - Search new jobs dail

Re: How to query a varchar column's value staring with a string?

thanks for the help, but what I really want is to select all the values that are a substring of 'test' as 't', 'te', 'tes' and 'test', and so I was trying the query select * from theTable where ( theColumn || '%' ) like 'test'; I think my previous email as a litle bit confusing. Sorry for that :

Re: How to query a varchar column's value staring with a string?

Hi there, I found a way to do it with the following query select * from theTable where 'test' like concat( theColumn, '%' ); Thanks for the help, Andre --- Andre Kirchner <[EMAIL PROTECTED]> wrote: > thanks for the help, but what I really want is to >

Questions about indexes

Hi, is it possible in the mySQL to have an index that none of the values could be repeated except for a single value that could be repeated? The values of the column would be something like this '123' '245' '233' 'XXX' 'XXX' '027' where just the value XXX could be repeated. Thanks, Andre ___