In Feburary 2016 26,
Open MySQL monitor and log in with your username and password.
Select the database you wish to update. For example, to use the database named TARDIS, type in the following at the command prompt:use TARDIS;
Type in the SQL statement to update your column. To update the Date column of a table named 'Destination' where the Location is equal to 'Gallifrey' you can use the following SQL statement:UPDATE DestinationSET Date='2011-11-11'WHERE Location='Gallifrey';If updating more than one column, for example 'Date' and 'Time,' you can use the following statement:UPDATE DestinationSET Date='2011-11-11', Time='11:11:11'WHERE Location='Gallifrey';
Press Enter to submit the changes.
Update Columns Using phpMyAdmin
Open phpMyAdmin and log in.
Click the name of the database you wish to update columns for.
Find the table you'd like to change, and click on the 'Browse' icon next to it.
Put a check mark on all the records that need to be updated and click on the pencil icon or the 'Change' icon.
Edit the text on all the columns you wish to update and click on 'Go.'
In Feburary 2016 26,
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, 26 February 2016
Saturday, 20 February 2016
How to Add a Foreign Key to MySQLIn Feburary 2016 20,
In Feburary 2016 20,
Click the Windows 'Start' button and click 'All Programs.' Click 'MySQL' and then click 'MySQL Workbench' to open your main console.
Click 'Edit SQL Script' in the main console window. This opens a SQL editor where you create the foreign key.
Type the following code into your editor:alter table table_name add constraint key_name foreign keyreferences tbl_name primary_keyThe first line sets the foreign key. Replace 'table_name' with the name of your table. 'Key_name' is the name of the column in your table you want to set as the foreign key. The second line is the primary key information to link to the foreign key. Replace 'tbl_name' with the table that contains the primary key and 'primary_key' with the primary key column name.
Click 'Run' to run your SQL statement. The foreign key is created, and your tables are set up with the linked attributes.
In Feburary 2016 20,
Click the Windows 'Start' button and click 'All Programs.' Click 'MySQL' and then click 'MySQL Workbench' to open your main console.
Click 'Edit SQL Script' in the main console window. This opens a SQL editor where you create the foreign key.
Type the following code into your editor:alter table table_name add constraint key_name foreign keyreferences tbl_name primary_keyThe first line sets the foreign key. Replace 'table_name' with the name of your table. 'Key_name' is the name of the column in your table you want to set as the foreign key. The second line is the primary key information to link to the foreign key. Replace 'tbl_name' with the table that contains the primary key and 'primary_key' with the primary key column name.
Click 'Run' to run your SQL statement. The foreign key is created, and your tables are set up with the linked attributes.
In Feburary 2016 20,
Saturday, 6 February 2016
Open Sources for SmallIn Feburary 2016 06,
In Feburary 2016 06,
An open-source software that works in multiple environments such as Microsoft Windows versions XP, Vista and 7, Mac OS X, Linux, BSD and Solaris, GnuCash was designed for easy use, power and flexibility, according to the software's website, GnuCash.org. Features include modules for vendors, customers, jobs, invoices, accounts receivables and payables. The software also provides reports and graphs as needed and relies on SQLite3, MySQL or Postgre SQL databases to store data.
XTuple Postbooks
Besides the standard accounting features, which include the general ledger, accounts receivable and payable, XTuple includes an integrated customer relationship management (CRM) platform with product definition, inventory, light manufacturing, and sales and purchasing features. This software works well for the small-to-medium business that provides customer inventory and may handle light manufacturing. The software runs on Windows, Mac and Linux systems.
TurboCash
The open-source software's website compares TurboCash to commercial software programs QuickBooks and Sage. Functions it includes in its software include general ledger, VAT accounting, bank reconciliation, invoicing, information for debtors and creditors, full reporting and analysis as well as room for more than one company or user. Applicable to multiple countries, the site provides an upgraded version for a fee.
Compiere
The Compiere open software website states that it 'automates all of your financial, distribution, sales and services processes and unifies your enterprise data in a single repository.' With customizable financial reports, Compiere also provides financial management and integrates enterprise-wide business processes and data.
In Feburary 2016 06,
An open-source software that works in multiple environments such as Microsoft Windows versions XP, Vista and 7, Mac OS X, Linux, BSD and Solaris, GnuCash was designed for easy use, power and flexibility, according to the software's website, GnuCash.org. Features include modules for vendors, customers, jobs, invoices, accounts receivables and payables. The software also provides reports and graphs as needed and relies on SQLite3, MySQL or Postgre SQL databases to store data.
XTuple Postbooks
Besides the standard accounting features, which include the general ledger, accounts receivable and payable, XTuple includes an integrated customer relationship management (CRM) platform with product definition, inventory, light manufacturing, and sales and purchasing features. This software works well for the small-to-medium business that provides customer inventory and may handle light manufacturing. The software runs on Windows, Mac and Linux systems.
TurboCash
The open-source software's website compares TurboCash to commercial software programs QuickBooks and Sage. Functions it includes in its software include general ledger, VAT accounting, bank reconciliation, invoicing, information for debtors and creditors, full reporting and analysis as well as room for more than one company or user. Applicable to multiple countries, the site provides an upgraded version for a fee.
Compiere
The Compiere open software website states that it 'automates all of your financial, distribution, sales and services processes and unifies your enterprise data in a single repository.' With customizable financial reports, Compiere also provides financial management and integrates enterprise-wide business processes and data.
In Feburary 2016 06,
How to Convert From Clob to Varchar2 in OracleIn Feburary 2016 06,
In Feburary 2016 06,
Start Oracle’s SQL*Plus program.
Type the following statement into SQL*Plus:SELECT dbms_lob.substr( clob_field, 4000, 1 ) FROM my_table;For “clob_field,” substitute the name of the clob field you want to convert to varchar2. Substitute the name of your data table for “my_table.” For example, if the clob field name is “budget_memo” and the table’s name is “budgets,” type the following statement:SELECT dbms_lob.substr( budget_memo, 4000, 1 ) FROM budgets;
Press 'Enter.' SQL*Plus executes the statement.
In Feburary 2016 06,
Start Oracle’s SQL*Plus program.
Type the following statement into SQL*Plus:SELECT dbms_lob.substr( clob_field, 4000, 1 ) FROM my_table;For “clob_field,” substitute the name of the clob field you want to convert to varchar2. Substitute the name of your data table for “my_table.” For example, if the clob field name is “budget_memo” and the table’s name is “budgets,” type the following statement:SELECT dbms_lob.substr( budget_memo, 4000, 1 ) FROM budgets;
Press 'Enter.' SQL*Plus executes the statement.
In Feburary 2016 06,
The Best Free Database for WindowsIn Feburary 2016 06,
In Feburary 2016 06,
Defined simply, a database is a structure that stores organized information, a natural task to assign to the powers of computers. Early computer databases were two-dimensional, with only rows and columns. Relational databases now work in a more three-dimensional fashion, as flat tables now interconnect, or relate, to other tables as part of a single database. A database system has two parts: the data storage component (or 'back end') and the user interface. The interface isn't necessarily part of the database program, however. It could be a website, for example, or a computer-based point-of-sale system.
The Importance of SQL
When discussing databases, the acronym SQL arises frequently. Structured Query Language is a standard language for asking questions, generating reports from and updating a database. Web scripting languages, such as PHP, can use SQL commands to connect a Web page to a database. Standalone database programs use SQL internally, so your queries and reports may use SQL functions without the need to fully understand the operations. Database servers may require a client to allow you to browse data and issue SQL commands.
Alternatives to Microsoft Access
Microsoft Access was, for years, part of the Office Productivity Suite, but as of 2010, the home edition of the package no longer includes the database. Replacing Access requires a database program that gives you the tools to not only build a database, but also creates data entry forms and reports. Free programs in this class include Base, part of the Apache Software Foundation's OpenOffice productivity suite, Kexi 2 and Axisbase.
Database Infrastructures
When you have a front end for your database that stands apart from the stored data, such as an online store, for example, your database needs change. The need for forms to enter your data is removed, so only a back end database manager is needed. These are called database servers, whether the software physically resides on a hardware server or not. Free offerings include Microsoft's SQL Server Express, MySQL and Firebird.
In Feburary 2016 06,
Defined simply, a database is a structure that stores organized information, a natural task to assign to the powers of computers. Early computer databases were two-dimensional, with only rows and columns. Relational databases now work in a more three-dimensional fashion, as flat tables now interconnect, or relate, to other tables as part of a single database. A database system has two parts: the data storage component (or 'back end') and the user interface. The interface isn't necessarily part of the database program, however. It could be a website, for example, or a computer-based point-of-sale system.
The Importance of SQL
When discussing databases, the acronym SQL arises frequently. Structured Query Language is a standard language for asking questions, generating reports from and updating a database. Web scripting languages, such as PHP, can use SQL commands to connect a Web page to a database. Standalone database programs use SQL internally, so your queries and reports may use SQL functions without the need to fully understand the operations. Database servers may require a client to allow you to browse data and issue SQL commands.
Alternatives to Microsoft Access
Microsoft Access was, for years, part of the Office Productivity Suite, but as of 2010, the home edition of the package no longer includes the database. Replacing Access requires a database program that gives you the tools to not only build a database, but also creates data entry forms and reports. Free programs in this class include Base, part of the Apache Software Foundation's OpenOffice productivity suite, Kexi 2 and Axisbase.
Database Infrastructures
When you have a front end for your database that stands apart from the stored data, such as an online store, for example, your database needs change. The need for forms to enter your data is removed, so only a back end database manager is needed. These are called database servers, whether the software physically resides on a hardware server or not. Free offerings include Microsoft's SQL Server Express, MySQL and Firebird.
In Feburary 2016 06,
Subscribe to:
Comments (Atom)