compiling mysql 4.0.4 error

to ib_config.h (or repair configure sripts, automaheader, automake, ) Regards, Michal Dvoracek [EMAIL PROTECTED] SQL, TABLE - Before posting, please check: http://www.mysql.com/manual.php

user

Hello, is possible to create user which will be not able to create other users and will have full access to all existing databases and databases which will be created in future? Thank you. Regards, Michal Dvoracek [EMAIL PROTECTED] mysql,query,sql

mysql documentation prompt

Hello, http://www.mysql.com/doc/m/y/mysql.html there is section how to set up own prompt for mysql. I tryed but doesn't working. (tested on 3.23.43 and 4.0.1-alpha) Is possible to set up own prompt in mysql ? Regards, Michal Dvoracek [EMAIL PROTECTED] sql, table

to_asci

Hello, i need function that will convert non-english characters () to english. Some values in table contains non-english characters and i need search them. (via LIKE) In posgresql is function to_ascii. Regards Michal Dvoracek [EMAIL PROTECTED] sql,query,table

join group problem

(tested on mysql 4.0.1 on win). but i need this result: descr count -- fir 4 two 0 fre 0 fou 0 it's possible to get this result in one guery ?? i need that goup by will affect only join, no whole query. Thank you for help. Regards, Michal Dvoracek

analyze/check

, drop database, flush, create database, read from dump) but second problem is still actual. Can you help me, please ? Thank you. Michal Dvoracek [EMAIL PROTECTED] - Before posting, please check: http

default value

Hello, s possible to create table with default value returned by built-in function ?? like: create table x (a int not null default UNIX_TIMESTAMP()); When inserting new column in table field a will contains timestamp? sql,query Regards, Michal Dvoracek [EMAIL

innodb on xfs

Hello, innodb can't be created on xfs ??? InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. 020216 14:25:49 mysqld ended S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6

innodb

Hello, is possible on the fly change size of innodb tables ?? i create table 1G large but is small and i need enlarge it. Can i change number in my.cnf or something else ? S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00

Re[2]: Uninstall MySQL!!!

Hello, if get this, try install the _SAME_ package(rpm -i or rpm -Uv) a then run rmp -e. if above failed try manualy delete all files created by this rmp (rpm -ql) and then run rpm -e --noscripts --notriggers --nodeps. Michal aka Lampa mysql, table, query

pam_mysql

Hello, anybody tryed %subj% ??? I have problem - module doesn't work. I must recompile mysql with some directive like --lpam or --enable-pam ?? Michal table, query, sql - Before posting, please check:

wait or install ??

Hello, i must install MySQL on my Linux Box to end of this week. So is better install version 4.0 or wait a while for 4.1 release ?? When will be 4.1 released ??? Regeards Michal query, table, sql - Before posting, please

mysql4 on win nt

Hello, i installed mysql-max-4. i need use czech sorting - i set [mysqld] default-character-set=czech but create table xx (t varchar(10)); insert into xx values('a'); insert into xx values('c'); insert into xx values('t'); insert into xx values('s'); insert into xx values('b'); insert into

Re: About MYSQL APIs

Hi, on freshmeat.net you can find some libraries which provide same comfort as mysql++, so try check... S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 602 210 900, ++420 2 3337 1117