Documentation

For AmbSQL Command Line Interface

• To login to Database
  connect
  
• To create new Table
  createtable(<table-name>, <column1-name> , <column2-name>, ....)
• To enter the values in Table
  insertvalues(<table_name>, <column1-value> , <column2-value>, ...)
• To show the Table schema
  showtable(<table_name>)
  
• To show the Table values
  showvalues(<table_name>)
• To Update all values of column
  updatevalue(<table_name> , <assignment>)
• To Update the values of column
  updatevalue(<table_name> , <assignment> , <condition>)(e.g- updateTable(ab, name=jack, age=23))
• To truncate the Table
  deletetable(<table_name>)
• To delete row(s) from Table
  deletetable(<table_name> , <condition>)(e.g- deletetable(ab,name==jack))
• To drop the Table
  droptable(<table_name>)
• To rename Table Name
  altertable(<old-table_name> , <new-table_name>)
• To create new User
  createuser(<user_name> , <password>)
• To delete a User
  deleteuser(<user_name>)
• To Logout
  logout()
• To clear the Screen
  clear()