MySQL Database Forum

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

aaaaaaaaaaaaaaaaaaaa

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. -

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...

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...

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

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.

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...

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...

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...

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',...

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?

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...

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

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,

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

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

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...

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...

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

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...

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

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

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)...

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.