[mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 00:08
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Query Help
At 23:09 + 2/28/04, John Berman wrote:
Hi
Using MySql 4.x and need some help with a query
There are two tables
Lists
Which holds list name +other stuff
Members
Which holds
At 0:32 + 2/29/04, John Berman wrote:
Paul
Err no, new area for me this
My two queries independently look like this
This give me all the lists some one is not a member of
SELECT lists_.Name FROM lists_ WHERE (((lists_.Name_) Not In (select
members_.List_ from members_ where
Paul
Well getting there, im now selecting the correct number of columns but get a
cant be distinct error ?
John B
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 00:47
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Query Help
At 0:32
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Query Help
At 0:32 + 2/29/04, John Berman wrote:
Paul
Err no, new area for me this
My two queries independently look like this
This give me all the lists some one is not a member of
SELECT lists_.Name FROM lists_ WHERE (((lists_.Name_
At 2:45 + 2/29/04, John Berman wrote:
Got it working at last
SELECT lists_.DescShort_ FROM lists_ WHERE (((lists_.Name_) Not In (select
members_.List_ from members_ where members_.EmailAddr_ like (' em
' union SELECT lists_.DescShort_ FROM members_ INNER JOIN lists_ ON
members_.List_ =
Soni, Sanjay K [EMAIL PROTECTED] wrote:
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql internal databases(the
ones that carries user and config info), the script is usually in
install_prefix/bin/mysql_install_db
If you have no recently installed mysql, and the server
Sanjay,
It seems you didn't run mysql_install_db script which is located in /scripts
directory. This script creates Grant tables for you when you first install mysql.
Basically the error says you missing those grant tables, you can re-run the script and
recreate them.
Hope that helps!!
Raza
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
Original Message
On 2/25/04, 4:19:12 PM, Rogers, Dennis [EMAIL PROTECTED] wrote
regarding Query help - add results then divide by :
Good
: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Hines, David
Subject: Re: Query help - add results then divide by
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
Original Message
On 2/25/04, 4:19:12 PM
I think that you can just do this:
select sum(ads.col)*1.191*sum(ads.depth)/131.77 where date ='2004-02-26'
AND editionID = '13' AND ads.page = '16';
because of the disttributive property of multiplication.
(2 * 1.191) +(6*1.91) +(4*1.91)/131.77 = 12 *1.91/131.77 =
(12*1.91)/131.77 =
Rogers, Dennis wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql describe ads;
+---+---+--+-+++
there must be some problem in concatenation of strings and number variables. If you
can send the lines, we'll be able to suggest the exact change.
Hope that helps
Nitin
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday,
90% of the time you forgot the ; on the line before the parse error. if
not then I would need to see the code to help you.
Respectfully,
Ligaya Turmelle
Nitin Mehta [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
there must be some problem in concatenation of strings and number
I'm copying this to the list (hope you don't mind). You'll find you get
quicker and better responses when all the experts on the list see your
question. Plus, someone else may have a similar question and benefit
from the answers you get.
I've never seen this problem myself, but it looks like
I'm still a beginner myself but try something like
SELECT COUNT(YEAR), WINNER1 AS WINNER, WINNER2 AS WINNER, YEAR FROM
CHAMPIONS WHERE CLASS = hd GROUP BY WINNER;
I think this will give you something like:
COUNT(YEAR) WINNER YEAR
2 carl
Carl Schéle, IT, Posten wrote:
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1
Hello, you might want to try select DISTINCT ?
http://www.mysqlfreaks.com/statements/18.php
/Jonas
- Original Message -
From: Carl Schéle, IT, Posten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 3:49 PM
Subject: SQL-HELP
Hello!
I got a table, champions,
Carl Schéle, IT, Posten wrote:
I got a table, champions, looking like this:
id winner_1 winner_2
0carl mattias
1daniel carl
2
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
There are some version on
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes,
Re: Urgent help needed - SCO Unix
binary
]
Subject
Re: Urgent help needed - SCO Unix
binary
should be able to claim SQL as a second language - you can say so
much with it!
Brandon Ewing
-Original Message-
From: Dominique Plante [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 4:43 PM
To: 'Brandon Ewing'
Subject: RE: Need help with a SELECT statement across 3 tables
Brandon
Aaron P. Martinez [EMAIL PROTECTED] wrote:
I am trying to set up a table from a script that came with some software
Value accounting/CRM and i'm getting a few errors, one of which i
can't seem to figure out/fix.
My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb
tables
No. With the method you're using (storing the parent id with each record)
you have to use a recursive series of queries to show the subtree levels.
Take a look at this article--especially the second and third pages about the
modified preorder tree traversal and nested sets. There are many
Hi,
I want to select from the table sum of logins for each day.
Would this help:
mysql select date_format(your_date_column, %Y-%m-%d), count(*)
- from your_table
- group by date_format(your_date_column, %Y-%m-%d);
Take care,
Aleksandar
--
MySQL General Mailing List
For list
- Original Message -
From: Mike Mapsnac [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 11:42 PM
Subject: Select help
Hello
I want to select from the table sum of logins for each day.
Here's one way to do it.
SELECT SUBSTRING(last_login, 1, 10) AS day,
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
[EMAIL PROTECTED]To:
[EMAIL
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
Thank you very much for responding. Sorry to be dense but will this SQL
find only those records with data in the TITLE field
cc:
Subject: RE: RegExp Help
01/21/2004 01:47
* sulewski
[...]
What I need is all records in table 1 that will
not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join to the rows you do NOT want with a left join, and put as a condition in
the WHERE clause that a joined column IS NULL. Something like
Roger,
Thank you for the feedback. But unfortunately this doesn't work. The
problem is that rid will never be null. I'm trying to find the item in
tab1 where a link cannot be created in tab2 where tab2.rid=tab1.id and
tab2.vid=46 because there is no record in tab2. Not that the record may
Roger,
In regards to my last e-mail what would be great is if I can get all
the records in tab1 then subtract from there all the records that match
the query tab1.id=tab2.rid and tab2.vid=46. The result would give me
what I need but alas mysql doesn't support minus.
Joe
On Friday, January
That is the whole point of a left join.
It joins to a null record when the appropriate right record does not exist.
sulewski wrote:
Roger,
Thank you for the feedback. But unfortunately this doesn't work. The
problem is that rid will never be null. I'm trying to find the item in
tab1 where a
Gerald,
Your right. You and Roger hit it on the head. Stupid me miss read
Roger's original post.
Last night I was banging my head on the left and right joins but I
didn't understand it until I read Gerald's last note. Plus I didn't
realize you can put two conditions in the ON clause which is
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes after the mysql
if
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
[EMAIL PROTECTED] wrote:
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could
Matthew Stuart wrote:
I am really struggling with a mysqldump. I am trying to create a dump of
a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is
called the system command line to be the mysql client environment. The
tutorial book that I have been going through instructs me to issue this
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
[EMAIL PROTECTED] wrote:
Similarly.
SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE c:/aaa/dump.sql from
ytbl_development;
(dump.sql file must NOT already exist)
zzapper (vim cygwin zsh)
--
vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/
Matthew Stuart wrote:
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is called
the system command line to be the mysql client environment. The tutorial
book that I have been going through
I think... you don't have an index on the Incident field itself, just
on (Date, Incident, Type, Task) which means that it concatenates those
fields and orders the result - thus this may be virtually useless if
you're looking for a specific incident within a large date range. Since
your query
On Jan 12, 2004, at 08:09 AM, Douglas Sims wrote:
I think... you don't have an index on the Incident field itself,
just on (Date, Incident, Type, Task) which means that it concatenates
those fields and orders the result - thus this may be virtually
useless if you're looking for a specific
* Soheil Shaghaghi
Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I can try. :)
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables
Tibby wrote:
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book| 7 |
| 6 | pen | 7 |
+-++--+
I need to get only one row from col. DESC, the one with the highest VALUE.
Hi,
I have already tried the 'rtfm', but it just didn't help.
But it's right there :)
3.5.2 The Row Holding the Maximum of a Certain Column
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book|
* Aleksandar Bradaric
select key, desc, value
from your_table t1
where value = (select max(value) from your_table where desc = t1.desc)
Anyway, when i execute this query, i get an error near 'select
max(value)'... :(
It's because the subselects are supported from version 4.1.
yes, just a typing mistakes~~
anyway, both of them work fine.
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
DId I type that?
I meant 1,4
I left it as substring because that was what he tried.
¿n©_ ¡E¢X ¡¸ wrote:
yes, it should work, but should not be 1,1 ?
How about:
update RemoteStation set company=substring(ID,1,1);
Jeff McKeon wrote:
Damn fat fingers and MS Outlook. I sent the Query Help message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters
yes, it should work, but should not be 1,1 ?
or simply:
UPDATE RemoteStation SET company=LEFT(ID, 4); ?
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
How about:
update RemoteStation set company=substring(ID,1,1);
Jeff McKeon wrote:
Damn fat fingers and MS
DId I type that?
I meant 1,4
I left it as substring because that was what he tried.
¿n©_ ¡E¢X ¡¸ wrote:
yes, it should work, but should not be 1,1 ?
or simply:
UPDATE RemoteStation SET company=LEFT(ID, 4); ?
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
How about:
I managed to figure out where I was going wrong (or at least I think I have.
I was playing around with the syntax and decided to add a BR after the
$Row[notes] and it displayed the records line by line. I don't know if this
was the best way to do it but it worked.
Thanks
Jess
-Original
Here is a link to the MySQL manual. Lots of good info here.
http://www.mysql.com/documentation/mysql/bychapter/index.htm l
The max size of a varchar is 255 characters. You will want to use one of the text data
types if you are going to store long articles. I suggest mediumtext. You can find
Are you aware that you are using a nested sql query which isn't available
until version 4.1?
Try splitting the delete into multiple steps 1) populate a temp table with
the id's you want to delete then 2) use the temp table data to delete the
rows.
- Original Message -
From: tech
Thank you for taking the time to reply
I am using version 4.1 as can be seen from the out put below
mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1 (i386)
Also I am unsure of the syntax for what you suggest
Are you aware that you are using a nested sql query which isn't available
Try:
SELECT C.company_id, C.company_name
FROM companies C
LEFT JOIN company_group_intersect CG
ON (C.company_id=CG.company_id AND CG.group_id='1')
WHERE C.status='1' AND CG.company_id IS NULL
--
Diana Soares
On Fri, 2003-12-05 at 15:08, Robert Hughes wrote:
I have the following 3 tables:
That worked perfectly!!! Thanks so much :-)
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:31 AM
To: Robert Hughes
Cc: [EMAIL PROTECTED]
Subject: Re: Need help with query. Please!
Try:
SELECT C.company_id, C.company_name
FROM
On 2 Dec 2003 at 7:20, Greg Jones wrote:
snip
select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c
where l.custsysid=c.custsysid
and l.ltsysid in (select l2.ltsysid from lientrak as l2 where l2.lientraknum
like '2003-%')
snip
Hi greg
Yopur problem is that you
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c
where l.custsysid=c.custsysid
and l.ltsysid in (select l2.ltsysid from lientrak as l2 where
l2.lientraknum
like '2003-%')
Sub queries are not going to be
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Greg Jones [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:32 AM
Subject: Re: Query Help
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
it to 4.0.16, and keep all the data intact. Do I just dump the
databases (just in case), stop the server, then ./configure, make, make
install over top of the old
PROTECTED]
To: Mark Marshall [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 10:18 AM
Subject: Re: Need Help Upgrading From 4.x to 4.x
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
What if one is using rpm - should just use the --upgrade option
rpm -U MySQL-server-4.x
Is this ok to do?
Thanks
Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red
You could try http://us2.php.net/ , http://us3.php.net/ , or
http://us4.php.net/ .
This isn't a PHP mailing list, but I'll answer your question briefly.
The php.ini setting register_globals is set to 'off', so the $PHP_SELF
variable isn't getting created. Either change $PHP_SELF to
Thank you. It was the king of advice that I needed,
because I was unaware of the existence of this
parameter.
I was struggling with the lack of mysql support when I
tried
to use the new RedHat 9. When I finally solved that
problem, I became confused with the inability to
transmit
variable values
Thank you.
Now I read tutorials at the new PHP web site, so my
old
scripts are refurbished and are functional.
I initialize every variable like this:
$var1 = $_POST['var1'];
for example, and values are correctly passed.
Mario
p
--- Chris [EMAIL PROTECTED] wrote:
You could try
Can you post what you are trying to do?
-Original Message-
From: Prasad Budim Ram [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 2:17 AM
To: [EMAIL PROTECTED]
Subject: Needing help for JDBC issue
Hi,
I'm getting the following error while connecting to a MySQL databases
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Prasad Budim Ram wrote:
Hi,
I'm getting the following error while connecting to a MySQL databases
using JDBC. Any clues??
java.net.SocketException: errno: 48, error: Address already in use
Thanks,
Ram
You don't say what OS you're running
KEVIN ZEMBOWER wrote:
The organization hired an outside consultant to
evaluate which SQL engine to go with. This is
what he sent to us:
...
SQL Server 2000 is a complete Relational Database
Management System (RDBMS) that also includes integrated
analysis functionality for OLAP and data mining.
Hi Thai,
I think you're just joining wy too many tables! LOL
Matt
- Original Message -
From: Thai Thanh Ha
Sent: Sunday, November 16, 2003 8:10 PM
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I
Typically, this is the kind of query I see at MS-SQL houses. :)
-- R. Deuce
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Thai Thanh Ha [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5:28 PM
Subject: Re: Please help DB Error: unknown error
Hi Thai
At 9:10 +0700 11/17/03, Thai Thanh Ha wrote:
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I don't know what is the problem. Please help me!!! Thanks in advance.
Joins can join up to 31 tables in MySQL.
Looks like you're exceeding that limit.
Regards,
Thai
SELECT
Can you please post the error?
-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I
* Elisenda
[...]
So, the good way to write joins will be as follows, doesn't it?
FASE.SQL_ID_CE=CA.CA_ID_CE AND
FASE.PR_PP_ID_COORD=PP.PP_ID_PP AND
CA.CA_ID_CE=CE.CE_ID_CE AND
FASE.AU_PR_AULA=AU.AU_AULA
Those are the exact same criteria as you had, only in a different order,
isn't it? The
know how to resolve
this problem.
Regards,
Thai
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:02 PM
To: 'Thai Thanh Ha'; '[EMAIL PROTECTED]'
Subject: RE: Please help DB Error: unknown error
Can you please post the error
Mario Miyojim wrote:
I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function
properly. For instance, I have many scripts that use
the
FORM ACTION=?php print($PHP_SELF) METHOD=post
Roger,
* Elisenda
[...]
The explain select says as follows:
[...]
I re-formatted the query and the EXPLAIN output for readability:
Sorry for not re-formatted the query, I've learn it for next time.
Well, I've learn a lot with your lessons.
Select FASE.PR_Date_Visita_2, CE.CE_Centro,
Roger,
Your help was fantastic. It seems that it goes better. At the end I achieve
some result but not all I need.
The explain select says as follows:
EXPLAIN Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio,
CE.CE_CP, CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV,
do a show status like 'open_files'
and a show variables like 'open_files_limit'
-Original Message-
From: William Bailey [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE-
Hash:
* Elisenda
[...]
The explain select says as follows:
[...]
I re-formatted the query and the EXPLAIN output for readability:
Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio, CE.CE_CP,
CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV, CE.CE_CCAA,
CA.CA_Horario,
PP.PP_Contacto,
I'm sorry I didn't explain anything.
The problem is that it 's too slow and the result doesn't appear. I am going
to try to explain the query.
Fields from Table FASE: (300.000 records)
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
SQL_ID_PY char(6),
SQL_ID_CE char(6),
PR_flag INT,
* Elisenda
The problem is that it 's too slow and the result doesn't appear.
I am going to try to explain the query.
Please do that using the EXPLAIN SELECT statement:
URL: http://www.mysql.com/doc/en/EXPLAIN.html
This will show what index is beeing used on the different joins, and
* Elisenda
I have a query which tries to select different fields from 5 different
tables.
In WHERE part I have write all the conditions and relationships.
Perhaps two many.
Joining 5 tables should not be a problem, but having indexes on the relevant
columns may be essential, especially
it would help alot if you dump the table structure for us
- Original Message -
From: Elisenda
To: [EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 7:10 PM
Subject: Some help with a complex query
I have a query which tries to select different fields from 5 different
* John Kelly
I have a table of full URLs and IPs and am using the following
query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct
ip) as count
from tablename WHERE
Hi Kevin,
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database
of choice for web-based dynamic content. I would not consider myself an
experienced, professionally-trained, knowledgeable database
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
It sounds like a copy and paste from Microsoft, but that is just my
guess. An objective recommendation with show pluses and minuses of
both. It most definitely does not sound like this consultant is
qualified to suggest a database product. What about PostgresSQL,
Oracle, Sybase, DB2? They all
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
Yup that worked -
I rebooted my machine - and I was allowed in -
Thank you very much
Andrew
-Original Message-
From: Brian Snyder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 3:30 PM
Cc: MySQL
Subject: Re: Upgrading help please
Andrew,
I had the same problem and had
Andrew,
I had the same problem and had to stop and restart the servers. Give
that a shot.
brian
On Wed, 2003-11-05 at 17:19, Andrew wrote:
Good day List,
I have just upgraded from 3.23 -4.0.16
I downloaded all the RPM's and then ran
rpm -U *.rpm
It did all that it was supposed to do,
This should work for you:
SELECT * FROM sometable WHERE surname BETWEEN 'A' AND 'D' ORDER BY
surname
In my quick test the first parameter is inclusive while the second is
not, which is why it is D and not C.
On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote:
I want to do a string
You can use RLIKE which is regular expressions then you should be able to execute
SELECT * FROM sometable WHERE surname RLIKE '^[A-C]' ORDER BY surname;
Kelley
Scott Brown wrote:
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing
Thanks for all of the responses!
Actually, Brent Baisley wins the syntax question of the day. The BETWEEN
syntax is what I needed.
REGEXP and RLIKE do not return any records, they return a count of the
number of rows matching the expression.
Thanks!
--Scott Brown
At 11:22 AM 10/30/2003, you
701 - 800 of 1409 matches
Mail list logo