<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date

Inserting a New Row into a Table in MySQL
How To Insert a New Row into a Table in MySQL? To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: mysql&gt; INSERT INTO fyi_links VALUES (101, 'dev.fyicenter.com', NULL, 0, '2006-04-30'); Query OK, 1...
2018-01-16, 406👍, 0💬

Query with a Full Outer Join in MySQL
How To Write a Query with a Full Outer Join in MySQL? There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.   ⇒SELECT Statements with JOIN and Subqueries in MySQL ⇒⇒MySQL Database Tutorials
2017-09-28, 406👍, 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, 406👍, 0💬

"ALTER INDEX ... REORGANIZE" - Defragmenting Indexes in SQL Server
How To Defragment Indexes with ALTER INDEX ... REORGANIZE in SQL Server? When an index is defragmented to a small percentage, like &lt; 30%, you can use the "ALTER INDEX ... REORGANIZE" statement to defragment the index. Here is a tutorial exercise on defragmenting indexes: USE FyiCenterData; GO...
2016-11-08, 406👍, 0💬

Using IN Conditions in MySQL
How To Use IN Conditions in MySQL? 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 tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; 1 SELECT 3 NOT IN (1,2,3,4,5) FRO...
2018-03-28, 405👍, 0💬

Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and: mysql&gt; ALTER TABLE fyi_links ADD COLUMN tag VARCHAR(8); mysql&...
2017-11-02, 405👍, 0💬

"mysql" - Command Line End User Interface in MySQL
What Is the Command Line End User Interface - mysql in 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 is not a Graphical User Interface (GUI). "mys...
2018-04-28, 404👍, 0💬

Converting Dates to Character Strings in MySQL
How To Convert Dates to Character Strings in MySQL? You can convert dates to character strings using the DATE_FORMAT(date, format) function. MySQL supports the following basic formatting codes: %a Abbreviated weekday name (Sun..Sat) %b Abbreviated month name (Jan..Dec) %c Month, numeric (0..12) %D D...
2017-12-26, 404👍, 0💬

Sorting Query Output in MySQL
How To Sort the Query Output in MySQL? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted by the values in the "counts...
2017-11-02, 404👍, 0💬

NULL Values Involved in String Operations in SQL Server
What Happens If NULL Values Are Involved in String Operations in SQL Server Transact-SQL? If NULL values are involved in string operations, the result will be string NULL values. The following tutorial script shows you some good examples: SELECT 'FyiCenter'+NULL; GO ---------- NULL SELECT LEN(NULL);...
2017-02-05, 404👍, 0💬

sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using sys.indexes in SQL Server? Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links"...
2016-11-15, 404👍, 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, 403👍, 0💬

Selecting Other User's Database in MySQL
Can You Select Someone Else Database in MySQL? If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will have no privilege to select other databases. ...
2017-10-23, 403👍, 0💬

Fixing INSERT Command Denied Error in MySQL
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT command denied" error is that your user account does not have the INSERT privilege on the table or database. To resolve this error, you need to ask your MySQL DBA to grant you the right privilege. Your DBA ...
2017-10-08, 403👍, 0💬

Renaming an Existing Column with Management Studio in SQL Server
How to rename an existing column with SQL Server Management Studio in SQL Server? If you are using SQL Server Management Studio, you can rename almost any data objects through the Object Explorer window. The tutorial example below shows you how to rename a column: 1. Run SQL Server Management Studio...
2016-11-15, 403👍, 0💬

What Is "mysqlimport" Command in MySQL
What Is "mysqlimport" in MySQL? "mysqlimport" - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables. Here is a sample commands supported by "mysqlimport": "mysqlimport databaseName fileName" - Imports the data from the specifi...
2018-05-19, 402👍, 0💬

Ways to Get the Current Time in MySQL
How Many Ways to Get the Current Time in MySQL? 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&gt; SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE...
2018-03-13, 402👍, 0💬

Using Group Functions in the SELECT Clause in MySQL
How To Use Group Functions in the SELECT Clause in MySQL? 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. The following select statement returns 3 values cal...
2018-01-06, 402👍, 0💬

Getting Month and Weekday Names from DATATIME Values in SQL Server
How To Get Month and Weekday Names from DATETIME Values in SQL Server Transact-SQL? In DATETIME values, the month part and weekday part have names. You can use the DATENAME() function to get the month name and weekday name from a DATETIME value in the following format: DATENAME(datepart, date) retur...
2017-02-14, 402👍, 0💬

What Are User Defined Functions in SQL Server
What Are User Defined Functions in SQL Server Transact-SQL? A user defined function is a collection of Transact-SQL statements that stored in the SQL Server. A user defined function will return data when executed. A user defined function works in the same way as a system function. It can be used as ...
2016-12-28, 402👍, 0💬

Syntaxes of Creating Table-Valued Functions in SQL Server
How Many Ways to Create Table-Valued Functions in SQL Server Transact-SQL? SQL Server supports two syntaxes of creating table-valued functions: 1. Inline Table-valued Functions - A table-valued function created with a single SELECT statement: CREATE FUNCTION function_name( @parameter_1 data_type, @p...
2016-12-18, 402👍, 0💬

UNIQUE Constraint Creating Default Index in SQL Server
Does the UNIQUE Constraint Create an Index in SQL Server? If you add the UNIQUE constraint on a column, SQL Server will automatically add a non-clustered index for that column. The tutorial exercise below shows you the index created as part of the UNIQUE column, "id", of "fyi_links": USE FyiCenterDa...
2016-11-13, 402👍, 0💬

Using Multiple Columns in the GROUP BY Clause in SQL Server
Can Multiple Columns Be Used in GROUP BY in SQL Server? If you want to break your output into smaller groups, you can specify multiple column names or expressions in the GROUP BY clause. Output in each group must satisfy a specific combination of the expressions listed in the GROUP BY clause. The mo...
2016-10-25, 402👍, 0💬

Tools to Manage MySQL Server in MySQL
What Tools Available for Managing MySQL Server in MySQL? 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 - A command-line interface for administrators to per...
2018-06-01, 401👍, 0💬

<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date