MySQL – Inserting data in MySQL tables
- No Comments
- Jun, 23, 2010
- Angelo Schalley
- Linux, MySQL, Plesk Linux
The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT.
INSERT into table_name (column1, column2....) values (value1, value2...);
where table_name is the name of the table into which we want to insert data; column1, column2 etc. are column names and value1, value2 etc. are values for the respective columns. This is quite simple, isn’t it?
Read more on MySQL – Inserting data in MySQL tables…
Mysql – Deleting entries from tables
- No Comments
- Jun, 23, 2010
- Angelo Schalley
- Linux, MySQL, Plesk Linux
The SQL delete statement requires the table name and optional conditions.
DELETE from table_name [WHERE conditions];
NOTE: If you don’t specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED!!!
Read more on Mysql – Deleting entries from tables…
change or add vlan id service console esx vmware
- No Comments
- Jun, 12, 2010
- Angelo Schalley
- Linux, vmware
esxcfg-vswitch -v 904 -p “Service Console” vSwitch0