Sunil,
in InnoDB, the maximum indexed column length is 767 bytes.
Osku is improving the error message:
http://bugs.mysql.com/bug.php?id=13315
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: Sunil Vishwas [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent:
Hello,
Can anyone tell me what advantages there are in keeping dates and times in a
MySQL DateTime field, as opposed to storing its string equivalent in a Varchar
field ?
Regards,
Danny
Can anyone tell me what advantages there are in keeping dates and times in
a MySQL DateTime field, as opposed to storing its string equivalent in a
Varchar field ?
Decent sorting, validity checking, being able to use the DATE and TIME
functions etc etc...
With regards,
Martijn Tonies
Database
Hi guys. I don't want my job done by anybody else, but I have found no solution
for several days to this problem.
I am developing a micro-finance system to farmer communities. The problem I
have got is in the database description.
I have three principal tables: (see SQL at the end).
1.
Is this what you are looking for:
SELECT clone_ids, COUNT(DISTINCT(gene_ids)) as count_genes
FROM table_name
GROUP BY clone_ids
or
SELECT clone_ids, COUNT(gene_ids) as count_genes
FROM table_name
GROUP BY clone_ids
Hope this helps,
Alvaro
- Original Message -
From: Xiaobo Chen [EMAIL
Hi.
I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27
(with static modperl module).
The database we are using is quite large.
The main problem we are having is that certain processes can take quite
a long time.
This is due to mysql churning through data.
I'd like to
Hi List,
I have a performance problem I can't get solved.
I have 2 tables, called Updates (1 mln rows) and Data (5 mln rows).
Table Updates has 2 (non-unique) keys, defined as:
Hash bigint(20) unsigned default NULL
Year tinyint(4) NOT NULL default '0'
Table Data has the same 2 (non-unique) keys,
Greetings everyone, I am having a problem with PHP and mysql I have copied a
script exactly off a website to open the database and insert a new user I
try to access the mysql database using the root user, and enter information
into the user table, this is the PHP I am using
?
include
Hi,
I think you could use something like
SELECT DISTINCT
(CASE p.ship_status
WHEN '1' THEN shipping_now
WHEN '2' THEN shipping_soon
ELSE 'unknow'
END) as status
FROM products AS p
INNER JOIN cart AS i
ON i.product_id = p.id
WHERE i.session_id = prepSQL(tConn, tSessionID);
If there are
Hi.
Looks like the 'hosts' grant table is missing,
corrupt, or does not have permissions set correctly.
My examples come from version 4.1 I hope they apply,
or at least point you in the right direction.
My datadir is /var/lib/mysql - your's may be different
within the datadir there is another
change the group
chown -R mysql.daemon /dir/name
try that
On Tuesday 25 October 2005 16:05, Michael McFadden wrote:
Hi.
Looks like the 'hosts' grant table is missing,
corrupt, or does not have permissions set correctly.
My examples come from version 4.1 I hope they apply,
or at
** Low Priority **
Hello,
I was able to install the following perl modules fine:
DBI
Data::Dumper
Data::ShowTable
DBI.pm
Then,when I am try to install perl module called 'DBD::mysql' on AIX
5.2(64-bit) and 5.3. In both cases I am getting following errors:
** Low Priority **
Hello,
I was able to install the following perl modules fine:
DBI
Data::Dumper
Data::ShowTable
DBI.pm
Then,when I am try to install perl module called 'DBD::mysql' on AIX
5.2(64-bit) and 5.3. In both cases I am getting following errors:
Claire McLister [EMAIL PROTECTED] wrote on 10/24/2005 05:19:18 PM:
Hi,
We've developed an automatic email mapping capability from Google Maps
API.
To try it out, we mapped origins of emails to this group from October
3 through October 14th.
The result of this map is at:
pedro mpa [EMAIL PROTECTED] wrote on 10/24/2005 06:32:48 PM:
Hi!
I need help on implementing a query that performs a search for items
under
nested categories. An example is on ebay search where you can restrict
your
search by selecting a subcategory and you only get items under that
How about posting the explain for your query. Just put explain before
it, MySQL with then tell you how it will go about executing the
query, like which indexes it's using. I assume you have both columns
indexed?
On Oct 25, 2005, at 4:46 AM, C.R. Vegelin wrote:
Hi List,
I have a
I would check the slow query log. Queries that are taking a long time
(meaning slow) should be logged there. You can check your MySQL
configuration file to find out how long a query will run before it's
considered slow and where it is logging the info.
On Oct 25, 2005, at 3:16 AM, Luke
Hi Brent,
Well I did post an EXPLAIN before my query,
but it got squeezed at the end of my former email.
The EXPLAIN for my query says:
==
id:1
select-type: simple
table:Updates
type: ALL
possible_keys: Hash, Year
key:
Adding compound (hash, years) index (or even better unique index if it
fits in your business logic) in both tables should speed up things.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
signature.asc
Description: OpenPGP digital signature
Jim C. [EMAIL PROTECTED] wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
[attachment signature.asc deleted by Shawn Green/Unimin]
I think they (MythTV) probably know more about
Hi all,
I am doing a tutorial to make a shopping cart. I need to make a mysql db or
convert an sql db to mysql.
Can anyone give me any pointers as to how to make the following tables?
The Microsoft SQL Server 2000 creation script is below the tables. Thanks a
lot for any pointers to get me
Sorry I missed the explain part.
You are doing a full table scan on the Updates table. There really is
no way around speeding up reading a million rows. That's going to be
dependent mainly on the speed of your disks and then how much memory
you have.
MySQL is optimizing your query to
[EMAIL PROTECTED] wrote:
Jim C. [EMAIL PROTECTED] wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
[attachment signature.asc deleted by Shawn Green/Unimin]
I think they (MythTV)
Erich Beyrent [EMAIL PROTECTED] wrote on 10/25/2005 12:06:28 PM:
[EMAIL PROTECTED] wrote:
Jim C. [EMAIL PROTECTED] wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
which I beleive is a foreign key constraint error.
Normally I just put FOREIGN_KEY_CHECKS=0; and that solves it but it doesnt
accept that line in 5.0
SOLVED, sorry for the message.
It was a different error, will post on it shortly
James
- Original Message -
From: James Sherwood [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 1:39 PM
Subject: Error 150 when inputing a dump
Hello,
I dumped a database
Hello.
MySQL allows you to find out the slow queries. Have a look here:
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
Luke Vanderfluit wrote:
Hi.
I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27
(with static modperl module).
The database we are
Hello.
Is it possible that you leave some variable blank? Your script doesn't
produce any error for me:
[EMAIL PROTECTED] mysql-debug-4.1.14-pc-linux-gnu-i686]$ mysql
--defaults-file=my.cnf -u${DB_NAME} -p${DB_PASSWORD} -eGRANT select,
update, insert, delete ON $DBNAME.* TO [EMAIL
Hello.
051024 18:38:29 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
Have you launched mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
tom wible wrote:
Description:
[EMAIL
Hello.
Run ps -axm on the second server, and normally you should see a lot of
mysqld threads.
Edward David wrote:
I just joined this list so I am hoping that this question is relevant to
this group.
I am running Linux AS4 Enterprise Server.
I am running Mysql Ver 14.7 Distrib
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
T Uma Shankari wrote:
Hello!
I am trying to run mysql on XP. I have started the net start mysql.
This service started without any error. My.ini file was there in
c:\windows only. But i
Hello.
May be this could be a bit helpful:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html
Alastair Roy wrote:
Greetings everyone, I am having a problem with PHP and mysql I have copied a
script exactly off a website to open the database and insert a new user I
try to
Hello.
and restarted MySQL with /etc/init.d/mysql start, I get the following:
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]'
Hello.
For example, the size of the field. DATETIME uses only 8 bytes. See:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
Sinang, Danny wrote:
Hello,
Can anyone tell me what advantages there are in keeping dates and times
in a MySQL
DateTime field, as opposed
I won't translate all of it but I can show you the patterns. See comments
interspersed
Ed [EMAIL PROTECTED] wrote on 10/25/2005 11:57:21 AM:
Hi all,
I am doing a tutorial to make a shopping cart. I need to make a mysql db
or
convert an sql db to mysql.
Can anyone give me any pointers
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
(1406 data too long for column)
This works fine on 4.0 but will not work on 5.0.
I also tried modifying the mediumtext to longtext in the dumpfile but
[EMAIL PROTECTED] wrote:
Erich Beyrent [EMAIL PROTECTED] wrote on 10/25/2005 12:06:28 PM:
[EMAIL PROTECTED] wrote:
Jim C. [EMAIL PROTECTED] wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this
Yes.
Whenever you have a problem, go back to basics. Can you login as root
on the commandline? What password do you use there? Once you're
there, check root's permissions, but I'd be willing to bet your
password is incorrect, or root is only allowed to logon from localhost
and not the machine
Hi
I need to have a single db that will have in excess of 100gb of data in
it - For this i will need to create more that 1 datafile as the max file
size of linux would be exceeded in this scenerio.
On Oracle you can say that a datafile is x mb in size and it can
autoextend to be x mb - Is
Mysql seems to have a problem returning ordered lists from views.
ie, 'select * from myView order by column' does not return a properly
ordered list. (it does change the ordering sequence, but to an
erroneous list)
converting myView to be a Temporary Table using 'ALGORITHM=TEMPTABLE'
in the
Must be a bug of sorts:
If you add an ORDER BY clause to the view itself, then mysql allows
the caller to override with their own ORDER BY clause and it works as
expected. However; if no ORDER BY clause is present in the CREATE
VIEW statement, then the caller receives erroneous results if they
Alastair Roy wrote:
Greetings everyone, I am having a problem with PHP and mysql I have copied a
script exactly off a website to open the database and insert a new user I
try to access the mysql database using the root user, and enter information
into the user table, this is the PHP I am using
Hello,
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
tried to revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the
service it uses a constant 25%cpu and seems locked up. I cannot even stop the
service I have to end
I have some data that has been dumped from Oracle into what appears to
be a proprietary text file... It is not delimited into a format that I
can just import into mysql (easily). The IT guy has provided me an
outline of the dump..
ie;
SQL describe isup051024;
Name
This is probably a silly question, but here goes... I have a table that
logs access to web services, and I am looking to create a report to
track the number of times each service was accessed in a given month.
I know I can loop through the days in the month in PHP and do a seperate
query for
On Tue, 2005-10-25 at 15:39 -0300, James Sherwood wrote:
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
tried to revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run
the service it uses a constant 25%cpu and seems
that looks like a spool file from sqlplus. does it have the data too or just
a bunch of describes?
if this is what he gave you he is either severly clue-challenged or trying
to sabotage you (my $ on later though they're not mutually exclusive).
you could write a perl program to parse this into
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
have fun tools like AUTOINCREMENT -- you're going to want to know what
the code is for any triggers on the data, because in order to do
AUTOINCREMENT in oracle
On 10/25/05, Ziaul Mannan [EMAIL PROTECTED] wrote:
** Low Priority **
Hello,
I was able to install the following perl modules fine:
DBI
Data::Dumper
Data::ShowTable
DBI.pm
Then,when I am try to install perl module called 'DBD::mysql' on AIX
5.2(64-bit) and 5.3. In both cases I am
I'm not *certain* of this but I'm pretty sure that SQL will never give you
zero rows of the kind you want from a query on a single table. (Then
again, I'm not an SQL Genius so maybe someone else can suggest something
that would work.) However, you can probably accomplish what you want fairly
Has anyone here successfully managed to install mysql
4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be
using
the glibc 2.2.5 libraries and mysql seems to insist on
using glibc 2.3. Am I out of luck?
__
Yahoo! Mail - PC Magazine
I was a database professor in a school of business until my retirement
last year. I taught Oracle SQL for several years and taught one class
in Uganda with MySQL so I am reasonably familiar with it from a user
standpoint. However, I am not a developer nor a programmer. A
professor in Uganda
I hope this isn't too long-winded. It's kind of hard
to explain.
I'm trying to figure out a scheme that will display
animal distribution information. First, I want to
divide animal species by continents. Next, I want to
further identify species that live on islands that are
associated with
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang of it until I get this error-any ideas? Thanks a
lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,`int_ClientID` INT,`int_ProductID` INT,`int_Quantity`
From: Tom Brown [EMAIL PROTECTED]
(...)
starting at say 1GB and then 'extending' to 25GB. So is it possible for
all datafiles, rather than just the last one, be 'autoextending'
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
The autoextend
More investigation shows that the query does make it to the slave, at
least into the relay log, yet it's still ignored. 'replicate-do-db' is set
and shows the correct DB in the slave status.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 20 Oct 2005, Atle Veka wrote:
I ran
Ed wrote:
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had got the hang of it until I get this error-any ideas?
Thanks a lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,
`int_ClientID` INT,
`int_ProductID` INT,
Since you want the setup with the least headache and because you are
thinking of writing a book about how to use MySQL, I recommend the Without
Installer version.
It's basically 4 steps:
1) unzip
2) edit config file
3) install as service
4) start the service
It can actually take you more time
David Blomstrom [EMAIL PROTECTED] wrote on 10/25/2005 06:23:52
PM:
I hope this isn't too long-winded. It's kind of hard
to explain.
I'm trying to figure out a scheme that will display
animal distribution information. First, I want to
divide animal species by continents. Next, I want to
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The oracle-supplied DBMS_METADATA package can do this for you.
-Jason Martin
--
Silence is
OK. I thought about that earlier, but I wasn't sure if
I'd be able to adapt it to this particular problem.
Do you think the automated tree traversal method
described at the link you posted...
http://www.sitepoint.com/article/hierarchical-data-database/2
...is the only one that would work? I've
- Original Message -
From:
Ed
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40
PM
Subject: Problem with syntax 4 creating 1
table
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang of
63 matches
Mail list logo
