Subject:how to select with a set type field
I have a table 'organisms' with a field 'category'
of type SET('birds','bees','flowers','trees').
A record could have none or more of these in that field.
How do I select all records with both 'flowers' and 'trees'?
I can SELECT category,key
* Jonathan Soons
I have a table 'organisms' with a field 'category'
of type SET('birds','bees','flowers','trees').
A record could have none or more of these in that field.
How do I select all records with both 'flowers' and 'trees'?
I can SELECT category,key FROM organisms;
Then I can test
hi all ,
i'm trying to improve performance of a quite big and heavily used mysql
set of tables.
i want to create some indexes on this table , but before this , i'd like
to remove the ones created by my predecessor , which are sometimes
duplicate , and somtimes useless.
here is an output from
* Benjamin KRIEF
[...]
first of all , i'm asking myself : why is there 2 primary keys on the
same column ?
Don't know... strange.
[...]
mysql drop index login connexion on v2easy0_users;
ERROR 1064: You have an error in your SQL syntax near 'connexion on
v2easy0_users' at line 1
In the last episode (Sep 01), Benjamin KRIEF said:
hi all ,
i'm trying to improve performance of a quite big and heavily used mysql
set of tables.
i want to create some indexes on this table , but before this , i'd like
to remove the ones created by my predecessor , which are sometimes
Hi Ben,
When using column/index names with odd characters (such as spaces), you
need to use backticks (SHIFT + the ~ key) around the name: `index id`
This ALTER TABLE query should make all the changes you want:
ALTER TABLE v2easy0_users
DROP INDEX `login connexion`,
DROP INDEX `index id`,
--
thanks for all your answers ! i'd never imagine that mailing-list to be
so active and efficient!
matt : does mysql locks the table during the whole alter table execution?
Matt W wrote:
Hi Ben,
When using column/index names with odd characters (such as spaces), you
need to use backticks (SHIFT
Just use
SET FOREIGN_KEY_CHECKS=0
To turn off all foreign key contraints before you import the data.
Then use
SET FOREIGN_KEY_CHECKS=1
to turn them back on.
Go to http://www.innodb.com/ibman.html and search for foreign_key_checks for the docs.
Hope this helps.
Toro
On 01/09/2003 at 1:01 Chris
Hi,
- Original Message -
From: Benjamin KRIEF
Sent: Sunday, August 31, 2003 8:17 PM
Subject: Re: spaces in index name
thanks for all your answers ! i'd never imagine that mailing-list to
be
so active and efficient!
It's usually not that active on weekends, volume-wise. And I see
Hello,
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
Hi
Having 2 tables
TOrders:
ProductID Amount
400810
4008 -5
4110 7
4110 2
4110 -4
4110 1
TStock
ProductID Count
4110 3
4110 2
What I want Is a sum of product
Hi All,
Can any body tell me how many records mysql can hold efficiently. i.e Is there any
boundation on number of records mysql can handle?
Please let me know ...
Thanks
Binay
http://www.mysql.com/doc/en/Table_size.html
On Sunday, August 31, 2003, at 01:07 PM, Binay Agarwal wrote:
Hi All,
Can any body tell me how many records mysql can hold efficiently. i.e
Is there any boundation on number of records mysql can handle?
Please let me know ...
Thanks
Binay
--
Hi !
I'm working on a regex to validate emails stored in a table.
I'll try other regex from php tips or javascripts tips, but the exact
syntaxe of regex in mysql are differents and nothing work fine... And
I'm not very good with regex :\
I find this :
SELECT email FROM mailing WHERE email
Hi,
Not sure about php syntax, but check out the perl module (in CPAN)
Email::Valid.
Here is the code fragment for the regex:
# Regular expression built using Jeffrey Friedl's example in
# _Mastering Regular Expressions_ (http://www.ora.com/catalog/regexp/).
$RFC822PAT = 'EOF';
Bonjour Matthew !
MS Not sure about php syntax, but check out the perl module (in CPAN)
MS Email::Valid.
I'm not searching the PHP syntax, but the SQL syntax... :)
A +
--
**
Richard CARLIER
I dont know why my brain stopped working :)
I have two tables T1 and T2, both of which have a column : SerialNo
Now I want to select those rows from T1 whose SerialNo is not present in
T2.
This dont work:
select T1.*
from
table1 as T1
straight_join
table2 as T2
where
On Mon, 01 Sep 2003 17:13:20 +0900
Nishant [EMAIL PROTECTED] wrote:
I dont know why my brain stopped working :)
I have two tables T1 and T2, both of which have a column : SerialNo
Now I want to select those rows from T1 whose SerialNo is not present in
T2.
This dont work:
select
I am in the process of porting some python scripts to Mysql.
Currently, the scripts I have queries a Pg database for entries (made)
between certain dates.
The python script snippet of the query
mainQuery =
select distinct
wow. yeah it works.
Thanks a lot.
-N.
On Mon, 01 Sep 2003 17:13:20 +0900
Nishant [EMAIL PROTECTED] wrote:
I dont know why my brain stopped working :)
I have two tables T1 and T2, both of which have a column : SerialNo
Mixo Shiburi wrote:
I am in the process of porting some python scripts to Mysql.
Currently, the scripts I have queries a Pg database for entries (made)
between certain dates.
The python script snippet of the query
mainQuery =
select distinct
Joseph Bueno wrote:
.
.
.
rt3=# select age(now(),'2003-08-26'::timestamp);
age
6 days 10:14:43.421275
+++
Thanks,
and
select age('2003-08-26',resolved)
where 'resolved' is a 'timestamp'.
--
MySQL General Mailing List
For list
Joseph [EMAIL PROTECTED] wrote:
I have a table I use to keep track of referred users on my top list. Below
you will find the four columns in my table. What I need to do is keep
entries (rows) unique based on the linkid, ipaddress, and the clicktype so
that a user is not counted twice if they
Rachel Rodriguez [EMAIL PROTECTED] wrote:
I have experience using MySQL and SQL commands in
general, but I am going through my first experience
with working with multiple character sets.
I am working on a Russian/English translation project
and I'd like to create a table where column1
[EMAIL PROTECTED] wrote:
In a normal case, to install Mysql in windows we need to run setup.exe and
it's launch a wizard when we define some things like a destination
directory.
I want to know (if somebody can help me) if it is possible to install mysql
and the wizard not be launched.
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP addresses on the server. I am assuming that localhost is the problem,
how can I manually change localhost to be an IP address?
The error message is:
Warning: mysql_connect(): Can't connect to local MySQL
On Mon, 1 Sep 2003 11:34:31 +0100
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
The error message is:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3
Unable to select database
is MySQL socket really placed
Could not read response from last sender :o(
-Original Message-
From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED]
Sent: 01 September 2003 11:35
To: Mysql
Subject: Cannot Connect to Server
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP
On Mon, 1 Sep 2003 11:51:07 +0100
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
Could not read response from last sender :o(
from [EMAIL PROTECTED] ?
it's Yet Another Spammer(or Autoresponder) on this list. YAS(A) =)
dunno why list administration haven't blocked him yet.
These robots are
Kevin Fries [EMAIL PROTECTED] wrote:
Can we 'unanalyze' a table? I'd like to remove the statistical
information from my analyzed table, for testing purposes.
You can't.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
I recently upgraded to MySQL 4.0.12 and I logged all queries for a little
while, just to see what was happening. When I looked at the log, I saw
that there was a Show Status query happening every 10 seconds. This happens
both on my server which runs WIndows 2000 Server and on my laptop which
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
You should be able to change that ins sqlsysadmin (the traffic light) under
the section options if I remember correctly and change default 10 to
whatever you wish
Albert
- Original Message -
From: Pam Vermeer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Pam [EMAIL
Make sure
%WINDOWS%\my.ini has the entry
bind-address=127.0.0.1
-Martin
- Original Message -
From: Antony Dovgal [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 3:42 AM
Subject: Re: Cannot Connect to Server
On Mon, 1 Sep 2003 11:34:31 +0100
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle
I've clearly done something worng but, novice that I am, I'm at a dead end
to figuring out just where I've gone astray. I've scoured the help files
and faqs locally and online but can't seem to find anything I recognize as
relevant. Perhaps someone can point me in the right direction.
Have
Hi!
On Aug 29, Kevin Fries wrote:
Can we 'unanalyze' a table? I'd like to remove the statistical
information from my analyzed table, for testing purposes.
yes, but it is not easy.
You cannot mark the table as unanalyzed - so you need to rebuild it
somehow.
REPAIR TABLE table_name EXTENDED
Hi
I know that there are two problems when using NFS and MySQL.
One is speed.
My question is that with a good filer like a Netapps with Gig Ethernet would
speed stop being a problem?
Two locking.
Why is this a problem? Do locks get missed when righting from the system to
the filer?
Thanks for
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm
5.5.3 tsnames.ora File
the file
ORACLE_HOME/network/admin/tnsnames.ora must point to the listener (i.e., the
TCP/IP port) on the database server. (ORACLE_HOME is
Bob-
I would start to look in
\Apache Group\Apache2\logs
and tell us what error.log says
-Martin
- Original Message -
From: Bob Demers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:46 AM
Subject: Can't start MySQL
I've clearly done something worng but,
I've got a user, admFrederic
He got the grants shown below.
Those are correct and I configured them that way.
mysql SHOW GRANTS FOR admFrederic;
+---
+
| Grants for [EMAIL PROTECTED]
|
On Mon, 1 Sep 2003 17:19:52 +0200
Joris Beckers [EMAIL PROTECTED] wrote:
I've got a user, admFrederic
He got the grants shown below.
Those are correct and I configured them that way.
don't forget about
FLUSH PRIVILEGES;
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General
Might also help if he would specify the O/S ...
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 1:12 PM
Subject: Re: Can't start MySQL
Bob-
I would start to look in
\Apache
On Mon, 1 Sep 2003 15:40:09 +0100
Simon Green [EMAIL PROTECTED] wrote:
Hi
I know that there are two problems when using NFS and MySQL.
One is speed.
My question is that with a good filer like a Netapps with Gig Ethernet would
speed stop being a problem?
Two locking.
Why is this a
On Monday, September 01, 2003 5:19 PM CEST, Joris Beckers wrote:
But, when I log in using that username. That user can access the main
database...
snip
Does anyone know how to fix this?
Only cehdb should be accessable.
Did you try to set the safe-show-database flag? Hm, let me see where I
On Fri, 29 Aug 2003 12:42:03 -0700
Grant Cooper [EMAIL PROTECTED] wrote:
I'm trying to get a query to work by listing all the people in a row with
the same last name and first name.
key, fname, lname
1 ,John, Smith
4, John, Smith
5, Cody,Edwards
2, Cody, Edwards
SELECT fname,lname,
He is on Win32, probably Win98
Regards,
Jakob
Might also help if he would specify the O/S ...
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 1:12 PM
Subject: Re: Can't start MySQL
I downloaded version 5.0 on 30/08/03,
everything went fine until I did make test
it failed with an error in derived,
/root/mysql5.0/mysql-5.0/client/.libs/mysqltest: At line 97: Result content mismatch
see output and attached.
I then tried make test --force as suggested, but --force is an
hi all , and thanx for your help on my weird_indexes problem.
no that i've created the indexes , the things are going a bit better but
it's still not so fast : here's some output from mytop :
-
Queries Total: 442,666Avg/Sec: 7.74 Now/Sec: 16.27
I used the flush privileges command
There are in total 6 databases
But only mysql and cehdb are visible.
The MySQL version is 4.1.0-max-nt
There are no other hosts configured for that user other then %
Because it's mysql 4, the safe-show-database option is not usefull
All the users that
Hi
I have 2 tables and I want a faster report like this.
| counter | user_company_name |
+-++
| 65537 | company1 |
| 65535 | company2 |
| 64563 | company3 |
| 52676 | company4 |
User_table description
| Field
Herewith is the ERROR LOG FROM \apache group\apache2\logs per Marty's
suggestion.
Special note: The domain name and server name default to that of my ISP.
Can't understand why that would be since the installation is entirely local.
ERROR LOG
[Mon Sep 01 11:47:26 2003] [notice] Parent: Created
52 matches
Mail list logo