"Scott Wong" <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/example-Foreign_keys.html
* http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
* http://www.mysql.com/doc/en/ALTER_TABLE.html
* http://www.mysql.com/doc/
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
56 Paris 1
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
5
On Thursday 06 February 2003 17:05, Octavian Rasnita wrote:
> Please tell me how can I sort a column and force placing the null values to
> the end of list?
Something like:
SELECT ... ORDER BY IF(column_name IS NULL, 1, 0), column_name;
--
For technical support contracts, goto https://order.m
Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html
[EMAIL PROTECTED] wrote:
Hi,
I am new to SQL. I am attempting to create a database that was
created in MS SQL to MySQL. The below SQL statements works with MS SQL.
I am executing the following:
CREATE TABLE 'Accounting'(
Hawk <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html
This was an automated response to your email 'converting MS SQL to MySQL'.
Final search keyword used to
Lisi,
First, limiting the clicks: You didn't have any condition on click.date in
your suggested queries. You need to have one. Here's my suggestion,
somewhat modified. Note that the limit on click.date goes in the ON clause,
while the limit on display.date goes in the WHERE clause. Looks wier
Doug,
> create table t1 ( id varchar(5) not null, name varchar(5) not null );
> insert into t1 ( id ) values ( "1234" );
> select count(*) from t1 where name = "";--> Result = 1
> 1) Why did the insert succeed since the "name" field is not null and I didn't
>provide a value?
> 2)
Dino,
> to double click or run mysql.exe from the MS dos prompt. I get the
> following message.
> C:\mysql\bin>>mysql
> ERROR 2003: Can't connect to Mysql server on 'localhost' (10061)
Most probably your MySQL server isn't running.
Using Windows Explorer or a DOS window, cd to c:\mysql\bi
Blaster <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/InnoDB_Next-key_locking.html
* http://www.mysql.com/doc/en/Query_log.html
* http://www.mysql.com/doc/en/Query_results.html
* http://www.mysql.com/doc/en/Query_Cach
Hello all.
Does any one know, or can anyone point me in the direction of the limits of
a number of tables I can put in a union of a merge table, I can figure out
what
the sql would be.
I have daily tables for an application that average about 2500 rows (2.5
million) , I want to make a merge t
Hi "Rusch (ext) Reiner" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Error_log.html
* http://www.mysql.com/doc/en/Too_many_connections.html
* http://www.my
Hi "Oliver Schlag" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/
On Thu, 6 Feb 2003 12:05:03 -0500, Doug Beyer wrote:
>
>I create the following table:
>
>create table t1 ( id varchar(5) not null, name varchar(5) not null );
>
>I insert the following row:
>
>insert into t1 ( id ) values ( "1234" );
>
>I do the following selects:
>
>select count(*) from t1 where n
Not sure my other email got through, so here it is again, with an updated
description of the problem.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then sort
Not sure my other email got through, so here it is again, with an updated
description of the problem.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then sort
Not sure my other email got through, so here it is again, with an updated
description.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then sort them in descen
On Thu, Feb 06, 2003 at 10:03:18AM -0500, Hawk wrote:
>
>
> Hi,
>
> I am new to SQL. I am attempting to create a database that was created in
> MS SQL to MySQL. The below SQL statements works with MS SQL.
MS SQL could refer to either Jet SQL or SQL Server SQL, but the SQL
below is obviously
mysqldump: Got error: 1064: You have an error in your SQL syntax near
'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
/*!32311 ' at line 1 when using LOCK TABLES
anyone know what is causing this, and more imporantly how to fix it?
Thanks
- kevin
PS, please cc me as i'm not
Hi "Johannes Ullrich" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Creating_many_tables.html
* http://www.mysql.com/doc/en/ALTER_TABLE_problems.html
* http
Hi "Insanely Great" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Many_versions.html
This was an automated response to your email 'SQLyog 3.02 Released'.
Final search keyw
context ... I had proposed writing a new backend for mysql
tailored to read only very large and very wide (lots of columns)
tables (14G + )
in which queries never involved more than a small percentage
of the available columns (i.e. < 5%) and often lacked WHERE
clauses.
A couple years ago I argued
I am using MySQL with Ultradev (asp server model), and I'm creating a
recordset insert form; however, the documenation is obvious that the user
has to enter the date in -mm-dd format. However, this will not work for
my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy
format.
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook but I want to store the data in a mysql database.
mysql> CREATE TABLE info
-> (
-> name varchar(50)
-> message varchar(
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook but I want to store the data in a mysql database.
mysql> CREATE TABLE info
-> (
-> name varchar(50)
-> message varchar
Hi "Octavian Rasnita" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Problems_with_NULL.html
* http://www.mysql.com/doc/en/NULL_values.html
* http://www.mysq
I am using MySQL with Ultradev (asp server model), and I'm creating a
recordset insert form; however, the documenation is obvious that the user
has to enter the date in -mm-dd format. However, this will not work for
my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy
format.
This thread is funny,
When I first read the phrase in question it made perfect sense in the
context in which it was written.
Is the next change to the manual going to remove the example in chapter
"6.4.5 UPDATE Syntax" which refers to age;
mysql> UPDATE persondata SET age=age*2, age=age+1;
Remo
Pretty sure dbmail can use mysql.
www.dbmail.org
-Erik
--- Ben Clewett <[EMAIL PROTECTED]> wrote:
> Paul DuBois wrote:
> >
> > I believe the Horde IMP server uses MySQL:
> >
> > http://www.horde.org
>
> Thanks. Looking at this, I belive it's an IMAP
> clinet. Unless the web
> site is i
I¹m having problems with a left join. I¹m not even sure if I should be using
a left join.
I have two tables; sites and site_service. Site_service contains service
dates for the sites. I¹m trying to write a query that will select each site
and the last service date for that site. A site may have ma
On 2/6/03 9:05 AM, "Doug Beyer" <[EMAIL PROTECTED]> wrote:
> I attempted to search various places for my answer but with no luck. So I'm
> posting here.
>
>
>
> I create the following table:
>
> create table t1 ( id varchar(5) not null, name varchar(5) not null );
>
>
> I insert the followin
Doug Beyer wrote:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( "1234" );
select count(*) from t1 where name is null; --> Result = 0
select count(*) from t1 where name = ""; --> Result = 1
Questions:
1) Why did the insert succeed sinc
Hi "Doug Beyer" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Problems_with_NULL.html
* http://www.mysql.com/doc/en/CREATE_TABLE.html
* http://www.mysql.com
Hi Varshavchick Alexander <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/JOIN.html
* http://www.mysql.com/doc/en/LEFT_JOIN_optimisation.html
* http://www.mys
>Description:
1. executing scripts/mysql_install_db gave a ton of warnings like the following:
19760:/usr/local/mysql/libexec/mysqld: /sbin/loader: Warning: Can't find strong symbol
for _ZN10field_real3st
dEP6Stringm
19760:/usr/local/mysql/libexec/mysqld: /sbin/loader: Warning: Can't find stron
I don't know whetehr this is going to make any sense!
I have a query pulling records from MySQL tables that are joined. The join is
for a color_id to an item...
///
function showColor($item_id)
{
$query="select ref_colours.* from item_color ,ref_colou
Hi "goth" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Commands_out_of_sync.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/
Hi again,
After some struggling, I have managed to get the problem below 99% working,
the problem now is that I can't get them in descending order. Here is my
select statement.
$query = "select manager.name, position, MAX(goals) from roster join
reference join manager where
manager.idn=refe
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
get the top number from each category for each name and display them from
most to least. I have checked all the docs on the select statement, but
thi
> On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote:
>
>> INSERT into tbl_name (username,password) values
>> ('user',PASSWORD('passwd'));
>>
>> and when authenticating the user you can do something like
>>
>> SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in
>> this case $pass i
The best way is to import data from MS SQL Server to MySQL. SQLyog at
http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard.
Try it out and all you data will be imported.
Insane
- Original Message -
From: "Hawk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday,
Hi, I'm trying to learn a little about query optimization.. I have a query that is
pretty slow, and was wondering if there is an easy way to speed it up.
mysql> EXPLAIN
-> SELECT
-> mailfrom,
-> sum((msgsize)/100) as mb,
-> count(id) as count,
-> avg(hits) as
I've gotten some weird responses to this type of question before, but
I'd like some input anyway. We are getting a new dedicated database
server. Currently our load average is hovering above 2 and although
things work fine, that snappiness is fading as the load becomes higher.
We may be able to s
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
Hmm, I thought this question I posted last weekend was a pretty
good one, however, no replies have been posted :-(
I am new to MySQL and this mailing list, is the the proper place and format
for questions of this type?
Regards,
Bill
> Hi all:
>
> I am building a database containing usage
At 04:13 PM 2/7/2003 +, you wrote:
We sell a data converter for this purpose check out www.bpenet.net
I'm not concern about transferring the data. I was having problems
creating the indexes.
thanks for the reply...
Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
T
Hi [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication
check the docs at www.mysql.com for the CORRECT command to create indexes.
=C=
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
-Original Message-
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 9:03 AM
To: [EMAIL PROTECTED]
Subje
Ben Clewett wrote:
I was rather trying to find an IMAP server using MySQL. Ie, somewhere
to store my millions of email messages, from many execlent mailing
lists, and get at them fast...
What you want is the Courier-IMAP mail server which uses the Maildir
format to store its messages, runni
In the last episode (Feb 06), Michael Boudreau said:
> Here's something weird: text strings containing newlines seem to have a
> backslash character added when the data is exported from the database.
> (MySQL 3.23.37 on Solaris--yes we're upgrading to .54)
>
> However, when I read the data out t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Guy --
...and then Defryn, Guy said...
%
% I was just reading through the Mysql manual section 3.32
% And came across a sentence that started like this
%
% Animal sex can be represented in a variety of ways
%
% My mother tongue is not English but d
I tried that, and the answers are very close. I need to do some more
testing as my dataset grows to see if it ties up with what is required.
My sql server takes ~4 minutes to do it "my" way, and ~1 minute to do:
select avg(scantime+processingtime)+(std(scantime+processingtime)*2)
from percentile
On 6 Feb 2003, at 8:58, Michael Boudreau wrote:
> mysql> select review into outfile '/tmp/MS55038rev1.txt' from
> MsReviews where
> msid=55038 and msreviewid=1;
> Query OK, 1 row affected (0.00 sec)
> mysql> quit
> Bye
>
> The newline seems to have had a "\" (backslash, octal
Hi Hawk <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html
This was an automated response t
On Wednesday 05 February 2003 02:07, aah at volunteermatch dot org wrote:
> >Description:
>
> Multiple IS NULL tests in a WHERE clause appear to be broken
> when testing NOT NULL date fields. Queries work fine against
> varchar and int, probably(?) others.
>
> >How-To-Repeat:
>
On Thu, Feb 06, 2003 at 09:52:11AM -0500, Brent Baisley wrote:
> As long as the foreign keys are index it should be pretty quick. There
> really is no way to get around processing every record in table "data".
> As that table grows, your query will get slower. But a 157K rows isn't
> really a wh
55 matches
Mail list logo
