General MySQL Oracle SQL Server

<< < … 6 7 8 9 10 11 12 13 14 15 16 > >>   ∑:377  Sort:Date

Drop an Existing Index in MySQL
How To Drop an Existing Index in MySQL? If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script: mysql&gt; DROP INDEX tip_subject ON tip; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0... 2018-02-14, 2327🔥, 0💬

Predefined User Accounts in MySQL
What Are the Predefined User Accounts in MySQL? 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 the installation. "root" has all access privileges ... 2017-09-08, 2323🔥, 0💬

CREATE TABLE Statement in MySQL
How To Create a New Table in MySQL? If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip": mysql&gt; CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) ... 2018-03-10, 2322🔥, 0💬

Data File of BDB Storage Engine in MySQL
Where Table Data Is Stored by the BDB Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, the BDB storage engine will create one file for each table to store table data and index data. If a new table is c... 2017-08-13, 2319🔥, 0💬

Using SELECT Statements in Views in MySQL
Can SELECT Statements Be Used on Views in MySQL? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: mysql&gt; CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE ... 2018-01-06, 2315🔥, 0💬

Counting Duplicated Values in a Column in MySQL
How To Count Duplicated Values in a Column in MySQL? If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAVING clause as shown in the following example. It ret... 2017-10-16, 2315🔥, 0💬

Inserting Data into an Existing Table in MySQL
How To Insert Data into an Existing Table in MySQL? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.... 2017-10-08, 2315🔥, 0💬

Concatenating Character Strings in MySQL
How To Concatenate Two Character Strings in MySQL? If you want concatenate multiple character strings into one, you need to use the CONCAT() function. Here are some good examples: SELECT CONCAT('Welcome',' to') FROM DUAL; Welcome to SELECT CONCAT('FYI','center','.com') FROM DUAL; FYIcenter.com   ⇒ E... 2018-04-07, 2314🔥, 0💬

Close MySQL Connection Objects in MySQL
How To Close MySQL Connection Objects in MySQL? MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumption of connection resources on your MySQL se... 2017-11-11, 2314🔥, 0💬

Shutdown MySQL Server Properly in MySQL
How To Properly Shutdown MySQL Server Daemon mysqld in MySQL? The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with options in a command window. Use Windows Tas... 2017-12-04, 2313🔥, 0💬

Query with an Inner Join in MySQL
How To Write a Query with an Inner Join in MySQL? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The tutorial exercise below creates another testing table and returns output with an inner join from two tables: fyi_links and fyi.r... 2017-12-31, 2311🔥, 0💬

Writing Date and Time Literals in MySQL
How To Write Date and Time Literals in MySQL? MySQL offers a number of formats for you to use to enter date and time literals: ANSI standard format: "YYYY-MM-DD HH:MM:SS". Non-standard limiters. Like: "YYYY/MM/DD HH^MM^SS" or "YYYY.MM.DD HH-MM-SS". No limiters. Like: "YYYYMMDD" for a date or "HHMMSS... 2017-12-26, 2311🔥, 0💬

Entering Microseconds in SQL Statements in MySQL
How To Enter Microseconds in SQL Statements in MySQL? If you want to enter microseconds in a SQL statements, you can enter them right after the time string as a 6-digit number delimited with '.'. '0' will be padded to right if not enough digits. Here are some good examples: SELECT TIME('1997/01/31 0... 2017-12-26, 2310🔥, 0💬

Entering Boolean Values in MySQL
How To Enter Boolean Values in SQL Statements in MySQL? If you want to enter Boolean values in SQL statements, you use (TRUE), (FALSE), (true), or (false). Here are some good examples: SELECT TRUE, true, FALSE, false FROM DUAL; +------+------+-------+------- +| TRUE | TRUE | FALSE | FALSE | +------+... 2018-03-31, 2309🔥, 0💬

Listing All User Accounts in MySQL
How To List All Existing User Accounts in MySQL? MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accounts, you can use the "SELECT" command as shown in the tutorial exercise below: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf mysql mysql&am... 2017-12-13, 2306🔥, 0💬

Commit the Current Transaction in MySQL
How To Commit the Current Transaction in MySQL? If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT command. It will make all the database changes made in the current transaction become pe... 2016-10-17, 2306🔥, 0💬

Data Removed in MEMORY Tables in MySQL
What Happens to MEMORY Tables When MySQL Server Is Stopped in MySQL? If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shut down by the DBA, all data rows will be removed. But the table structure will remain in the server. The tutorial exercise bel... 2017-08-08, 2305🔥, 0💬

Delete an Existing Column in a Table in MySQL
How To Delete an Existing Column in a Table in MySQL? If you have an existing column in a table and you do not need that column any more, you can delete it with "ALTER TABLE ... DROP COLUMN" statement. Here is a tutorial script to delete an existing column: mysql&gt; ALTER TABLE tip DROP COLUMN ... 2018-03-04, 2304🔥, 0💬

Merge Outputs from Two Queries in MySQL
How To Use UNION to Merge Outputs from Two Queries Together in MySQL? If you have two queries that returns the same row fields, you can merge their outputs together with the UNION operator. The following tutorial exercise shows you how to return all links that were created since year 2006 plus the o... 2017-12-21, 2304🔥, 0💬

Turn on Binary Logs in MySQL
How To Turn on Binary Logs in MySQL? If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: &gt;cd \mysql\bin &gt;mkdir \mysql\logs &gt... 2017-11-29, 2300🔥, 0💬

Entering Numeric Values as HEX Numbers in MySQL
How To Enter Numeric Values as HEX Numbers in MySQL? If you want to enter numeric values as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a numeric value, if the expression... 2018-03-31, 2293🔥, 0💬

Turn on Query Logs in MySQL
How To Turn on Query Logs in MySQL? If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log file: &gt;cd \mysql\bin &gt;mkdir \... 2017-12-04, 2289🔥, 0💬

Using Subqueries with the EXISTS Operator in MySQL
How To Use Subqueries with the EXISTS Operator in MySQL? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from fyi_links table that th... 2017-09-17, 2288🔥, 0💬

Insert Multiple Rows with 1 INSERT Statement in MySQL
How To Insert Multiple Rows with One INSERT Statement in MySQL? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good exa... 2018-01-16, 2287🔥, 0💬

<< < … 6 7 8 9 10 11 12 13 14 15 16 > >>   ∑:377  Sort:Date

General MySQL Oracle SQL Server