Hi all,
I have two question about UDF(User Defined Function)
(MySQL-4.1.1-alpha-Max-log and 4.0.18-log)
1. how to get character_set_* in UDF.
I want to get following character_set_* information in UDF.
MySQL-4.1.1:
character_set_serve
character_set_system
character_set_database
characte
Hi Boyd,
Can I ask why it really matters? :-) I would assume the DEFAULT value
is stored at creation time; but the end result would be the same either
way.
BTW, I hate how MySQL's SHOW CREATE TABLE quotes DEFAULT INT-family
values. :-( It shouldn't do that.
Matt
- Original Message -
Hi sascha,
How's the space on your datadir partition (or wherever this table is)?
I believe MySQL creates the temp tables during ALTER in the DB
directory, not the tmpdir.
If the space there is OK, have you checked the error log for anything
related?
Matt
- Original Message -
From: "s
Hi Steve,
You might want to look at FLUSH TABLES WITH READ LOCK. That's a query
to run from mysql, but I'm sure you can get it to work in your shell
script (you need to maintain the MySQL connection while doing the
backup). I don't know much about that, though. I think you just run
UNLOCK TABLE
Hi Matt, thanks for the help.
Meanwhile the index has been built, and I assume it's a problem of
terminal sessions:
At first I tried it with a remote mysql client issuing the ALTER TABLE
command. This session was closed after some inactivity.
Then I logged in to the database host and retried -
"David Carlos Brunstein" <[EMAIL PROTECTED]> wrote:
>
> By these days I'm facing a system DB migration to MySQL (the last
> production version) and I have the followin problem. All the SELECTs
> sentences are all over the application, and for date/datetime filters
> are using the dd/mm/ format
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi
I have redhat 7.2 running on my server with plesk
i forgot mysql password for user root
so i reset it by following way
services mysqld stop
safe_mysqld --skip-grant-tables &
mysqladmin -u root fulsh-privileges password newpassword
services mysqld restart.
now i can logon to mysql by root use
Hello,
I have a database with fields :
- firstname
- lastname
And I want to do a search from the query string "john smith" in order to
find anyone having john in his firstname and smith in the lastname or smith
in the firstname and john in the lastname.
It tried :
SELECT * FROM members WHERE CON
Hello again,
To follow my previous message, the CONCAT method does works, but now my
problem is to make a search where the order doesn't count : then to find
members whose firstname is john, lastname smith and vice-versa.
I would like to use an operator or a function for this, but I cannot
enumer
On Saturday 10 April 2004 08:15 am, [EMAIL PROTECTED] wrote:
> hi
>
> I have redhat 7.2 running on my server with plesk
> i forgot mysql password for user root
> so i reset it by following way
>
> services mysqld stop
> safe_mysqld --skip-grant-tables &
> mysqladmin -u root fulsh-privileges passwor
Hmm.
You might be best off using the FIND_IN_SET function (check the manual at
mysql.com for more information).
In short, if you replace all spaces in your string to search with commas,
you should be able to do something like:
SELECT * FROM xyz WHERE FIND_IN_SET(test_column, your string here) >
Hi All;
I would like to take a moment to announce the launch of
http://uc2004.vbmysql.com. This site is intended to serve as a resource for
the MySQL community as a blog collection and photo gallery related to the
2004 MySQL User Conference & Expo
(http://www.mysql.com/news-and-events/users-confer
warning: complete db server newbie!
(I've done plenty of SQL & JDBC coding, but never
had to care about the server side until now ;-)
Installed the binary distribution packages for Mac OS X:
mysql-max-4.0.l8.pkg
MySQLStartupItem.pkg
no problem.
But then when trying to configure the root user
Hi Egor.
Thanks for your answer. I'm relatively new to MySQL.
Isn't any way -like an environment variable or configuration file
setting or something like that- to change the date format at the MySQL
side, not at client side ?
Regards,
David.
==
David Carlos Brunstein
System
Hi,
Thanks to the reply from Sergei, I understand why
MySQL requires SAME block size on all indexes when
"load index into cache...".
However, this feature basically useless for the table
that has any fulltext index. Based on what I've seen,
fulltext indexes use 2048 block size, whereas others
use
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title` varchar
I needed 5to do some subqueries. I had mysql-3.23. Somehow I thought
mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
got it working except it doesn't do subqueries. Therefore we installed
mysql-4.1.1 6 hours of figuring out the permissions finally we got the
databases all fix
I needed to do some subqueries. I had mysql-3.23. Somehow I thought
mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
got it working except it doesn't do subqueries. Therefore we installed
mysql-4.1.1 6 hours of figuring out the permissions finally we got the
databases all fix
hi
I am new to mysql and have a create script that when sourced throws a syntax error.
The script :
CREATE TABLE employee (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
)
TYPE=InnoDB;
CREATE TABLE position (
id INTEGER UNSIGNED NOT NULL AUTO
Howdy all,
I am having trouble configuring my server parameters
with my.cnf because there seems to be several mysql
server instances (mysqld processes) running on my
linux box. What I would like to do is bump up the
innodb_buffer_pool_size on the server to 512M (the box
has 3GB of RAM). The proble
I learned that there are three types of indexes (PRIMARY, UNIQUE, and
INDEX).
Now assuming I create a performance-critical PRIMARY key, will I better have
to specify UNIQUE and INDEX for this column also !? It should be obvious
that a primary key is unique anyway, and an index as well, shouldnt it
I suppose this would be easier with subselects but I am using MySQL 4:
I want all orders that are of orderStatus 2 and whose orderitems
contain a product that is in a productparent category greater than 2.
An orderitem can only have one product, and that product has a single
certain product par
Hi Rodrigo.
I'm facing a similar task but from Informix to MySQL. What I do is:
1. Obtain a SQL script to create the logical database (an Informix tool
give it). You can use Erwin, with reverse engineer and the save the
script.
2. Add the "Type=INNODB" clause for each CREATE sentence.
3. Divid
24 matches
Mail list logo
