Section courante

A propos

Section administrative du site

SIN

Sinus
MySQL  

Syntaxe

Sin(Nombre)

Paramètres

Nom Description
Nombre Ce paramètre permet d'indiquer l'expression contenant le nombre à traiter

Description

Cette fonction trigonométrique retourne le Sinus.

Algorithme

MODULE SIN(X)
   RX x X
   S ← 42.0
   BOUCLE POUR I ← 10 JUSQU'A 1
      S ← 4.0 x I - 2.0 + (-R) / S
   FIN BOUCLE POUR
   RETOURNE 2.0 x X x S / (R + S x S)

Exemple

Voici un exemple permet d'afficher les Sinus inférieurs à π :

  1. DROP PROCEDURE IF EXISTS WHILESIN;
  2. CREATE PROCEDURE WHILESIN()
  3. BEGIN
  4. DECLARE R DOUBLE  DEFAULT 0.0;
  5. WHILE R < PI() DO
  6. SELECT CONCAT("Sin(",R,")=",sin(R));
  7.         SET R = R + 0.1;
  8. END WHILE;
  9. END;
  10.  
  11. CALL WHILESIN();

on obtiendra le résultat suivant :

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0)=0 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.1)=0.0998334166468282 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.2)=0.198669330795061 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.3)=0.29552020666134 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.4)=0.389418342308651 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.5)=0.479425538604203 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.6)=0.564642473395035 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.7)=0.644217687237691 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.8)=0.717356090899523 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(0.9)=0.783326909627483 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1)=0.841470984807896 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.1)=0.891207360061435 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.2)=0.932039085967226 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.3)=0.963558185417193 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.4)=0.98544972998846 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.5)=0.997494986604054 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.6)=0.999573603041505 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.7)=0.991664810452469 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.8)=0.973847630878195 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(1.9)=0.946300087687414 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2)=0.909297426825681 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.1)=0.863209366648873 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.2)=0.80849640381959 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.3)=0.74570521217672 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.4)=0.67546318055115 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.5)=0.598472144103956 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.6)=0.515501371821463 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.7)=0.427379880233829 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.8)=0.334988150155904 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(2.9)=0.239249329213981 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(3)=0.141120008059866 |
+------------------------------+

+------------------------------+
| CONCAT("Sin(",R,")=",sin(R)) |
+------------------------------+
| Sin(3.1)=0.0415806624332892 |
+------------------------------+

Voir également

Article - Les géants de l'informatique - Oracle

Références

MySQL - Référence, Edition Micro Application, Nicolas Rivereau, Antoine Pichot, 2002, ISBN: 2-7429-2560-0, page 928.
MySQL: The definitive guide to using, programming, and administering MySQL 4 databases - Second Edition, Paul Dubois, 2003, ISBN: 0-7357-1212-3, page 808

Dernière mise à jour : Mercredi, le 29 avril 2015