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();
}
