SQL problem

Hello all, Please help a newbe ;-) Have a little problem with to make a sql-query as I want to have it... The problem is I need to check in 3 tables and count out and get it presentated per n_id like n_id counted 01 5 02 10 03 2 My tables look as follows... In sub: id n_id

Re: set auto_increment does not work?

Hi! For InnoDB, CREATE TABLE ... AUTO_INCREMENT=... works starting from 5.0.3. Until then, you have to use the 'insert + delete a dummy row' method to init the counter. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot

Best way to order mysql results with limit

Hey list I have a table like this: Act_name Act_type_id Act_date Heyhey 1 22-06-05 Aloha 2 22-06-05 Tralala 2 22-06-05 Wuhu 1 22-06-05 Hehe 3 22-06-05 Olalal 3 22-06-05 Pompom 1 22-06-05 Wuhu 2 22-06-05 Now i want to do a select which returns the two most near (in

where mysql_config?

Hi listers i am fiddling around with the problem of not being able to access mysql 4.1.* from php with new users created in mysql 4.1. no official statement can be found nor from mysql nor from php concerning this problem. both just avoid to talk about it. the only hint i found is create php

Re: Effect of VARCHAR length?

Hello. Really, a varchar(255) column gives you a big flexibility and may save a lot of space. Usually such records uses as many characters as needed plus one byte for it's length. When you use MyISAM tables you can get some performance disadvantages and use more space when your table is

Re: Unable to install 4.1 on Fedora Core 2

Hello. Package Not Found dialog box saying Unlocatable Package libmysqlclient.so.10 Required Install MySQL-shared-compat-4.1.10-0.i386.rpm. If error remains use --force --nodeps options for the rpm command. [snip] I'm trying to install MySQL-server-4.1.10-0.i386.rpm on Fedora Core

Re: connect /sellect to 2 dbs

Hello. Can I select from one db and insert into another? Yes. For example: insert into test2.t2 select a from test.t2; We insert values from table t2 of the database test into table t2 of the test2 database. See: http://dev.mysql.com/doc/mysql/en/identifier-qualifiers.html

Re: Merging / Moving InnoDB Databases

Hi Heikki, Thanks for the reply. If you were charged with moving an InnoDB database with 40,000,000 records (based on an old version of one of our databases, has since grown) within a standard maintenance slot (say up to 4 hrs) what would you do? Are we looking at requiring a separate hardware

Re: referencial integrity problem

Hello. Use InnoDB tables instead of MyISAM. See: http://dev.mysql.com/doc/mysql/en/ansi-diff-foreign-keys.html Philipp Snizek [EMAIL PROTECTED] wrote: Hi I run a Postfix MTA attached to a mysql DB with various domains on it. A domain consists of email addresses. When I

Re: referencial integrity problem

Hello. What output does the following statement produce: show variables like 'have_innodb'; Philipp Snizek [EMAIL PROTECTED] wrote: =20 You need to make *both* of your table definitions include=20 Type=3DInnoDB; *then*, the cascading delete should work fine. This is

Re: Upgrading mySql from 3.23 to 4.1.10

Hello. Install MySQL-client-4.1.10-0.i386.rpm. Troy Richard [EMAIL PROTECTED] wrote: I have upgraded from mysql 3.23 to 4.1.10 everything seems to be working. I'm trying to run the mysql_fix_privilege_tables script to update the privileges and I'm getting the following error:

Re: missing header file?

Hello. You should run configure in the source directory, which will create a Makefile in the include/ directory. Then cd into it and run: make my_config.h [snip] I'm trying to modify and recompile some UDFs for MySQL 4.1. I'm using the header files from the version 4.1.10 Linux

Re: SQL problem

Sorry, I have missed information in my earlir question, that I have added below. Joppe A wrote: Hello all, Please help a newbie ;-) Have a little problem with to make a sql-query as I want to have it... The problem is I need to check in 3 tables and count out and get it presentated per

Re: Problem with mysqlhotcopy

Hello. e:\mysql\scripts\mysqlhotcopy.pl -u root -p password db_name /backup_test I think, the problem is in the missing period in /backup_test, it should be ./backup_test. But generally Windows isn't listed in operating systems list on which mysqlhotcopy works. Maybe cygwin will help.

Re: [ERROR] Got error 127 when reading table

Hello. I went so far as to delete entire tables and recreate them. Can you create a new table (with name which you didn't use before) and check if the errors remain on the new table? Does REPAIR TABLE solve the problem? Also ensure that there are no another MySQL instances running? Or

Re: access to mysql in linux

Hello. It is a frequently asked question. Search in the list. For example see thread: http://lists.mysql.com/mysql/160391 Sebastian Luque [EMAIL PROTECTED] wrote: Dear List members, Having relatively recently moved to GNU/Debian Linux from Windows, I'd like to move my MS

Re: mysqlbug

Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Jerome Campbell [EMAIL PROTECTED] wrote: Hello, I've been using MySQL for a while on my computer to host a couple of things and since today I've got this error: 2003 - Can't connect to MySQL server

Re: Which version for fastest simple inserts, selects etc

Hi Pete! Am Mi, den 23.02.2005 schrieb Pete Lancashire um 4:43: If I needed a brute force DB on an x86 platform would using Version 3 vs 4 buy me any performance today ? IMO, you should not start with version 3 any more - it is too old. Probably, you should not even start with 4.0 but use

RE: referencial integrity problem

Hi Hello. What output does the following statement produce: show variables like 'have_innodb'; mysql show variables like 'have_innodb'; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | YES | +---+---+ 1 row in set (0.00

Re: where mysql_config?

Hello. i am fiddling around with the problem of not being able to access mysql 4.1.* from php with new users created in mysql 4.1. What error does the php produce? this type of api i need a program called mysql_config, which is said to Usually it is included with the official

Re: Which version for fastest simple inserts, selects etc

Hello. Use the latest release (4.1.10 now). You'll get a huge speed up using bulk inserts. Pete Lancashire [EMAIL PROTECTED] wrote: If I needed a brute force DB on an x86 platform would using Version 3 vs 4 buy me any performance today ? 90% inserts, 5% simple selects, 5% other.

Re: Strange Issues

Hello. If important I am version running 4.1 on Win XP SP2 IIS. Use the latest release (4.1.10 now) and hexademical values. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html Rob Cochrane [EMAIL PROTECTED] wrote: I am new to this list and to MySQL returning to

Lost InnoDB Data

Hello all. I have a problem which is very serious for us. After shutting down our mysql database and starting it up again, ALL our innodb-tables are just as they were several weeks ago (january 31). All the changes, additions, deletions that have happened since are gone. The same thing happens

Re: Avoiding filesort #2

Thanks Mike for your feedback. Unfortunately the HANDLER statement has the same limitation, i.e. it doesn't allow you to specify range criteria for index key parts. You have to specify constants in the index_name (...) specifier. --- mos [EMAIL PROTECTED] wrote: At 08:47 PM 2/22/2005, you

Authorizing Problem in MySQL 4 with Mandrake 10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is localhost and user is root.I entered the root password. Here is the log :-

Re: Authorizing Problem in MySQL 4 with Mandrake 10

Prabath Ranasinghe (by way of Prabath Ranasinghe [EMAIL PROTECTED]) ha scritto: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is

Connect to MYSQL server from Wi-Fi enabled Windows CE device

Hi All, I am developing a embedded VB application running on a hp ipaq running Windows CE 2003. This app has to connect to a MYSQL DB over a wireless network. I have surfed the internet for hours with no luck. Can anyone please help me with this problem. Regards Hough -- MySQL General Mailing

RE: UNIQUE Key Allowing Duplicate NULL Values

Is there any flag I can set on the column or key to not allow duplicate nulls? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: Paul DuBois

RE: UNIQUE Key Allowing Duplicate NULL Values

At 8:10 -0500 2/23/05, Gustafson, Tim wrote: Is there any flag I can set on the column or key to not allow duplicate nulls? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ No, you'd

RE: referencial integrity problem

Hi thanks for your help and your answers, it works now. foreign key (ownerdomain) references domains(domain) on delete cascade ^^ was missing. Philipp -Original Message- From: Philipp Snizek [mailto:[EMAIL PROTECTED] Sent:

RE: UNIQUE Key Allowing Duplicate NULL Values

Oh well, thanks anyhow. If I could put in a feature suggestion, it would be a flag that I could set to disallow duplicate nulls. :) Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/

SELECT ERROR

I'm trying to compare 2 tables and keep getting an error. SELECT * from listings where listings.id = fake.id; The error is Error 1109: Unknown table 'fake' in where clause or Error 1109: Unknown table 'listings' in where clause depending on the table order at the end of the query. Both tables

RE: Authorizing Problem in MySQL 4 with Mandrake 10

Be careful maybe you are mistaking here: the mysql root user as nothing to see with the mandrake root user. For exemple I lauch the mysql server as root from command line whereas I'm just a user on my desktop. So the mandrake root password and the mysql root password are also completly

Re: UNIQUE Key Allowing Duplicate NULL Values

Tim, Oh well, thanks anyhow. If I could put in a feature suggestion, it would be a flag that I could set to disallow duplicate nulls. :) What for? NULL is not equal to NULL. Period. If you don't want NULLs, make the column not null. The specification is correct. With regards, Martijn

RE: SELECT ERROR

If you want to compare the 2 tables you have to join them: select * from listings, fake where listings.id=fake.id; If you do your query SELECT * from listings where listings.id = fake.id; it simply doesn't know where to get fake.id From: Ed Curtis [EMAIL PROTECTED] To: mysql@lists.mysql.com

RE: SELECT ERROR

Thanks, as soon as I seen it I slapped myself really hard :) On Wed, 23 Feb 2005, mel list_php wrote: If you want to compare the 2 tables you have to join them: select * from listings, fake where listings.id=fake.id; If you do your query SELECT * from listings where listings.id = fake.id;

RE: UNIQUE Key Allowing Duplicate NULL Values

Martijn, The problem is that I don't want more than one row in the table that has a null value in the column. As you've pointed out in your e-mail, there's a difference between NULL and BLANK. It's not that I don't want NULL values, it's that I don't want MORE THAN ONE. Tim Gustafson MEI

list

Checking if this message gets through Reinhart Viane D-studio [EMAIL PROTECTED] Graaf van Egmontstraat 15/3 2800 Mechelen Tel: +32 (0)15 448 901 STRICTLY PERSONAL AND CONFIDENTIAL This message may contain confidential and proprietary material for the sole use of the

BIGINT UNSIGNED issue?

Hi I am testing against MySQL 4.1 current release on Windows and there seems to be a fault with unsigned bigint datatypes. Using a BIGINT UNSIGNED datatype, the maximum value that will be accepted on insert query is 9223372036854775807 , which is actually the published maximum for signed

Fw: Merging / Moving InnoDB Databases

(forwarded to the list) - Forwarded by Shawn Green/Unimin on 02/23/2005 09:08 AM - [EMAIL PROTECTED] wrote on 02/22/2005 04:59:39 PM: Regardless of the Mysql angle - a windows editor that allows you to view large text files is an absolute necessity. Notepad tries to load the

Re: UNIQUE Key Allowing Duplicate NULL Values

The problem is that I don't want more than one row in the table that has a null value in the column. As you've pointed out in your e-mail, there's a difference between NULL and BLANK. It's not that I don't want NULL values, it's that I don't want MORE THAN ONE. I can easily continue

Re: UNIQUE Key Allowing Duplicate NULL Values

Tim, The table in question is used to store aliases to web sites. That is, meitech.com is the main web site, and www.meitech.com is the alias. So, the first column is the domain name in question, and the second on is the host name part of the alias, in this example www. Now, I also have

Change default character_set_client, connection, results

Hello, could someone tell me if it is possible to change default settings for character_set_client, character_set_connection and character_set_results variables? They are always set to latin1 and I didn't find any way how to change their default value. I'm using MySQL 4.1.9-nt and MySQL ODBC

Re: Avoiding filesort #2

At 05:12 AM 2/23/2005, Homam S.A. wrote: Thanks Mike for your feedback. Unfortunately the HANDLER statement has the same limitation, i.e. it doesn't allow you to specify range criteria for index key parts. You have to specify constants in the index_name (...) specifier. Are you saying you can't

RE: Odd rounding errors with 4.1

This reminded me of one more difference between Windows and Linux/Unix. MySQL use the round function out of the host libraries. If you are on a Windows box the rule for rounding is if the column immediately to the right of the column you are rounding to is a 5 then round up i.e. make 2.485

Re: MySQL constraint question

Thanks for these answers. I can now write this in the application and be OK with it without that nagging feeling that somebody will say upa if you just put xxx in the database then you could filter all that in your query. If it ever happens I can say, ah yes but when I wrote that we were only

Re: Is there a Library of complex queries/inserts/queries?

On Sun, 13 Feb 2005 10:34:39 +, wrote: Hi, Sometimes an example is worth a 1000 words. Does anyone know of a website with lists of mysql statement examples? ie a list of queries, a list of updates, list of inserts from simple examples to joins regexps etc From Shantanu

Re: Change default character_set_client, connection, results

Hello. Use MYSQL_SET_CHARSET_NAME option for mysql_options() function. See: http://dev.mysql.com/doc/mysql/en/mysql-options.html [snip] Hello, could someone tell me if it is possible to change default settings for character_set_client, character_set_connection

Date Functions in MySQL

I have a log table that records certain transactions on one of my sites. I'm using a timestamp field to mark the date/time of each transaction. I'm trying to run a query that will display the transactions by date using the following SQL: SELECT COUNT(log_id) AS total,

Selecting with a list of keys

I would like to construct a query that searces on a variable list of primary keys. Example: Lkeys = [12, 23, 15, 17]## python - style list of integers Select column from table where ID in Lkeys; ## mysql statement? Is this possible, or does one have to generate a query for each key or

Re: UNIQUE Key Allowing Duplicate NULL Values

In article [EMAIL PROTECTED], Gustafson, Tim [EMAIL PROTECTED] writes: Martijn, The problem is that I don't want more than one row in the table that has a null value in the column. As you've pointed out in your e-mail, there's a difference between NULL and BLANK. It's not that I don't want

Re: Selecting with a list of keys

Tim Johnson wrote: I would like to construct a query that searces on a variable list of primary keys. Example: Lkeys = [12, 23, 15, 17]## python - style list of integers Select column from table where ID in Lkeys; ## mysql statement? Is this possible, or does one have to generate a

Re: Date Functions in MySQL

Clarence wrote: I have a log table that records certain transactions on one of my sites. I'm using a timestamp field to mark the date/time of each transaction. I'm trying to run a query that will display the transactions by date using the following SQL: SELECT COUNT(log_id) AS total,

Re: Date Functions in MySQL

Shoot me now, please. Thanks - I don't know how I missed that! Thanks - re-ran the query and things seem to be a-ok! On Wed, 23 Feb 2005 18:42:17 +0100, Roger Baklund [EMAIL PROTECTED] wrote: Clarence wrote: I have a log table that records certain transactions on one of my sites. I'm using

Shell execution of mysql query

I am executing a mysql query through shell and expecting to see a return of SQL execution. mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile rc=$? Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the same query as listed below. If the same

LOAD INDEX INTO CACHE behaviour

Hi, Working on v4.1 (and from what I read, soon to upgrade to 4.1.18) and I'm dealing with an MyISAM table expected to idle at around 400 million records. Since it is the back-end to a high volume web site, we are trying to optimize the performance of the indexes. I read in

Re: Shell execution of mysql query

On Wed, 23 Feb 2005, Nupur Jain wrote: Hi Nupur, I am executing a mysql query through shell and expecting to see a return of SQL execution. mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile rc=$? Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the

RE: Shell execution of mysql query

On Wednesday, February 23, 2005 12:30, Nupur Jain wrote: I am executing a mysql query through shell and expecting to see a return of SQL execution. mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile rc=$? Here rc is always 0 and so are $opFile entries. $queryFile

Re: Shell execution of mysql query

At 10:29 -0800 2/23/05, Nupur Jain wrote: I am executing a mysql query through shell and expecting to see a return of SQL execution. mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile rc=$? Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the same

Re: Avoiding filesort #2

--- mos [EMAIL PROTECTED] wrote: At 05:12 AM 2/23/2005, Homam S.A. wrote: Thanks Mike for your feedback. Unfortunately the HANDLER statement has the same limitation, i.e. it doesn't allow you to specify range criteria for index key parts. You have to specify constants in the index_name

Difficulty starting mysql

Hello, I'm attempting to start mysql 4.1.10 compiled source code on Red Hat Advanced Server 2.1 with apache 2.0.49. ./configure, make and make install went successfully. But when I attempt to start mysql using this command: sudo mysqld_safe --user=mysql I get the following errors: Starting

Re: Lost InnoDB Data

Henrik, the most probable reason is that someone has edited my.cnf meanwhile, and you are now reading ibdata files from somewhere else. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also

RE: Difficulty starting mysql

Did you follow the procedure in http://dev.mysql.com/doc/mysql/en/quick-install.html ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 1:29 PM To: mysql@lists.mysql.com Subject: Difficulty starting mysql Hello, I'm

Backup User

Is it recommended to create a MySQL user for doing backups? Running mysqldump from a script, the username and password will have to be embedded in plain text. If I were to create a MySQL user expressly for doing nightly backups what are the minimum permissions needed? -- MySQL General

Re: Backup User

Jim McAtee wrote: Is it recommended to create a MySQL user for doing backups? Running mysqldump from a script, the username and password will have to be embedded in plain text. If I were to create a MySQL user expressly for doing nightly backups what are the minimum permissions needed? You

Re: Backup User

On Thu, Feb 24, 2005 at 08:39:00AM +1100, Daniel Kasak [EMAIL PROTECTED] wrote: You don't need to create a special MySQL user for backups. If you like, you can create a Linux account that only you know the password to, and then make sure the backup scripts is only readable by you ( root will

Innodb - raw partition vs filesystem store?

What are pros/cons as far as performance, reliability, and ease of backup/restore? Anyone have any experience running Innodb on raw partition? Any thoughts as to best filesystem for Innodb? What about pros/cons of journaled filesystems when in use with Innodb (i.e. transactions)? How do the

RE: missing header file?

Thanks, I'll try that. I haven't actually tried to compile MySQL from source and haven't read the instructions. Sorry. It seems that the file in question is present in MySQL Linux binary distribution, missing from source (i.e. configure should be run), missing from Windows binary, present in

Re: Backup User

- Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Jim McAtee [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, February 23, 2005 2:39 PM Subject: Re: Backup User Jim McAtee wrote: Is it recommended to create a MySQL user for doing backups? Running mysqldump from a

Access Denied For User

Hello, I have a Linux server running Apache, MySQL, unixODBC, MyODBC In my odbcinst.ini file I have the following: [MySQL] Description= ODBC for MySQL Driver = /usr/local/lib/libmyodbc3.so FileUsage = 1 I have setup the following system DSN in the odbc.ini file: [PbDatabase]

Re: Difficulty starting mysql

errno 13 is permission denied. It looks like mysql doesn't have permission to access your grant tables. -Eric On Wed, 23 Feb 2005 14:00:58 -0600, John Trammell [EMAIL PROTECTED] wrote: Did you follow the procedure in http://dev.mysql.com/doc/mysql/en/quick-install.html ?

RE: Is there a Library of complex queries/inserts/queries?

MySQL Cookbook by DuBois. -Original Message- From: zzapper [mailto:[EMAIL PROTECTED] Sent: Sunday, February 13, 2005 2:35 AM To: mysql@lists.mysql.com Subject: Is there a Library of complex queries/inserts/queries? Hi, Sometimes an example is worth a 1000 words. Does anyone know of a

MYSQL_FIELD

Dears, My code is : void CMysql::ReadingFld(const char *tblname) { MYSQL_RES *fldres; int i; fldres=mysql_list_fields(connection2db,tblname,%); ptr.srcFldNumber=mysql_num_fields(fldres); FieldsRow=mysql_fetch_fields(fldres); for (i=0;iptr.srcFldNumber;i++) cout FieldsRow[i]; }//end of

Images to MySql Database in PHP or JAVA

Hello list- I am programing both in Java and PHP. Can anyone point me to sample code for either on saving an image to a table? Thanks, -Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Images to MySql Database in PHP or JAVA

Dear member,you can visit: http://dev.mysql.com/doc/connector/j/en/index.html http://dev.mysql.com/doc/mysql/en/php.html Hello list- I am programing both in Java and PHP. Can anyone point me to sample code for either on saving an image to a table? Thanks, -Chris -- MySQL General Mailing

Excessive Server Load Problems

Hi all, I have just created a databased website that is working with a fairly large number of records (well, 10 million records is the biggest database ive ever worked on so far) but also have a large number of searches of these records happening regularly. The problem ive come across, is my