Posts
Showing posts with the label PROGRAMMING
TCP/IP Protocol Suite Explained
- Get link
- X
- Other Apps
Communication between 2 machines on a network are done through different protocol suits and TCP/IP is one of them. Well Explained in this video: tcp/ip layers LAYER FUNCTIONALITY Application Data that is sent by the user. EX: Any script, file, form data etc., Transport Data from application layer is broken down into segments. Each segment is named with sequence id so that they are received and appended in the right order in the receiver end. The transport header is added to each segment in this layer, which is having the destination and source address with the port number. Internet In this layer Internet header is added to segment, which contains source and destination IP address and routing information [How to reach receiver] Network In this layer Network header is added to segment, which contains source and destination physical address [mac address, ethernet] In this...
MySQL in Short
- Get link
- X
- Other Apps
NOTES : Remember to put a semicolon at the end of your SQL statements. The ; indicates that your SQL statment is complete and is ready to be interpreted. Strings must be in single quotes. The percent sign "%" can be used as a wild card to match any possible character that might appear before or after the characters specified. ACTION QUERY Match any first names that start with ' Er ' SELECT first, last, city FROM empinfo WHERE first LIKE 'Er%'; Match any last names that end in a ' s ' SELECT first, last FROM empinfo WHERE last LIKE '%s'; Select rows where the first name equals ' Eric ' exactly SELECT * FROM empinfo WHERE first = 'Eric'; Select last name, city, age from table whose age is greater than 30. SELECT last, city, age FROM empinfo WHERE age > 30; Select first name, last name, age whos elast name consists of “ illia ”. SELECT fi...