Quote from MySQL documentation ...
"MySQL allows you to store some wrong date values into DATE and DATETIME columns (like
2000-02-31 or 2000-02-00). The idea is that it's not the SQL server job to validate
date. If MySQL can store a date and retrieve exactly the same date, then MySQL will
store
Nicholas Fitzgerald wrote:
go to the command prompt and use mysql or mysqladmin I get "access
deniged for user "@localhost". No "root" or anything like that. I don't
know where I screwed up, but I obviously screwed up something. Any ideas
out there on how I can get back in control of this situa
I'm running 3.23.58 on a Red Hat Fedora Core 1 box with the latest
updates, (as of a couple days ago). I was using webmin to change the
permissions on the database so I could access it from another box. Now,
no matter who or what I log in as I can't access anything. If I try to
go to the comman
>Description:
when compiled and started, mysqld_safe and mysql work fine
from console, but hen used with apache and php, i get the
error Client does not support authentication protocol requested by server;
consider upgrading MySQL client
>How-To-Repeat
just compile
Hi Mike,
You have to start the mysql server before you
can run the client. Try running "mysqld_safe --user=mysql"
from /usr/bin or /usr/local/bin, depending on where
you installed it.
To see if it is running currently on your machine,
try this: ps -ef | grep mysqld
Hope this helps...
~~Ni
I just install MYSQL on Linux (Red Hat 9)
using this manual:http://www.mysql.com/doc/en/Installing_binary.html
Have no idea what's wrong. I looked on the mysql.log file and the file is
empty.
ERROR MESSAGE:
[EMAIL PROTECTED] bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through so
Try this:
mysql> set @@session.sql_mode = 'ansi';
Query OK, 0 rows affected (0.00 sec)
mysql> select @@session.sql_mode;
++
| @@session.sql_mode
|
+-
By the way, I should point out that I *can* get it to work by adding:
[mysqld]
ansi
Or:
[mysqld]
sql_mode=PIPES_AS_CONCAT
But this is not what I want, since I'm going to be hosting this app
where I won't have access to the server config. I need to be able to set
it on a per sessi
Howdy all,
I've tried to search for an answer to this on the lists (and on google),
but I haven't been able to come up with anything, so I apologize in
advance if this question is redundant.
According to the docs (http://www.mysql.com/doc/en/SQL_mode.html):
"The MySQL server can operate in d
Hey wait a minute. Where did you get the my_free(), may be you are
trying to say mysql_free(), but then that is used only if result set is
used/called.
But the code does not show any result set call. ie. mysql_use_result()
or mysql_store_result().
So, the question now, how come there is a leak
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my ibook running
Mac OSX Version 10.1.5 on it.
I read the documentation on the mysql site and it
said to do the following next:
shell> cd /usr/local/mysql
shell> s
hi,
Thanks for the response.
I thought update is for existing records and insert is to add new records?
My Scenario is if two users open an existing record with data already in the
fields. They then add
some information to the end of a field with data.
Now when they click update the last user/bro
On Fri, 16 Jan 2004 17:54:06 -0500
"Syed Ali" <[EMAIL PROTECTED]> wrote:
> I have a Perl CGI script which uses DBI to access MySQL.
> I noticed that each query through the Perl CGI script using DBI has a
> connect, query and then quit.
> I was wondering if there is a way of keeping the connection
Is it possible to find out when the table was created? How to get information about
the table?
Thanks
On Fri, 16 Jan 2004 13:43:55 -0800
"Ron McKeever" <[EMAIL PROTECTED]> wrote:
> Scenario 1:
> I have noticed that if two users open a record to edit it
> in two different browsers
> and they edit the same field and then click update,
> the last user/browser gets written to the db,
> where the first
BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:[EMAIL PROTECTED]
ORGANIZER:MAILTO:[EMAIL PROTECTED]
DTSTART:20040117T11Z
DTEND:20040117T113000Z
TRANSP:OPAQUE
SEQUENCE:0
UID:0400
Hi!
You're looking for the function my_free(). Enjoy!
Regards,
Chris
John McCaskey wrote:
I have the following code:
//try the mysql connection
mysql_init(&mysql_connection);
if(!mysql_real_connect(&mysql_connection, db_host, db_user, db_pass,
db_db, 0, NULL, 0)) {
It's just a simple select:
select * from mytable
but run from within the control center
The error returned:
[RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist
where RM_SERVER is the server I created and rm_development is the database.
I did see someone else has posted with the same
Hi!
Can anybody guide me to the link for MySQL on a HP-UX 10.20 system. I
have found the binaries for HP-UX 11 and 11.11, but nothing for 10.20.
Thanx for the help in advance,
Gagneet
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
19 matches
Mail list logo
