Rene Churchill [EMAIL PROTECTED] wrote on 02/22/2005 04:23:47 PM:
[EMAIL PROTECTED] wrote:
Rene Churchill [EMAIL PROTECTED] wrote on 02/22/2005 03:39:05
PM:
Hi Shawn,
This is what I wound up going with:
SELECT b.id,
if(a.a = b.a, NULL, b.a),
if(a.b
Joppe A [EMAIL PROTECTED] wrote on 02/17/2005 09:45:31 AM:
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAME
Albert Padley [EMAIL PROTECTED] wrote on 02/17/2005 12:08:31 PM:
I have the following 2 tables:
CREATE TABLE `division_info` (
`id` int(11) NOT NULL auto_increment,
`division` varchar(50) NOT NULL default '',
`spots` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY
Michael Dykman [EMAIL PROTECTED] wrote on 02/17/2005 12:20:44 PM:
On Thu, 2005-02-17 at 12:08, Albert Padley wrote:
I have the following 2 tables:
CREATE TABLE `division_info` (
`id` int(11) NOT NULL auto_increment,
`division` varchar(50) NOT NULL default '',
`spots`
Ed Reed [EMAIL PROTECTED] wrote on 02/16/2005 02:13:40 PM:
Can anyone tell me the limit for the number of records that can be
inserted in a single call?
I'm trying to insert multiple records like this,
INSERT INTO t1 (f1, f2, f3, f4) VALUES
(test, 1, some data, Done),
(testing, 21, some
Gaspar Bakos [EMAIL PROTECTED] wrote on 02/15/2005 04:28:26 PM:
Hi,
My understanding is that with mysql = 3.23 versions the last value of
an auto_increm column is stored, thus even if records are deleted, when
a new one is inserted (as NULL), values will not be re-used.
This is a fine
shaun thornburgh [EMAIL PROTECTED] wrote on 02/15/2005
04:53:54 PM:
Hi,
I have a table with 26 fields, each row in this table must be unique. I
can't define all of the fields to be primary keys as the limit is 16.
Therefore before I insert data I have to check that each row is unique.
YES, I need a LOT more information. Please provide ALL the information I
asked for in my previous post (especially questions 1, 2, and 3). To
compare with my automobile analogy: You told me that your auto is towing
a lot of identical trailers and that if you use a different vehicle on a
Normally I do not reply to myself but I just realized that in my previous
response I confused COUNT(*) (which is slow for InnoDB because it always
does a table scan to resolve the version lock of each and every row) with
SHOW STATUS (which computes table sizes based on the average of 1 random
Asad Habib [EMAIL PROTECTED] wrote on 02/11/2005 04:03:32 PM:
Does anyone know where I can find a list of characters that cannot be
inserted into a MySQL database as part of a string? I know that MySQL
does
not accept single and double quotes and that these have to replaced by
their name
See below
Shailendra Soni [EMAIL PROTECTED] wrote on 02/10/2005 01:43:18
AM:
Thank ,
But i can't create multipal index it will not useful for my tabels.
I tryed to set GLOBAL keycache1.key_buffer_size = 128*1024
but it gives error that unknown system varible ' keycache1' .
can you
Brent Baisley [EMAIL PROTECTED] wrote on 02/10/2005 12:21:38 PM:
I am looking to store all incoming emails into a MySQL database. I've
looked into dbmail, but can't get it to compile under Mac OSX (I posted
a message on that list). I was wondering if anyone could point me in
another
Marcin Lewandowski [EMAIL PROTECTED] wrote on 02/08/2005 05:29:39 PM:
Chuck Herrick napisa(a):
200 - 400 tables is too many.
Is it too many for merge, innodb or both?
Try having one CUSTOMERS table. You know who is logged in, so you can
use that information in a WHERE clause.
Yes,
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
E SA [EMAIL PROTECTED] wrote on 02/08/2005 06:40:40 PM:
All,
I have done some reading and research; however, I
seem to be at a loss...
And this time, I am not sure how to ask Google...
Here is the problem:
Table A: id INT
valuevarchar (10)
Table B: id
Shailendra Soni [EMAIL PROTECTED] wrote on 02/09/2005 08:28:36
AM:
Hi,
I have a question regarding speed of the query.
In my application i am useing Mysql 4.0.20a-nt.
I have 10 tables and each table contains 400 records
and also 61 columns. I already created indexs on six column which
Dean Karres [EMAIL PROTECTED] wrote on 02/09/2005 12:46:46 PM:
Hi,
I have a table full of activity records. Each record has a DATETIME
field for when the activity started and one for when it ended.
I want to post process this table and produce billing records from it.
Billing records
reconstituted from a munged response
(original post)
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that
Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 03:43:22 PM:
I downloaded the MySql Administrator and simply run that. and
dragged the icon to the startup menu so it loads MySql on startup.
Not entirely sure how to load MySql as a 'service' on Win2003 Server.
The only message I get, and
Sue Cram [EMAIL PROTECTED] wrote on 02/08/2005 01:18:48 AM:
Thanks to the people who helped me with my IF statement question
last night. Now I need to carry it one step further to a compound
'IF' statement. Again, can't find much information in the manuals --
Several people sent me IF
Nupur Jain [EMAIL PROTECTED] wrote on 02/08/2005 01:26:06 PM:
I have problems with access permissions on a Solaris 9 installtion
of MySql-max 4.1. My user table shows this
select * from user;
| Host| User | Password
| Select_priv | Insert_priv | Update_priv | Delete_priv |
Eli [EMAIL PROTECTED] wrote on 02/08/2005 02:26:41 PM:
Hello,
Say I get these rows in a regular query:
col1 col2col3
---
NULLB1NULL
NULLNULLNULL
A3 B3 NULL
A4 NULLC4
A5 B5 C5
NULLB6 C6
(It's important
Eli [EMAIL PROTECTED] wrote on 02/08/2005 03:27:42 PM:
Eli [EMAIL PROTECTED] wrote on 02/08/2005 02:26:41 PM:
Hello,
Say I get these rows in a regular query:
col1 col2col3
---
NULLB1NULL
NULLNULLNULL
A3 B3 NULL
A4
Sue Cram [EMAIL PROTECTED] wrote on 02/07/2005 02:57:59 AM:
This is a pretty basic question, but I'm learning SQL from a book
and it's very very frustrating!
I'm writing a report listing animals from our shelter and whether
they have been adopted. I am selecting the animal name field
Nick Arnett [EMAIL PROTECTED] wrote on 02/07/2005 02:06:30 PM:
I'm considering the best strategy for updating large tables that I'm
indexing with Lucene. I'm
indexing in chunks of 5000 items at a time, which I select with
LIMIT statements and an incremental
multiplier (SELECT blah FROM
A Z [EMAIL PROTECTED] wrote on 02/04/2005 07:21:35 AM:
MySql 4.0.14
I understand that the most effective way of speeding
up SELECT statements is to have column level indexes.
Are there any other level indexes exist? I have been
told that there are but I have no idea, looked through
Winn Johnston [EMAIL PROTECTED] wrote on 02/04/2005 10:30:54 AM:
I have taken on a job replacing an old AS400 RPM
database with four thin clients. They really like the
feel of the thin client interface, no point and click,
no graphics, just green text on a black background. I
could use any
Jack Lauman [EMAIL PROTECTED] wrote on 02/04/2005 11:57:37 AM:
I want to run a nightly cron job where you iterate throught each row of
a single table and reset a field depending on the conditions specified.
In this case I want to take a date field (RenewalDate) and compare it
to the
Whil Hentzen [EMAIL PROTECTED] wrote on 02/03/2005 11:02:48 AM:
1. Windows 2K and MySQL 5
2. Downloaded the 3.51.9 driver (I've seen a number of issues reported
with the .10 driver, so avoided it to begin with) and installed it. It
shows up in the ODBC admin nicely.
3. Created a new file
matt_lists [EMAIL PROTECTED] wrote on 02/02/2005 08:50:16 AM:
Jay Blanchard wrote:
[snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
[/snip]
More info
The word IN is an alias for = ANY. Thus these two statements are the
same:
SELECT s1 FROM
Dan Stromberg [EMAIL PROTECTED] wrote on 02/02/2005 01:31:17 PM:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is:
Ferhat Bingol webmail [EMAIL PROTECTED] wrote on 02/02/2005
03:31:00 PM:
Hi all,
I have case like this.
200312211750 14.65 0 14.65 14.65 6
200312211800 118.9 119.41 14.65 697.17
200312211810 1324.1 122.6 697.17 1502.3 2
Last field is MODE. That case
Always include the list in your responses. It will get you more results
faster than if you have to wait on just me. - Shawn
- Forwarded by Shawn Green/Unimin on 02/02/2005 04:53 PM -
Ferhat Bingol webmail [EMAIL PROTECTED] wrote on 02/02/2005
03:55:36 PM:
Hi,
This is a mode
Yep, you seem to have a good handle on the authentication issue. Have you
tried compiling a DEBUG version and tracing through the code? Maybe you
can catch the GPF when it happens and figure out what's messing up. Since
it's failing early (during a connection) this should be rather easy to
I have seen this type of security implemented through multiple VIEWs but
not directly by the storage engine. You will need to create a view for
your user that exposes only out those rows designated for that user. The
drawback to this is that you will need to issue one view for each user or
We need more details in order to help:
What operating system are you on?
Which version of MySQL are you attempting to run?
How are you attempting to start the MySQL server?
Has it worked before or is this a new installation?
What errors are being reported to your error log? The default location
Matt Babineau [EMAIL PROTECTED] wrote on 02/01/2005 03:20:49 PM:
Hi All-
I'm running a query that uses SQL_CALC_FOUND_ROWS for my search engine
on a
real estate site. The problem is that I get an error when I run my
query:
Warning mysql_query(): Unable to save result set in
Forwarded to the list - Shawn
- Forwarded by Shawn Green/Unimin on 02/01/2005 03:49 PM -
Debora Gomes.unitech [EMAIL PROTECTED] wrote on 02/01/2005 06:33:43
PM:
The operating system is Red Hat 7.3
The MySQL version is 4.1.9
The error appears when i run ./configure in mysql/
Jon Wynacht [EMAIL PROTECTED] wrote on 02/01/2005 03:33:13
PM:
Hi,
I'm wondering if anybody can help me decrypt what this error code is
referring to:
ERROR 1071: Specified key was too long. Max key length is 500
This is the offending table creation script:
CREATE TABLE `APPROVAL`
This was sent to me, off list. I am just forwarding it to it's original
targets. -- Shawn
- Forwarded by Shawn Green ([EMAIL PROTECTED]) on 01/28/2005 09:00 AM
-
Kyle Elmblade [EMAIL PROTECTED] wrote on 01/27/2005 04:59:28 PM:
Hello Simon,
I ran accross the post below in the MySQL
Mike Jennings [EMAIL PROTECTED] wrote on 01/28/2005 07:57:06 AM:
Hello,
I am looking to export a mysql database to a gui type interface.
Basically i'm looking at a big database and I wanna dump it to a
webpage/uml where I can add notes on what each table is and what it
does, even
symbulos partners [EMAIL PROTECTED] wrote on 01/28/2005 11:14:00 AM:
On Friday 28 Jan 2005 15:41, you wrote:
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
Are you suggesting to have a full copy of the table in MyISAM
Diana Castillo [EMAIL PROTECTED] wrote on 01/28/2005 11:53:20 AM:
how do I make a query that does this?
update tbl_a set location_code=0 where tbl_a.country_id = (select id
from
countries where has_zones=0)
The UPDATE statement (as of 4.0.4) allows you to update multiple tables at
once.
Homam S.A. [EMAIL PROTECTED] wrote on 01/28/2005 02:27:51 PM:
Dropping an index on a MyISAM table should be
instantaneous. It should only take as long as deleting
the idx file from the file system. But it's taking
almost as long as creating the index itself!
Here's my queries and time they
José Pablo Ezequiel Fernández [EMAIL PROTECTED] wrote on 01/26/2005
03:49:50 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
After the good comments I've got on this mailing list, I think I have
the
structure more or less complete. In some cases I follow the comments, in
some
Ângelo M. Rigo [EMAIL PROTECTED] wrote on 01/27/2005 03:04:15
PM:
Hi
I have an aplication wich is opening to many connections even i am
using persistent connectins and closing every connection i do open
I have created indexes in all the fields i supose they are needed
I would like
This could be a case where your dump files are not split in such a way so
that they honor the max_packet_length setting of the recieving server.
Make sure you tell mysql dump what the maximum size of an INSERT statement
will be for the server you want to read the dump into or it will put all
cristopher pierson ewing [EMAIL PROTECTED] wrote on 01/27/2005
04:01:22 PM:
I'm running a query that pulls information from about six different
tables
in a DB. I'd like to be able to do a fulltext search on fields in
several
different tables. The end result should be that any row with a
Here is your original query, reformatted merely so that we humans can read
it better:
SELECT DISTINCT specials.specials_id
, products_to_categories.products_id
, categories.parent_id
, products_description.products_name
, products.products_price
,
Pupeno [EMAIL PROTECTED] wrote on 01/26/2005 07:00:34 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello MySQLers,
I'm trying to define a structure for my database and I'm experience some
problems, any comments would be appretiated.
This is for a (web) application to handle
Pupeno [EMAIL PROTECTED] wrote on 01/26/2005 08:56:05 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Shawn Green,
Je Merkredo Januaro 26 2005 15:42, [EMAIL PROTECTED] skribis:
If it were me, I would have separate tables for groups, songs,
performances, recordings, and
Pupeno [EMAIL PROTECTED] wrote on 01/26/2005 11:48:59 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There where two cases where I have roles:
How an artist participated in a song (creating the lyrics, creating the
musici, etc, etc) and how an artist participates in a group.
Do you
Pupeno [EMAIL PROTECTED] wrote on 01/26/2005 11:53:06 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Je Merkredo Januaro 26 2005 18:56, [EMAIL PROTECTED] skribis:
For instance, when Eric Clapton did his unplugged version of Layla,
he
was the same ARTIST as recorded the original
Jigal van Hemert [EMAIL PROTECTED] wrote on 01/24/2005 03:10:40 AM:
so it will be like this
no date price limit
01 1/1/05 5000 100
02 1/2/05 5010 100
03 1/3/05 5020 60 **
04 1/6/05 5010 100 ** there are 3 days difference
but how do make a query to check for record no 04 with 03
Paul Wallace [EMAIL PROTECTED] wrote on 01/19/2005 06:50:48 PM:
Was there a reply to this post? If so, I could have (did) missed it. Can
you please resend?
Rgds
Paul.
Sorry, but I never said (woops!)
Which language I use depends on where I want to run the script and how
often,
[EMAIL PROTECTED] wrote on 01/20/2005 08:59:15 AM:
Hi,
Thank you. Could you please help me in writing an equvivalent
query in mysql for the following oracle subquery?.
update macvm set embedded='Y' where vm_server in
(select a.vm_server from macvm a, component b,
Mike Zornek [EMAIL PROTECTED] wrote on 01/20/2005 11:01:38 AM:
I have the following query which will get me all of the emails for my
current membership:
SELECT email.email_address
FROM member, email
WHERE
member.member_primary_email_id = email.email_id
AND member.member_standing !=
sam wun [EMAIL PROTECTED] wrote on 01/20/2005 11:45:40 AM:
[EMAIL PROTECTED] wrote:
SELECT DISTINCT i.basename
FROM inventory i
INNER JOIN transaction t
ON i.prodcode = t.prodcode
AND t.date = '2004-01-01'
AND t.date = '2004-01-31'
INNER JOIN
You must be having a problem with your email client as this is about the
ninth time I have seen this same request today. Please check your client
for problems. I know because I have responded once already.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED]
James Black [EMAIL PROTECTED] wrote on 01/20/2005 02:44:41 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Philippe Poelvoorde wrote:
|
| Insert into comments(list of you fields here )
| select 0,1,null,'testuser','testcomment',max(idx) from comments
| where sourceid=1;
|
| but
James Black [EMAIL PROTECTED] wrote on 01/20/2005 03:08:33 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| You should already KNOW the parent comment of a comment when you
create
| it. Don't you? Imagine the following thread:
~ I am trying to not have to
Martijn Tonies [EMAIL PROTECTED] wrote on 01/19/2005 03:33:32 AM:
Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department
sam wun [EMAIL PROTECTED] wrote on 01/19/2005 07:02:37 AM:
Hi list,
The following sql statement takes 3 mintues to complete the query. How
can I improve its speed?
select DISTINCT i.basename from inventory i, transaction t, customer c
where i.prodcode = t.prodcode and c.custcode =
[EMAIL PROTECTED] wrote on 01/17/2005 06:45:22 PM:
Hi there:
I have a How do I... SQL question regarding selecting
distinct values from a field not included in an aggregated
query when LIMIT is in effect, illustrated by the
following example:
Table a contains the names of individuals,
Ronan Lucio [EMAIL PROTECTED] wrote on 01/18/2005 01:13:10 PM:
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
1) Is a SELECT DISTINCT over 5,000 records a weight
query? (Supposing it has about 20 different option the the
Ronan Lucio [EMAIL PROTECTED] wrote on 01/18/2005 02:53:39 PM:
Shawn,
Your tips are realy good but I can´t use cache neither for
queries nor for pages because our site serves hundreds of
clients, each one with your own code make a different
query, returning different rows.
It would be
Craig Hoffman [EMAIL PROTECTED] wrote on 01/18/2005 04:17:30 PM:
Hi There,
I have web form where a user can search certain fields and then have
them displayed aggregated. For example, find all the routes I climbed
with partner A in area(s) ALL (% - wildcard) between date1 and date2 --
so
Paul Wallace [EMAIL PROTECTED] wrote on 01/17/2005 12:04:13 AM:
Hi,
How can I, if at all, acquire table relationships - in particular
one-to-may/many-to-one relationships? I have looked into the
DatabaseMetaData object (Java) , but have not as yet been able to
acquire the said
I think I can summarize what has been explained before:
1) InnoDB does not always know exactly how many rows are in the database
from the point of view of each user. This is a side effect of the
row-level locking system. Each user has the potential to see a different
set of rows depending on
OK, then you were on the right track with your JOINS because you wanted to
know how many of each type of item (gift or event) each user had.
Off the top of my head, I think you need to perform an OUTER JOIN (not the
implicit INNER JOIN you create by listing table names separated by commas)
I would think that the Jan solution should execute in a single pass
through the table. The Dave (subquery) version will probably need to make
3 passes through the table get the same results.
As was mentioned in another response, the inequality comparisons
(=,,,etc.) are much faster than a
Your first fix failure (command prompt start) sounds like you started the
CLIENT not the SERVER.
CLIENT = mysql.exe
SERVER = mysql-nt.exe or mysqld-nt.exe or... (there are several versions
that come with each distribution)
Your second fix failure matches with your installation error. There is
Scott Purcell [EMAIL PROTECTED] wrote on 01/13/2005 01:05:01 PM:
I understand the auto-increment capability, but how would one share
it amount three different tables?
Would one have to do a rig, and create an extra table with increment
in it, then get that value to update table 1, then
There may be other ways to get at the information you want. What is the
purpose of your query?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
2wsxdr5 [EMAIL PROTECTED] wrote on 01/13/2005 01:57:31 PM:
I have these 2 queries.
SELECT count(*) gifts
FROM gift g
I have done this numerous times. What you have to do is match 2 conditions
in your ON clause.
I need to make up some information to answer your question because I don't
know all of the table names involved in this particular query (you didn't
say in your original post). I know you have two
May I introduce you to the family of SHOW commands?
SHOW DATABASES - lists all databases on a server
SHOW TABLES - lists all tables within your current database
SHOW CREATE TABLE x - returns a table containing a SQL statement you
could use to recreate the table x if you needed to
Marcus Claesson [EMAIL PROTECTED] wrote on 01/10/2005 02:00:37
PM:
Hi Michael!
Before the holiday you tried to help me with a problem that I had
over-simplified and made more confusing than it was. I'll now try again,
and also by giving the columns their right names.
My table consists
I know that your options for physical partitioning depend on your OS, your
filesystem, and whether you are using InnoDB or MyISAM. I cannot speak
from personal experience on the mechanics of this but I know that several
others on the list have performed this particular optimization (which is
Marcus Claesson [EMAIL PROTECTED] wrote on 01/11/2005 11:05:49
AM:
Thanks for helping!
So you ARE having problems trying to change your sbj_count and
hsp_count columns after adding information to your table your so that
data is re-ranked according to some rule(s) you have. Exactly, how
OOPS! the ON AND was a typo. Sorry! Should have been just ON. I am
puzzled why it worked but I am glad it did.
That's what I get for too much cut-and-paste at the end of the day. I
apologize to everyone!
What actually made it work was not the ON AND (yuck!) but the LEFT JOIN.
What you were
Gerald Preston [EMAIL PROTECTED] wrote on 01/07/2005 01:02:04 AM:
Hi!
Running mysql on a XP command line. Doing dhow databases list the
following;
Database
Club
Mysql
Test
I did a grant all user id;
How can I list the rows and columns.
One of these may help: SHOW CREATE TABLE
Richard Reina [EMAIL PROTECTED] wrote on 01/07/2005 03:31:26 PM:
I am having trouble with a query that gives me
activities that have not been written up but if
these activities are a party they whould only appear
in the query if they have been held, hence date will
not='-00-00'
If I
After hearing both sides being suggested, I think I would recommend the
more normalized approach of having one or more separate tables for the
names (one name per row) and a mapping table that associates a name field
(mother's maiden name, decedent's given name, decedent's surname, etc.) on
a
As Rhino said, the INFORMATION_SCHEMA views (data dictionary) are coming
in v5.x (so they are close but not here yet). Until then a more native
alternative is to parse the results of either SHOW CREATE TABLE
tablename or SHOW COLUMNS FROM tablename LIKE 'columnname' in whatever
language you
Stephen Moretti [EMAIL PROTECTED] wrote on 01/05/2005 07:22:18 AM:
Kentucky Families wrote:
Very new to MySQL and this list. Thanks in advance for your
patience with elementary questions. I'm in process of converting a
current web site to a mysql database. As this database will
It's probably your JOIN on shipped items producing a cross product with
your JOIN on ordered items. What happens if you take the entire
shippeditems JOIN out of your statement? Are your numbers still off?
Since your query is not using data from that table you should be able to
eliminate it
Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... )
that VS produces to make an ASP.NET application? Have you EVER had to be
in the position to debug and modify that by hand (without the aid of VS)?
I have. I ask that you try it before you continue your high praise for
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
05:20:49 PM:
[snip]
Anyhow, it has been a good discussion. No bugs were uprooted and
everyone's understanding may have risen a notch. After a couple of
decades using SQL I still find interesting topics to discuss.
Yes, I too have
Did you think to check the manual?
English:
http://dev.mysql.com/doc/mysql/en/String_functions.html
German
http://dev.mysql.com/doc/mysql/de/String_functions.html
French:
http://dev.mysql.com/doc/mysql/fr/String_functions.html
and your query would look like
SELECT ...
FROM ...
WHERE
This will give you a list of names and their soundex values. Is this what
you want? What is it you are trying to do, there may be a better way to do
this than by getting a list and reprocessing it somehow.
SELECT nn, soundex(nn)
FROM table
WHERE nn ''
Shawn Green
Database Administrator
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
07:59:35 AM:
[snip]
atomically from my applications point of view means:
I have a snapshot of my data (due to InnoDB this does not change
hiddenly during
my session). I send a query to the database. I get the result / changed
data.
And
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
11:43:43 AM:
[snip]
I hope I am not so naive that Kai and I are the only two who sees a
problem with this behavior. Some of you may think this is a feature
but I do not like it because that means that calculational errors will
occur
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 12:34:31 PM:
We loaded a new server with Windows XP professional, and mysql
server 4.1. We can't get Mysql to run. After installing mysql and
trying to execute it we get the following message:
ERROR 1045 (28000): Access denied for user
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 01:32:41 PM:
I'm going to the dos window on the server and typing mysql to kick it
off.
That's when I get the error.
OK, mysql is the client that comes with the server. What you attempted
to do was to login as nobody and you said you weren't
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
01:32:20 PM:
[snip]
I understand that is the behavior of the assignment operator. That's why
I used it. ;-) I expected the results to be 19 and 6 not 19 and 20.
This is just another example of the serialization of evaluation that
occurs
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
03:50:24 PM:
[snip]
... a bunch of stuff
[/snip]
It alomost sounds as if you're coming from a M$ campwhat you
describe are VIEWS.
In a way it is, an internally generated view of the source/destination
tables.
Anyhow, the
When scripting for Windows you have two immediate choices: VBScript and
JScript. Both are natively supported by the WSH (Windows Scripting Host)
executable which comes in two flavors: command line (cscript.exe) and
windowed (wscript.exe). If you want to use Perl or some other scripting
I thought you were building a local application, not a web-based app??
I believe you can still use PHP through WSH (instead of IIS) but you will
need to do some research, though. I know that Perl is supported by both
WSH and IIS (I have seen it working before) so I think that PHP and Python
shaun thornburgh [EMAIL PROTECTED] wrote on 12/29/2004
03:00:08 PM:
Hi Shawn,
Thanks for your reply, but your query seems to return everyone allocated
to
that project plus everyone who has ever been booked on that project.
What I
need is everyone who is currently allocated to that
You are correct. The AV scan should not happen unless the database is
shutdown or some kind of file locking contention could occur.
It should be possible in your OS to deny your AV access to the folders
that contain your database files. This may mean changing the user account
your AV runs
901 - 1000 of 1587 matches
Mail list logo
