B4J Question MySQL experts, come !!

marcick

Well-Known Member
Licensed User
Longtime User
I know yhis is not the correct place, but I googled much without success ...

I need to find the minimum value between the maximum value in a column and a constant

In my mnd the sintax would be this but doesn't work

SELECT LEAST(SELECT MAX(columnname) FROM records, 100);

Any help ?
 
Sort by date Sort by votes

OliverA

Expert
Licensed User
Longtime User
marcick said:
The problem with the quoting character is in PhpMyAdmin
Click to expand...
No. Quoting is one of those things that each SQL engine seems to have their own solution towards (even though there is a standard). MySQL uses regular single quotes to delineate a string literal. It can also use double quotes for that task. (see https://dev.mysql.com/doc/refman/8.0/en/string-literals.html ). By default, MySQL uses the single back ticks to escape "object names" (see https://dev.mysql.com/doc/refman/8.0/en/identifiers.html). Now if you enable ANSI_QUOTES, double quotes can be used for object names, but never single quotes.
As I'm typing:
LucaMs said:
MS Sql Server accepts square brackets too !
Click to expand...
As to
never single quotes
Click to expand...
SQLite:
If a keyword in single quotes (ex: 'key' or 'glob') is used in a context where an identifier is allowed but where a string literal is not allowed, then the token is understood to be an identifier instead of a string literal.
Click to expand...
source: https://www.sqlite.org/lang_keywords.html

Once more: I'm typing to slow
 
Upvote 0

marcick

Well-Known Member
Licensed User
Longtime User
Be careful in PhpMyAdmin (I think in MySql too) you have to quote with 0096 at the beginning and at the end, not use 0180
 
Upvote 0
You must log in or register to reply here.

Similar Threads

C
  • Question
B4J Question xChart Library Question
Replies
2
Views
227
ChristopherP
C
  • Question
B4J Question [SOLVED] B4XTable - How to get...
Replies
4
Views
846
Mahares
M
  • Question
B4J Question [SOLVED] How To Get Precise B4XTable Column Numbers
2
Replies
22
Views
3K
cklester
P
  • Question
B4J Question MySQL number of records with 3 search parameters[Solved]
Replies
2
Views
737
OliverA
  • Question
B4J Question [B4X] [B4J] [SOLVED] jRotaryKnob set Value
Replies
2
Views
2K
GMan
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…