Making fulltext is very slow!!

Hi I have a Huge amounts of data imported into mysql. My database has about 1,500,000 rows.each row has a text field with approx 70 words in it!.Size of my .MYD is 1013MB mysql has been starting to make fulltext index on text field since 55 hours ago!!! and now it dose not accomplish this jo

Making fulltext is very slow

Hi I have a Huge amounts of data imported into mysql. My database has about 1,500,000 rows.each row has a text field with approx 70 words in it!.Size of my .MYD is 1013MB mysql has been starting to make fulltext index on text field since 55 hours ago!!! and now it dose not accomplish this job

RE: Left join?

Hi, I have a similar problem (with phones & calls) but I would like to select only those elements that have less than a number. Using the previous example, is like selecting only those interest elements that have less that 5 members associated. Something like this (obviously this doesn't work)

problem about MYSQL reserve characters

Hi, everyone, I want to export mysql record into txt file. But some mysql reserved characters such as '&', '>' and '<' can't be export. They are replaced with '&', '<', and '>'. How do I fix it. Best Regards, Liu Qianghua -Original Message- From: Michal Dvoracek [mailto:[EMAIL PROT

Re: Can't open file

Liu, Wednesday, June 05, 2002, 5:59:53 AM, you wrote: LQq> I am making use of mySQL to provide my client a solution. However, one of tables often crash and produces the folloing error message when I try to use the table in a query: LQq> mysql> select * from action; LQq> error 1016: Can't open

Re: Re: /tmp/mysql.sock problem

adam, Tuesday, June 04, 2002, 7:55:23 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D >>> >> >> a> Thanks. However, something's still wrong. >> >> a> Restarted the daemon

Re: installation problem

mandar, Wednesday, June 05, 2002, 8:49:42 AM, you wrote: mmp> I have R.H Linux 7.2 and i have installed mysql mmp> MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how mmp> should i proceed?how to start the database and afterinstallation mmp> where r the folders/files created? mmp

How to convert non latin characters?

Hii there, I have a table containing cities of the world. Now I am running into problems because people are starting to complain that some mayor cities are not in the db like Tokyo. After checking my table I discovered that there lots of cities are written with some non latin characters. Tokyo i

Strange problem with Left join and order request

Hi, i've got a really strange problem with a request using multiple left join and order by : Here is the first sql query : i display two columns of my table CV and one column of table ANNOTATION_CV SELECT ID_CV, TITRECV,ANNOTATION_CV.ANNOTATION_CV FROM CV LEFT JOIN CV_POSE ON CV_POSE.FK_CV=CV.ID

A column of the SELECT-part of a query returns allways NULL in some cases.

>Description: A column of the SELECT-part of a query returns allways NULL in some cases. This seems to happen when using a "GROUP BY" and computing on some parts of the SELECT. >How-To-Repeat: create table users_table (id integer primary key not null auto_increment, gender varcha

Load Local Infile

USING LOAD LOCAL INFILE Have a database file 15000± records however only approximately 8300 will load in from the file. I found some of the records that did not load in and they appear to be ok. So I emptied the loaded fields and tried to just load approximately 180 records that did not load

InnoDB table design Q

When you have a table with both numeric and variable-length text data, and you need to update the numeric part a lot, it made sense in MyISAM to split the numeric from the textpart. (Because working on fixed-length tables is so much faster.) Say... Original: Table 1: id1, id2, articletext MyIS

Problem when inserting a record - auto_increment field gets max integer value instead of next id

Hi, I have a database with the following table and data: When I add a new record the auto_increment number becomes '2147483647' not sure why? Checked the SHOW TABLE STATUS too and this shows that the next auto_increment number will be '2147483647' anyone know why? Running MySQL 3.23.41 Regard

System Table

Hi List I am just wondering is there a sysusers / systables table in mySQL (like SQL Server). I am creating an multi user script whereby users will be able to create their own db on a linux box, but I will be only allowing one database per user. I would like to do a lookup on a system table if

Re: How to convert non latin characters?

No ð is not Japanese letter. It is Iclandic letter with ISO 8859-1 0xf0 or 240. Jon Ingason "andy"

Re: Problem when inserting a record - auto_increment field gets max integer value instead of next id

Bobby, On Wed, Jun 05, 2002 at 12:30:17PM +0200, Bobby Oswald wrote: > I have a database with the following table and data: > > When I add a new record the auto_increment number becomes '2147483647' > not sure why? Checked the SHOW TABLE STATUS too and this shows that the > next auto_increment n

Decode to Case

Hi All I am currently in the process of converting our database from Oracle to MySql. I Use 3.23.50 Max on Win 2k Well..here's a query where we use decode function in oracle...How do i change it to MYSQL The Query is -

RE: Problem when inserting a record - auto_increment field gets max integer value instead of next id

Removed all the negative values and the same problem still occurs > -Original Message- > From: Fred van Engen [mailto:[EMAIL PROTECTED]] > Sent: 05 June 2002 12:50 > To: [EMAIL PROTECTED] > Subject: Re: Problem when inserting a record - auto_increment > field gets max integer value inst

Re: Bug related to large tables and it's indexes on Win2k

- Original Message - From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Jared Richardson" <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 5:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k | On 4 Jun 2002, at 15:43, Jared Richardson wrote: |

mysql-4.0.1-alpha (Official MySQL RPM) installtion problem

From: ymalik To: [EMAIL PROTECTED] Subject: [Installation ] >Description: mysql-4.0.1-alpha (Official MySQL RPM) installtion problem >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email su

Re: Problem when inserting a record - auto_increment field gets max integer value instead of next id

Bobby, On Wed, Jun 05, 2002 at 01:49:50PM +0200, Bobby Oswald wrote: > Removed all the negative values and the same problem still occurs > Did you re-create the table with the queries that were shown in your first mail (except the negative values of course)? MyISAM tables remember their latest

ÓòÃûÖ÷»úÈ«¹ú×îµ×¼Û

ÄúºÃ£¬ºÜðζµÄ¸øÄãÀ´ÐÅ¡£Ï£ÍûÎÒµÄÀ´ÐÅ»á¸øÄú´øÀ´·½±ã¡£ רҵµÄÓòÃûÖ÷»ú·þÎñÉÌΪÄúÌṩ³¬µÍ¼Û£¬¸ßËÙ£¬°²È«£¬Îȶ¨µÄÖ÷»ú·þÎñ¡£ 30MÖ÷»úÖ»Ðè198Ôª¡£ »¹Ë͹ú¼ÊÓòÃû¼°ÓÊÏä¡£ ¹¦ÄÜ£ºÖ§³ÖCGI PHP MYSQL SQL£¬ACCESS ASP 50M ¡¢100M ¡¢200M ÏêÇéÇë¿´£ºhttp://www.raeline.net È«¹ú×îµÍ¼ÛµÄ´úÀí¼Û¸ñ¡£×ÉѯQQ£º16559573

RE: Left join?

Try this. SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, i.name FROM member_interests AS mi left join outer interests AS i on mi.interest_id = i.id GROUP BY mi.interest_id HAVING count < 5 ORDER BY i.name =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.cale

RE: Decode to Case

Try a function called coaleace It will return the non null value. But i dont have the exact syntax with me nor the manual. Hope it helps Tommy -Original Message- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Wed, 05 Jun 2002 13:26 To: MySQL Subject: Decode to Case Hi All I am curre

RE: System Table

Not like they exist in MS SQL. However, take a look at the mysql database. My guess is that you can infer the information you want from the permissions granted. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Niall Merrigan

RE: Problem when inserting a record - auto_increment field gets max integer value instead of next id

Cool, no negatives reset the key and it works, thanks, > -Original Message- > From: Bobby Oswald > Sent: 05 June 2002 13:50 > To: Fred van Engen; [EMAIL PROTECTED] > Subject: RE: Problem when inserting a record - auto_increment > field gets max integer value instead of next id > > > R

Re: System Table

Take a look at the 'mysql' database; the relevant tables are 'user' and 'ub'. See: http://www.mysql.com/doc/P/r/Privileges.html And http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.html If your naming scheme is to nam

Re: How to get data from MySQL with perl

Here's an example: - #! /usr/bin/perl use Mysql; $dbh = Mysql->connect("localhost", "verycooldatabase", "", ""); $query = "select this from that"; $sth = $dbh->query($query); // returns one row at the time in array @arr while(@arr = $sth->fetchrow) { foreach $data (@arr) print(

Re: Decode to Case

Hi Tommy My Requirement is not to select a non null value ...I need to select the companyid and if the companyid is null i need to select the userid from user table and if the companyid is not null , there may be many users for the company and i need to select the user i need (where user_type = 2

Re: processlist

You can also tail -f the logfile of mysqld... >> tail -f /var/log/mysqld.log ...or something like that... Eivind - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://list

setting up two instances of mySQL

I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't

Re: Is it possible to have MySQL perform an action at a specifictime?

Hummm..one solution is just to exploit the 'at' program of unix/linux systems... I use that for backups, table dumps etc. combined with perl or php scripts... $0.02; Eivind - Before posting, please check: http:/

RE: setting up two instances of mySQL

The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data. The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer

Re: Problem when inserting a record - auto_increment field gets max integer value instead of next id

Bobby, Wednesday, June 05, 2002, 1:30:17 PM, you wrote: BO> I have a database with the following table and data: BO> When I add a new record the auto_increment number becomes '2147483647' BO> not sure why? Checked the SHOW TABLE STATUS too and this shows that the BO> next auto_increment number w

Re: setting up two instances of mySQL

Chris, Wednesday, June 05, 2002, 3:55:52 PM, you wrote: CS> I have one product already using a mySQL database. We just inherited a new CS> product (via an acquisition) that uses it's own mySQL database which we're CS> going to stick on the same server. My manager wants me to setup a second CS>

Re: System Table

Niall, Wednesday, June 05, 2002, 1:53:59 PM, you wrote: NM> I am just wondering is there a sysusers / systables table in mySQL (like NM> SQL Server). NM> I am creating an multi user script whereby users will be able to create NM> their own db on a linux box, but I will be only allowing one data

Failover possiblity

Hi, (mysql 3.23.49, debian linux 2.4.18) I am looking at running a program called keepalived so I can monitor the availability of my mysql server. Data is stored on a NetApp filers so its readily available to multiple machines. What I'd like to do is use keepalived to failover to a secondary

Re: Failover possiblity

At 09:15 2002-06-05, Ramon Kagan wrote: >Hi, > >(mysql 3.23.49, debian linux 2.4.18) > >I am looking at running a program called keepalived so I can monitor >the availability of my mysql server. Data is stored on a NetApp filers so >its readily available to multiple machines. What I'd like to d

\T Question!!!

Hello, IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form. Can anyone tell me if you can export the query in another formatTab delimited,cvs etc. Any hel

Re: Bug related to large tables and it's indexes on Win2k

On 5 Jun 2002, at 7:50, Jared Richardson wrote: > This table is part of a product that contains publicly available (and > always expanding) publicly avilable biological data in addition to > large companies internal data. A one terrabyte cap very well could > come back to haunt us one day! (sadl

mysqlhotcopy regexp problem with 640 and more Databases

Description: When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and having 640 or more Databases produces the following error: DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not found (Errcode: 24) at ./bin/mysqlhotcopy line 432. The file exists

\T QUESTION

Hello, IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form. Can anyone tell me if you can export the query in another formatTab delimited,cvs etc. Any hel

Re: mysqlhotcopy regexp problem with 640 and more Databases

In the last episode (Jun 05), Pabst Simon said: > Description: > > When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and > having 640 or more Databases produces the following error: > > DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not >found (

RE: \T QUESTION

[snip] IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form. Can anyone tell me if you can export the query in another formatTab delimited,cvs etc. [/snip] f

doc archive?

Is there an archive of the MySQL doc? The doc at mysql.com is for v 4.0 alpha and I'd like to get the doc for v 2.23.49 which I just downloaded. (As a new user I'd like to be able to RTFM before bugging the list with dumb questions. I'll still probably ask dumb questions, but at least I'll have ma

Re: setting up two instances of mySQL

- Original Message - From: "Chris Stefanick" <[EMAIL PROTECTED]> To: "MySQL Support" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 2:55 PM Subject: setting up two instances of mySQL > I have one product already using a mySQL database. We just inherited a > new > product (via an acqui

OUTFILE

Hi, Is there a way to designate which folder on the server the OUTFILE ends up in? Will it accept a full path in the file name? Mysql;mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming.

adel 23 : compilation and link problem

I am using mysql++1.7.9. i have installed and configured mysql++ but , i don't succeed even to compile the examples given with the api. please , try to help me. How can i find dependicies. how can I link .. thaks all - B

Re: Is it possible to have MySQL perform an action at a specifictime?

- Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 8:48 PM Subject: RE: Is it possible to have MySQL perform an action at a specific time? > Sounds like you need to run a CRON job (you will have to know if your > specific im

Maximum JOINED tables

I have searched the manual without success. I want to know the maximum number of tables MySQL permits to be JOINed in a single SELECT statement. TIA, Arthur - Before posting, please check: http://www.mysql.com/manual.php (

RE: Maximum JOINED tables

32. -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 9:48 AM To: mysql mailing list Subject: Maximum JOINED tables I have searched the manual without success. I want to know the maximum number of tables MySQL permits to be JOINed in a sing

multiple where's

I am new to MySQL and SQL in general. I was wondering how to narrow down a search. I wanted to do something like select * from table where x, y, z; but this doesn't work. Can someone help me? - Before posting, please check:

RE: Maximum JOINED tables

Would have been a little spooky if were '42'! :) Andrew Hazen -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 11:51 AM To: 'Arthur Fuller'; mysql mailing list Subject: RE: Maximum JOINED tables 32. -Original Message- From: Arthur

Re: adel 23 : compilation and link problem on linux

adelpfe wrote: > I am using mysql++1.7.9. > i have installed and configured mysql++ > but , i don't succeed even to compile the examples given with the api. > please , try to help me. > How can i find dependicies. > how can I link > .. > thaks all > ---

RE: Maximum JOINED tables

Yup, it'd be the answer to everything. :>) -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 10:00 AM To: Weaver, Walt; 'Arthur Fuller'; 'mysql mailing list' Subject: RE: Maximum JOINED tables Would have been a little spooky if were '42'!

RE: Left join?

I have a reply for both Cal and Javier, Cal, I have a hunch the JOIN is backward for you. > SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, >i.name > FROM member_interests AS mi left join outer interests AS i on > mi.interest_id = i.id > GROUP BY mi.interest_id > ORDER BY i.name

Re: Maximum JOINED tables

* Arthur Fuller > I have searched the manual without success. I want to know the maximum > number of tables MySQL permits to be JOINed in a single SELECT statement. According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39. http://www.mysql.com/information/crash-me.php > -- Roger --

RE: OUTFILE

[snip] Is there a way to designate which folder on the server the OUTFILE ends up in? Will it accept a full path in the file name? [/snip] yep, even something like "/somefolder/someotherfolder/somefile.foo" HTH! Jay mysql, sql, query "It's hip to snip!" -

RE: multiple where's

[snip] I am new to MySQL and SQL in general. I was wondering how to narrow down a search. I wanted to do something like select * from table where x, y, z; but this doesn't work. Can someone help me? [/snip] select * from table where x and y and z HTH! Jay "It's hip to snip!" ---

RE: OUTFILE

As far as I can tell it works from root (Linux, BSD) but may not be the case for all distros. Do a quick test and you will be able to find out. HTH! Jay mysql, query, sql Always reply to the list, so that others may participate in the discussion. ---

RE: Maximum JOINED tables

Hmmm... we're running 3.23.47 here and have run into a 32 table join limit... --Walt -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 10:19 AM To: mysql mailing list Cc: Arthur Fuller Subject: Re: Maximum JOINED tables * Arthur Fuller > I

More normalization

Here's a design question similar to the current threads on normalization issues. Suppose I have three types of contact information I want to keep track of: Postal address, phone, and email. The design is that any given entity that has contacts info associated may have zero or more of each. I al

Re: doc archive?

I believe the docs for whatever version you downloaded are included in the full source distribution; they are at the top level of the source tree: manual_toc.html manual.html manual.txt But yes, it would be nice for the docs in various formats for previous - or at leas

Re: doc archive?

Gary, Wednesday, June 05, 2002, 6:05:08 PM, you wrote: GD> Is there an archive of the MySQL doc? The doc at mysql.com is GD> for v 4.0 alpha and I'd like to get the doc for v 2.23.49 GD> which I just downloaded. (As a new user I'd like to be able GD> to RTFM before bugging the list with dumb ques

Re: multiple where's

Chris, Wednesday, June 05, 2002, 6:51:16 PM, you wrote: CH> I am new to MySQL and SQL in general. CH> I was wondering how to narrow down a CH> search. I wanted to do something CH> like CH> select * from table where x, y, z; You can use AND and OR in WHERE clause, f.e. SELECT * FROM table WHE

UPDATE problems

Hello, I'm new to the mailing list. I have a simple table: tbl keyint, primary key, auto increment valint I've inserted several dummy values so that my table looks like this: key val 150 2100 3150 4200 I can successfully run this query: UPDATE tbl SET val = va

Re: doc archive?

Thanks Egor (and the others who responded). I don't normally install unfamiliar software without first at least skimming the doc. Once I ran the install it unpacked the doc directory. See, first dumb question. 8-) --Gary Egor Egorov wrote: > > Gary, > Wednesday, June 05, 2002, 6:05:08 PM, you

RE: UPDATE problems

[snip] tbl keyint, primary key, auto increment valint I've inserted several dummy values so that my table looks like this: key val 150 2100 3150 4200 I can successfully run this query: UPDATE tbl SET val = val + 1 but THIS query fails: UPDATE tbl SET val = val

enumerated type and indexing

Hello all, I have a table that has a column named foo. It is enumerated with values ("Excellent","Good","Fair","Poor") and is indexed. The table has a few million records in it. I recently did a select query where I mistakenly typed "where foo='Goo'" instead of 'Good'. This query took quite

Looking for some help

I am running MySQL 3.23 on WIN 2k server and would like to create a daily scheduled task that will utilize mysqlhotcopy (or other back up method) to back up my db. I understand that I need to create a .BAT file that contains the command to run hotcopy but I'm a bit confused as to the syntax. What

how do I get off this list?

I'm really sorry to send this to the whole list, but I've tried every conceivable thing I can think of, over the last week, and none of it works. I promise this will be my only broadcast message, regardless of what happens next (so you don't need to flame about it!) specifically, I've tried:

Re: Maximum JOINED tables

And how long does it take to compile a 32-tables-statement? With the gupta server a 14-tables-statement took 2 hours. Sabine "Weaver, Walt" wrote: > > Hmmm... we're running 3.23.47 here and have run into a 32 table join > limit... > > --Walt > > -Original Message- > From: Roger Baklun

RE: UPDATE problems

> Isn't 'key' a reserved word? Yeah... *slaps forhead* That's why I "always" use 'id' as my key column name and "always" quote my column names. Thanks for the quick response! nik ( sql query ) - Before posting, please che

mysql & mysqld cannot communicate (error 2003)

Problem: mysql & mysqld cannot communicate (error 2003) Synopsis: (a) I installed mysql on a Unix SunOS system, but the post-installation died silently in mysql_install_db. There were no diagnostic messages. Trial-and-error indicated that mysql_install-db has a bug (a missing '&'). When this

SunOS binary: compiled with pthreads or not?

Does anyone know whether this binary distribution was compiled with pthreads or not? mysql-3_22_30-sun-sunos4_1_4-sparc_tar.gz Or: does anyone know how one can find out? Thanks Peter Lloyd --- mysqlbug form --- From: Peter Lloyd <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Error 2003: m

Re: Maximum JOINED tables

In the last episode (Jun 05), Sabine Richter said: > "Weaver, Walt" wrote: > > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > > * Arthur Fuller > > > I have searched the manual without success. I want to know the > > > maximum number of tables MySQL permits to be JOINed in a single > > > SELECT

help with empty set

using PHP what is the value for a returned result from MySQL of "empty set" ex: if($result != NULL){ do this } else{ do that } but NULL is not right. what should I replace NULL with? - Before posting, please

Slave logs, and defaults

Hi, I had an odd thing happen yesterday. I had replication running, the master being on a server farm, the slave being in our office. I tested it early in the morning by creating a table on the master, it showed up on the slave right away. Of course as soon(a few hours later) as I went to sho

Re: Maximum JOINED tables

* Arthur Fuller > > I have searched the manual without success. I want to know the maximum > > number of tables MySQL permits to be JOINed in a single SELECT > > statement. * Roger Baklund > According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39. > > http://www.mysql.com/information/crash-me

Re: how do I get off this list?

Have you tried the link at the bottom of every message from the list? Chuck At 10:22 AM 6/5/2002 -0700, Bob Purvy wrote: >I'm really sorry to send this to the whole list, but I've tried every >conceivable thing I can think of, over the last week, and none of it >works. I promise this will b

Re: how do I get off this list?

I looked at the same message you got and at the bottom it says to try this address: [EMAIL PROTECTED] So perhaps eliminating the "digest" part in your address will work. Also, you have to do it from the same email account that you signed up with but you probably did that. >>> Bob Purvy <[EMAIL

Re: help with empty set

have u tried with \0 ?? - Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 1:54 PM Subject: help with empty set > using PHP what is the value for a returned result from MySQL of "empty > set" > ex: > > if($result != NULL)

WHERE-ing an alias...

Ah, after I write my SQL SELECT query I discover that you can't use WHERE with an alias. Here's what I'm trying to do: SELECT posterdata.*, IF (aptitle LIKE 'The %',SUBSTRING(aptitle,5), IF (aptitle LIKE 'A %',SUBSTRING(aptitle,3),IF (aptitle LIKE 'An %',SUBSTRING(aptitle,4),aptitle))) AS sort_t

Re: help with empty set

yeah that kinda works... what i have is $result = mysql($database "select x, y, z from $table where a and b and c;", $link); if ($result == empty set){ $z = NULL; } else $x = mysql_result($result, 0, "x"); $y= mysql_result($result, 0, "y"); $z = mysql_result($res

Re: Replication speed?

Hi all, Does anyone have any numbers on the speed of MySql replication? I am concerned with the transfer of up to 10 gigabytes to a master db... what state are the slaves in during the replication catch up time? Is the delay primarily related to the network bandwidth? I am assuming that all t

Attn: MySQL AB: we need 3.23.5x NOW !

If any folks from MySQL AB are reading this: I need to go into production *today* with 3.23.5x. I am using InnoDB heavily (and need the newer fixes). 3.23.50 hasn't even been released yet (the pre-release version is not "stable") and based on posts on this list, we know that there are several bu

More Query Help

First off, I would like to thank everyone on this lists who helps people like myself! I'm having trouble with the following query: SELECT username, first_name, email, DATE_FORMAT(signup_date, '%b %e, %Y') AS signup_date FROM members WHERE referer = (id) It selects a list of all members from the

Max Number of Rows

> Hi All, > > I need to know how many rows are supported in mysql db. > > Thanks, > Pooja. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: help with empty set

- Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 2:26 PM Subject: Re: help with empty set > yeah that kinda works... > > what i have is > > $result = mysql($database "select x, y,

More Query Help [more info]

I probably did not provide enough info the first time. The members table is setup as follows: Id (primary key) Referer (relates to the primary key of the table) I am given a member ID, say 4. I need to display all members who have been referred by member 4 (obviously no problem). However, for ea

RE: Looking for some help

No, a batch file and the task scheduler are the best way to do it. As to the syntax I've not used mysqlhotcopy but most of the mysql programs will display help if you enter no parameters to invalid parameters. (or the parameter --help) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * h

RE: Left join?

You could be correct, but I don't think so. The question was count the members and give me the description. Just by reading it, I don't think your query will answer that question. I would however drop the distinct because the group by will do that for you. > SELECT mi.interest_id, COUNT(*) AS c

RE: WHERE-ing an alias...

[snip] SELECT posterdata.*, IF (aptitle LIKE 'The %',SUBSTRING(aptitle,5),IF (aptitle LIKE 'A %',SUBSTRING(aptitle,3),IF (aptitle LIKE 'An %',SUBSTRING(aptitle,4),aptitle))) AS sort_title FROM posterdata WHERE ap_type='Original Movie Poster' AND sort_title LIKE 'G%' ORDER BY sort_title ASC As per

still not-empty set

thanks for all the replies!! but it is not working. here is the loop: if($result == EMPTY SET){ $Scheduled = NULL; } else{ $Tech = mysql_result($result, 0, "tech"); $SNumber = mysql_result($result, 0, "snumber"); $Scheduled = mysql_result($result, 0, "scheduled");

Re: Max Number of Rows

In the last episode (Jun 05), Pooja Daryani said: > > > > Hi All, > > > > I need to know how many rows are supported in mysql db. If there is a limit, it's probably 4294967296 rows. But you'll never get that many in a table anyway. -- Dan Nelson [EMAIL PROTECTED] --

RE: Left join?

I'd correct my post to recommend: SELECT i.interest_id, COUNT(mi.interest_id) AS count, i.name FROM interests AS i left join member_interests AS mi on i.interest_id = mi.interest_id GROUP BY i.interest_id, i.name ORDER BY i.name My original group-by was wrong, as I was referring

Re: WHERE-ing an alias...

On 5 Jun 2002, at 14:30, Ian M. Evans wrote: > As per previous suggestions, I use sort_title so that film titles like > "The Godfather" get sorted as "Godfather". In the above select I was > trying to narrow the search down so I could grab all the films that > started with 'G' but still using the

Is it possibile to have something similar?

Hi. I need to have a cardinal number near each data, when I submit a query: for example, if my table is: +-+ | example | +-+ | cat | | dog | | horse | I'd like to have, with a "select" statement.. +-+---+ | example |

Can I connect to a MySQL Database on a unix platform from a PC?

As a potential MySQL customer, I am trying to find the answer to the question "Can I connect to a MySQL Database on a unix platform from a PC through TCP/IP network? If the answer is yes, what other additional supporting software will be needed on the Unix platform and on the PC? Any pointers,

Re: Can I connect to a MySQL Database on a unix platform from a PC?

In the last episode (Jun 05), Liqiang Feng said: > As a potential MySQL customer, I am trying to find the answer to the > question "Can I connect to a MySQL Database on a unix platform from a PC > through TCP/IP network? If the answer is yes, what other additional > supporting software will be

  1   2   >