How to SELECT DEFAULT value of a field

by 
"SELECT $group FROM grouptable WHERE $group=DEFAULT( $group ) "

Or I think better:

"SELECT DEFAULT( $group ) FROM grouptable LIMIT 1 "

Update – correction

As @Jeff Caron pointed, the above will only work if there is at least 1 row in grouptable. If you want the result even if the grouptable has no rows, you can use this:

"SELECT DEFAULT( $group ) 
 FROM (SELECT 1) AS dummy
   LEFT JOIN grouptable 
     ON True
 LIMIT 1 ;"

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Im trying to create some temporary tables in mysql using php
  5. Php foreach give 2 users random value
  6. How can I prevent SQL injection in PHP?
  7. SQL injection that gets around mysql_real_escape_string()
  8. How to include a PHP variable inside a MySQL statement
  9. How to apply bindValue method in LIMIT clause?
  10. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  11. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  12. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  13. I cannot get my login form to connect interact properly with mySQL database [closed]
  14. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  15. Increment value in MySQL update query
  16. Do SQL connections opened with PDO in PHP have to be closed
  17. WAMP/MySQL errors not in correct language
  18. MYSQL Select from tables based on multiple rows
  19. How to execute raw queries with Laravel 5.1?
  20. How to convert ISO8601 to Date format in php
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. Extension mysqli is missing, phpmyadmin doesn’t work
  23. How do you do multiple SQL statements in one mysql_query?
  24. Fatal error: Call to a member function query() on null
  25. How would I implement a simple site search with php and mySQL?
  26. How to log in to phpMyAdmin with WAMP, what is the username and password?
  27. Do I have to use mysql_real_escape_string if I bind parameters?
  28. PDO and MySQL ‘between’
  29. MySQL Join Multiple Rows as Columns
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment