many examples for all queries.
- Nessi -
At 05:47 27/07/01 , you wrote:
>I am having trouble setting a column attribute to not null. Below is the
>statement I am using:
>
>create table table_name (
> Column_Name not null
>);
>
>If this is not the correct way to do it,
I think you are looking for something like:
create table namelist (ID int not null auto_increment, name char(60), ...);
?!?
Cheers, Nessi
>At 15:21 04/07/01 , you wrote:
>>I move from MDB to mySQL, I got a question concern how to create a auto
>>digital number field
this example select query is only from a test file, my
original file
sets the whole query together in a php process.
"as x" will give only more than 0% if all three words apply.
So you only need a function in your script reading out the rows with x > 0.
See also the IF() section in the my
x27;Society')), 0), 0), 0)) as x FROM books, publ WHERE publ_id =
>pub_id ORDER BY x DESC
>
>Hope this helps!
>
>Cheers, Nessi
>
>
>At 22:22 26/06/01 , you wrote:
>>Ok,
>>
>>The message set that I noticed this morning sparked my interest in this.
>&
not a text with LIKE.
Cheers, Nessi
At 13:13 26/06/01 , you wrote:
>Partial searches can be done with 'LIKE', i.e.:
>
>SELECT * FROM yourtable WHERE somefield LIKE '%searchstring%'
>
>The '%' is MySQLs wildcard here, so if you only want strings s
way I had my search,
but I didnt change any of the settings (left everything at default), and
still had only exact matches in the output.
If you find out how to change it either way, please let me know.
I thought it would not be possible to use partial searches.
Cheers,
Nessi *amazed* ;)
PS: Maybe
Is this what you are looking for?
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
Just take a look at the manual!
Cheers, Nessi
At 09:22 22/06/01 , you wrote:
>how do i change a table's name without recre
Why dont you use the GRANT command?
GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Something like that...
Cheers, Nessi
At 15:55 20/06/01 , you wrote:
>MySQL newbie question here!!
>
>I have MySQL installed on Red Hat Linux 7. I
the manual:
Minimal length of word to be indexed is defined in myisam/ftdefs.h file by
the line
#define MIN_WORD_LEN 4
Cheers, Nessi
At 17:09 19/06/01 , you wrote:
>Hi. We're using full text searches to search a database of books.
>
>In the absence of AND searches, promised for
you what the search limitations are.
Cheers, Nessi
At 12:15 15/06/01 , you wrote:
>Hi,
>
>I have some problems with the Fulltext query it doesn't
>seem to function as I aspect. E.g. I have a table with a
>Fulltext index on columns title and description.
>
>If I query f
nfusing or you need more details let me know
>and Ill send an example of my select query.
>
>Cheers, Nessi
Darn I keep having probs with this mailing list :((
-
Before posting, please check:
http://www.mysql.com/man
My replies seem to never send to the mysql-list
but to the ppl who sent a request only, so
I am forwarding this again.
Maybe it will help other ppl as well :)
Nessi
>Date: Wed, 13 Jun 2001 11:36:41 +0100
>To: "Ute Hoffmann" <[EMAIL PROTECTED]>
>From: Nessi <[EM
lf). Could it be a problem with the settings? Its the
only explanation
I have. But I dont know what to do about it.
Does anybody have any ideas on this? I just thought it would be nice to
have something
like a percent score in the search output.
Thx in advanc
Alright alright...
I didnt want to believe it, but our disk is really full (got some funny
things going on at server terminal UGH!).
I hope my query will work okay once we get the server organized.
Thx anyways ;)
Nessi
olumn in
table publ.
publ_id is the id referred to in table books by pub_id.
I checked that the indexes are correct, so I dont think thats the error.
If anyone has an idea on this Id be happy about any suggestions!!!
Or if anyone knows where to find script examples on this query on the
15 matches
Mail list logo
