// DELETE - MASTER
public static string Delete(string table, string where = "", int limit = 0)
{
_SQLQuery = new SQLQueryItem();
_SQLQuery.Type = SQLQueryItem.TypeEnum.DELETE;
_SQLQuery.Table = table;
if (!String.IsNullOrEmpty (where))
_SQLQuery.SetFilter (where);
if (limit != 0)
_SQLQuery.Limit = limit;
return _SQLQuery.build();
}
public static string Insert(string into, string[] value)
{
_SQLQuery = new SQLQueryItem();
_SQLQuery.Type = SQLQueryItem.TypeEnum.INSERT_INTO;
_SQLQuery.Table = into;
add_insert_value (value);
return _SQLQuery.build();
}