Re: does mySQL support a boolean data type?

ehm, why do i say INT(1) then, and not just INT? but one could also take a 1 char type and perform some AND and OR on that one by hand. it's not really fast but it's possible right now. and it should be possible to convert the table later (for version 5.1 maybe) and with a little abstraction in

Re: does mySQL support a boolean data type?

why don't you use int(1) and set it to 0 or 1? -yves -Ursprüngliche Nachricht- Von: "Dan Anderson" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Sonntag, 13. Juli 2003 18:41 Betreff: does mySQL support a boolean data type? > I ran a search through the mySQL manual and google

Re: Can mysql handle this load?

why use INT for a date? i am used to do this with my bulletin board, since i need a 1-second resolution and so i can easily use the time() function in php and format the output string with date(), which is also using unix timestamps. but for applications that only need a resolution of 1 day, some

order of table joins or where clauses relevant?

As we're on this topic in another thread right now: Say I have a SELECT query from more than one table and with some conditions, does it matter in what order I enter the tables in the FROM clause and in what order the WHERE conditions appear in my query? Or does it make any difference if I use W

Re: Can mysql handle this load?

i think this should be no problem... i'd think of some table layout like this: date int PRIMARY student_id int PRIMARY status int extra_data what-you-want then you should get about 360,000 records per year. i saw people on this list reporting about millions of records

Re: Determining primary field

you mean the primary key (also called primary index), do you? just query 'SHOW INDEX FROM yourtable' and read all rows with Key_name = 'PRIMARY'. you can play around with this in the mysql commandline. you'll get all column names that belong to the primary key in the Column_name field of the ret

Re: Anyone running Windows 2000?

running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows 2000 professional sp3 (going to upgrade to sp4 soon) - no problems by now what's your question? :) ··· yves at unclassified.de -Ursprüngliche Nachricht- Von: "Ola Ogunneye" <[EMAIL PROTECTED]> An: <[EMAIL PROTECT

Re: The quote ' problem...

oops, i forgot this one... isn't that parameter binding only available from mysql 4.1 on? at least, when i browse through the php doc, it's part of the "improved mysql extension (mysqli)", available for mysql 4.1. does anyone know about version 4.0? -yves -Ursprüngliche Nachricht- Von

Re: The quote ' problem...

i don't believe there is another solution, but anyway, how many characters per second can your users type that this string replacement could be a measurable slowdown of the process? -yves -Ursprüngliche Nachricht- Von: "harsh" <[EMAIL PROTECTED]> An: "My Sql List" <[EMAIL PROTECTED]>

Re: stored procedures in mysql5

"insane" you mean extremely fast? or easy to use? i'd like to know what those SPs are good for... -yves -Ursprüngliche Nachricht- Von: "electroteque" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Montag, 30. Juni 2003 00:09 Betreff: RE: stored procedures in mysql5 > thanks th

Re: Insert statement with an ' in it

why don't you just insert your values after you escaped some special characters? specifically, you have to replace all ' by \' (prepend a single backslash character), and everything works fine! i guess you do your INSERTs from out of some programming language, like PHP, Perl or C. just use the

Re: can you insert null?

hm, no, it works fine with int and varchar(40) -Ursprüngliche Nachricht- Von: "danchik" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Freitag, 27. Juni 2003 00:01 Betreff: Re: can you insert null? > was the field type varchar? because it seems that no default varchars set > th

Re: can you insert null?

hm? i just did a little test on mysql 3.23.56-nt, and had no problems setting a null value on a null column having a default value other than null. it turned to be null, rather than the default value. ··· yves at unclassified.de -Ursprüngliche Nachricht- Von: "danchik" <[EMAIL PROTEC

Re: SHOW DATABASES user rights

thanks for your hint in that direction! i'm currently using the latest mysql 3.23, but i guess, i'll upgrade to 4.0 before i get my server up and running. but what i found, and may be more appropriate for my needs is the --safe-show-database option. i just added it to /etc/my.cnf, restarted the s

SHOW DATABASES user rights

Hello, I have a MySQL server running with some users besides root, that I want to grant all privileges for their own databases, but no rights for anything else. So to say, I have a user web01 that shall be able to do whatever he wants with the database db01. There are more databases, like db02 et