General MySQL Oracle SQL Server

<< < … 39 40 41 42 43 44 45 46 47 48 49 … > >>   ∑:1351  Sort:Date

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, 2285🔥, 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, 2285🔥, 0💬

OUTPUT - Receiving Output Values from Stored Procedures in SQL Server
How To Receive Output Values from Stored Procedures in SQL Server Transact-SQL? If an output parameter is defined in a stored procedure, the execution statement must provide a variable to receive the output value in the format: "@variable_name OUTPUT" or "@parameter_name = @variable_name OUTPUT". Th... 2016-12-28, 2283🔥, 0💬

"DROP SCHEMA" - Dropping an Existing Schema in SQL Server
How To Drop an Existing Schema in SQL Server? If you want to delete a schema, you need to move all objects out of that schema, then use the "DROP SCHEMA" statement to delete the schema. The tutorial exercise below shows you how to drop schema "fyi": -- Login with "sa" USE FyiCenterData; GO -- Drop f... 2016-10-20, 2283🔥, 0💬

"CREATE USER" - Creating a User Name in a Database in SQL Server
How To Create a User Name in a Database in SQL Server? User names are security principals at the database level. If you want to allow a login name to access a specific database, you need to create a user name in that database and link it to the login name. Creating a user name can be done by using t... 2016-10-19, 2283🔥, 0💬

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv... 2024-08-14, 2282🔥, 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, 2282🔥, 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, 2282🔥, 0💬

Performing Comparison on Character Strings in SQL Server
How To Perform Comparison on Character Strings in SQL Server Transact-SQL? Comparison operations on character strings are performed based on the associated collation. Each collation defines rules on how characters are ordered, how character cases and accents are treated, etc. The tutorial exercise b... 2017-01-21, 2281🔥, 0💬

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, 2280🔥, 0💬

Filter Out Duplications in Returning Rows in Oracle
How To Filter Out Duplications in Returning Rows in Oracle? If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT or UNIQUE in the SELECT clause. The tutorial exercise below shows you that DISTINCT works on selected columns only: S... 2019-12-19, 2279🔥, 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, 2279🔥, 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, 2278🔥, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL&gt; CREATE TABLESPACE users 2 DATAFILE '/oraclexe/oradata/FYI/users01 .dbf'SIZE 10... 2019-03-27, 2277🔥, 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, 2277🔥, 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, 2277🔥, 0💬

Providing Login Information for a New ODBC DSN
How To Provide Login Information for a New ODBC DSN? Continue from the previous tutorial. After clicking Next on the first screen of the "Create a New Data Source to SQL Server" wizard, you should see the second screen asking you to select SQL Server login type, login name and password. Select the r... 2024-08-06, 2276🔥, 0💬

Counting Groups Returned with the GROUP BY Clause in SQL Server
How To Count Groups Returned with the GROUP BY Clause in SQL Server? If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the number of groups, you can put the GROUP BY query i... 2016-10-29, 2276🔥, 0💬

Using Subqueries with the EXISTS Operators in SQL Server
How To Use Subqueries with the EXISTS Operators in SQL Server? 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 t... 2016-10-29, 2276🔥, 0💬

Create Tables for ODBC Connection Testing in Oracle
How To Create Tables for ODBC Connection Testing in Oracle? If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL&gt; CONNECT system/retneciyf Connected. SQL&gt; CREATE USER fyi IDENTIF... 2016-10-15, 2276🔥, 0💬

Use Variables in SQL Statements in Oracle
Can Variables Be Used in SQL Statements in Oracle? Yes, you can use variables in SQL statements as part of any expressions. The tutorial script provides you some good examples: (Connect to XE with SQL*Plus) CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VA... 2018-09-24, 2275🔥, 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, 2275🔥, 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, 2273🔥, 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, 2273🔥, 0💬

<< < … 39 40 41 42 43 44 45 46 47 48 49 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server