Sub Query question

Hi there, I was wondering if its possible to be able to send a field from the outer table to be used as the where statement for the sub query ? something like this select somefield from table 1, (select count(*) from table2 inner join table1 using somekey where table1.key=somefield) as alias w

Simulate delete restrict on myisam

Hi there is there any possible modular way to simulate a resitrict delete on myisam tables ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

weird transaction issues

hi there, i am trying to use transactions on some innodb tables although a few things i am experiencing, on one query the value appears, i refresh the page and the value dissapears again, i am using persistant connections in php, the value is actually there in the console, what could be the prob

lock error

hi there i keep getting an error on a table Lock wait timeout exceeded; Try restarting transaction i intitally had made the update query but it wasnt committed, as it was using a myisam query function i have gone back to it with and innodb query function which starts a transaction , i have trie

check table type

hi i was wondering if there is a way to check for a table type ? ie i have an authentication class, in some situations it uses innodb and sometimes its myisam and currently its not autocomitting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

set auto commit

when is it a good time to do the set auto commit=0 , while doing the update or insert query or sometime before that in the application ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting the primary key in an update query

that works cheers >>> "Roger Baklund" <[EMAIL PROTECTED]> 09/11/03 10:48am >>> * Daniel Rossi > Hi there i was wondering if there was anyway to determine the > primary key field instead of explicitly setting it in an update > sql query ? > > f

Getting the primary key in an update query

Hi there i was wondering if there was anyway to determine the primary key field instead of explicitly setting it in an update sql query ? for instance i'd like to go update table *** where primarykey=1 instead of where id=1 as the primary key is named differentrly for each table and i'm trying t

key constraints

Hi there i am having another issue with key constraints now, i emptied the tables and made the foreign keys fine although now when i try and insert a row into the table i get this ERROR 1216: Cannot add or update a child row: a foreign key constraint fails What could be the problem ? -- MySQL

Re: Constraint Symbol

I worked out the problem, it worked if i emptied the table, what could that be all about ? >>> Daniel Rossi <[EMAIL PROTECTED]> 09/05/03 10:50am >>> What is the definition of the constraint symbol there is no example of it in the docs ? Also on a few tables i get errors

Constraint Symbol

What is the definition of the constraint symbol there is no example of it in the docs ? Also on a few tables i get errors trying to setup foreign keys ALTER TABLE departments ADD FOREIGN KEY (departmentID) REFERENCES departments_join(departmentID) ON UPDATE CASCADE this for example gives me Can

Re: PHP mysql_connect randomly failing

funny i was just having the same problemo with mysql 3.22 on php3 the most painful system to debug i hate it to bits, anyway mysql_error doesnt get returned on permission or database connection errors, i wonder if that is soughted out in mysql4 ?? maybe this is a php.net question >>> Jon Drukma

subselect doesnt work

hi there, i am trying to remove values from a list menu if the join table doesnt have keys when a key is selected for instance: locations locationID locations_join locationID shotlistID SELECT SQL_NO_CACHE l.locationID , l.location FROM locations l LEFT JOIN locations_join lj ON l.locationID =

join tables on a large database 200 meg

Hi there i am trying to work out the most efficient way to list say multiple categories of entries, the database is quite large about 200 meg. I would like to know if using join tables is more efficient than storing the keys in a varchar field then within the second loop doing a where in (1,2,3

punctuation limitation in fulltext search

Can someone please tell me if my problem with the punctuation in a fulltext search is a bug or limitation? Ultimately the users of the system i built do not want to have to try using the + search then trying the * search for all the words which will obviouslly return a lot of results, is there a

punctuation in fulltext searching

Hi i have just come across an issue where a word is not being searched up if there is any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

Re: Help with count(*)

what ever happend to a unique primary key like userID ? >>> "gord barq" <[EMAIL PROTECTED]> 08/11/03 11:15am >>> I have a table I'm using for logging purposes with a schema like: create table results ( user varchar(255) ); Where user is not a unique field and I want to find out how

major match issue

hi there i am having a major matching issue trying to import data from an old database with free text and matching the record and getting the id , ok say i have a record which is saraw i need to match it to sara winter for instance how can i do this ? -- MySQL General Mailing List For list arch

force index

sorry i worked it out put it after the table , i got some interesting results Queried The Database 1 times for 9.9892050027847 seconds +---+--+--+--+-++--+-+ | table | type | possible_keys|

example of using FORCE INDEX

hi there i dont think this will help any further on my full text searching but i would like an example of how to use FORCE INDEX , there is no example on the mysql site and the hint is misleading i am getting sql errors , lemme know thanks -- MySQL General Mailing List For list archives: http:/

use of UNION

hi there , i finally worked out union joines are supported in 4.0 i thought it was 4.1 , anyway what are possible examples of its uses ? say i'm trying to join two tables the second table has 10 rows returned with the key of the first table i would like to only get one record from the first tabl

user defined static variables in mysql

hi there i was wondering if there is anyway to setup static variables in mysql , ie to setup predefined paths in mysql . so all i can do is go select variablname as path etc .. ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

open source shema relationship diagram tool

hi there i was wondering if there was a table relationship diagram open source tool around anywhere ? i am trying to document a project at the moment please let me know thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

indexes question

hi just reading up on optimising indexes, does it matter what order u set your indexes ? The first index part should be the most used column. If you are always using many columns, you should use the column with more duplicates first to get better compression of the index. i dont really under

Re: intersting bug with full text match against

It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has length 2. If you want to search both exact matches use + operator in BOOLEAN MODE or phrase search: http://www.mysql.com/doc/en/Fulltext_Search.html ok well i'm soughting that out but how about the

Re: intersting bug with full text match against

hi sorry to got this , ok say i search for this "something1 something2" + "something3 something4" that doesnt work either is the syntax correct ? >>> Egor Egorov <[EMAIL PROTECTED]> 05/29/03 08:15pm >>> Daniel Rossi <[EMAIL PROTECTED]> wrote: &g

Re: intersting bug with full text match against

i have also noticed that the boolean default is OR how can i explicitly set it to AND like i'd like both exact matches in the search currently its exact match 1 or exact match 2 :| >>> Daniel Rossi <[EMAIL PROTECTED]> 05/29/03 01:23pm >>> i am getting people to tr

intersting bug with full text match against

i am getting people to try and break a search engine i built , when we put in the word DB into the search query i get no results even if its there in the record , why is this ? WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN BOOLEAN MODE) LIMIT 0 , 10 ; also how come this doe

useful use of transactions

hi guys , i am trying to sort out if the app i am about to build would require the use of transactions, there may be a few users simultanously entering data, but possible not updating the same data and maybe a lot of users accessing the data (search/select) , will this require some form of trans

Re: Can we make some C, Java based "Mysql App Server"

hmm a middleware product would be good , extra processing=time ? also stored procedures would be excellent , also maybe a middleware product to load balance between slave and master and delegate slaves if a master goes down is there such a thing ? >>> Nitin Nanivadekar <[EMAIL PROTECTED]> 04/0

table structure design

is there any table structure design program in a graphical layout for windows available ? i have tables and fields on paper but would like a way to be able to lay them out on a screen and show which table joins to what and what keys it uses let me know thanks -- MySQL General Mailing List For

intuitive searching in mysql4

ok so we can ingore the last message i've finally convinced that mysql 4 will be the best option for the searching, i am moving over an access database of a tape library which is 100,000 records. this is pretty massive search wise , what could be the best way to go about this , we have a title,

Re: compiling issue

woah let me get it straight , u are compiling on a RH 6 machine to be installed on a RH 7 ? why not compile and install on the same machine , i really cant say if it makesd a difference but they do have different kernels and are years apart , i've had no trouble whatsoever compiling and installi

get table name from select staement as output as field

hi guys is this possible ? select tablename1 as table1, id from tablename1 , tablename2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

get the table name from a field for 3 different tables

hi there i would like to find out how to get the table from a field if i am joining three tables together for instance select a.id, b.id, c.id from a, b, c when i get the results i need to be able to get the table name a if i get the result from a.id , is it possible ? -- MySQL General Mailin

Re: "Soon"?

ooo thats sounds like something to avoid , if the compiling doesnt even work dont go there, painful >>> "Martin Gainty" <[EMAIL PROTECTED]> 03/28/03 09:38am >>> Hej Michael- In order to to see 4.1 mysqladmin working I started to compiling the 4.1 source obtained from bitmaker Originally I had

two order by fields

hi guys is this possible ? order field1 and order by field 2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: IN and comma delimitered id's

wicked thanks heaps this worked select * from User where userID=3 AND FIND_IN_SET(34, site_access); your a champ ! >>> Don Read <[EMAIL PROTECTED]> 03/24/03 03:02pm >>> On 24-Mar-2003 Daniel Rossi wrote: > hi there i have a field which i place comma delimitered id&

IN and comma delimitered id's

hi there i have a field which i place comma delimitered id's like so 64,14,13,15 these are site id's which i check against a user who has access, i also use it to check if to show a banner on a particular site, although further checking showed that say i did a select * from table where sites_a

RE: RAND is mysql 3.22

hi guys i just tried this on my works old mysql server and it doesnt seem to work , is it possible ? :| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

RE: date issue

tableName WHERE DATE_FORMAT(columnName, '%M') = 'January'; Regards, Victor Pendleton -----Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 6:59 AM To: Daniel Rossi; [EMAIL PROTECTED] Subject: Re: date issu

Re: date issue

ou can do a range of months, though you could use the IN clause with the WHERE clause. - Original Message - From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> To: "Daniel Rossi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 03,

date issue

hi there i am having an issue formatting a date string back to mysql for a query, say i have a month string January from a get query string like so ?month=January , and i need to check a range of results within an endate so i need WHERE end_date > $_GET['month'] , how can i format the month stri