SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Feb 2003
    Location
    eez
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Why doesn't SELECT Id FROM (SHOW FULL PROCESSLIST) work?

    Hi guys,

    as I know you are very talented in mysql programming, I thought I could turn to you for some qsnts on the subject.

    1/ Why doesn't this work?
    SELECT Id FROM (SHOW FULL PROCESSLIST)

    2/ Why doesn't this work?

    IF (thread_exist(1254)) KILL 1254

    Thank you

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    1) show commands are not allowed in subqueries.
    2a) the function thread_exist() does not exist
    2b) that's not a valid statement in mysql


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •