The port number is wrong. Change it to 3306, and u should be fine.
:>I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm
:>trying to connect to it by ssh from another machine(ip 202.157.137.97) as
:>follows :
:>
:>$ mysql -h 202.157.188.2 -u root -p
:>Enter password:
On Sat, 8 Jun 2002, Charlie Thunderberg wrote:
Hi.
:I'd like to find out how I could convince mysql to generate warnings
:whenever the data I want to insert is modified by the server.
I believe there's no built-in way of doing that.
I keep a checksum of a data stored. And when i want to write
I use exclusevely command line interface, and i believe most of the
programmers prefer command line interface over GUI.
As to large queries... just save them in yor files or use 'edit' command.
On Mon, 3 Jun 2002, Ehmer David wrote:
> Hi
>
> Very new to MySQL and just wondering if there is
This query seems to be quite easy, but I still cannot figure
out how to do it.
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course
Guys, i get the following error. What does this mean?
DBI->connect(myskycastle) failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16
-
Before posting, please che
y easily, and I'd say an image fits under
> that category. And last time I checked my local hard drive is faster than my
> network connection :) The choice is yours, but if you have heavy load, I
> wouldn't use it.
>
> Andrei Cojocaru
> [EMAIL PROTECTED]
> - Origina
For real-life example, check out http://cdbaza.ultracgis.com, and check
out the filename
of the thumbnails images. I'm SELECTing those images from the MySQL
database.
That's how it's done:
1_ Create a table to store your JPGs, and the column that holds JPG data
should be declared as BLOB
Hi
> Hi,
> Can i have a table in which i can store my JPG file somehow in
> MYSQL database.
Absolutely.
just declare a BLOB column, and load your images rightinto the columsn
> Sameer
>
>
>
>
>
>
>
> --
> http://www.dypatil.edu For Better tomorrow
>
> -
Hi
> my_print_defaults: not found
> Didnt find usr/local/libexec.mysqld
> you should do a make install before executing this script
So, did you do "make install"? In that case check out the location above,
and try to find libexc.mysqld. And make proper changes
--
Hi Walter
> My question is, as I read in the documentation, that the process is
> irreversible, how can I deal with the fact
> that a user can forget his password, if I will not be able to retrieve the
> original string, because what i can see is the encrypted data
The purpose of the encryp
Hi. As far as I know, MySQL doesn't suport row-locking, only table locking
is available.
But I figured table locking for sessions table of CGI::Session::MySQL
would be
quite inefficient, for there might be millions of rows and hundreds of
them
could be active at any time. So what do you guys
ve the same result?
>
>
> On Sat, 2002-03-23 at 12:27, Sherzod B. Ruzmetov wrote:
> >
> > Is there a function or a way to find out how many days/hours/mins/secs
> > have elapsed since date n?
> >
> > For example, i need to be able to get the answer lik
Is there a function or a way to find out how many days/hours/mins/secs
have elapsed since date n?
For example, i need to be able to get the answer like: "2 days and 3
hours have passed since date [some_date]"
Thanks
sherzodR
--
sql, query
13 matches
Mail list logo
