http://dev.mysql.com/downloads/connector/net/1.0.html
Looks like it got implemented into an official provoider, does this
mean I dont need MyODBC ?
On 09/03/2006, at 3:34 PM, Dan Rossi wrote:
Hi there, ive been tyring to find a native provider for .NET , as I
had followed the .NET example vi
> Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
>
> I myself make my SQL 3.23 compatible.
Part of the reasons could be the license change in v4, of course.
MySQL no longer comes for free in many cases.
Martijn Tonies
Database Workbench - development tool for MySQL, a
13.1.5.1. Silent Column Specification Changes
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
[table_options] [select_statement]
^^^
Regards
Keith
In theory, theory and practice are the same;
In practice they are not.
On Wed,
Dave
What common transaction you have? INSERT? SELECT? UPDATE? DELETE? Are
you using InnoDB?
I have my personal experience with InnoDB and MySQL 5,
with kernel 2.4 (as you use on RedHat 9) MySQL 5 is unstable on high
load insert/update/delete
with kernel 2.6 (CentOS, Fedora, ...) you'll get m
Can you run without the Order By at all? If not, you may need to
properly join the tables.
I could reproduce the issue with MySQL 4.1 as well and I would go around
it myself by creating a temporaty table, populating it with the
aggregate, doing a select on the temp table and then of course droppin
Hi there, ive been tyring to find a native provider for .NET , as I had
followed the .NET example via an article on the mysql site which uses
the ODBC connector, however it states on the mysql .NET info page that
ODBC is slower than a native provider. My issue is the bytefx provider
has an old
Many thanks for that Dave.
Do you know whether it's possible for MySQL to return fully qualified
column names by default?
For example, I'd like
select * from foo;
to return
++--+
| foo.a | foo.b|
++--+
| 1 | Rex |
| 2 | Buddy|
| 3
That SQL 101.
It's a basic INSERT / SELECT.
http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
Scroll down for the examples.
-Original Message-
From: clint lenard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 8:54 PM
To: mysql@lists.mysql.com
Subject: Need help with
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info out of one Table and Insert it into the other Table.
Can anyone show me a simple example of this? I can figure out how to
do the rest if I had a s
On 9/03/2006 8:42 a.m., Dave Pullin wrote:
I am running MySQL on 6 servers - 3 Linux and 3 Windows. I recently upgraded
to V5 on all servers. Now MySQL is crashing regularly (several times per
day, some days) with 'got signal 11'.
My 3 Linux servers are very different machines running different
All you are doing when you quote the expression like `COUNT(pets.pet_id)`
is referencing the column in the select by its default column name (which is
the same as the expression.)
That's why it only works when the expression is a column.
If you dont want the order by column to appear in the result
Hey there Ady, Philip,
Thanks for the suggestions for the phenomenon. I also notice something
along the course of optimisation:
1. Sorting records with huge fields (ie: blobs, text) is significantly
slower than if you extract the blobs/ text fields into a separate table.
The record size makes
Hello,
I noticed something strange in MySQL (I'm using 4.1.15).
If I use an aggregate function in the ORDER BY clause I get an error.
SELECT men.man_name,
COUNT(pets.pet_id)
FROM men,
pets
WHERE men.man_id = pets.pet_man_id
GROUP BY men.man_id
ORDER BY COUNT(pets.pet_id) DESC;
gives
You should be able to pull each table (create + inserts) out into a stand
alone file
table1.sql
table2.sql
etc...
and then you can restore table by table.
This might be harder depending on the size of your database tables. If you
have a million rows, chances
are your .sql file is huge and it
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then
downgraded again, back to 4.1.14. I took a complete dump of all
databases/tables into a .sql file, and now I would like to restore just
specific databases or tables from it.
Is this possible without restoring everything or
On 3/8/06, Nicolas Verhaeghe <[EMAIL PROTECTED]> wrote:
> Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
>
> I myself make my SQL 3.23 compatible.
>
Well, it all depends on what you'll do with the system, if its a
development desktop, a server for commercial stuff, etc. MyS
could you tell us if these 6 are in a cluster or in a replication set up,
and u also said the 3 linux bixes all crash at once, did u check the logs,
do they crash under load, what about the OS, is it stable when mysql
crashes
Kishore Jalleda
On 3/8/06, Dave Pullin <[EMAIL PROTECTED]> wrote:
>
Hello,
Another division in my organization is maintaining a mysql database. For
various reasons, data is deleted from this database after it has aged
more than a month. My division has a need for long term storage of the
same data, so I am trying the following strategy:
1. Create a snapshot ("sl
Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
I myself make my SQL 3.23 compatible.
Yes, it is too new, and it is sad, because stored procedures will make
our job much easier.
I also program for MS SQL and use SPs extensively for all the good
reasons.
-Original Mess
I am running MySQL on 6 servers - 3 Linux and 3 Windows. I recently upgraded
to V5 on all servers. Now MySQL is crashing regularly (several times per
day, some days) with 'got signal 11'.
My 3 Linux servers are very different machines running different software
a uniprocessor Pentium with 512MB ru
Thank you.
I went with your solution and the create table worked.
Tested inserting on primary key and it worked.
Need to load more data before I can test alt indexes.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:39 AM
To: mysql@list
Gabriel,
Try the "on-demand" webinar page at:
http://www.mysql.com/news-and-events/on-demand-webinars/
-Sheeri
On 3/8/06, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
> Up until now I have missed all 3 webminars I registered... because of good
> various reasons...
>
> I was wondering weather the p
Hello Everyone,
I am discovering that my MySQL server tends to get locked up by runaway
queries, that are continuously sending data. Even after all night long.
(The origin of these queries is from report development.)
Without having to kill each connection manually on the MySQL server, is
there
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
Dear all,
Two questions about server variables tuning.
1) key_buffer_size stores MyISAM indexes; innodb_buffer_pool_size
stores InnoDB indexes and rows. So the innoDB buffer would need more
space in general. It sounds like a good idea, if the number and size
of MyISAM and InnoDB tables is roughly
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
Hi, we have a db with myisam and a single innodb table. 2 separate
processes are inserting data into myisam and the innodb tables at the same
time. Intermittently, we have noticed an issue where commits to the innodb
table appear to be delayed until the process inserting into the myisam
tables is
Webhosts are telling me they dont support 5.0 because
it is too new and potentially unstable without
reliability documentation. Im having difficulty
finding a webhost that will support 5.0. Is earlier
versions of mysql available? Any help here appreciated
--
MySQL General Mailing List
For list ar
> In this case, cnelson, you can only have a one to one relationship.
Why? If the Attribute table keyed on (ProductID,Attribute), surely a
1:M is possible.
> He wants to allow a one to many relationship.
Yes, I know.
> Using one field to store all the attribute ids in the product table is
> wh
Just want to share and confirm my findings on a performance issue I've been
experiencing.
My database is strictly non-transactional, but it's got about 200,000 records
in this particular table. The table has a primary index, and 2 integers - one
for the date and the other for the time. Among t
In this case, cnelson, you can only have a one to one relationship.
He wants to allow a one to many relationship.
Using one field to store all the attribute ids in the product table is
what he is trying to do and it is not the best idea. Better use a table
in the middle, with product ids and attr
Yes thats very true, as the corrupt slave would pick up from where it left
and its quite posssible that the record was already updated on the healthy
slave from the master, causing the replication to fail, but having said that
may be you could do this
1) stop the healthy slave
2) put a global read
although mytop would give you overall performance statistics , you can
monitor the processes/queries/threads for a specific database using the
switch "d" ( if thats what you are looking for)
JFYI: type in "?" in the mytop window and it would give you a full list of
options to choose from...
Kish
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of slightly
more complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen
I'm still hoping someone can else can share their input on this.
What do other people usually do as far as the collation setting?
Thanks,
-Ryan
Ryan Stille wrote:
> When we migrated to MySQL from MS SQL, I left everything set
> to the default as far as collations - latin1_swedish_ci.
> This was
I guess you are Not selecting the database .. any error msg ?
eg : mysql_select_db( '' ) or die( 'Could not select database' );
--Praj
On Wed, 8 Mar 2006 07:45:20 -0300
Kleiton L R Soares <[EMAIL PROTECTED]> wrote:
> Please, i'm a crazy ! i dont can write in a table, please anybody can help me
You are doing this
mysql_connect
mysql_query
And you need to do this
mysql_connect
mysql_select_db
mysql_query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Been wondering this for a while now, I can explain how I do it, but
> I am sure there are better ways.
> ...
Maybe I'm really missing something here but I think that your querying
problem arises from bad data design. This is what I'd do:
Product table:
ProductID
some other stuff
On 3/8/06, Adrian Bruce <[EMAIL PROTECTED]> wrote:
> one solution (may not be the best but would work) would be to use 'like'
> instead of '=' and then put wildcards %%$var % around the variable so
> that if it is not there then it wount effect the query.
>
Yeah, I use this kind of "trick" for SEL
one solution (may not be the best but would work) would be to use 'like'
instead of '=' and then put wildcards %%$var % around the variable so
that if it is not there then it wount effect the query.
Ade
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of slight
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen. (area, and
interest).
Am Mittwoch, den 08.03.2006, 12:22 +0200 schrieb Gabriel PREDA:
Hello Gabriel,
> mytop measures the overall performance of the server... it's not daatabase
> bound !
you are right.
> For itself it uses the "test" database... but that has no meaning...
maybe it is meant to confuse clueless pe
Please, i'm a crazy ! i dont can write in a table, please anybody can help me
try find the error
Thanks
--
---
---
Kleiton L R Soares (21-2620-0735 | 21-9639-5829)
PCS - Processos Consultoria Soluções
www.pcs.com.br / [EMAIL PROTECTED]
--
MySQL General Mailing List
F
mytop measures the overall performance of the server... it's not daatabase
bound !
For itself it uses the "test" database... but that has no meaning... it's
not measuring that database performance...
You can see queries that take to long aprearing in the list...
It uses
SHOW STATUS - to get and/
Am Dienstag, den 07.03.2006, 17:00 -0600 schrieb Ryan Stille:
> > What else can I do to observe myslqd?
>
> mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
Hello Ryan,
mytop is indeed very nice. :-) Thank you for that.
One question: Is it possible to oberserve more than one
da
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen. (area, and
interest).
Up until now I have missed all 3 webminars I registered... because of good
various reasons...
I was wondering weather the presentations from those webminars can appear
online at: http://dev.mysql.com/tech-resources/presentations ???
That would be great... a lot of people can access them that wa
Hi,
If mysql database server installed on Linux without problem, but
on
win2000/XP:
select substring_index(user(),_utf8'@',-1) return the local
windows
station computer name instead of IP ?
Best regard!
Shuming Wang
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
It is not possible to have more than one PRIMARY
key per table.
Maybe you need to use one PRIMARY key as the main index into
the table, then use UNIQUE or KEY which is a synonym for
INDEX on the other two columns.
This book will help you ALOT with designing tables.
It will also teach you how
Hi Foo,
MyISAM impress me on insert speed, however on many case MyISAM is not
better than Innodb. If you can't use combination of them,
better your break down your need to decide which one to use. AFAIK, sub
query is better in innodb rather than myisam, and if you have only
200.000 records
wit
50 matches
Mail list logo
