Software QA (13)
SQL Server (1)
How To Define and Use Table Alias Names
How To Define and Use Table Alias Names? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql> SELECT l.id, l.url, r.... 2007-05-11, 4789👍, 0💬
What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t... 2007-05-10, 4786👍, 0💬
How To Name Query Output Columns
How To Name Query Output Columns? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows ... 2007-05-11, 4782👍, 0💬
What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the speci... 2007-05-11, 4777👍, 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, 4775👍, 0💬
How To Create a New View
How To Create a New View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements You can create a new view based on one or more existing tables by using the "CREATE VIEW viewName AS selectStatement" statement as shown in the following script: mysql> CREATE TABLE comment (faqID INTEGER, m... 2007-05-11, 4775👍, 0💬
How To View User Privileges
How To View User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userN... 2007-05-10, 4775👍, 0💬
How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing table with existing data rows, and want to add a new column to that table, you can use the "ALTER TABLE ... ADD COLUMN" statement. The tutorial script below shows ... 2007-05-11, 4769👍, 0💬
How To Start MySQL Server Daemon mysqld
How To Start MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration There are a number of ways to start MySQL server daemon, mysqld: Double click on the file name, mysqld.exe, in a file explorer window. This is an easy way to start the server. But you will not be able to spec... 2007-05-11, 4769👍, 0💬
How To Turn on mysql Extension on the PHP Engine
How To Turn on mysql Extension on the PHP Engine? - MySQL FAQs - PHP Connections and Query Execution The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check... 2007-05-10, 4768👍, 0💬
How To Include Comments in SQL Statements
How To Include Comments in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM D... 2007-05-11, 4763👍, 0💬
What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - MySQL FAQs - Introduction to SQL Basics Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character se... 2007-05-11, 4758👍, 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, 4758👍, 0💬
How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:... 2007-05-11, 4753👍, 0💬
Can one issue DDL statements from Forms?
Can one issue DDL statements from Forms? DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported from Forms because your Forms are not suppose to manipulate the database structure. A statement like CREATE TABLE X (A DATE); will result in error: Encountered the ... 2011-04-05, 4751👍, 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, 4745👍, 0💬
What Tools Available for Managing MySQL Server
What Tools Available for Managing MySQL Server? - MySQL FAQs - Administrator Tools for Managing MySQL Server MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin ... 2007-05-11, 4741👍, 0💬
How Many Ways to Get the Current Time
How Many Ways to Get the Current Time? - MySQL FAQs - Introduction to SQL Date and Time Handling There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql> SELECT CURRENT_TIMES... 2007-05-11, 4740👍, 0💬
What Are the Differences between BINARY and VARBINARY
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in va... 2007-05-11, 4733👍, 0💬
What Is mSQL
What Is mSQL? - MySQL FAQs - Database Basics and Terminologies Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared th... 2007-05-10, 4729👍, 0💬
How To Dump a Table to a File with "mysqldump"
How To Dump a Table to a File with "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: >cd \mysql\bin >mysqldump ... 2007-05-11, 4724👍, 0💬
What Is "mysqlshow"
What Is "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow": "mysqlshow" - Shows all the databases. "mysqlshow databaseName" - ... 2007-05-11, 4724👍, 0💬
What Are Storage Engines
What Are Storage Engines? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine.... 2007-05-10, 4714👍, 0💬
How To Create a New Table Using the InnoDB Storage Engine
How To Create a New Table Using the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org. InnoDB... 2007-05-10, 4713👍, 0💬
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...
What is the quickest sorting method to use? The answer depends on what you mean by quickest. For mos...
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...
.NET INTERVIEW QUESTIONS - What is COM ? Microsoft’s COM is a technology for component software deve...
Where Is the Submitted Form Data Stored? - PHP Script Tips - Processing Web Forms When a user submit...