I got an "interesting" problem with creation of indexes on MyISAM
tables in MySQL 5.6.15 and MySQL 5.6.14 running on FreeBSD 8.4 for float
columns - I am not able to create indexes on these columns
Indexes on all other columns work just fine
The problem occur while I was loading data
Hi,
I have some xml data following the following DTD. It seems that it is
better to import the xml file into multiple table, for example, author
table, journal table. I read the mysql manual section on "load xml",
but I don't see how to load xml in multiple table and how to design
the schema autom
On 12/21/06, Behrang Saeedzadeh <[EMAIL PROTECTED]> wrote:
Hi,
What is your favorite GUI tool for working with MySQL. EMS SQL Manager
is feature-rich but sometimes buggy and also very expensive. Navicat
is not very handy. It forces to switch between mouse and keyboard
repeatedly.
What is your f
and also
http://fabforce.net/dbdesigner4/
sorry for 2 seperate emails.
saqib
http://www.full-disk-encryption.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sqlyog is pretty nice:
http://www.webyog.com/
saqib
http://www.full-disk-encryption.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> What is your favorite GUI tool for working with MySQL. EMS SQL Manager
> is feature-rich but sometimes buggy and also very expensive. Navicat
> is not very handy. It forces to switch between mouse and keyboard
> repeatedly.
>
> What is your favorite tool?
Mine is Database Workbench, but hey
Hi,
What is your favorite GUI tool for working with MySQL. EMS SQL Manager
is feature-rich but sometimes buggy and also very expensive. Navicat
is not very handy. It forces to switch between mouse and keyboard
repeatedly.
What is your favorite tool?
Regards,
Behi
--
"Science is a differential
On 4/28/06, P. Evans <[EMAIL PROTECTED]> wrote:
Thanks all,
this looks exactly like what i'm looking for.
However, when I create the federated table, it says it was successful but
creates the table as Myisam.
CREATE TABLE `petestdb.backup_pp_line_code` (
`catalog_id` int(10) unsigned NOT NUL
Thanks all,
this looks exactly like what i'm looking for.
However, when I create the federated table, it says it was successful but
creates the table as Myisam.
CREATE TABLE `petestdb.backup_pp_line_code` (
`catalog_id` int(10) unsigned NOT NULL,
`line_code` char(3) NOT NULL,
On 4/27/06, P. Evans <[EMAIL PROTECTED]> wrote:
>
> Hello Listers,
> Is it possible to run a query on one mysql server to another database on
> a different server ?
> eg creating an alias in database A on server A to table B on database B on
> server B ?
>
> Like a federated nickname on db2 udb or
At 14:38 -0700 4/27/06, P. Evans wrote:
Hello Listers,
Is it possible to run a query on one mysql server to another
database on a different server ?
eg creating an alias in database A on server A to table B on
database B on server B ?
Like a federated nickname on db2 udb or synonym on
Hello Listers,
Is it possible to run a query on one mysql server to another database on a
different server ?
eg creating an alias in database A on server A to table B on database B on
server B ?
Like a federated nickname on db2 udb or synonym on informix ?
Thanks
Pierre
ent;
select * from join_temp;
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 3:31 PM
Subject: Temporary tables in mySQL
> Hi,
> Is it possible to create a temporary table in mySQL using columns
from tables in
Hi,
Is it possible to create a temporary table in mySQL using columns from tables in
two databases? Basically I want to split a table between two databases and if some
logic is satisfied I want to "merge"(the right word?) the
two tables into one in one of these databases. What's the best wa
HACKATHORN, TODD (SWBT) wrote:
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import cu
Are you using the DTS to schedule replication or periodic data imports?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import current data from other databases
* Zaxpaw
> I am getting a syntax error from MySQL when executing the following
> query (names substituted):
>
> Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
> WHERE Another_ID='1');
>
> What is going wrong?
Version 3.x does not support sub-selects.
> My guess is that the
I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
My guess is that the SELECT is considered a subquery, but how else do
you get the "sele
Hi Caroline,
> Hi, I have several simple questions regarding creating
> tables in the MySQL.
>
> 1. For a variable of Java primitive int type, I should
> use INT or INTEGER? Do I have to specify the length of
> the field?
> CREATE TABLE message_thread( thread_id INT or INTEGER
> NOT NULL AUTO_INC
Hi, I have several simple questions regarding creating
tables in the MySQL.
1. For a variable of Java primitive int type, I should
use INT or INTEGER? Do I have to specify the length of
the field?
CREATE TABLE message_thread( thread_id INT or INTEGER
NOT NULL AUTO_INCREMENT PRIMARY KEY);
2. A fie
://www.mysql.com
sql query
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, March 13, 2003 11:13 AM
Subject: Incorrect handling of foreign key constraints in InnoDB tables in
MySQL 3.23.55-max run on Windows ME
> Hi,
>
> If a &qu
I hope you can use the following example to repeat the problem and fix
this bug
Thank you
Jan Mazánek
[EMAIL PROTECTED]
#
============
===
# Incorrect handling of foreign key constraints in InnoDB tables in
MySQL 3.23.55-max
#
A understand that a problem with temporary tables is that you can't
do a self-join in MySQL 3.xx using temporary tables. I have a situation
that requires exactly this (the alternative is not algorithm-effective).
I wonder if the following is a practical solution: to create a copy of the
tempo
Hi, all
I have two tables with full of data. Their structure is same.
Tables1
id type name
1
2
3
...
Tables2
id type name
1
2
3
4
I want to merge them into one table.
id typename
1
2
3
4
5
6
7
...
How can I do it?
thanks in advance.
luoya
sql,query,queries,sm
Hi, does anyone have any experience using db_stat to get statistics on BDB
tables in MySQL. How did you go about this please? Thanks.
Geetika
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi.
On Mon 2002-11-18 at 17:05:23 -0800, [EMAIL PROTECTED] wrote:
> Hello ,
> I need help with heap tables and calculating memory usage. I checked
> in the Manual and found a formula, but I need help
> deciphering it ;)
>
> " The memory needed for one row in a HEAP table is:
>
> sizeof(char*) i
Hello ,
I need help with heap tables and calculating memory usage. I checked
in the Manual and found a formula, but I need help
deciphering it ;)
" The memory needed for one row in a HEAP table is:
SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof(char*))
macrosoft misleads thousands of people by the way
they designed access. in your case, they've
confused relations with referential integrity.
we cringe when that question hits this list, as
it does periodically.
relational databases don't have hard coded
relations. NEVER. furthermore, re
John Meyer wrote:
AFAIK, MySQL doesn't have any sort of referential integrity checks with
fields. conceptually, you can do it, and write your program to force it,
but the database itself doesn't have it.
Or you can use REFERENCES with InnoDB tables;
http://www.mysql.com/doc/en ... search fo
FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Wednesday, November 13, 2002 8:14 AM
To: MySQL Mailinglist
Subject: RE: How to link tables in MySQL
AFAIK, MySQL doesn't have any sort of refere
Hannes Niedner [mailto:hannes.niedner@;gmx.net]
Sent: Tuesday, November 12, 2002 1:55 PM
To: MySQL Mailinglist
Subject: Re: How to link tables in MySQL
On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote:
> 2 - In MS Access you have to graphically connect the
> table id fields
You can still use Access to build your queries then click the SQL button
and you'll have the the code for the command line. Access SQL is a
little different but you should still be able to get an idea on how to
do it.
- Ed
>>> tmb <[EMAIL PROTECTED]> 11/12/02 12:41:49 PM >>>
1 - any way to search
On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote:
> 2 - In MS Access you have to graphically connect the
> table id fields to tell Access how the tables relate.
>
> How do you do this In MySQL... from the command line
> I'm sure... just a code snippit or reference to one
> would be nice...
1 - any way to search archives of MySQL list?
2 - In MS Access you have to graphically connect the
table id fields to tell Access how the tables relate.
How do you do this In MySQL... from the command line
I'm sure... just a code snippit or reference to one
would be nice...
Thanks for any help -
:01 PM
To: whiskyworld.de
Cc: MySql Lists Geral (E-mail); MyODBC
Subject: Re: Tables in MySQL
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_da
Putting the efficiency issues aside to the extent we already have, I don't
see why you can't just use a simple join table for this purpose. You do have
the minor complication of symmetry, but with a simple ordering operation
against your original insertion join even this can be overcome.
Let's wri
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_date
whatever other junk is relevant to a given transaction...
itemlist
transaction_id
item
Hi,
im currently developing a Webshop system. One of the new features of it
should be a "Costumers that bought this product also bought" feature -
concerning this im currently unsure how to implement it - (LAMPS) - my
current thought is following:
Costumer A buys Products with NO: 12, 13 , 2
I seem to have answered my own question :-)
The answer is that you have to use -Q or --quote-names in mysqldump
Cheers!
Augey Mikus
Augey Mikus wrote:
> I am attempting to migrate a MySQL driven web application that, in my
> opinion, was designed by a stupid monkey. The php web frontend
I am attempting to migrate a MySQL driven web application that, in my
opinion, was designed by a stupid monkey. The php web frontend
dynamically creates tables to store chunks of data rather than just
adding rows to existing tables. Don't ask me why! However, when
attempting to migrate the
Uma,
Friday, March 15, 2002, 2:10:50 PM, you wrote:
UST>Now i am struck up with one problem...When i am trying to create a
UST> table in the mysql database it is giving this error...Can anyone plese
UST> help me how to rectify this problem..
UST> ERROR 1: Can't create/write to file './dbase/r
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my t
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my ta
Thi Cao writes:
> All,
>
> Using MySQL++, how do you check to see whether or not a specific table exist
> before you go ahead and create it?
>
> TIA
>
> Thi
>
HI!
This has nothing to do with MySQL++.
Try to select count(*) from a table and if you get C++ exception with
a corresponding error
All,
Using MySQL++, how do you check to see whether or not a specific table exist
before you go ahead and create it?
TIA
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Ive just downloaded Mysql Max 4.0 binary distribution
for Windows ...
Does this distribution supports Innodb tables ?
How do I turn on this feature ?
I follow the instruction (modifying my.ini to include support for innodb )
buy Mysql does not start ( I am using Winmysqladmin ) and I am using
my
PROTECTED]
- Original Message -
From: "Alexander Shaw" <[EMAIL PROTECTED]>
To: "MySQL Win 32 List" <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 6:56 AM
Subject: Create Tables in MySQL Database from Access
> Hi all,
>
> Seem to be hittin
Jeremy Zawodny writes:
> On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote:
> Does this mean they'll re-appear in the manual as well?
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-593
On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote:
>
> Yes, in 3.23.41 source tarball only.
>
> We will not put Gemini tables in our binaries due to several reasons
> of which stability is just one.
Does this mean they'll re-appear in the manual as well?
--
Jeremy D. Zawodny,
Pete Kuczynski writes:
> Hi,
> since Nusphere release the source code for gemini yesterday I believe it
> was, I was wondering if Mysql AB was going to incorporate it into a
> future release if it's database.
>
> I realise in light of recent .org events
>
>
> Pete
> --
> __
Hi,
since Nusphere release the source code for gemini yesterday I believe it
was, I was wondering if Mysql AB was going to incorporate it into a
future release if it's database.
I realise in light of recent .org events
Pete
--
___
Pete Kuczynski
Sr. Fiel
Thank paul. I know about Date_format, but was curious if there is some
setup parameters would allow us to define the MySql date format .
Paul DuBois wrote:
> On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
>
>> Hello,
>>
>> I would like to change the default date format MySql from
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
> Hello,
>
> I would like to change the default date format MySql from /mm/dd to
> dd/mm/. Does anyone know, how to make this change in MySql?
You can't.
However, you can select DATE, DATETIME, or TIMESTAMP values using
DATE_F
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
55 matches
Mail list logo
