#mysql - Sun 20 May 2007 between 02:03 and 17:11

NY Lost Funds



Xgcperljunkie: Maybe you didn't ask a clear question.
perljunkie: Did you mean you wanted to delete all but the first 2000 records, without regard to id?
KevinOmanWarning: mysql_connect() [function.mysql-connect]: Host 'prodrive.websitewelcome.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in /home/myproweb/public_html/kevin/db/mysql4.php on line 48
what does this mean
techjimI'm getting the famous "access denied to root," and I'm not quite sure why.
pdxuserNoob Q: Is there a WHERE condition that lets me specify a value rather than a relation, so it would be, and this is pseudo code, but WHERE t1.id = foo, not WHERE t1.id = t2.id?
Oh, double-quotes.
nm
garotosopapdxuser, actually it's more common than the relation... what's the point?
pdxusergarotosopa: I was just wondering how to do it.
garotosopapdxuser, just like you said. isn't it working properly?
jmoncayoeverything looks find to me
*fine
cereal2ndcod_user doesn't have a type
jmoncayobut it is a foreign key from table user
cereal2ndand a text type can't have default value i think
hmm, foreigen keys
jmoncayoi thought the constraint at the end made the job for cod_user
cereal2ndnops
not sure about foreigen keys
jmoncayoi thought it was like oracle
:(
cereal2ndbut normally you need to define every field as a specific type
garotosopayou must specify the type even for foreign keys
jmoncayoso this is like ms-sql
:S
it should be like oracle
:) easier that way
garotosopaand you probably want INT UNSIGNED NOT NULL for your primary key
jmoncayotrue thanks
alanhaggaiI want to get value1 from table1 and then check value1 against table2 and then return value1 and value3 (from table2)
How can I do that? It is like I need to check for a value in two tables.
cereal2ndyou can use a join
select field1, field3 from table1, table2 where table1.field2=table3.field2
something like that
alanhaggaiThank you cereal2nd.
cereal2ndnp
jonkrihow do i get the number of rows in a column?
cereal2ndselect count(column) from table
jonkrihm, thought i tried that :)

Page: 3 10 17 24 

IrcArchive

NY Lost Funds