| |
| |
| |
|
Comments:
<0> Hello
<0> I have a delete from with a subquery and I get syntax error
<0> I can't see the error and I'm getting mad about it
<0> the mysql statement is: delete from tProdCatGlue where uProduct in (select uProduct from tProduct where uModDate < 1143878400);
<0> any help is appreciated
<0> grazzy any idea ?
<0> Freman ?
<0> Eldritch ?
<1> check out subquery section of mysql
<1> as i know
<1> u cant use delete and a subquery from same table
<0> yes I read that part
<1> but i migh tbe wrong
<0> but is not the same table
<0> www99 you are right about that
<1> do you have constraing?
<1> constraints*
<0> and I quote "Currently, you cannot delete from a table and select from the same table in a subquery."
<1> between those two tables
<0> no I don't
<1> well
<0> but I get "ERROR 1064: You have an error in your SQL syntax."
<1> maybe you
<1> dont have proper format for in()
<0> as if the query is wrong
<1> returned from your query
<0> is there another way to use subqueries ?
<2> what? no
<0> Eldritch do you see a syntax error in delete from tProdCatGlue where uProduct in (select uProduct from tProduct where uModDate < 1143878400); ?
<2> stop talking to me
<1> is umoddate in epoch format?
<0> sorry, I didn't intend to upset you
<0> www99 yes
<3> the_monje, do the subquery by itself and see what you get
<1> btw whats your mysql version?
<1> some old versions dont support subqueries
<1> like 4.0 series
<3> heh, yes that could be a problem
<0> Ver 4.0.25
<3> there it is
<0> bloody hell
<0> well, thank you very much for your help guys
<3> use a join
<0> how ?
<3> http://tyson.homeunix.org/notes/mysql.html
<3> there is a join in there with a link to the manual page for joins
<0> k
<0> thank you very much beebum
<3> your welcome
<3> later, i'm headed home. ;)
<4> i have made a mistake and removed user privilages to have grand access
<4> how can i fix the problem?
<5> So, the registered DNS name for my machine is longbow.timb.us, it has a forward and reverse DNS on it that works. Fresh install of MySQL 5. I've added users such as 'user'@'longbow.timb.us', however, when I try to do a mysql -h longbow.timb.us -u user -p, it fails, telling me: ERROR 1130 (00000): Host 'longbow' is not allowed to connect to this MySQL server
<5> I seem to remember this working out of the box before. Is there anything I'd be missing?
<5> Anyone?
<5> Everyone here and no one can answer?
<6> is there a function to avoid disp;laying mysql errors to users ?
<6> it's just a small error that I can't fix: ( Length parameter must be greater than 0 in...... ) in fread()
<6> allright, it's ok, BillMaurray gave me the solution
<7> does mysql support EXCEPT ?`
<7> like.. (SELECT a FROM b) EXCEPT (SELECT a FROM b WHERE a>2)
<7> (allthough.. that exact sql statement could be written as one select :)
<8> hello
<9> hi
<8> does anyone know why I can't select a database althourh I am connected?
<9> what programming lang did you use?
<9> php?
<8> yes
<9> ah
<9> what error messages?
<9> can't select database?
<8> Could not select database (aldafatan) because of : Access denied for user: 'supress@localhost' to database 'aldafatan'
<9> check the p***word of the database
<9> if its correct
<8> you know conan I can't find any "privileges" link
<8> to add a user
<8> and I use the username and the p***word, which I connect to the database
<9> hmm
<9> did you try connect to phpmyadmin?
<9> then no problem?
<8> nope
<9> try to login with your username and p***word to phpmyadmin i think is your username and p***word
<8> I am putting this
<8> I am connecting
<8> but it doesn't let me to select the database
<9> mysql_select_db('database_name');
<8> yeap
<9> banxt its somthing to do with your username
<8> tell my how to add a new user
<8> and I'll try to connect with that username
<8> and we'll see..
<9> banxt where did you run your program in your computer or in webhosting
<9> if in the webhosting you can contact the probider and ask about the mysql account
<8> it's a web hosting
<8> company
<9> ah
<8> in my computer it works
<8> do you think I must use the GRANT !?
<9> just try
<10> hello all
<10> can we cl*** result bu coount(*) ?
<11> what?
<10> i have a table with all my command
<10> and i would like to have a list beginning by the bestseller down to the worst seller item
<10> i did that SELECT prod_id, count(*) FROM `chumon` group by prod_id
<10> that was working
<10> by i wanted to put order by adding order by count(*)
<10> but mysql rejected it
<10> would you mind to give me some help ?
Return to
#mysql
or
Go to some related
logs:
xxxpasswordz
#linux
#chatzone
dl140 sata chipset used
any girle
ordeouvers
#networking
#linux
#mirc
how can i get iterator length using getelementbyname
|
|