Marc,
In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
not possible to use functions as default values; you could create:
create table tester (f_date date default curdate()); But this doesn;t
work. You have to struggle through your knoda how to present the current
date.
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]
Description:
i try
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: install mysql-SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be
On Friday 30 December 2005 10:35, jean-marc Jegou wrote:
i try to install mysql-standard-5.0.17_linux-x86_64-glibc23, but it did
not work !
machine, os, target, libraries (multiple lines)
System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10
04:34:27 EST 2005 i686
Hi everyone
One of the projects I am working on requires me to take snapshots of
the Content Management System from certain points in time (usually
before a change is made).
These snapshots contain everything (not just the page contents), from
navigation ordering to user permissions to actual
Gary Richardson wrote:
We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a
script that went through and optimized all tables with keys on
text/varchar and char fields.
We're also slowly ALTERing innodb tables to get them into the new
compact format.
i tryed to update from
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB doesn't lock tables during
Thanks, Danny. This little info was all I needed. It works perfectly
now.
Have a Happy New Year!
--Marc
On Fri, 2005-12-30 at 10:28 +0100, Danny Stolle wrote:
Marc,
In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
not possible to use functions as default values; you
Hi,
Is there any compiler to Compile Embedded SQL Macros into source codes
for MySql?
In otherwords, what is the equivalent of PRO*C (in Oracle) in MySql?
Thanks,
Ezhilarasan
Re: install mysql-5.0.17 on linux AMD 64 processor
http://lists.mysql.com/mysql/193352
dir Duncan Hill ,
thank you to answer to my question !
my processeur is AMD 64 2800+ ( 64 Bits processeurs!) and linux is
seeing an Athlon 32 bits processor (see previous message).
My OS IS Linux Aurox ver
On Friday 30 December 2005 14:05, jean-marc Jegou wrote:
Re: install mysql-5.0.17 on linux AMD 64 processor
http://lists.mysql.com/mysql/193352
dir Duncan Hill ,
thank you to answer to my question !
my processeur is AMD 64 2800+ ( 64 Bits processeurs!) and linux is
seeing an Athlon 32
Hi,
I have a web app where I am doing a boolean search. I only want to return
10 results per page, but I'd also like to know how many total rows match the
search query. I'm currently performing this with 2 query statements:
1. (To get the actual rows via the search)
SELECT
Very odd problem. I do have a larger database, with many myisam tables.
A couple days ago, some of them turned 'read only'.
Symptom:
delete from day_48392 where id=28398776259;
ERROR 1036 (HY000): Table 'day_48392' is read only
I checked:
- table file permissions are right ('660
I have 290 records in the database with backslashes. I want to remove the
backslashes. Why the query below doesn't remove backslashes?
update name set first_name = REPLACE(first_name,'','') where first_name
like '%%';
Hello list
I've just install v4.1.
Every thing works fine exept SQLyong shows all non-latin characters as
question marks and the old Mysql-Front can't connect with tables after
mysql_fix_privilege_tables.
How can I change character_set_client=greek than to latin?
I thing this will solve my
So it should be possible to automate a skip of errors setting by code , at
run-time, sql_slave_skip_counter = 1, each time I check the slave status and
I found an error, and then I restart the slave
Thanks, I should try this way.
One think it is astonished: I can agree that there should bu some
Hi,
MySQL 5.0.18, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not
Hello.
Sorry. It seems that I've understood your question now. In my opinion,
IGNORE_SPACE not related to CREATE FUNCTION statement, because at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
for some cases we have to use a space between the name and the following
Hello.
I guess my question is, how do I make sure the full text search is
being done against the CommentsIDX and not just against the individual
fields...
If I've got your question right, you shouldn't worry about
it. As far as I know, the search is done against the union of all
Hello.
One think it is astonished: I can agree that there should bu some
conflict, but why i have remove the same row, with the same key value
several times about 5-6 times ).Do you have some knowledge of problem
like that ?
It is difficult to say something, because the whole picture of
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE table SET fieldname = fieldname-1
when the fieldname is 0 gives me 4294967295
fieldname is integer(10) unsigned...
maybe it would be more logical the
Well, I found the reason for these table becoming 'read only':
These tables where part of a merge table, which included some read only
tables (read only set in file system).
Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file
Hi,
What you perhaps could use is the REGEXP usage in your where clause.
Try this:
update name set first_name=replace(first_name, '\\', '') where
first_name regexp '';
The fun thing is that when you put '\\' instead of the '' after the
regexp function it doesn't work. But this sure
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the
result is greater 100,000 rows or something? I have a bone head user
who keeps querying two tables and NOT joining them, and then
dragging the DB server down while
On Friday 30 December 2005 3:31 pm, Scott Baker wrote:
How can I prevent this?
Scott
You know when I deal with users like this, I like to think about what Dennis
Leary said about spanking children; I don't need to spank them, I find that
waving the gun around works just as well.
--
At 04:31 PM 12/30/2005, Scott Baker wrote:
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the result is
greater 100,000 rows or something? I have a bone head user who keeps
querying two tables and NOT joining them,
Danny Stolle wrote:
Hi,
What you perhaps could use is the REGEXP usage in your where clause.
Try this:
update name set first_name=replace(first_name, '\\', '') where
first_name regexp '';
The fun thing is that when you put '\\' instead of the '' after the
regexp function it doesn't
Scott Baker wrote:
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the result
is greater 100,000 rows or something? I have a bone head user who
keeps querying two tables and NOT joining them, and then dragging the
Like to know how to query MySQL for loaded or installed modules. Is this done
through using the code:
? phpinfo(); ?
I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and
perl-DBI.
Thanks
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META
I am having trouble with table lock.
The query is as follows:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
I keep getting this error: #1206 - The total number of locks exceeds the
lock table size
I would like to create a trigger that either updates or inserts a row in
my USERS_PER_HOUR table when an entry is made in the LOG table.
The log table has LOG_DATE, LOG_TIME and a CUID columns that I would
like to either create a new row if the LOG_DATE and LOG_TIME do not
exist or update the
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE table SET fieldname = fieldname-1
On 12/30/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
I guess my question is, how do I make sure the full text search is
being done against the CommentsIDX and not just against the individual
fields...
This shows that the search is done against concatenation of the fields:
mysql
I have a sql script that needs to be re entered using the following command
mysql create.sql but the database already exists. IS there a way to
overwrite or update the database using the script, or do I have to delete the
existing database?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
34 matches
Mail list logo