ation for utf-8 in MySQL. If you use
literal strings MySQL may assume that these have the default collation
and comparing them to columns with other collations or performing things
like cast operations may produce errors about invalid combinations of
collations.
--
Met vriendelijke groet,
Jigal v
others in this thread use Gmail which obviously lacks a button "Reply to
list".
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
other reply for details on the software that
was used.
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
On 10/12/2014 09:02, Johan De Meersman wrote:
- Original Message -
From: "Jigal van Hemert"
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicat
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ing from any host
In that case you would know that connecting via a Unix socket is not the
same as connection via a network.
See:
http://bugs.mysql.com/bug.php?id=69570
http://dev.mysql.com/doc/refman/5.5/en/connecting.html
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
M
wrong here :-)
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
s of functions
available to manipulate the data itself.
[1] http://dev.mysql.com/doc/refman/5.5/en/update.html
[2] http://dev.mysql.com/doc/refman/5.5/en/functions.html
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql
application that has SELECT rights on the
view but not on the table.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Asma,
I think maybe it is a good idea if you start reading Mysql for dummies or
something similar. If you do not understand the basic concepts of unix/linux
and mysql, I see a hard road for you.
Google is you friend and I believe they would even have documentation in your
native language.
Reg
Why don't you just use yum install .
Should sort out most if not all your problems regarding installation of mysql.
Regards
Brian vd Westhuizen
-Original Message-
From: Asma rabe [mailto:asma.r...@gmail.com]
Sent: Wednesday, 5 March 2014 1:21 a.m.
To: geetanjali mehra
Cc: Johan De Me
Dont understand your question ?
But
If you have 2 masters replicating to each other, yes you can a have a single
slave hanging from either those servers.
Things to keep In mind
Each server have unique server id
Make the slave read only
If you have very little experience in DBA'ng and particul
, a UNIQUE index
permits multiple NULL values for columns that can contain NULL.
Only for 5.0 there is the exception that the BDB storage engine does not
allow multiple NULL values in a column with a UNIQUE index.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Ma
t used normally. E.g.
for an INT field where you only use values of zero or larger you can use
e.g. -1 as a special value.
If you insist on using NULL and the crazy <=> operator you can use NOT
to invert it:
SELECT NOT(A <=> B);
--
Kind regards / met vriendelijke groet,
Jigal van H
fear Google is right.
http://www.net-security.org/malware_news.php?id=1853
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ual it is called "gap locking":
http://dev.mysql.com/doc/refman/5.5/en/innodb-record-level-locks.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-next-key-locking.html
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://li
On Aug 30, 2011 6:46 PM, "Brandon Phelps" wrote:
> SELECT
>sc.open_dt,
>sc.close_dt,
>sc.protocol,
>INET_NTOA( sc.src_address ) AS src_address,
>sc.src_port,
>INET_NTOA( sc.dst_address ) AS dst_address,
>sc.dst_port,
>sc.sent,
>
ry. If there are not
enough different values in a column (low cardinality) it might be faster
to do a full table search instead of first reading the index and then
having to go through the table anyway.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
Fo
es in the schema and even changes in the data can
lead to changes in the behaviour.
You can make suggestions for the indexes to be used and you can even
force the use of an index if the query optimizer makes the wrong
decisions in a case.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
it the search for the last
10 to 20 days.
Of course this requires an index which includes gmtdate, but it can make
the result set before the limit a lot smaller.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
tuations if possible without having to look for all possible
combinations of the encoded data.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
eceived some messages off list from people
offering you tutoring for money. Nobody else saw those messages and your
replies looked a bit odd because of this.
Please keep track of whether a message came from the list or from
someone personally...
--
Kind regards / met vriendelijke groet,
Hi,
On 2-4-2011 2:18, Thomas Dineen wrote:
Can't find file: './mysql/host.frm' (errno: 13)
http://tinyurl.com/3sc3ydx
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
ll need to update it with additional text.
Best regards,
Almar van Pel
www.makeweb.nl
-Original Message-
From: Jaime Crespo Rincón [mailto:jcre...@warp.es]
Sent: dinsdag 22 februari 2011 13:20
To: Joerg Bruehe
Cc: mysql@lists.mysql.com; Almar van Pel
Subject: Re: contact gives empty re
+
| NULL |
| SomethingHelloDoes not work|
++
Best regards,
Almar van Pel
www.makeweb.nl
ind threads with 'solutions' such as
"ignore this", "found it myself", "never mind, solved", etc.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Ryan Chan wrote:
> According to this document:
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>
> It said MySQL support UTF-8 using one to three bytes per character.
>
> But I have created a test table:
>
> -- create table test ( c char(5) ) default charset =utf8;
>
> >From the table
configuration of the
application was enough.
It really depends on the situation of your application which table
structure is the most suitable. Test the performance of all kinds of
operations you need to do with realistic data and various amounts of
data to see how it scales.
--
Jigal van Heme
;>>No thanks, just take me to the downloads!"
Pretty simple to avoid the questions.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
M and InnoDB tables.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Geert-Jan Brits wrote:
> Perhaps you could give us a (generalized) description of your use-case, so
> we can better grasp what you want to achieve, and how you want to use it.
> i.e: since I can't imagine/ envison a real 'eucledian distance' over 96
> dimensions I bet you're talking a generalized d
Hello Chris,
The use case I'
m talking about is actually a typical usecase for GIS applications: give
me the x closest points to this one. E.g: give me the 10 points closest
to (1,2,79) or in my case: give me the 100 points closest to
(x1,x96). A query like yours might be possible and might be
ing to define a
distance measure based on each individual point. I'm not sure this is
feasable.
In general: KD-trees are quite good tools to deal with such large
dimensional spaces, but I see no possibility to use them in mysql,
Wkr,
>
>
> On Tue, Mar 30, 2010 at 11:39 AM, Werner Van
Geert-Jan Brits wrote:
> You're most likely talking about something like consine-similarity on
> N-dimensional vectors.
> http://en.wikipedia.org/wiki/Cosine_similarity
> http://stackoverflow.com/search?q=cosine+similarity
>
Cool links ! Although it is not why I need it for. I'm really talking
abou
Hello,
I have been pondering this for a while, but never really looked deeply
into the problem.
I have 96 dimensional points and I would like to pose queries such as:
'give me all points that are within such a radius of this one'. The gis
extensions to mysql might support such type of query. The
1 DAY
GROUP BY `account_id`
ORDER BY avg_hits DESC
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ine
to do a full text search on them surely is a limitation of that
database, not a conceptual disqualification of storing binary data in
a database.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
use is really useful, chances are that the
application is a lot simpler, faster and easier to maintain.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
x datasets are even made more
complex by normalization, trying to be ultimately flexible and creating
a solution for problems which simply don't exist.
In almost all cases a simple solution will be the best.
Regards,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: ht
people requiring more powerful hard- and software
for their application are simply forgetting that they were supposed to
produce a working application and not the most normalized database with
all the fancy views and other stuff.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list arc
Claudio Nanni wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
Initially her was convinced that MySQL as a division of Sun would really
benefit the future of MySQL [1]. Obviously his relationship with Sun
changed "a bit" later on.
It shows tha
Claudio Nanni wrote:
"Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
I fail to see the relevance of this quote for this thread...
Regards,
Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
Shawn,
Thanks for the info, it does help indeed.
I had also replied back to Gary to thank him as well, but I don't think that
it made it to the list... so to Gary, thanks as well.
Regards,
Terry
Terry Van de Velde
Email: bya...@rogers.com
Phone: (519) 685-0295
Cell: (519) 619
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially foreign keys to teams.team_no
erybody who answered. :)
Regards,
Sebastiaan
Ananda Kumar wrote:
does the table ur trying to delete has any primary-foreign key relation.
do "show create table table_name\G"
Also instead of delete, use truncate, i t will be faster.
regards
anandkl
On Tue, Nov 10, 2009 at 3:19 A
Hi,
I have the following model:
Domain (*)<-(1) Account (*)<-(1) User
That is, each user belongs to exactly 1 account, an account can have
multiple users; each account belongs to a single domain, and a domain
can have multiple accounts.
A user has an email address, which must be unique acro
ix the issue.
1. Do proper shutdown of mysql server.
2. Check the error log file that mysql server is shutdown properly.
3. Remove log files (ib_logfile0 and ib_logfile1).
4. Start mysql server (The log files will be created automatically)
Thanks,
Krishna
On Sun, Nov 8, 2009 at 2:51 PM, Sebastiaan v
why o why
did I have to upgrade in the first place).
Regards,
Sebastiaan
Johnny Withers wrote:
Are you running selinux?
On Sunday, November 8, 2009, Sebastiaan van Erk wrote:
Hi,
$ ls -ld /tmp/mysql
drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
$ ls -ld /tmpfs/mysql
drwxr-xr-x 2
Hi,
$ ls -ld /tmp/mysql
drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
$ ls -ld /tmpfs/mysql
drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
So I don't see the difference
Has anyone encountered similar problems, or know what's going on here?
Best regards,
Sebastiaan
Hi all,
I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts of
temp file problems. For example, when I try to delete a row and violate
a contraint I get:
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)
On 9/2/2009 3:43 AM Victor Subervi said...
Hi:
I have the following python code:
import os
os.system("mysqldump -u root -pPASSWORD --opt spreadsheets > dump.sql")
First, test this at the system command line -- you'll likely get an
empty file there as well, so calling from within python simply
On Tue, Feb 10, 2009 at 1:47 PM, Steven Buehler wrote:
> From: Jochem van Dieten:
>> What the database will do for you behind the scenes is expand your
>> usage of the view. In effect, the database will replace "x" with its
>> definition. So your query SELECT a FROM
ro that assigns an alias to a select
statement, and when you reference that alias the select statement will
get substituted back in.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
a AS
SELECT
*
, (SELECT MAX(x) FROM y) AS z
FROM flight
This is not updatable because there is no sensible way to propagate
changes to the y base table.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote:
> Basically each product is listed in the master table, and can have a number
> of suppliers linked to it (ProductTB). The query above will show me a list
> of products for all suppliers for a particular product. However I want to
> be able to
Chris,
> I might be being an idiot.
Yes, you are :-)
> -122.1529 is between -121.148 and -121.1575
This is not true!
-122.something cannot be between -121.somethingother and -121.somethingelse
-121.1529 is between -121.148 and -121.1575
Regards,
--
Jigal van Hemert.
--
MySQL G
ELECT up in the online manual).
> So,I should "convert" table a according to table b. Thank you in advance
> for all your help
My approach would be the opposite:
SELECT t1.`STY`, t3.`STY` FROM `table_b` AS t1 JOIN `table_a` AS t2 ON
t1.`CUI` = t2.`CUI1` JOIN `table_b` AS t3 ON
Sebastian Mendel wrote:
Werner Van Belle schrieb:
Hello,
You might find the following challenging -or- you might now the
answer :-)
Table Q
Subtable, field, val, ID
A 1 a42
A 2 b42
B 1 a78
B 2 t78
B 3 o78
C
the return value
Subtable, field, val, ID
A 1 a42
A 2 b42
C 1 u23
Is there anybody that bumped into a similar query and was able to solve
it satisfactory ?
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
--
MySQL General Mailing List
For
Hi,
> if i have for example
> a simple table call person
>
> with 'id' and 'name' how columns
>
> i can do a backup and get some file (A.sql)
> with all the inserts statements
>
> here, all fine
>
> but
> how i can do this?
Have a look at the 'mysqldump' command line utility.
It goes somethin
On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote:
> Is it possible to add to the syntax of the INSERT operator appoximately
> in such way:
> SELECT list INSERT [IGNORE] INTO ... - an added one.
> SELECT list UPDATE - an added one.
> PS: I understand that adding the changes into a language i
teractive_timeout' can be used.
Lowering max_join_size could be an option too (it's currently
100,000,000), but I don't want to break people's existing apps that may
rely on this hight join size.
Thanks,
--
Martijn van den Burg
ASML ITM&S MySQL/TIBCO Support
--
T
[EMAIL PROTECTED]
> Sent: Wednesday, January 02, 2008 14:06 PM
> To: Martijn van den Burg
> Cc: Martin Goldman; mysql@lists.mysql.com
> Subject: Re: Backing up via slave
>
> Hi Martijn,
> Master will not have any information of SLAVE how r u doing
> this in you second s
On Jan 17, 2008 9:02 PM, Kerry Frater wrote:
> Thanks for the input Jochem.
If you wish to ignore my code and continue with your own code that of
course is fine with me. But why do you expect me to continue to help
you if you ignore me anyway?
Jochem
--
MySQL General Mailing List
For list archi
On Jan 17, 2008 2:22 PM, Kerry Frater wrote:
> Can someone please advise. I am looking to create a "multiuser" friendly way
> of getting a subset number of rows from a table into another whilst making a
> modification.
> create temporary table Ttable1 (select * from masterlist where ref='ABCDE');
Hi Martin,
> Hi folks,
>
> I have two MySQL servers running in a master-slave
> configuration, and I want to set up a process for backing up
> our application's data in which backups are sent to a server
> at another location. Ideally, I'd like to do a full backup
> once a week, and then incr
Of Baron Schwartz
> Sent: Thursday, December 20, 2007 15:50 PM
> To: Martijn van den Burg
> Cc: mysql@lists.mysql.com
> Subject: Re: How to set 'sql_warnings' in the config file
>
> That is not a mysqld option, it's a session variable:
>
> mysql> select @@
95,
could that be related?
Regards,
Martijn van den Burg
--
The information contained in this communication and any attachments is
confidential and may be privileged, and is for the sole use of the intended
recipient(s). Any unauthorized review, use, disclosure or distribution is
prohibited.
On 10/21/07, Rob Wultsch wrote:
> I was previously on a list where the reply-to was setup as it is on the
> mysql list, with the originator receiving a response rather than list. It
> ended up that that setting was the default, and had not been changed when
> the list was setup.
>
> Is there a good
VARCHAR(128));
LOAD DATA LOCAL INFILE 'imports/ensgdescriptions.csv'
INTO TABLE EnsgDescriptions;
Wkr (don't write this in your script :-),
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
been nice if I could just use various databases through the same local
server.
Are there any solutions for this kind of problem ?
Werner,-
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
signature.asc
Description: This is a digitally signed message part.
The comma at the end of the SELECT statement needs to be removed
Naz Gassiep wrote:
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id
= group_post_moderation
On 7/26/07, Andrew Armstrong wrote:
> * Table 1: 80,000,000 rows - 9.5 GB
> * Table 2: 1,000,000,000 rows - 8.9 GB
> This is a generic star schema design for data warehousing.
> I have read that it is better if perhaps partitioning is implemented, where
> new data is added to a partiti
ysql server, which will
accept the db update and render via a php script this list (song, number
plays, skip count, etc.) as an include for publication from other pages
on this site.
Anyone started on such a thing?
If not, and anyone else interested, I'll post my final mo
On 7/8/07, Mogens Melander wrote:
On Fri, July 6, 2007 17:55, Michael Dykman wrote:
I have been on this list for a pretty long time but in the last few
months I have started to receive random 'confirm unsubscribe'
messages..They always seem to originate from a Roadrunner IP (I
have not thor
Well,
you can save all data encoded in the database:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode
- Mike
Chris schreef:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should
Is there a way to monitor SQL query response times?
Mysqlperformanceblog has patches for higher granularity query log:
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/
You could always just wrap the query calls in between some time registration
of your own.
--
Hello list!
I've noticed in MySQL 5.0 partial keys on character fields aren't always
used. In 4.1 they were.
They seem not to be used when using inequality comparison.
I'm not sure whether this is a bug or intended (in the latter case I have to
work around it to get the speed I got with 4.1 ba
Dear list,
My company wants to migrate MySQL 5.0.18 from SPARC/Solaris 8 to
Intel/RedHat Enterprise Linux 4 update 4.
Are there any incompatibilities or snags to be expected (expect from the
endian issue, which will be solved by exporting/importing the data)?
Thank you for your time,
Martijn
t
mysqldump or something? Or any other solution?
Grtz,
Mark van Herpen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
Ananda Kumar said the following, On 28-Mar-07 06:15:
Hi All,
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
To check if a database is still running is diffrent then the actuall
process.
Do you wan
On 3/27/07, Tim Lucia wrote:
> -Original Message-
> From: Maciej Dobrzanski
> Sent: Tuesday, March 27, 2007 6:46 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why doesn't the InnoDB count() match table status?
>
> MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
> spr
(-1,1,2,3) where -1 stands for to be started, 1 for started and so
on.
To answer your question:
ORDER BY `status` = 'to be started', `status` = 'started', `status` =
'finished', `status` = 'canceled'
Mike van Hoof wrote:
Hello everybody,
I got a smal
Hello everybody,
I got a small problem with ordering on en ENUM field. The values in this
field are:
- to be started
- started
- finished
- canceled
And i want to order on this field, but in the direction the are above
here (and not alpabetically).
Is that possible?
- Mike
--
Medusa, Media
Hi!
I would start at:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication.html
Bye,
Ian
Ananda Kumar said the following, On 16-Mar-07 11:04:
> Hi All,
> We are planing to develop and high available mysql db.
> Can anybody please point me to any good documentation. Also how stable is
> > Hi,
> >
> > I have allocated 500MB to key_buffer_size, but only 324MB is in use
> > (64%).
> >
> > Am I right to assume that this can mean one of the
> following: (1) all
> > indexes have already been cached and together they are just 324 MB,
> Do "find /var/lib/mysql -name "*.MYI" -ls" (if
Hi list,
As part of a server virtualization project, we are going to migrate
MySQL from SPARC/Solaris 8 to AMD/x86 Solaris 10.
I seem to remember that it is possible to:
- stop the SPARC server
- move the mount point of the MySQL data directory to the Solaris/x86
server
- start the AMD x86 serve
Hi,
I have allocated 500MB to key_buffer_size, but only 324MB is in use
(64%).
Am I right to assume that this can mean one of the following: (1) all
indexes have already been cached and together they are just 324 MB, (2)
there is a limiting variable (open_files, inodb_open_files, for example)
tha
On 2/5/07, Jim C. wrote:
When I uncomment some of these statements I get an error in regards to a
comma. What I'm afraid of is that perhaps there is a compatibility
issue such that an INSERT command on Postgres can't take as many records
as MySQL.
What version are you running?
Jochem
--
MyS
On 2/5/07, Jim C. wrote:
CREATE TABLE "credits" (
"person" integer NOT NULL default '0',
"chanid" int NOT NULL default '0',
"starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00',
"role" VARCHAR NOT NULL,
CONSTRAINT role_check CHECK "role" IN
('actor','director','producer','ex
On 2/2/07, Jim C. <[EMAIL PROTECTED]> wrote:
I'm having to move some data from MySQL to Postgres. I used mysqldump
--compatible=postgresql, but the compatibility is extremely lacking.
It looks more like the person that designed the schema has payed very
little attention to the SQL standard. You
pers_id
What would like is something like:
select pers_id, random_select(odate) from t group by pers_id
Does anyone know how to do this?
Cheers, Paul
--
Paul B van den Berg, Manager InterAction database, http://www.iadb.nl
Dept of Social Pharmacy, Pharmacoepidemiology and Pharmacotherapeutics
Hello, I pinned down the problem to the order by line. If i leave this
away the query is done in 0.05 seconds.
- Mike
Mike van Hoof schreef:
Hello,
i have the following query:
SELECT DISTINCT (
Waarde
) AS bestemming
FROM xml_kenmerk
WHERE Omschrijving = 'Bestemming
Hello,
i have the following query:
SELECT DISTINCT (
Waarde
) AS bestemming
FROM xml_kenmerk
WHERE Omschrijving = 'Bestemming'
AND IF (
DatumBegin IS NOT NULL
AND DatumBegin != '-00-00', DatumBegin <= CURDATE( ) , 1 =1
)
AND IF (
DatumEind IS NOT NULL
AN
7; is an Operator and ? is a wild character. Only wildcharacters
should be follow the Operators.
Try with.
SELECT 'boer bv' REGEXP '[b|^b](!?[v$|v])';
Thanks
ViSolve DB Team
- Original Message - From: "Mike van Hoof" <[EMAIL PROTECTED]>
To: "mys
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
On 1/1/07, mos wrote:
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
>On 1/1/07, mos wrote:
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
http://tweakers.net/reviews/649/6
Has this been fixed?
As the article on the MySQL Performance B
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-
On 12/19/06, David Sparks wrote:
I noticed an interesting benchmark at tweakers.net that shows mysql not
scaling very well on hyperthreading and multicore cpus (see links at end
of email).
Does anyone know what engine they are using for their tests? (Innodb,
myisam, berkdb heheh)
InnoDB, the f
1 - 100 of 1526 matches
Mail list logo