How to include a dynamic function result in a view?

I have a table with date values: ++ | theDate| ++ | 2005-08-15 | | 2005-08-16 | | 2005-08-14 | ++ I can execute this select statement on it: select * from tDay where theDate > date_sub( now(), interval 1 day); And I can create a view from it: create

Re: How to include a dynamic function result in a view?

I'm using 5.0.9 beta standard. I'll try to upgrade and will re-post if I still get erroneous results. s.m. Am Mon, 15 Aug 2005 18:53:40 +0200 hat Gleb Paharenko <[EMAIL PROTECTED]> geschrieben: Hello. What version of MySQL do you use? On my 5.0.11 I have a correct result: mysql> show c

SQL Parser woes

>Description: I try to run mysql in conjunction with Apple WebObjects5 (the EnterpriseObjects Framework). This framework generates certain SQL Statements which fail (see How-To-Repeat). >How-To-Repeat: Ok first the "positive test": create table test ( nam

Fulltext index is not being built with large database

it to a partition with 50GB space (about 15 times as much as the database tables). Mysql runs on gentoo-linux 2.4 with 800MB RAM with server version 4.0.17. Any clues, hints or tips? Thank you. sascha mantscheff hahnenbach 51570 windeck [EMAIL PROTECTED] telefon +49-2292-922 492 telefax +49-229

Re: Fulltext index is not being built with large database

. s.m. Am Sat, 10 Apr 2004 04:01:15 -0500 hat Matt W <[EMAIL PROTECTED]> geschrieben: 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,

order by problem with 3.22

The following query works with mysql 3.23: SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) It does not with mysql 3.22.27. Neither does any query with a function call in the order by clause. Is this documented somewhere? Am I missing something? Is there a workaround other t

Re: order by problem with 3.22

Am Sonntag, 16. Februar 2003 21:15 schrieb Paul DuBois: > At 20:43 +0100 2/16/03, sascha mantscheff wrote: > >The following query works with mysql 3.23: > > SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) > >It does not with mysql 3.22.27. Neither

cannot enter german umlauts in mysql

I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with "mysql --default-character-set=latin_de", but it complained about the character sets not being installed. Then I installed the mysql server, which

Re: cannot enter german umlauts in mysql

> 'support-files' directory of the mysql source code. > > Ich hoffe daß ich dir geholfen habe. > Ken > - Original Message - > From: "sascha mantscheff" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 19, 2002 9:46 AM

Re: Cannot access the Database on same Machine

probably something wrong with the permissions in the mysql database. as a workaround, try to connect not via the local socket, but via a tcp/ip-connection: # mysql -h 127.0.0.1 -u my-user -p my-database or insert the real ip of the machine instead of the loopback address. check if there

still no umlauts in mysql --experts help needed

I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with "mysql --default-character-set=latin_de", but it complained about the character sets not being installed. Then I installed the mysql server, which

Re: still no umlauts in mysql --experts help needed

Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. > > mysql does not let me enter german umlauts, though. I tried to start it > > with "mysql --default-character-set=latin_de", but it complained about > > the character sets n

different row count in explain select on different systems

I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server. The FreeBSD mysql version is 3.23.49. The linux mysql version is 3.23.33. I just copied a large table using mysqldump | mysql from the linux server to the FreeBSD server. An explain statement on a select on this table shows different row cou

Re: still no umlauts in mysql --experts help needed

ue, by default LINUX sets the language > environment for the shell to an ISO setting, FreeBSD does not. > > Ken > ----- Original Message - > From: "sascha mantscheff" <[EMAIL PROTECTED]> > To: "Harald Fuchs" <[EMAIL PROTECTED]> > Cc: <[EMAIL PR

Re: logrotate problem

in the postrotate section, you have to add the user and password parameters to mysqladmin: mysqladmin -u someuser --password=somepassword flush-logs s.m. Am Donnerstag, 21. März 2002 19:23 schrieben Sie: > Hello there! > > > I have added recently administrative user to mysql database:

Re: still no umlauts in mysql --experts help needed

Am Donnerstag, 21. März 2002 16:44 schrieben Sie: > sascha, > Wednesday, March 20, 2002, 12:52:41 PM, you wrote: > > sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > sm> > I just installed mysql fresh out of the box on a fresh SuSE linux > 7.1. sm> > mysq

Re: Can you Change Nulls in the MySQLDump from \N?

can't you filter the output with sed? s.m. Am Donnerstag, 21. März 2002 21:11 schrieben Sie: > Is there a way to tell MySQL to put a blank space instead of \N in the > tab-delimited files when it does a dump? I'm working on a MySQL to SQL > Server migration and having problems with the output fi

Re: still no umlauts in mysql --experts help needed

Am Freitag, 22. März 2002 11:58 schrieben Sie: > > Egor: > > Thanks for the hint. I browsed the manual for readline(3) and for > > /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all > > other programs and from the bash command-line - only in mysql they don't > > work. Where

Number pickup with parallel updating?

timestamp field) and then updating this filed with a timestamp. How can i realize this with using perl ? Any advice? How to connect to database using perl i allready know but iam trying to find out how manage this small problem the most easy way... Thanks in advance Sascha

Where to find options / my.cnf documentation?

Where do I find a complete documentation of all options and entries in my.cnf and the mysqld start options? I searched the mysql.com site, but to no avail. Neither does the online documentation doesn't seem to have a chapter on it. s.m. Qualimedic AG S

Re: Re[2]: Where to find options / my.cnf documentation?

Ihre Nachricht vom Monday 09 July 2001 17:10: > It's so easy, you won't think of it: start mysqld with parameter > -h (=help): > > mysqld -h > > shows all parameters and current settings Alas, it does not. It shows a couple of variable settings, but not the syntax for tha various logging options

MYSQL failes at startup

hi, on a suse 7.1 system my mysql fails on startup. it can't create a pid. how can i fix this ? sascha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

error 127

ny comments highly appreciated. ------ Sascha Eversmeier Web Developer MAGIX Entertainment Products GmbH Rotherstraße 19 10245 Berlin fon: +49 (0)30 29392-325 fax: +49 (0)30 2939

Perl Problem!

advance Sascha PS: the code sub generatepins { open (GETESTET, ">> /usr/local/httpd/sms/generated.pin"); open (GENERIERT, "< ./pinanfrage.dat"); db connect und write my $dbh = DBI->connect("DBI:

Watchdog für mysql in Perl?

Hi! Short question: i want to have a perl watchdog telling me when executed if my sql-server is running and if anything is allright with it. So if i get any errormessage i can restart the server by remote. Has someone done this allready? Any hint? Thanks again and best regards Sascha Kettner

Select with dbi perl??? Help please!

ideas to fix the problem? Thanks a lot in advance Regards Sascha Kettner #!/usr/bin/perl use DBI(); # # Get form Data # # &parse_form; # Script Variables # $input{knd} = ""; $input{pin} = &qu

Select with dbi perl??? Help please!

other ideas? Regards Sascha Kettner > -Ursprüngliche Nachricht- > Von: Jesse Shy [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 6. Januar 2002 23:54 > An: [EMAIL PROTECTED] > Betreff: RE: Select with dbi perl??? Help please! > > > I have found that unless I put a % s

no umlauts in mysql client

. qualimedic ag sascha mantscheff telefon 02292-922 492 telefax 02292-922 493 mobil 0171-620 0380 e-Mail [EMAIL PROTECTED] - Before posting, please

Re: Checking if Replication really works

I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. s.m. - Before posting, please check:

Re: Checking if Replication really works

Ihre Nachricht vom Friday 18 January 2002 12:14: > sascha mantscheff wrote: > > I'm not using replication, but for a test if it really works I would do > > some data manipulations on the master and afterwards a complete mysqldump > > of master and replica and diff the

Re: Checking if Replication really works

Ihre Nachricht vom Friday 18 January 2002 12:14: > sascha mantscheff wrote: > > I'm not using replication, but for a test if it really works I would do > > some data manipulations on the master and afterwards a complete mysqldump > > of master and replica and diff the

RE: Mysql to Mdb

that created the tables in mssql (that could be done locally on your pc with access) and then opens access and transferred it to the server. may this be a way? ciao sascha - Before posting, please check: http://www.mysql.com/

LIKE clause in DELETE-Statement

the SELECT and WHERE functions chapter. So does MySQL actually deny LIKE in DELETEs as it seems to do or is there a way to use this combination as you can guess reading the manual?! Thanks in advance for a short "No, not possible" or a hint how it coul