public static void Sample() { string config = "server=localhost;uid=your-uid;password=your-password;port=3306;database=your-db-name"; MySqlConnection con = new MySqlConnection(config); con.Open(); MSCommand command = new MSCommand(con); // SELECT_ALL_FROM => Select all from TESTING, EACH LIST WILL HAVE JSON DATA STRING List <string> u = command.SELECT_ALL_FROM("testing"); u.ForEach(x => Console.WriteLine(x)); con.Close(); }
public static void Sample() { string config = "server=localhost;uid=your-uid;password=your-passs;port=3306;database=your-database"; MySqlConnection con = new MySqlConnection(config); con.Open(); MSCommand command = new MSCommand(con); // Update -> update the table-name, then set the VARIABLES which is selected to NEW VALUE, WHERE (condition) var u = command.UPDATE("table-name").SET("name = 'newname'").WHERE("age = 50"); if (!u.IsSuccess) { Console.WriteLine(u.Message); } else { Console.WriteLine("Done!"); } con.Close(); }
public static void Sample() { string config = "server=localhost;uid=your-uid;password=your-password;port=3306;database=your-db-name"; MySqlConnection con = new MySqlConnection(config); con.Open(); MSCommand command = new MSCommand(con); // DROP_TABLE_IF_EXISTS => Drop a table if its exist var u = command.DROP_TABLE_IF_EXISTS("testing"); if (!u.IsSuccess) { Console.WriteLine(u.Message); } else { Console.WriteLine("Done!"); } con.Close(); }
public static void Sample() { string config = "server=localhost;uid=your-uid;password=your-password;port=3306;database=your-db-name"; MySqlConnection con = new MySqlConnection(config); con.Open(); MSCommand command = new MSCommand(con); // CREATE_TABLE => Create a new table, param 2 : set the columns and rows var u = command.CREATE_TABLE("testing", "name TEXT, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY"); if (!u.IsSuccess) { Console.WriteLine(u.Message); } else { Console.WriteLine("Done!"); } con.Close(); }