.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 131 132 133 134 135 136 137 138 139 140 141 … > >>   Sort: Rank

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i... 2007-05-10, 5182👍, 0💬

How To Create Nested Tables
How To Create Nested Tables? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells You can create nested tables by including a child table inside a cell of the parent table. Below is a tutorial example of nested tables: &lt;?xml version="1.0" ?&gt; &lt;!DOCTYPE html PUBLIC "-//W3C... 2007-05-09, 10880👍, 0💬

How To Avoid the Antialias Edges When Cutting and Pasting
How To Avoid the Antialias Edges When Cutting and Pasting? - PSP Tutorials - Fading Images to Background Colors with PSP When you finish a larger image and want to select one area as a new image, you can use the Selection tool to cut and paste that area into a new image. But the new image will show ... 2007-05-09, 6040👍, 0💬

How In-Line Elements Are Mixed in Text Lines
How In-Line Elements Are Mixed in Text Lines? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements If an in-line element is mixed in a text line, it will be placed immediately after the preceding character. The vertical position of the in-line element will be determined by it... 2007-05-09, 6403👍, 0💬

How In-line Elements Affect Line Box Heights
How In-line Elements Affect Line Box Heights? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements If a line box contains only text without any in-line elements, its height is equal to the line-height property of the enclosing block element. If a line box contains text mixed ... 2007-05-09, 6063👍, 0💬

How To Experiment Dead Locks
How To Experiment Dead Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements a... 2007-05-09, 5605👍, 0💬

What Are Transaction Isolation Levels
What Are Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected se... 2007-05-09, 5689👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - MySQL FAQs - Transaction Management: Commit or Rollback A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create lock ... 2007-05-09, 6051👍, 0💬

What Is a Data Lock
What Is a Data Lock? - MySQL FAQs - Transaction Management: Commit or Rollback MySQL uses two types of data locks at two levels to provide you the transaction isolation level you need: Share Lock at Row Level (S) - A data row is locked by a transaction for reading. Exclusive Lock at Row Level (X) - ... 2007-05-09, 5512👍, 0💬

How To Test Transaction Isolation Levels
How To Test Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to test transaction isolation levels, you need to make sure that: The tables are created with transaction-safe storage engines, like InnoDB. Multiple-statement transactions are started wit... 2007-05-09, 7473👍, 0💬

What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks
What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks? - MySQL FAQs - Transaction Management: Commit or Rollback If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock d... 2007-05-08, 5602👍, 0💬

How To Revoke User Privileges
How To Revoke User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a priv... 2007-05-08, 5794👍, 0💬

How To Give a User Read-Only Access to a Database
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access Privileges If you want give a user read-only access to a database, you can grant to him/her only the "SELECT" privilege, so that he/she can not run any DDL statements, and any INSERT, UPDATE, or DELET... 2007-05-08, 7560👍, 0💬

Where Are User Privileges Stored on the Server
Where Are User Privileges Stored on the Server? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored ... 2007-05-08, 5781👍, 0💬

How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new database... 2007-05-08, 5219👍, 0💬

What Are the "mysql" Command Line Options
What Are the "mysql" Command Line Options? - MySQL FAQs - Command-Line End User Interface mysql "mysql" offers a big list of command line options. Here are some commonly used options: "-?" - Displays a help message on how to use "mysql" and terminates the program. "-u userName" - Specifies a user na... 2007-05-08, 5028👍, 0💬

How To Turn On or Off Recycle Bin for the Session
How To Turn On or Off Recycle Bin for the Session? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script: SQL> connect HR/fyicenter Connected. SQL... 2007-05-04, 5878👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c... 2007-05-04, 5545👍, 0💬

How To View the Dropped Tables in Your Recycle Bin
How To View the Dropped Tables in Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/... 2007-05-04, 5586👍, 0💬

How To Empty Your Recycle Bin
How To Empty Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables ... 2007-05-04, 11272👍, 0💬

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace. 2007-05-04, 5236👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. 2007-05-04, 5226👍, 0💬

How To Turn On or Off Recycle Bin for the Instance
How To Turn On or Off Recycle Bin for the Instance? - Oracle DBA FAQ - Managing Oracle Database Tables You can turn on or off the recycle bin feature for an instance in the instance parameter file with "recyclebin=on/off". You can also turn on or off the recycle bin feature on the running instance w... 2007-05-04, 5917👍, 0💬

What Is a Recycle Bin
What Is a Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle data... 2007-05-04, 5432👍, 0💬

<< < … 131 132 133 134 135 136 137 138 139 140 141 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML