<< < 51 52 53 54 55 56 57 58 59 60 61 > >>   Sort: Date

How To Write a Query with a Full Outer Join
How To Write a Query with a Full Outer Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.
2007-05-11, 5269👍, 0💬

How To Replace a Group of Characters by Another Group
How To Replace a Group of Characters by Another Group? - PHP Script Tips - PHP Built-in Functions for Strings While processing a string, you may want to replace a group of special characters with some other characters. For example, if you don't want to show user's email addresses in the original for...
2007-04-20, 5268👍, 0💬

How To Use Existing Values in UPDATE Statements
How To Use Existing Values in UPDATE Statements? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represen...
2007-05-11, 5266👍, 0💬

What’s difference between “Optimistic” and “Pessimistic” locking
What’s difference between “Optimistic” and “Pessimistic” locking ? In pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking. In optimistic locking multiple users can open th...
2007-10-24, 5265👍, 0💬

How To Run MySQL Server on a Different Port
How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start t...
2007-05-11, 5265👍, 0💬

How To Create a Stored Procedure
How To Create a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example scrip...
2007-04-26, 5263👍, 0💬

In Which Does File FireFox Store Persistent Cookies
In Which Does File FireFox Store Persistent Cookies? - PHP Script Tips - Understanding and Managing Cookies If you change FireFox to keep cookies "until they expire", FireFox will store persistent cookies from all Web servers in a single file at: \Documents and Settings\$user\Application Data\Mozill...
2007-04-24, 5263👍, 0💬

How To Create a Web Form
How To Create a Web Form? - PHP Script Tips - Processing Web Forms If you take input data from visitors on your Web site, you can create a Web form with input fields to allow visitors to fill in data and submit the data to your server for processing. A Web form can be created with the &lt;FORM> ...
2007-04-23, 5263👍, 0💬

I want to force the datareader to return only schema of the datastore rather than data
I want to force the datareader to return only schema of the datastore rather than data ? pobjDataReader = pobjCommand.ExecuteReader(Comm andBehavior.SchemaOnly)
2007-10-24, 5262👍, 0💬

How To Use IN Conditions
How To Use IN Conditions? - Oracle DBA FAQ - Understanding SQL Basics An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ...
2007-04-23, 5262👍, 0💬

How To Check Your PHP Installation
How To Check Your PHP Installation? - PHP Script Tips - Downloading and Installing PHP PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\...
2007-04-22, 5262👍, 0💬

How In-line Elements Are Formatted Side by Side
How In-line Elements Are Formatted Side by Side? - CSS Tutorials - Understanding Multiple Element Formatting Rules If in-line elements are coded next to each other, they will be formatted side by side in a line box. Their individual widths and heights will be respected. Their relative vertical posit...
2007-05-11, 5261👍, 0💬

How does XML handle white-space in my documents
How does XML handle white-space in my documents? All white-space, including linebreaks, TAB characters, and normal spaces, even between structural elements where no text can ever appear, is passed by the parser unchanged to the application (browser, formatter, viewer, converter, etc), identifying th...
2007-04-11, 5261👍, 0💬

Can you explain the process areas part 2
Can you explain the process areas? part 2 Purpose The purpose of Organizational Innovation and Deployment (OID) is to select and deploy incremental and innovative improvements that measurably improve the organization's processes and technologies. The improvements support the organization's quality a...
2007-10-30, 5260👍, 0💬

What Are the Predefined User Accounts
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes ...
2007-05-10, 5260👍, 0💬

What Are Sub-elements of the entry Element
What Are Sub-elements of the entry Element? - RSS FAQs - Atom Feed File Structure and Elements The "entry" element has the following sub-elements defined: &lt;author&gt; - Specifying the personal information about an author of the contents provided in this feed entry. A feed element may have...
2007-05-12, 5259👍, 0💬

Is FORM a Block Element
Is FORM a Block Element? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements Is &lt;FORM> a block element? The answer is yes. &lt;FORM> is behaves like a &lt;P>. Below is a good example of a floating block element and a floating inline element: &lt;html>&...
2007-05-11, 5259👍, 0💬

How To Drop a Stored Function
How To Drop a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example: SQL> CREATE O...
2007-04-25, 5259👍, 0💬

Can Group Functions Be Used in the ORDER BY Clause
Can Group Functions Be Used in the ORDER BY Clause? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many links were created in each year ...
2007-05-11, 5258👍, 0💬

How To Read a Text File into an Array
How To Read a Text File into an Array? - PHP Script Tips - Reading and Writing Files If you have a text file with multiple lines, and you want to read those lines into an array, you can use the file() function. It opens the specified file, reads all the lines, puts each line as a value in an array, ...
2007-04-22, 5258👍, 0💬

How To Get All the Keys Out of an Array
How To Get All the Keys Out of an Array? - PHP Script Tips - PHP Built-in Functions for Arrays Function array_keys() returns a new array that contains all the keys of a given array. Here is a PHP script on how to use array_keys(): &lt;?php $mixed = array(); $mixed["Zero"] = "PHP"; $mixed[1] = "P...
2007-04-21, 5258👍, 0💬

What Is Class.forName
What Class.forName will do while loading drivers? It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a DBMS.
2007-04-03, 5258👍, 0💬

How To Float an Image to the Right Side
How To Float an Image to the Right Side? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps If you want to float an image to the right side of the paragraph instead of inline within a text line, you have to use the CSS property "float" to do this. The "float" property takes two value...
2007-05-12, 5257👍, 0💬

What Are BIG and SMALL Tags/Elements
What Are BIG and SMALL Tags/Elements? - XHTML 1.0 Tutorials - Understanding In-line Elements and Tags "big" and "small" elements are inline elements that you can use to specify text to be displayed in bigger and smaller font sizes respectively. Here are basic rules about "big" and "small" elements: ...
2007-05-12, 5257👍, 0💬

<< < 51 52 53 54 55 56 57 58 59 60 61 > >>   Sort: Date