| |
thread by: none |
last post Apr 24 '06 by: Michael Austin
I am trying to optimize a search engine.
let's say I have 3 tables. one has titles, one has words, and an index
where each title is broken into words (title_id and word_id)
I want to be able to search terms in any order, so "potter harry" is
the same as "harry potter".
select t.name from titles t, words w, index i where (w.name in
|
thread by: gxj |
last post Apr 24 '06 by: gxj
aaaaaaaaaaaaaaaaaaaa
|
thread by: service |
last post Apr 23 '06 by: service
This is a multi-part message in MIME format
--siNt1NhCoyB3mEPydjXJyOTcg=_X6kQe0H0
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
- This mail is a HTML mail. Not all elements could be shown in plain =
text mode. -
|
thread by: umangjaipuria |
last post Apr 23 '06 by: umangjaipuria
I have two job queues doing complimentary work and writing their output
once a minute into a file. The files for each minute have to processed
in pairs - one from the first job queue and one from the second and the
results are merged and delivered to the final client. The filename and
other details of these files go in to a MySQL database - a...
|
thread by: saifmsg |
last post Apr 23 '06 by: Bill Karwin
Hello everyone,
I am using a custom php class where i have wrapped all the mysql
connection settings and query functions. Instead of calling direct
mysql functions i creat an instance of this class and than use the
custon functions for query, connection etc. At some places i also use
direct php mysql functions to connect and query.
My...
|
thread by: jullietta.jung |
last post Apr 23 '06 by: Bill Karwin
HI,
I have a Questionnaire table that has a column "SchoolId"(int).
I want to return the questionnaire table with the name of the school
rather than the SchoolId (schoolid and schoolName are stored in another
table).
Hope this makes sense.
Thanks
Jules
|
thread by: John Small |
last post Apr 22 '06 by: guzguz
Hi,
I'm using MySQL on Windows and I hit a limit somewhere
between 1300 and 1500 columns in a table. (There is
a good reason why I need that many columns - so please
bear with me.)
Is there any way to allow a table to have perhaps 2,000 to 5,000
columns without going to blob fields where I have to manage
the columns.
|
| |
thread by: kleinhans |
last post Apr 22 '06 by: kleinhans
Hi netters,
I am used in MYSQL + PHP. Sometimes POSTGRESQL + PYTHON/ZOPE was used.
Now I have to build a bibliography system that stores a lot of
XML-Files and I am not quite sure wether it is a good idea to stick to
the good old sql-databases and go ahead with the same old techniques I
am using all the time.
Well, let's see what's...
|
thread by: Matt |
last post Apr 22 '06 by: Jeff North
Stop me if you've heard this one...
I want to create a "data dictionary" table of all my user tables in a
certain database. The data dictionary (my version) will contain
columns such as "TableName", "ColumnName", "DataType", "DataLength",
etc, etc. I know this information is available in the MySQL engine
tables, I just don't know where to...
|
thread by: Jim Hubbard |
last post Apr 21 '06 by: Gordon Burditt
I have a client that desires a new application for use at several stores in
different cities. He wants "real time" access to all store data and the
ability to continue to run locally even if the internet connection goes
down.
It occurs to me that a local MySQL instance should definitely be
in each store to continue work if the net is down...
|
thread by: Juan Antonio Villa |
last post Apr 21 '06 by: Gordon Burditt
Hello, I'm having a problem replicating a simple database using the binary
log replication, here is the problem:
When the master sends an update to the slave, an example update reads as
follows:
UPDATE MainInfo SET dAddress='38 Holland Blvd', dCity='miami',
dState='FL', dZip='33000', dCountry='USA', dPhone='999987565',...
|
thread by: Joel |
last post Apr 21 '06 by: Bill Karwin
Hi,
I transferred a VB6 application using MySql 3.51 Drver From Windows 98
platform to XP. I downloaded MySql 3.51 set up the ODBC driver connection
(User DSN). The VB6 application runs great however, when I update a record
(.Update) I receive run-time error -2147217864...row cannot be located for
updating etc. What am I doing wrong?
|
thread by: macbrando |
last post Apr 21 '06 by: macbrando
I installed version 5.0.19 for OS X 10.4. In the documentation, it says
it runs the mysql_install_db script for you. I started the server and
ran the test it told me (mysqlshow mysql) and it gives me an error. So,
I just do (mysqlshow) and it's missing the mysql database! The only two
databases I see are information_schema and test. So i...
|
thread by: trihanhcie |
last post Apr 21 '06 by: trihanhcie
Hi,
Well the following query is not the one i will use but it's the same
prob :
SELECT sum(country_id ) , count( country_id )
FROM Tbl_Country, Tbl_config
WHERE country_id =1
Well ...the result should be sum(country_id )= 1 et count( country_id
|
thread by: kai.hendry |
last post Apr 21 '06 by: kai.hendry
I posted to Mysql forums without much luck:
http://forums.mysql.com/read.php?10,83774,83774#msg-83774
I just wondering if there is a recommend table design for dealing with
time series data?
Best wishes,
|
| |
thread by: wesley |
last post Apr 20 '06 by: Bill Karwin
Is there a way to take an entire row from a table and convert it to an
output string? I want to use the string and append it to a text file.
Thanks Wes
|
thread by: awebguynow |
last post Apr 20 '06 by: Bill Karwin
I've seen the syntax in the J. Stephens/C. Russell book and believe the
"alter table" would be:
ALTER TABLE tbl
FOREIGN KEY (column_list)
REFERENCES tbl_name (column_list)
the Syntax is really not a problem, and I'm pretty sure I won't be
violating any FK contraints right off the bat. If so, I expect the
|
thread by: Fred S |
last post Apr 20 '06 by: Bill Karwin
Hi,
I am working on a database of time series, where the main table looks
like this
date | id | value
but i have something like several thousands of id's and several
thousands of dates as well
my goal is to obtain
date in the format of a matrix with the rows being the dates and each
column contains the values for a certain ID.
Now...
|
thread by: clops |
last post Apr 20 '06 by: clops
Dear Collegues,
can anyone explain me WHY the following set of instructions does not
spit any errors (MySQL 5.017) -- the second insert should not have
worked as it references a non-existing record!
mysql> CREATE TABLE struct(
-> node_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
-> parent_node_id INT UNSIGNED REFERENCES...
|
thread by: wesley |
last post Apr 20 '06 by: wesley
Is there a way to take an entire row from a table and convert it to an
output string? I want to use the string and append it to a text file.
Thanks Wes
|
thread by: Dave Mennenoh |
last post Apr 19 '06 by: Bill Karwin
I am potentially building a music listening site and want the users to be
able to place songs into their favorites list. Easy enough, stick the id of
the song, from the songs table, into the users favorites. From this however,
how would I go about selecting the songs that are most in peoples
favorites - ie top favorites?
--
Dave -
Adobe...
|
thread by: Thegate |
last post Apr 18 '06 by: Thegate
Hola a todos:
Me gustaria saber si hay alguna manera de expandir una variable.
Ejemplo;
Drop table if exists myDatabase.Text;
create table myDatabase.Text (
emp char(3) not null default '',
Nom varchar(30) not null default '' ) engine myisam;
insert into myDatabase.Text (emp, nom) select emp, nom from
|
thread by: GSP |
last post Apr 18 '06 by: onedbguru
Using SQLyog 5.02 into MySQL server 5.0. Have built table structures and am
trying to import data from CSV. I get a rather non-descript dialog box
saying only "Error while importing data".
Does anyone have any suggestions on how to better accomplish this import or
how this error could be deciphered?
Steve
|
| |
thread by: taras.di |
last post Apr 18 '06 by: taras.di
Hi everyone,
I've come across an extremely strange problem. The exact same query in
both mysql command line client, and mysql query browser gives entirely
different results. I was hoping someone out there could shed some
light.
Ok, the query (I've stripped it bare, the real query is a bit more
complex)...
|
thread by: David Smithz |
last post Apr 17 '06 by: onedbguru
Hi,
If you run a query which has a WHERE statement in which has a few
possibilities separated OR statements, e.g.
Select * from table where (Afield = 2) OR (Bfield = 2) OR (Cfield = 2)
In the returned results is it possible to know what particular part of the
WHERE clause a field matched.
|