Cookie is simply a variable that your webpage can store on or retrieve from the user’s computer to host machine. Examples of cookies could be: First time the visitor arrives the name is entered.(for example “John Wayne”). The username is then stored in a cookie. Next time he arrives at your page, it writes something … Read more
Once you have written the program you need to type it and instruct the machine to execute it. To type your C program you need another program called Editor. Once the program has been typed it needs to be converted to machine language (0’s and 1’s) before the machine can execute it. To carry out … Read more
we would write our first C program now. Once we have done that we would see in detail the instructions that it made use of. Before we begin with our first C program do remember the following rules that are applicable to all C programs: Each instruction in a C program is written as a … Read more
An entity that may vary during program execution is called a variable. Variable names are names given to locations in memory. These locations can contain integer, real or character constants. In any language, the types of variables that it can support depend on the types of constants that it can handle. This is because a particular type … Read more
As programs get bigger and more complicated, they get more difficult to read. Formal languages are dense, and it is often difficult to look at a piece of code and figure out what it is doing, or why. For this reason, it is a good idea to add notes to your programs to explain in … Read more
Syntax: IF(expr,if_true_expr,if_false_expr) MySQL IF function is control flow functions that returns a value based on a condition. The IF function is sometimes referred to as IF ELSE or IF THEN ELSE function. If the expr evaluates to TRUE i.e., expr is not NULL and expr is not 0, the IF function returns the if_true_expr , … Read more
If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to error 150, that means a foreign key definition would be . Error: 1005 … Read more
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near ‘%s’ at line %d Error #1064 means that MySQL can’t understand your command. To fix it: Read the error message. It tells you exactly where in your command MySQL got confused. Check the manual. By comparing against what MySQL expected at that point, the problem is often … Read more
Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Message: Can’t dropp database ‘%s’; database doesn’t exist
MySQL Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) If you get a too many connections error,Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR), when you try to connect to the mysqld server, this means that all available connections are in use by other clients. To increase the concurrent connections what are allowed to connect to the server, change the max_connections … Read more