hi,
would someone please tell me how to create mysql user? and how to set the
mysql root password?
Thanks
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
HI
i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have "./" infront of the command
for example: mysqladmin won't work unless its written "./mysqladmin".
please let me know if i am doing something wrong
Thanks
__
;t want that to happen.
Right. That is what the 'text' type is there for.
> I wouldn't be terribly opposed to having an option to be set to allow this,
No need. Just let the 'text' type get into the SQL standard, if it is not
already there.
Cheers,
--
,
M A R I O
. including 'bounded'.)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PORTO, Portugalmob 351+939354002
-
m length, the value is truncated to fit."
(MySQL Manual)
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PORTO, Portugalmob 351+939354002
don't think SQL has one. I would guess it was
simplicity (of the definition of SQL), not withstanding the fact that SQL
is spuriously complicated in other things.
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823
t-padding too short values with spaces).
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PORTO, Portugal
document description are by the research group GLINT of the CENTRIA. I
used to be among them. Call [EMAIL PROTECTED] and tell him I say
hello :-)
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax
it is used in a WHERE clause (see example
above) the rows returned are automatically sorted with relevance
decreasing.
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V
er.com).
However Ada is not "as C" in a number of traits, notably debbuging time
;-)
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PO
k5;
++++---+
| id | first3 | fourth | remainder |
++++---+
| 1 | abc| 0 | def |
| 2 | abc| 92 | 0def\ |
| 3 | abc| 92 | 0def |
++++---+
The 'problem' is in the output from the "mysql" program:
known
problems with the float type. Maybe this is one of them (in the function
sum).
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+2260036
your opions and experiences, good or bad.
I have made the move from Postgres to MySQL for speed reasons. Postgres
has more features but is slow---and not that very stable either. With
MySQL I am experiencing speed improvements of 10 to 50 times faster over
Postgres, and I am not experiencing any l
my previous response to Sinisa for the extraordinary consequencies of
passing NULL ;-)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PO
e result, can you? You are in a
limbo.
If (2), the MYSQL structure must be a newly created one, since you did not
pass any! And voila, you have created a MYSQL structure without mysql_init
(this is of course is in contradiction with the rest of the
documentation).
Cheers,
--
,
M A R I O data
tation/mysql/bychapter/manual_toc.html)
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PORTO, Portugalmob 3
nning fetching a calculator, I did it for you: 1 million
records === 42 minutes.)
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150-180 PORTO, Portugalm
On Wed, 14 Nov 2001, Aaron Williams wrote:
> At 3:54 PM + 11/14/01, M. A. Alves wrote:
> >On Wed, 14 Nov 2001, Aaron Williams wrote:
> >> . . .
> >> I am not expert on innodb, or mysql either. I started playing with
> >> those values after reading
the HTTP request originator. Is this all it
is? Is this the "performance guide" you have read?
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150 PORTO, Portugal
nsert a file that is in a local machine?
Not with LOAD_FILE, according to the Manual. You must do it inside your
application i.e. read the file and generate the corresponding SQL
statement using your programmatic means. Do not forget to escape the
necessary characters (NUL, \, ', ", I thin
al poster for an example. But anyway I think Carl has guessed
correctly what was on the poster's mind and yes Carl the rest of your
message makes it quite clear.
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+
mysql
On Mon, 12 Nov 2001, Christian Andersson wrote:
> Is it possible in myslq to do an order by before an group by?
For me it is not clear why would you want to do that. Can you give an
example?
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O
ata _without_ the extra field; update the extra field after
> the data has loaded.
>
> 2. load the data thru a specific program (that someone has to write) that
> performs the required operation.
>
>
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ex
rstand* '=' better then JOIN.
*
* *
It is good we found your bug now!
There is still the question of your mysql monitor seemingly yelding the
right results for the wrong query, but I'll leave that problem for you now
;-)
--
,
M A R I O data miner, LIACC, room 221 tel 3
I know K&R (section 4.9, 2nd ed.) says
char s[] = "...";
is equivalent to
char s[] = { . . . , '\0'}
but I always explicitely attach the \0 just to be sure i.e.
char s[] = "...\0";
/* mysql, database (cheating the filter, human reader ignore) */
n a file, then input to mysql --> success :-)
This fits my diagnosis that it has to do with concurrent access to the
same table.
Thanks,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150
On Tue, 30 Oct 2001, M. A. Alves wrote:
> I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
> 2 or 3 items but only 2295 are returned. What might be the cause
> of this?
The probable cause is I was accessing the same table at the same time (but
thru
I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
2 or 3 items but only 2295 are returned. What might be the cause
of this?
Thanks,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351
> How can i insert image in a database.
<>
(The MySQL Manual, section 7.1.1)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150 PORTO, Portugalmob 351+
> You have written the following:
>
> "compress" was there all along. I was giving the wrong linker options.
>
>
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A
+0xbb): undefined reference to `compress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x12a): undefined reference to `uncompress'
What am I missing?
Isn't there a way to find out what library has a given item?
Thanks a lot,
-
/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x12a): undefined reference to `uncompress'
What am I missing?
Thanks a lot,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 35
Fernando,
Te sugiero que veas la página http://mmmysql.sourceforge.net/ por un JDBC y
en su docs vas a encontrar ejemplos de como resolver tu problema.
Si necesitas mayo ayuda, no tengo problema en enviarte porciones de código
donde se resulve este problema.
Maximiliano.
- Original Message -
I know that in Oracle it is possible to select a number
from DUAL and put it in a variable. Is it possible
In mysql? and how?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
34 matches
Mail list logo