default characterset of function string parameter

Dear MySQL fans, I am checking MySQL 5.0 to use multibyte strings, Japanese. When I use char type parameter without CHARACTER SET clause, parameter's character set is not the database character set but latin1. 17.2.1. CREATE PROCEDURE says: For character data types, if there is a CHARACTER S

Help on query joining a 3rd table

Hello! I am building a query to get a monthly total for receipts and receipts plus TAX. My problem is the TAX, it can be different for each receipt. I need help on including and relating each TAX value/id with each receipt, like receipt_items.price * 1.21 etc. The tables are like the following ex

Help on query joining a 3rd table

Solved. Thanks. -Mensagem original- De: pedro mpa [mailto:[EMAIL PROTECTED] Enviada: domingo, 29 de Janeiro de 2006 18:25 Para: mysql@lists.mysql.com Assunto: Help on query joining a 3rd table Hello! I am building a query to get a monthly total for receipts and receipts plus TAX. My p

Support between MySQL and PHP

Hi all. I figured this question was suitable for both the MySQL list and the PHP-General list. Here's what I'm running into. I just installed MySQL5 and currently have PHP 4.3.11 installed. I am wanting to connect to the mysql database on localhost, but I get the following results: --

display a hierarchic tree

I have the following table: mysql> select * from link_categories; ++---+-+---+---+-+ | id | level | category_id | category | parent_id | deleted | ++---+-+---+---+-+ | 1 | 1 |1000 | So

Re: display a hierarchic tree

Jochen, ...I want to display a tree like: Software Virenscanner Linux Debian Woody Windows Windowsd XP Packprogramm Sniffer Hardware Vermischtes It looks more like a parts

Re: Support between MySQL and PHP

Hi Philip. I'm wondering if you have mysql server version 3.23.49 still running on your machine? If so, version 5 would not start up, as it would not be allowed access to port 3306. Try doing my_print_defaults mysqld and my_print_defaults client mysql from a root shell and see what values y

Re: display a hierarchic tree

Hi Jochen. An alternative approach could be to pull all the values out of the database using select * from ..., and then build the tree-structure in your application logic. Insert the relevant values returned from mysql in the appropriate places of the tree-structure in the app code. Keith

Re: MySQL ignores foreign key relationships between tables?

Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Paul DuBois wrote: At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote: I have two tables, registration & schedules, that look like this: CREATE TABLE registration ( idSERIAL NOT NULL UNIQUE,

Can't reload from dump file

We have had some problems with corrupt data due to running out of space recently. I wanted to repair the tables so I backed up our database by dumping to a file with mysqldump. I then tried to repair the database and had some problems with that. I stopped MySQL and moved the database to database

Re: MySQL ignores foreign key relationships between tables?

At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Paul DuBois wrote: At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote: I have two tables, registration & schedules, that look like this: CREATE TABLE registration (

Revert using Binlog

Am hoping someone can give me the safest advice here. Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot of foreign key constraints. However... ON DELETE CASCADE When we needed RESTRICT. Net effect? Some editing today lead to cries of "Where has half the data gone?" We have