Community

Learn

Tools Library

AI Tools

Leisure

English

Programming Dictionary

Online technical manual for service programmers

Popular searches：
PHP
MySQL
jquery
HTML
CSS

MySQL Related dictionaries

mysql Translation example syntax

select Translation example syntax

distinct Translation example syntax

where Translation example syntax

and Translation example syntax

or Translation example syntax

order-by Translation example syntax

insert Translation example syntax

update Translation example syntax

delete Translation example syntax

top Translation example syntax

like Translation example syntax

in Translation example syntax

between Translation example syntax

alias Translation example syntax

join Translation example syntax

inner-join Translation example syntax

left-join Translation example syntax

right-join Translation example syntax

full-join Translation example syntax

union Translation example syntax

select-into Translation example syntax

create-database Translation example syntax

create-table Translation example syntax

not-null Translation example syntax

unique Translation example syntax

primary-key Translation example syntax

foreign-key Translation example syntax

check Translation example syntax

default Translation example syntax

alter-table Translation example syntax

auto-increment Translation example syntax

null Translation example syntax

avg Translation example syntax

count Translation example syntax

first Translation example syntax

last Translation example syntax

max Translation example syntax

min Translation example syntax

sum Translation example syntax

group-by Translation example syntax

having Translation example syntax

ucase Translation example syntax

lcase Translation example syntax

mid Translation example syntax

len Translation example syntax

round Translation example syntax

now Translation example syntax

format Translation example syntax

mysql ROUND() function

Chinese translationRecent Updates：2018-05-15 11:24:07

英[raʊnd] 美[raʊnd]

adj. Round; arc-shaped; plump, fat; integer

adv. Everywhere; around; roundabout ; in the opposite direction

prep.approximately; around, surrounding; (indicating position) around; nearby

n. circle, circle; cycle; round object, spherical object; (Meeting) One round

vt.& vi. Make a circle; go around; turn around; round...

Third person singular: rounds Plural: rounds present participle : rounding Past tense: rounded Past participle: rounded Comparative: rounder Superlative: roundest

mysql ROUND() function Video explanation

mysql ROUND() function syntax

Function: Used to round numerical fields to the specified number of decimal places.

Syntax: SELECT ROUND(column_name,decimals) FROM table_name

##Parameters:

ParameterDescriptioncolumn_name Required. The field to round. decimals Required. Specifies the number of decimal places to be returned.

mysql ROUND() function example

//把名称和价格舍入为最接近的整数。
SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products;

submit

