Problem Description:Recently replaced upgraded server, there has been a problem, is that many users can ping and tracert through our site, but when the landing is not normal, occasionally refresh can open, very abnormal.Catch packet found that the user came over the IP can to the server, but the server did not reply.Thanks to Huang's analysis!!!!Here is a summary of some of the solutions found online.===================================================
Function: tracert-parameter IP (or computer name) trace Route (packet)
Usage: tracert-d www.baidu.com
If you do not add the-D argument, the address will be resolved to host name, so it will be very slow, and then do not convert, the speed is much faster. The other parameters are as follows:
Options:-D does not resolve addresses to host names.-h maximum_hops The maximum number of hops for the search tar
" Goto nexttestSet numbertracert = 1ECHO is currently detecting 1 IP AddressFor/F % A in (% ipfile %) do set tempip = % A goto allyesno: NexttestIf "% numberip %" = "% numberline %" Echo. Echo no timed out IP address found in this testSet/A numberip = numberip + 1Echo.ECHO is currently detecting % numberip % IPSet numbertracert = 1Set/a skip = skip + 1For/F "Skip = % skip %" % A in (% ipfile %) do set tempip = % A goto allyesno: AllyesnoECHO is testing % numbertracert % hops for % tempip %. P
, you can know all the information.7. ARP (Address Resolution Protocol)View the appropriate MAC address for the IP address.How to use: Arp-a IP Displays the current ARP cache table for all interfaces.Arp attack is to realize ARP spoofing by fake IP address and MAC address, can generate a large amount of ARP traffic in the network to block the network, the attacker can change the IP-MAC entry in the target host ARP cache as long as the persistent ARP response packet is issued, causing network int
Tags: blog ar os sp DIV log BS AD asAdd a column:ALTER TABLE Emp4 Add test varchar2 (10);To modify a column:ALTER TABLE Emp4 Modify Test varchar2 (20);Delete a column:ALTER TABLE emp4 drop column test;Here are a few places to note, first, add and modify the column is not required to add the keyword column, or will error ora-00905.Second, to delete a single column, be sure to add column, and then remember that the deletion is not required to add the type.Add multiple columns:ALTER TABLE Emp4 Add
Add a column:
Alter table emp4 add Test varchar2 (10 );
Modify a column:
Alter table emp4 modify test varchar2 (20 );
Delete a column:
Alter table emp4 drop column test;
Here pay attention to a few places, first, add and modify the column is not need to add the keyword column, otherwise it will report an error ora-00905.
Second, if you delete a single column, you must add column. Remember that you do not need to add the column type to delete the column.
Add multiple
Adaptive width of left and right columns, fixed width of middle columns, and adaptive width of left and right columns
The width of the left and right columns is adaptive, and the width of the middle column is fixed:The width of the middle column is fixed, and the adaptive effect of the width of the left and right
ALTER table: Add, modify, delete table columns, constraints, and other table definitions.View column: Desc table name;Modify table name: ALTER TABLE T_book Rename to BBB;Add column: ALTER TABLE name add column name varchar (30);Delete column: ALTER TABLE table name drop column name;Modify Column name Mysql:alter table BBB change nnnnn hh int;Modify the column name Sqlserver:exec sp_rename ' t_student.name ', ' nn ', ' column ';Modify the Column name O
ALTERTable: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER TABLE table name drop column name;
Modify Column name Mysql:alter table BBB change nnnnn hh int;
Modify the column name Sqlserver:exec sp_rename ' t_student.name ', ' nn ', '
1. Add a column:Alter table name add column name varchar2 (10);2. Modify a column: Alter Table name modify column name varchar2 (20);3. Delete a column: Alter table name drop column name ;Here are a few places to note, first, add and modify the column is not required to add the keyword column, or will error ora-00905.Second, to delete a single column, be sure to add column, and then remember that the deletion is not required to add the type.4. Add multiple
Oracle Column Operations
Add a column:
ALTER TABLE Emp4 Add test varchar2 (10);
Modify a column:
ALTER TABLE Emp4 Modify Test varchar2 (20);
Delete a column:
ALTER TABLE emp4 drop column test;
Here to pay attention to a few places, first of all, add and modify columns do not need to add a keyword column, or will be an error ora-00905.
Second, to delete a single column, be sure to add column, and then remember that deletion is not required to a
ALTER table: Add, modify, delete table columns, constraints, and other table definitions.
View column information: DESC table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column field name varchar (length);
Delete column: ALTER TABLE name drop column field name;
Modify Column name mysql:alter table name change cloumn The original field name the new field name data type, while modi
ALTER table: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER TABLE table name drop column name;
Modify Column name Mysql:alter table BBB change nnnnn hh int;
Modify the column name Sqlserver:exec sp_rename ' t_student.name ', ' nn ',
MYSQL adds constraints, deletes constraints to add columns, modifies columns, and deletes columns to add primary key constraints: alter table name add constraint primary key (for example, PK _ table name) primary key table name (primary key field); add foreign key constraint: alter table add constraint foreign key from the table (for example, FK _ slave table _ m
Tags: des style blog http os for AR artMySQL joins columns, changes columns, deletes columnsALTER table: Add, change, delete table columns, constraints and other table definitions.
View column: Desc table name;
Change table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER
MySQL joins columns, changes columns, deletes columnsALTER table: Add, change, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Change table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER TABLE table name drop column name;
MySQL joins columns, changes columns, deletes columnsALTER table: Add, change, delete table columns, constraints and other table definitions.
View column: Desc table name;
Change table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER TABLE table name drop column name;
Label: ALTER table: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALTER TABLE table name drop column name;
Modify Column name Mysql:alter table BBB change nnnnn hh int;
Modify the column name Sqlserver:exec sp_rename ' t_student.name ',
Tags: des style blog http os ar for SP divMySQL joins columns, changes columns, deletes columnsALTER table: Add, change, delete table columns, constraints and other table definitions.
View column: Desc table name;
Change table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column: ALT
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.