<< < 64 65 66 67 68 69 70 71 72 73 74 > >>   Sort: Date

How To Return Query Output in XML Format
How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: >cd \mysql\bin >...
2007-05-10, 5235👍, 0💬

How Cookies Are Transported from Browsers to Servers
How Cookies Are Transported from Browsers to Servers? - PHP Script Tips - Understanding and Managing Cookies Cookies are transported from a Web browser to a Web server in the header area of the HTTP request message. Each cookie will be included in a separate "Cookie:" header line in the following fo...
2007-04-24, 5235👍, 0💬

How To Write Numeric Literals
How To Write Numeric Literals? - Oracle DBA FAQ - Understanding SQL Basics Numeric literals can coded as shown in the following samples: SELECT 255 FROM DUAL -- An integer 255 SELECT -6.34 FROM DUAL -- A regular number -6.34 SELECT 2.14F FROM DUAL -- A single-precision floating point 2.14 SELECT -0....
2007-04-24, 5235👍, 0💬

How To Specify a Background Image
How To Specify a Background Image? - CSS Tutorials - Page Layout and Background Image Design The quickest way to specify a background image is to use the background-image style property. Let's try with an image from the Windows system called, follow.jpg: &nbsp; &nbsp; &nbsp; &nbsp; &...
2007-05-11, 5234👍, 0💬

How To Show All Tables with "mysql"
How To Show All Tables with "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: >cd \mysql\bin >mysql -u root test Welc...
2007-05-11, 5234👍, 0💬

How To Connect to MySQL from a PHP Script
How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format: $con = mysql_connect($server, $username, $password); If you are c...
2007-04-18, 5234👍, 0💬

What is DCOM Can anybod explain in detail
What is DCOM Can anybod explain in detail Short for Distributed Component Object Model, an extension of the Component Object Model (COM) that allows COM components to communicate across network boundaries. Traditional COM components can only perform interprocess communication across process boundari...
2009-03-06, 5233👍, 0💬

What Is a Transaction
What Is a Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transac...
2007-05-11, 5232👍, 0💬

What Are DDL Statements
What Are DDL Statements? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the defi...
2007-05-11, 5232👍, 0💬

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

What Are the "mysqld" Command Line Options
What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages ...
2007-05-11, 5231👍, 0💬

Can You Drop an Index Associated with a Unique or Primary Key Constraint
Can You Drop an Index Associated with a Unique or Primary Key Constraint? - Oracle DBA FAQ - Managing Oracle Table Indexes You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement o...
2007-05-02, 5231👍, 0💬

How To Get a List of All User Accounts in the Database
How To Get a List of All User Accounts in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use a SELECT statement to get a list of all user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. ...
2007-04-27, 5231👍, 0💬

How can we make a thread sleep for infinite period
How can we make a thread sleep for infinite period ? You can also place a thread into the sleep state for an indeterminate amount of time by calling Thread.Sleep (System.Threading.Timeout.Infi nite).To interrupt this sleep you can call the Thread.Interrupt method.
2007-10-22, 5230👍, 0💬

How To Convert Dates to Characters
How To Convert Dates to Characters? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') FROM DUAL; -- SYSDATE returns the current date 07-MAY-2006 SELECT TO_CHAR(SYSDAT...
2007-04-23, 5230👍, 0💬

How To Define a Data Field as NOT NULL
How To Define a Data Field as NOT NULL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When defining a specific RECORD type, you can define a data field as NOT NULL to make sure variables with this RECORD type to always have values in this field. A field defined as NOT NULL must have a d...
2007-04-27, 5229👍, 0💬

What To Do If the StartBD.bat Failed to Start the XE Instance
What To Do If the StartBD.bat Failed to Start the XE Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If StartBD.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not b...
2007-04-24, 5229👍, 0💬

How To Write a String to a File without a File Handle
How To Write a String to a File without a File Handle? - PHP Script Tips - Reading and Writing Files If you have a string, want to write it to a file, and you don't want to open the file with a file handle, you can use the file_put_contents(). It opens the specified file, writes the specified string...
2007-04-23, 5229👍, 0💬

How To Convert Numbers to Strings
How To Convert Numbers to Strings? - PHP Script Tips - Understanding String Literals and Operations In a string context, PHP will automatically convert any numeric value to a string. Here is a PHP script examples: &lt;?php print(-1.3e3); print("\n"); print(strlen(-1.3e3)); print("\n"); print("Pr...
2007-04-20, 5229👍, 0💬

What Is the Author META Tag/Element
What Is the Author META Tag/Element? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags The author meta element is a special meta element that provides information about the author of the XHTML document. The author meta element must include the "name" attribute as, name="author". Here is...
2007-05-12, 5228👍, 0💬

How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) F...
2007-05-11, 5228👍, 0💬

How To Use Group Functions in the SELECT Clause
How To Use Group Functions in the SELECT Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query....
2007-04-20, 5228👍, 0💬

Do I have to know HTML or SGML before I learn XML
Do I have to know HTML or SGML before I learn XML? No. Although it's useful because a lot of XML terminology and practice derives from two decades' experience of SGML. Be aware that "knowing HTML" is not the same as "understanding SGML". Although HTML was written as an SGML application, browsers ign...
2007-04-11, 5228👍, 0💬

What is Tracing in ASP.NET
What is Tracing in ASP.NET ? Tracing allows us to view how the code was executed in detail.
2007-10-24, 5227👍, 0💬

<< < 64 65 66 67 68 69 70 71 72 73 74 > >>   Sort: Date