Hi!
MySQL 4.0.1 is now released.
I would like to start by saying that the MySQL 4.0.0-alpha release has
worked very well and we haven't (yet) found any really fatal bugs in
it. Our intention is to continue with development on the 4.0 series
for a couple of more weeks and then shift to work on
Hi !!!
Is there a check constraint available in Mysql?
If there is one plase send the Syntax as well
Amit Lonkar
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Hi!!
I have been trying to create the following tables:-
1) create table scenario (
scenario char(10) not null primary key,
copyfromscenario char(10)) type = innodb;
2)
create table attributekit(
attributekit char(25) not null primary key,
expression blob not null,
linkoperator char(5) defa
Hello Gurus,
I have installed the mysql-3.22 on Solaris(Intel) and when I execute the
bin/safe_mysqld --user=mysql &
and support-files/mysql.server start
successfully, runing the server and able to enter in mysql> client.
So, hold on startup as per support-files/mysql.server script document
mysq
Hello Gurus,
I have downloaded the following mysql kit to install on Solaris (intel) and
gtar-i386.gz
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t
ar.gz
http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz
and then done gzip -cd mysql-3.23.39-pc-solaris2.8-i386
I wasn't on the list when the thread below started, but I saw it on google
and wanted to add some more information, but this time, my columns aren't
char based and I get the same error. Here's my SQL:
CREATE TABLE `user` (
`user_id` int(11) NOT NULL auto_increment,
`username` varchar(30) NO
edit your rc.local file and add the command to start your mysql server.
Curtis
On Sat, 22 Dec 2001, sreedhar wrote:
> hi all,
>
> How can i autostart MYSQL while starting of my LINUX server.
>
> regards,
> sreedhar
>
>
> -
Hi
I am a novice in Mysql, and have recently managed to configure my IIS-JRun
server to connect to MySql. However, when I try to test the connection, I
get an error message saying Server Configuration denies access to Data
Source.
Please let me know whether the configurations that I shall have to
Hi
I have a question on the table_lock_waited and table_lock_immediate
variables
for MySQL.
On my server, am seeing the sum of 'table_lock_immediate' and
'table_lock_waited'
way less than 'Questions' for 'show status' (only about 40%). Although I do
run queries
like 'show status' they are defini
You should use "binary" attribute.
mysql> select binary "fff " = "fff" ;
+-+
| binary "fff " = "fff" |
+-+
| 0 |
+-+
1 row in set (0.28 sec)
mysql> select "fff " = "fff" ;
+--+
| "
select VERSION()
+---+
| VERSION() |
+---+
| 3.23.41 |
+---+
select "fff " ="fff"
+-+
| "fff " ="fff" |
+-+
| 1 |
+-+
Query OK, 1 rows in set (0,06 sec)
Maybe this is not a bug, but in my case i need
> > Ok, I will, but I CC it to the mailinglist, maybe others have interest
> > and/or comments. Besides, I think I may have found a bug...
>
> Yes, of course my fault not to post directly to the list :)
>
> I have another problem with this query.
> If the textvalue field is the text type, then i
Hi,
The part: AND 'varAuthor' <> ''
is a test to see if the variable is empty or NULL
-Michael
> Uh, I think the problem is that if nothing is entered, you search for '%'
+
> nothing + '%' , so in effect, you search for '%%' , which is everything.
>
> Have your code check if the fields you're s
You must make sure you don't perform arithmetic differences between integer
values such as "2000" representing 8:00 pm and "1945" representing 7:45 pm
because that obviously would result in wrong values. For example 2000-1945=55,
which is arithmetically correct but not the desired result if you wa
I have installed and configured MySQL server on my local win 98 machine
How may I export the locally created DB to my remote ISP/MySQL? Any third
party tool?
My site is set on Linux/Apache my local machine is Win 98
Thank you
Henry
> select distinct
> t1.textkey,
> if(t2.textid,t2.languageid,t3.languageid) as languageid,
> if(t2.textid,t2.textid,t3.textid) as textid,
> if(t2.textid,t2.textvalue,t3.textvalue) as textvalue
> from texts t1
> left join texts t2 on
> t2.textkey=t1.textkey and
> t2.languageid='da'
> le
All:
I have been trying to just simply create a database
and I receive the following error:
mysql> create database MyCollection;
ERROR 1006: Can't create database 'MyCollection'. (errno: 13)
I know it is a privilege problem but I cannot figure out where
it is located. i have tried creating
I was using float...but even when I changed it to time, MySQL still gave me
odd values on those rows. What type should I use?
Alex Kirk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi,
Could it be that no data is written, or read from the files when executing
from the server? Possible your server uses another user then mysql. And the
server has no access to the files, or the permissons set on the files do not
allow them to be read from that user.
You should test it by usin
I downloaded and installed the latest MyODBC drivers for Win2000 and got
everything installed and configured. My question is this, when I run an
append query, Access pops-up a message box saying something like:
You are about to append 737 records, are you sure you wish to continue?
Regardless
Hi!
I have a proplem using my perl code to write some data into my mysql
database. When running in consolemode anything works fine, but when
executed by the wwwserver the scripts is processed without errors,
except the data is not written into the database! Any idea how to fixit?
Thanks in advanc
Hi mysql list,
I am just new to the list.
I have a 16 bit DOS APP which runs currently
under a Windows box and I would like to access
to a Mysql DB running on a LINUX Server.
The appl. is made with MSC 6.0.
Is there any API or Client for me which
I could use, or somebody has a tip how
solve this
When I do a search for Author, Keyword, or Title
and I leave a search box blank, the search is returning ALL records in the
database:
I only want it to return records from fields that match with the search
criteria.
I exported the database from MSAccess (with ALLOW ZERO LENGTH set to YES and
REQ
> Ok, I will, but I CC it to the mailinglist, maybe others have interest
> and/or comments. Besides, I think I may have found a bug...
Yes, of course my fault not to post directly to the list :)
I have another problem with this query.
If the textvalue field is the text type, then i get this erro
The option
--pid-file=/var2/db
can be used for mysqld
In my.cnf use
pid-file=/var2/db
Matthew
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: 23 December 2001 15:26
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Mysql maillist
Subject: RE: hostname.pid
Thank
Thanks for fast reply's :)
How can I change it so that MySQL looks for the file at /var2/db by using
the my.cnf file ?
Regards Jacob
[ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]
> -Original Message-
> From: Almar van Pel [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, Decemb
Does the unix user who wunns mysqld have write permissions to /var/local/var
(and does it exist?)
M
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: 23 December 2001 15:09
To: Mysql maillist
Subject: hostname.pid
How do I correct this database problem ? Plea
Hi,
Check your autorisations for this file for the user mysql runs under. It
does not have permissions to access the specified directory.
Regards,
Almar van Pel
-Oorspronkelijk bericht-
Van: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Verzonden: zondag, december 23, 2001 16.09
Aan:
How do I correct this database problem ? Please also reply to my E-Mail
address.
/usr/local/libexec/mysqld: Can't create/write to file '/usr/loc
al/var/hostname.pid' (Errcode: 13)
-
Before posting, please check:
http://www.m
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Hi!
Heikki> Ok, I looked in the manual and found the following:
Heikki> http://www.mysql.com/doc/S/i/Silent_column_changes.html
Heikki> So the bug is actually a 'feature'. Of course it would be better if the
Heikki> pars
I do not see this as a feature(documented bug). It is a handy
implementation method for potentially saving storage space.
Not all database designers (people who design databases as
opposed to those who have a qualification to do so) understand
the meaning of the various types. One database I ha
Hello mysql team,
I have downloaded the following mysql kit to install on Solaris (intel) and
gtar-i386.gz
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t
ar.gz
http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz
and then done gzip -cd mysql-3.23.39-pc-solaris2.8-
Hello Gurus,
I have installed the mysql-3.22 on Solaris(Intel) and when I execute the
bin/safe_mysqld --user=mysql &
and support-files/mysql.server start
successfully, runing the server and able to enter in mysql> client.
So, hold on startup as per support-files/mysql.server script document
mysq
Depends on the column type -- what column type do you use for storing
the time values?
Bogdan
Alex Kirk wrote:
> Is this a bug in MySQL 3.23.37? Could it have something to do with my OS
> (OpenBSD 2.9)? Or am I doing something wrong with the statement "update
> time_worked set total = start - f
Hello Gurus,
I have installed the mysql-3.22 on Solaris(Intel) and when I execute the
bin/safe_mysqld --user=mysql &
and support-files/mysql.server start
successfully, runing the server and able to enter in mysql> client.
So, hold on startup as per support-files/mysql.server script document
mysq
Hello mysql team,
I have downloaded the following mysql kit to install on Solaris (intel) and
gtar-i386.gz
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t
ar.gz
http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz
and then done gzip -cd mysql-3.23.39-pc-solaris2.8-
36 matches
Mail list logo
