Skip to main content

Posts

Showing posts from February, 2013

MySQL error #1045 on GoDaddy phpMyAdmin

After I made a new MySQL databases, I logged in to phpMyAdmin to test and got this message: #1045 – Access denied for user ‘myusername’@’10.10.10.10’ (using password: YES) What??? After couple attempts for a few hours, I decided to use a new difference password. Now it worked. It seem to me, there is a character in my initial password did not carry to or accepted by MySQL database.

SQL Questions and Answers - Part 2

Continue from previous part . What is a constraint? Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. SQL Server supports the following classes of constraints: NOT NULL specifies that the column does not accept NULL values. CHECK constraints enforce domain integrity by limiting the values that can be put in a column. UNIQUE constraints enforce the uniqueness of the values in a set of columns. PRIMARY KEY constraints identify the column or set of columns that have values that uniquely identify a row in a table. FOREIGN KEY constraints identify and enforce the relationships between tables. Read more at http://msdn.microsoft.com/ What is a unique constraint? A Unique constraint uniquely identified each record in a table. This provides uniqueness for the column or set of columns. Use a Unique constraint when yo

JavaScript Questions and Answers

What is JavaScript? JavaScript is the object oriented scripting language developed by Brendan Eich, an engineer at Netscape, in 1995. It is also known as Mocha, LiveScript, JScript, ECMAScript, and it is one of the world's most popular programming languages. Is JavaScript subset of Java? No. Although Javascript's syntax came from Java and C, they are difference. JavaScript developed by Netscape. Java developed by Sun. Java is an OOP programming language while Java Script is an OOP scripting language. Java creates applications that run in a virtual machine or browser while JavaScript code is run on a browser only. Java code needs to be compiled while JavaScript code are all in text. What are JavaScript types? Number. String. Boolean. Object: Function, Array, Date, RegExp Null . Undefined . What is the difference between undefined value and null value? undefined means a variable has been declared but has not yet been assigned a value. undefined is a property of the global object,