On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard,
wrote:
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Please note that PostgreSQL provides a gateway to other databases thanks to
the DBI-Link extension, as well as it support more than
I want to execute three sql statements in single query which will perform
following task...
1. select a particular row
2. insert that row to another table
3. delete that row from 1st table
in short, i want to move one row from table 1 to table 2 with single query..
thanks in advance for any
Hi Brent, Lars, all !
While I cannot offer a solution, I still know the replace() approach
is incorrect:
Brent Baisley wrote:
The only regular expression MySQL support return a true/false if the
expression was found. I had to do something similar to what you want to
do. Although I needed
not to forget that there can also be street adresses like foobarstreet 23-25
or foobarstreet 17b and so on ... so i
guess i'll have to split my addresses into 2 fields from now on (street and
number). anyway thanks for ideas and
replies! best: lars
On 7/27/07, Joerg Bruehe [EMAIL PROTECTED]
Hi All,
I have just released version 0.5 of the BLOB streaming engine for MySQL.
This version includes all the basic functionality required to stream
BLOB data in and out of MySQL tables.
The main features are:
- Uploading of BLOB data directly into the database using HTTP PUT or
GET
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 partitioned
So far as I know, the only way to accomplish what you want is to do what you
tried: put the Boolean match in the WHERE clause and order by a natural
match. That's what I do on our web site.
By the way, you can't use prefix stemming: *abcd is the same as abcd.
Regards,
Jerry Schwartz
The
Since my original post has been hijacked I'm writing a new one with
maybe some more info.
I have downloaded the GNU TAR source code. I'm using gcc 3.0.2 and GNU
make 3.76.1
I have configure as follows
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
if you are using MySQL 5 you could use a stored procedure
On 7/27/07, Samrat Kar [EMAIL PROTECTED] wrote:
I want to execute three sql statements in single query which will perform
following task...
1. select a particular row
2. insert that row to another table
3. delete that row from 1st
Jochem,
Yeah, I'm aware of partition pruning - and would be partitioning in such a
way to ensure there is a small partition to be scanned/inserted to when
required.
I'm aware of timezone issues and we just use unix timestamps so there are no
problems here.
I'll look closer into MySQL's
I am trying to design tables to track if a given user has viewed a
change/addition or not.
The basic layout of the database presently is:
DocumentTable
DocID,FileName,Description,Cost,etc...
ChangeTable
ChangeID,Date,UserID,DocID,ChangeDescription
By looking in the ChangeTable I can tell what
11 matches
Mail list logo