SELECT would take a very long time

,gerbranch) ) TYPE=MyISAM; jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: How to change DATETIME format ??

you cannot use DATETIME field but CHAR,VARCHAR,TEXT but you lose the simple system of setting the date with just calling NOW(). JAri Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual

uppercase for first letter

sql,query Hi, How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed JAri Mäkelä - Before posting, please check: http

Multiple FULLTEXT searches

sql,query Hi, how one can do a FULLTEXT search from multiple tables? SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); above format works for one table but how I need to alter it for it to search multiple tables? JAri Mäkelä

many small queries or one big one

sql,query HI, which one would be best for performance, many simple queries or one complex? jari mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Changing character X to Y in a table

Hi, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? Jari Mäkelä mysql,query,select,insert - Before

changing allowed number of connections

Hi, Where one can alter the number of connections going to MySQL? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

SELECT by similarity

explanation based on two things; WHERE code=level(x) AND level(x) LIKE level(x-1) All levels are the same , starting from the beginning and each level adds more defining attributes. Simple LIKE does not work but is there some alternative functions that would allow the comparison? Jari Mäkelä

Getting the length of a field

Hi, can you count the number of characters in a field with MySQL? The length(str) function seemed like a choice tool but can it be used to get the length of data in a field or is there some other way? Jari Mäkelä - Before

using DISTINCT

Hi, Is it possible to get all data; SELECT * FROM and still get some fields filtered by DISTINCT? Jari Mäkelä database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual

Doing queries using field labels as criteria

to the found fields? jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

JOINS what is the difference in?

for JOINS? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e

MySQL crashing/stopping in ABRIASOFT's installation

: 'Project' user: 'root' host: `localhost' (Unknown error) 010904 14:20:21 Aborted connection 3 to db: 'Project' user: 'root' host: `localhost' (Unknown error) 14:20:21 Aborted connection 5 to db: 'Project' user: 'root' host: `localhost' (Unknown error) Jari Mäkelä

MySQL crashing in abria merlin server

moments. Does anyone else have similar troubles with it? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

LAST_INSERT_ID()

(0,LAST_INSERT_ID(),'text'); INSERT INTO foo3 (id2,auto2,text) VALUES(0,LAST_INSERT_ID(),'text'); or would it take the first last_insert_id() from first line and second from second line? jari mäkelä - Before posting, please

Re: LAST_INSERT_ID()

. Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

No identical entries in a field

Hi, how a field ( names of products ) of database should be defined so that you could not enter identical entries at the field? Or does one need to do the validation before inserting info? Jari Mäkelä - Before posting

database basics

Hi, was wondering as am starting a database with just some 5000 different ID entries and each entry having some 60 datafields, which would work best/faster a single table of the data or divided into separate tables? Jari Mäkelä

Database accepts only 127 records

Hi, got a problem as mysql does not allow writing but 127 entries to a database, any idea how to correct this abnormality? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

another question to continue

hi again, am not quite sure of this as Mysql is too new thing to me but apostrophes like plain 'and é in text being written in has to be dealt with somehow, is the say 0'keefe solution the proper way to do that. meaning that O\'keefe works? Jari Mäkelä

adding many entries to database

) { $p = explode(';',$line); $string[4] = substr ($p[4], 1, -1); $string[5] = substr ($p[5], 1, -1); $string[6] = substr ($p[6], 1, -1); $query = INSERT INTO names VALUES ('0','$string[4]','$string[5]','$string[5]'); $result = mysql_query ($query,$connect) or die (input error!!!); } ? Jari