Library Powered by BSD http://bsd.org/ FreeBSD http://freebsd.org/ MySQL http://mysql.com/ Apache http://apache.org/ PHP http://php.net/ PHP http://SourceForge.net/
© February 14, 2007 Lorentz JÄNTSCHI


You can select only from `MendeleevSystem` table
SELECT fields list FROM `MendeleevSystem` WHERE 1 AND clauses list ORDER BY sort order list LIMIT limit definition		Your fields (Name [Type]):
  • Discovery [tinytext]
  • Appearance [tinytext]
  • Source [text]
  • Uses [text]
  • Biological [text]
  • General [text]
  • Number [tinyint(3) unsigned]
  • Mass [float unsigned]
  • Melting [float]
  • Boiling [float]
  • Density [float unsigned]
  • Configuration [varchar(65)]
  • Affinity [float]
  • nuclide [varchar(200)]
  • Atomic [varchar(65)]
  • abundance [varchar(90)]
  • life [varchar(100)]
  • Ionisation [text]
  • Fusion [float]
  • Vaporisation [float]
  • main [varchar(200)]
  • others [varchar(165)]
  • Bonds [text]
  • Symbol [char(3)]
    • SELECT

    field list    		WHERE 1 AND

    clause list
    ORDER BY

    sort order list    		LIMIT

    limit definition