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
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 bac
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-0
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 w
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 frag
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
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
>
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 targ
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.
> W
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.
>
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:
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
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
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 h
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
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 M
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 ser
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 4.
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.
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 bin
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% ot
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
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
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
-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 :-
[EM
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
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 L
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 [mailto:
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 hav
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
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/
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 tabl
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
different
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,
Mart
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
Su
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;
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 Techno
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
o
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 Bigints.
(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 en
> 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 arg
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 a
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 3.
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 ref
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 >>>
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 on
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
http://en
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 and
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,
WEEK(FROM_UNIXTIME(UNIX_TIM
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
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 do
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 quer
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,
WEEK(FROM_UN
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
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 que
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 the
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
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. $qu
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
--- 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 t
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
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 ba
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,
>
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 Mailing
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 d
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
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
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 Wi
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Jim McAtee" <[EMAIL PROTECTED]>;
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 script, the us
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]
Descri
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
>
> ?
>
> > ---
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 w
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;ihttp://lists.mysql.com/mysql
To unsubscribe:http:
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]
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 Genera
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 ho
76 matches
Mail list logo