numberRequired. The number to be truncated decimalsRequired. The number of decimal places to truncate to Technical Details Works in:From MySQL 4.0 More Examples Example Return a number truncated to 0 decimal places: SELECTTRUNCATE(345.156,0); Try it Yourself » ❮ MySQL Functions
DROP TABLE TheDROP TABLEcommand deletes a table in the database. The following SQL deletes the table "Shippers": ExampleGet your own SQL Server DROPTABLEShippers; TRUNCATE TABLE TheTRUNCATE TABLEcommand deletes the data inside a table, but not the table itself....
command creates a new table in the database. The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:Example CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), Ci...
Run Example » Definition and Usage Thetruncate()method resizes the file to the given number of bytes. If the size is not specified, the current position will be used. Syntax file.truncate(size) Parameter Values ParameterDescription sizeOptional. The size of the file (in bytes) after the ...
TheCREATE TABLEcommand creates a new table in the database. The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City: ExampleGet your own SQL Server CREATETABLEPersons ( ...