You have some unnecessary indicies.
What happens if you remove them?
Ciprian Trofin wrote:
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE
On 3 Feb 2003, at 13:58, Stefan Hinz, iConnect (Berlin wrote:
You could use the DATE_FORMAT() function of MySQL for this:
mysql SELECT DATE_FORMAT(NOW(),'%M');
+-+
| DATE_FORMAT(NOW(),'%M') |
+-+
| February|
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting to
MyISAM. I wanted to change it to InnoDB, but everytime I save it, it reverts
back to MyISAM.
Is this feature not available in Windows? It appears that
Hi
Has anyone managed to get Microsoft SQL Server (2000 (SP2)) to replicate
data to MySQL (3.23.49) via Microsoft heterogeneous replication MySQL ODBC
Driver (3.51)?
Deletions at the MS end replicate to the MySQL Successfully, BUT
Insertions and updates fail, it seem to be a problem with
Wiley,
E:\mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
Error 13 means permission denied. Check if the MySQL has write access
to E:\. BTW, I don't think E:\ is a very good place to store your
databases. I would recommend at
Hi Stefan,
Thanks a lot! With your help my issue resolved. Now both the
command line connection and PHP connection can work fine.
But still I have question regarding my.cnf: I searched the whole file
system and found only one my.cnf in /etc/, and no .my.cnf. All I can
find about the datadir and
Well, this query works, so it must be doable
SELECT DATE_FORMAT(NOW(),'%M') AS TheMonth,
IF(DATE_FORMAT(NOW(),'%M')='February','Yep','Nope') AS IFCheck
FROM pickAnyTableAsLongAsItExists
WHERE DATE_FORMAT(NOW(),'%M') = 'February'
LIMIT 1;
And provided the month is indeed February. ;)
Not
hello,
I have a question about database structure and optimization.
I have a shopping cart where several items can fall into several of many categories,
but each item can also be several of a few product types.
my product type is limited to aprox. 5 product types. Further 99% of items will be
In the last episode (Feb 03), Rochester, Dean said:
We had an issue the other day where we could not access the myslq
database we have on our redhat linux 7.2 box.
when I did a
ps -ef |grep mysql
I got the following.
root 645 1 0 2002 ?00:00:00
man this took a day to get to the list, it needs to check a range in particular month
end_date or month start_date
Kevin Smith [EMAIL PROTECTED] 02/04/03 08:55am
Well, this query works, so it must be doable
SELECT DATE_FORMAT(NOW(),'%M') AS TheMonth,
Stefan,
You had it.
SELECT columnName
FROM tableName
WHERE DATE_FORMAT(columnName, '%M') = 'January';
Regards,
Victor Pendleton
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 6:59 AM
To: Daniel Rossi; [EMAIL PROTECTED]
The location of the cnf files determine what options should be applied and
take precedence during the starting of the MySQL server.
/etc/my.cnf is for global options
while the datadir/my.cnf is specific to the server
and the ~/my.cnf is user specific MySQL options.
Chapter 4.1.2 my.cnf Option
I am assuming that you do not have logging turned on.
-Original Message-
From: Jude DaShiell [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 7:04 AM
To: peter a
Cc: [EMAIL PROTECTED]
Subject: Re: restoring lost data
If it's lost, it's lost. But that's not the end of the
Alex,
I'm happy to hear you were able to resolve the socket problem!
But still I have question regarding my.cnf: I searched the whole file
system and found only one my.cnf in /etc/, and no .my.cnf. All I can
find about the datadir and socket configurations are just staying in
/etc/my.cnf and
this is how i soughta got it working
$formatted_month = date(Ym,strtotime(1 $month 2003));
$where = WHERE (DATE_FORMAT(e.start_date,\%Y%m\) = '$formatted_month' ||
DATE_FORMAT(e.end_date,\%Y%m\) = '$formatted_month' AND '$formatted_month'
DATE_FORMAT(e.start_date,\%Y%m\));
as just the
Description:
Any issue of the 'show variables' command via the mysql client is causing the
mysql server to get a signal 10 on HP-UX 11. The text in the .err log is as follows:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the
what happens when mysql -utest returns an error 2002? perror 2002 says
that's an unknown error.
--
Jude dashielljt(at)gmpexpress-dot-net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hey All,
Sorry for the newbie question, at least I think it is. Here is
my problem. I have 2 tables in my database with the following fields:
names_table and emails_table
name_id (primary key auto increment) email_id (primary key auto
increment)
hello,
I have a question about database structure and optimization.
I have a shopping cart where several items can fall into several of many categories,
but each item can also be several of a few product types.
my product type is limited to aprox. 5 product types. Further 99% of items will be
- Original Message -
(BFrom: "Richard Morton" [EMAIL PROTECTED]
(BTo: "MySQL List" [EMAIL PROTECTED]
(BSent: Tuesday, February 04, 2003 1:49 AM
(BSubject: Off Topic - PHP/Mysql Development company
(B
(B
(B Hi,
(B
(B I am sorry this is a bit off topic.
(BTrue. Not only off topic
Are you sure u have
journoNatOpt.journoid = ''
records?
select count(*) where journoNatOpt.journoid = ''
If not, maybe IS NULL instead of = ''
will help.
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 8:46 AM
Take a look at http://www.mysql.com/doc/en/NT_start.html. And about
innodb tables you can read http://www.innodb.com/ibman.html.
[EMAIL PROTECTED] wrote:
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting
I guess this question is directed at Paul DuBois, I know he hangs out on
this list: Is there, or are you planning on putting out, a shortened
version of MySQL for people who are upgrading from your last book? i.e. I
very much want to know the differences between the older and newer versions
of
HI,
To test for records that are not present in a table you should use
journoNatOpt.journoid is NULL
instead of
journoNatOpt.journoid = ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL
That was where I was going wrong. I had previously tried = Null which
doesn't work but IS NULL works.
Thanks.
Dave
At 11:46 2/4/2003 +0200, you wrote:
HI,
To test for records that are not present in a table you should use
journoNatOpt.journoid is NULL
instead of
journoNatOpt.journoid = ''
The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables
created and several MyISAM types too (approx 30 more.). On adding the 11
table of InnoDb type the following error is displayed:
ERROR 1005 at
Hi,
I think the problem is that your assuming that journoNatOpt.journoid is
'' (empty) when journoDetails.journoid has no entry in journoNatOpt.
But that's not true, the value is NULL.
So, try replacing
AND journoNatOpt.journoid = ''
with
AND journoNatOpt.journoid IS NULL
On Mon,
Hi all,
First of all , the version of mysql is 3.23.52. I am using When I do a
truncate table on a MyIsam table, the show table command shows thatt there
are no records but the table size is about 100 MBs.
Afterwards, I run an optimize table command and the table size decreases to
2KB's.
Michelle de Beer wrote:
This question might be a little OT.
My question is, what is the smallest working install
of mySQL?
Can you install it in a PDA, like the Yopy, that uses
linux as OS?
http://www.yopy.com/english/products/specification.htm
// Michelle
sql, query
Hi Michelle,
MySQL has
Nothing.
I fixed the problem w/ the indices, but it still doesn't work. Same probl.
g You have some unnecessary indicies.
g What happens if you remove them?
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE
EMS HiTech is very glad to announce MySQL Manager v2.0! Our software
becomes cross-paltform - the Linux version is immediately available.
Also a lot of new features: Database Designer, MDI Interface, Foreign
Key support, HTML Report and many more...
You can download the new version from
I installed MySQL 3.23.54 on RedHat 8.0. The installation
ran smoothly ; but when trying to start MySQL, from
the terminal this appeared communiqu:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
What I should to do?
Thanks in advance to all who
You probably know it but...
You probably know it
Using mysqlodbc 3.51.05.00 (the one you distribute ) on a w2000server
connecting to a freebsd server running mysql 4.0.9-gamma-standard i get
once in a while tha famous 0x800a01fb exception error on my asp pages.
Nothing deterministic it comes
Now I know why this error 2002 happens, nothing in the /var/run/mysql/
directory for mysql to use or run.
-- Jude dashielljt(at)gmpexpress-dot-net
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi All,
I have a string containing recordID's in a specific order (e.g.
$string=17,2,33,5,99)
How can I select those records from a table in the right order (as
determined in $string)?
SELECT * FROM table WHERE recordID IN ($string)
results in the right records but not in the order I want,
In my Linux machine the MySQL 3.x is running (installed via RPM,
using /var/lib/mysql/mysql.soc). I am trying to login using
following command but get the error as followed.
[tom@host01 ~]$ mysql -u root test
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Hi all,
First of all , the version of mysql is 3.23.52. I am using When I do a
truncate table on a MyIsam table, the show table command shows thatt there
are no records but the table size is about 100 MBs.
Afterwards, I run an optimize table command and the table size decreases to
2KB's.
Hello!
I have a problem with the innodb files, Well I have a database with a big
table with more than 3 milon of register, beside I have other databases
that haz different size. My innodb file grow up to 1 G, I make a
sql sentence, delete from from big_table, and the size of the innodb
What you're talking about is a many-many relationship, as one product can
belong to many categories, and one category can encompass many products.
The best way to implement this is to have a [category] table, a [product]
table, and a [categoryproduct] table. The latter table implements the
i'm currently developing a software using vb6 and mysql 4.0 the problem is
i'm getting a random hang from the software i develop, the hang last for
about 2 seconds or more and then it resumes again. my test environment is
win98se and the production environment is also win98. the hang symptoms also
In the DTS engine you can write a VB script to handle the quotations during
the transfer. I replicate from MS SQL to MySQL using Java and came across
the same issue. Let me know if you need any help.
-Original Message-
From: Jonathan Bedford [mailto:[EMAIL PROTECTED]]
Sent: Monday,
From the downloads page:
The Windows download contains both the Standard and Max server binaries. It
also contains a version of the command-line client which uses the Cygwin
library to provide command history and editing. Source code for the version
of Cygwin we have used is available on this
Are you looking for a comprehensive searchable archive of all posts
to this MySQL list?
Would you prefer to use archives that are actually powered by MySQL
(version 4)?
Are you interested to see what other people are searching for as it
pertains to MySQL?
Are you interested in seeing how
Are you looking for a comprehensive searchable archive of all posts
to this MySQL list?
Would you prefer to use archives that are actually powered by MySQL
(version 4)?
Are you interested to see what other people are searching for as it
pertains to MySQL?
Are you interested in seeing how
Hi All
I am trying to make a replication for my database.
The master and the slave both in version 3.23.41
I create user with FILE privilege and I flush all the tables and block write
queries.
Now I run the query SHOW MASTER STATUS and I get null in all the columns
(file, position, Binlog_do_db
* Devin Miller
[...]
thought that since name_id in the emails table would be handled
automatically by mysql since it is a foreign key. Is this a wrong
assumption? Is it the job of the application to do this?
Yes yes. :)
Note the difference between a foreign key and a foreign key constraint.
Hi All
I have been told that my php connection to my MySQL could be slow. The guys
that are telling me this have 3 years php development. Is thee anything out
there that I can measure the performance with.
This is a web site and I coud really do with the performance being fast.
Andrew
Hi,
Is there any better way of setting the
thread/process limit on Linux than
by hacking the safe_mysqld script ?
Have I missed a configuration variable
somewhere that will tell MySQL to attempt
to raise the process limit ?
I would have thought MySQL would figure it
out based on the
If you have, and always will have, no more that 64 product types, you can
store the product type in a SET field. This is effectively a hybrid between
your list and boolean solutions. MySQL stores this as a bitmap with one bit
per product type and
provides the appropriate query methods. You can
I'm thinking of setting up a bulletin board for a system with Windows 2000
OS.
Most of the good, affordable BB software uses MySQL databases.
Is it possible/practical to run MySQL on Windows OS? Does it take a lot of
techy knowledge, time trouble?
Help appreciated,
Derek.
-Original Message-
From: kk [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 8:32 PM
To: list mysql
Subject: Re: Off Topic - PHP/Mysql Development
- Original Message -
From: Richard Morton [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday,
At 10:30 +0200 2/4/03, Lisi wrote:
I guess this question is directed at Paul DuBois, I know he hangs
out on this list: Is there, or are you planning on putting out, a
shortened version of MySQL for people who are upgrading from your
last book?
Sorry, no. That wouldn't really work very well.
Hi All,
I noticed that when you return a zerofill field from a select statement into
a server-side language, say PHP or Perl, it will store the number with the
zeros included, great no problem.
However, if I insert into that table which has a primary key which is set as
a zerofill field, when I
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 6:46 PM
To: Dmitry Kosoy
Subject: Re: Innodb: Create different db on separate disks
Your message cannot be posted because it appears to be either spam or
simply off topic to our
MySQL,
My first post, please go easy if this is the wrong pleace!
I'm trying to find an IMAP server which used MySQL so that my Mozilla
Email client can file it's email a little faster.
Has anybody heard of such a device?
Regards,
Ben
Dyego Souza do Carmo writes:
How-To-Repeat:
create table teste ( id integer auto_increment unique,imagem LONGBLOB not null);
insert into teste (id) values (1);
update teste set image = (IMG OF 300K) where id = 1;
select if(imagem is null, ERRO, OK) from escriba2.teste where id = 1;
* My
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM contacts c, projects p WHERE
CONCAT(c.firstName, , c.lastName) = p.name
On Monday 03 February 2003 13:31, Ciprian Trofin wrote:
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
[skip]
Now, the problem:
This doesn't work:
SELECT R.id, U.user FROM ring R, users U WHERE R.user = U.id;
id user
-
4 0
On Monday 03 February 2003 00:40, vim m wrote:
Hi: I am new to mysql. I did an rpm install of
ver-3.23.55 on RH 7.1.
By default the data is stored in /var. Can I change
this option.
Take a look at --datadir option of mysqld or you can also specify another
location of the data dir in the
On Monday 03 February 2003 23:20, Dana Shields wrote:
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting to
MyISAM. I wanted to change it to InnoDB, but everytime I save it, it
reverts back to MyISAM.
Hello,
to allow tables bigger than 2GB, I want to compile MySQL in a way that
it can utilize the LFS support on my Linux box (SuSE 8.1, ext3 FS,
should support files up to 2048GB).
Anyone has an advice?
--
Manuel Kiessling
On Tue, 4 Feb 2003, Shomal Bafna wrote:
The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables
created and several MyISAM types too (approx 30 more.). On adding the 11
table of InnoDb type the
It appears that the record has room out of room.
135 = No more room in record file
-Original Message-
From: Shomal Bafna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 9:56 AM
To: [EMAIL PROTECTED]
Subject: Innodb: Limited creation of tables
The box is running a MySQL
I'd recommend a column of type SET.
Read about it here: http://www.mysql.com/doc/en/SET.html
Basically, if your list of product types is static, this may be a good bet. The SET
type can store any combination of 64 members,
stored as bits.
To list all items int a product type, you might use
64 matches
Mail list logo
