In Feburary 2016 26,
A computer engineer must have extensive technical skills to design and choose software components for a project. This includes understanding technical language, such as C++, Java, JavaScript, HTML, CSS, SERVLET and UML design. It also includes recognizing the major differences between operating systems like Windows, DOS, Mac and Linux. Some computer engineers also work with computer databases like MySQL, Access and Oracle.
Communication Skills
Communication and interaction is a vital part of a computer engineer's job. He must interact with managers or business owners for company projects or directly with customers, if the computer engineer is working on developing solutions for customers. The computer engineer must communicate the possibilities of the given project budget, update customers or managers on the progress of projects and be able to conduct presentations on the computer development projects.
Research and Training Skills
A computer engineer must also have extensive research and training skills, especially if placed in a managerial position. Computer sciences and possibilities in the information technology and computer industry are constantly evolving and expanding. The computer engineer must be able to research and learn new programming options and skills to provide the best possible outcome for companies or customers. The computer engineer should also be able to train coworkers or employees in these new skills and programming options.
Decision-Making and Troubleshooting Skills
Computer engineers frequently work with the design and development process of computer software on behalf of customers or within a company. The computer engineer must be able to make the best decisions for the program development project in question. This is done by combining the technical skills and knowledge with the demands and needs of the customers or company. If something does not work throughout the design and development process, the computer engineer must also be able to troubleshoot to repair the issues. This can be a clash of software programs or operation systems, for instance. These skills need to be honed for computer engineer manager positions.
In Feburary 2016 26,
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
Friday, 26 February 2016
Wednesday, 17 February 2016
How to Reinstall MySQL for UbuntuIn Feburary 2016 17,
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
How to Restart MySQL in PleskIn Feburary 2016 17,
In Feburary 2016 17,
Log in to your server computer using administrative rights.
Open the terminal window based on the kind of operating system you are using.
Type the following command to restart MySQL for Linux-based systems and press the 'Enter' key:/etc/rc.d/init.d/mysqld restart
Type the following command to restart MySQL for FreeBSD systems and press the 'Enter' key:/usr/local/etc/rc.d/mysql-server.sh restart
Close your terminal window once you have finished restarting your MySQL server.
In Feburary 2016 17,
Log in to your server computer using administrative rights.
Open the terminal window based on the kind of operating system you are using.
Type the following command to restart MySQL for Linux-based systems and press the 'Enter' key:/etc/rc.d/init.d/mysqld restart
Type the following command to restart MySQL for FreeBSD systems and press the 'Enter' key:/usr/local/etc/rc.d/mysql-server.sh restart
Close your terminal window once you have finished restarting your MySQL server.
In Feburary 2016 17,
Friday, 12 February 2016
How to Connect PHP to MySQL Using WAMPIn Feburary 2016 12,
In Feburary 2016 12,
Launch a plain text editor, such as the Notepad, and create a new file.
Enter the script to connect PHP to a MySQL database by passing the hostname, username and password. For example, type:<?php
mysqli_connect('localhost', 'username', 'password') or die('Connection failed! ' . mysqli_error());
echo 'Connection successful!';
?>
Save the file as 'connect.php' and place it in the 'htdocs' directory for your WAMP implementation.
Test the connection by opening
connect.php in a Web browser and confirm that the connection was successful.
In Feburary 2016 12,
Launch a plain text editor, such as the Notepad, and create a new file.
Enter the script to connect PHP to a MySQL database by passing the hostname, username and password. For example, type:<?php
mysqli_connect('localhost', 'username', 'password') or die('Connection failed! ' . mysqli_error());
echo 'Connection successful!';
?>
Save the file as 'connect.php' and place it in the 'htdocs' directory for your WAMP implementation.
Test the connection by opening
connect.php in a Web browser and confirm that the connection was successful.
In Feburary 2016 12,
Tuesday, 9 February 2016
How to Create a MySQL TableIn Feburary 2016 09,
In Feburary 2016 09,
Write the skeleton of the CREATE command. In this example, the table is named 'customers.' Replace 'customers' with the name of the table you want to create. Example:
CREATE TABLE customers (
);
Create an id column. All tables should have an id column to uniquely identify that row, since two rows can exist with identical data. Without an id column, it would be impossible to tell the two rows apart.
Define the id column as an integer. It should also be an AUTO_INCREMENT column. This means MySQL keeps track of the id numbers for you in sequential order. Example:
id INTEGER AUTO_INCREMENT,
Remember that an AUTO_INCREMENT column is also required to be a primary key and add this line. Example:
PRIMARY KEY (id)
Create a string column using the VARCHAR column type. A VARCHAR(n) will hold up to n characters but no more, so be sure to choose an n that's large enough to hold all the data you'll need, yet short enough so it won't waste space. Example:
name VARCHAR(32),
Create a real number column. A 'real' number is anything but an integer. If, for example, you want to store a customer's balance, you'll need to store cents as well as dollars, so a FLOAT column type is also necessary. Example:
balance FLOAT,
Create an integer column. Here an INTEGER is used to track the number of purchases a customer has made. Example:
purchases INTEGER,
Create a date column. This example uses a DATE column to store the date of the first purchase. Example:
customer_since DATE,
Put the column types together. The command can be on multiple lines to make it easier to read and to store in files. The MySQL command-line client also allows for commands to be entered this way. Example:
CREATE TABLE customers (
id INTEGER AUTO_INCREMENT, name VARCHAR(128),
address VARCHAR(512),
ph_number VARCHAR(20),
email VARCHAR(64), balance FLOAT, purchases INTEGER, customer_since DATE, PRIMARY KEY (id)
);
In Feburary 2016 09,
Write the skeleton of the CREATE command. In this example, the table is named 'customers.' Replace 'customers' with the name of the table you want to create. Example:
CREATE TABLE customers (
);
Create an id column. All tables should have an id column to uniquely identify that row, since two rows can exist with identical data. Without an id column, it would be impossible to tell the two rows apart.
Define the id column as an integer. It should also be an AUTO_INCREMENT column. This means MySQL keeps track of the id numbers for you in sequential order. Example:
id INTEGER AUTO_INCREMENT,
Remember that an AUTO_INCREMENT column is also required to be a primary key and add this line. Example:
PRIMARY KEY (id)
Create a string column using the VARCHAR column type. A VARCHAR(n) will hold up to n characters but no more, so be sure to choose an n that's large enough to hold all the data you'll need, yet short enough so it won't waste space. Example:
name VARCHAR(32),
Create a real number column. A 'real' number is anything but an integer. If, for example, you want to store a customer's balance, you'll need to store cents as well as dollars, so a FLOAT column type is also necessary. Example:
balance FLOAT,
Create an integer column. Here an INTEGER is used to track the number of purchases a customer has made. Example:
purchases INTEGER,
Create a date column. This example uses a DATE column to store the date of the first purchase. Example:
customer_since DATE,
Put the column types together. The command can be on multiple lines to make it easier to read and to store in files. The MySQL command-line client also allows for commands to be entered this way. Example:
CREATE TABLE customers (
id INTEGER AUTO_INCREMENT, name VARCHAR(128),
address VARCHAR(512),
ph_number VARCHAR(20),
email VARCHAR(64), balance FLOAT, purchases INTEGER, customer_since DATE, PRIMARY KEY (id)
);
In Feburary 2016 09,
Sunday, 7 February 2016
How to Create a Forum WebsiteIn Feburary 2016 07,
In Feburary 2016 07,
Register a domain name for your website at a domain name registrar such as FreeHostia or GoDaddy (see Resources).
Buy a web hosting package to host your website online. Hosting is available from the domain name registrars listed above and many different sites. Buy a package that includes at least one MySQL database.
Download and extract the newest version of the phpBB Installation Package from its official website (see Resources).
Upload every file and folder you just downloaded into the same public location on your website (such as yoursite.com/forum).
Open a web browser and navigate to the 'install' folder of wherever you put phpBB. If you put it in yoursite.com/forum, go to yoursite.com/forum/install.
Click on the 'Install' tab and follow the on-screen instructions to install phpBB. If you get stuck, you can find detailed installation instructions in INSTALL.html and README.html, in the 'docs' folder.
Find extra add-ons for your forum and different visual styles from the phpBB website (see Resources).
Tell people to come to your site and start talking.
In Feburary 2016 07,
Register a domain name for your website at a domain name registrar such as FreeHostia or GoDaddy (see Resources).
Buy a web hosting package to host your website online. Hosting is available from the domain name registrars listed above and many different sites. Buy a package that includes at least one MySQL database.
Download and extract the newest version of the phpBB Installation Package from its official website (see Resources).
Upload every file and folder you just downloaded into the same public location on your website (such as yoursite.com/forum).
Open a web browser and navigate to the 'install' folder of wherever you put phpBB. If you put it in yoursite.com/forum, go to yoursite.com/forum/install.
Click on the 'Install' tab and follow the on-screen instructions to install phpBB. If you get stuck, you can find detailed installation instructions in INSTALL.html and README.html, in the 'docs' folder.
Find extra add-ons for your forum and different visual styles from the phpBB website (see Resources).
Tell people to come to your site and start talking.
In Feburary 2016 07,
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 Check MySQL Null on PHPIn Feburary 2016 06,
In Feburary 2016 06,
Open your PHP source file in a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to send a MySQL query to the active database. For example, '$result=mysql_query('Select my_var from my_table');'.
Use the 'mysql_fetch_assoc(result)' function inside a 'while' loop to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($result)) {'.
Use the 'is_null(variable)' function inside the 'while' loop to determine if a field from a returned row has a NULL value. For example, if (is_null($my_values['my_var'])) { echo 'is NULL'; } }' will print 'is NULL' for any values of 'my_var' that are NULL.
Save the PHP file.
In Feburary 2016 06,
Open your PHP source file in a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to send a MySQL query to the active database. For example, '$result=mysql_query('Select my_var from my_table');'.
Use the 'mysql_fetch_assoc(result)' function inside a 'while' loop to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($result)) {'.
Use the 'is_null(variable)' function inside the 'while' loop to determine if a field from a returned row has a NULL value. For example, if (is_null($my_values['my_var'])) { echo 'is NULL'; } }' will print 'is NULL' for any values of 'my_var' that are NULL.
Save the PHP file.
In Feburary 2016 06,
How to Create a Table in GoDaddy With MySQLIn Feburary 2016 06,
In Feburary 2016 06,
Open a Web browser. Navigate to the GoDaddy website and log in to your customer account. At the top of the window, click the 'Database' tab to open a list of database management features.
Click the 'Run Query' link to open a query manager. Click 'MySQL' to open a view of your database. You can create tables, delete tables and edit table information in the phpMyAdmin application.
Type the following code to create a GoDaddy table:create table customer(id int,name varchar(50))In this example, a customer table is created with two columns: ID and name. You can add as many columns as you need in the table. Separate each column definition with a comma.
Click the 'Run' button. The application creates the table and sets up the columns. After the page refreshes, the new table is displayed in the phpMyAdmin window.
In Feburary 2016 06,
Open a Web browser. Navigate to the GoDaddy website and log in to your customer account. At the top of the window, click the 'Database' tab to open a list of database management features.
Click the 'Run Query' link to open a query manager. Click 'MySQL' to open a view of your database. You can create tables, delete tables and edit table information in the phpMyAdmin application.
Type the following code to create a GoDaddy table:create table customer(id int,name varchar(50))In this example, a customer table is created with two columns: ID and name. You can add as many columns as you need in the table. Separate each column definition with a comma.
Click the 'Run' button. The application creates the table and sets up the columns. After the page refreshes, the new table is displayed in the phpMyAdmin window.
In Feburary 2016 06,
Friday, 5 February 2016
How to Display Text From MySQL in PHPIn Feburary 2016 05,
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Tuesday, 2 February 2016
How to Open MySQL Database With MS AccessIn Feburary 2016 02,
In Feburary 2016 02,
Type 'Data Sources (ODBC)' in the search box on 'Start.' Click the result and enter your administrative password if necessary. Click 'System DSN.' Choose the MySQL driver from the list and click 'Finish.'
Click 'Add Data Source Name.' Enter all of the information for your MySQL database, such as the name, server, username and password. Click 'OK.'
Open Microsoft Access.
Click 'File.' Select the option 'Get External Data.' Click 'Link Tables.'
Select 'ODBC Databases ()' in the explorer window that opens. Select the MySQL data source.
Click 'Select All' to import all of your MySQL tables into Access. Click 'OK.'
In Feburary 2016 02,
Type 'Data Sources (ODBC)' in the search box on 'Start.' Click the result and enter your administrative password if necessary. Click 'System DSN.' Choose the MySQL driver from the list and click 'Finish.'
Click 'Add Data Source Name.' Enter all of the information for your MySQL database, such as the name, server, username and password. Click 'OK.'
Open Microsoft Access.
Click 'File.' Select the option 'Get External Data.' Click 'Link Tables.'
Select 'ODBC Databases ()' in the explorer window that opens. Select the MySQL data source.
Click 'Select All' to import all of your MySQL tables into Access. Click 'OK.'
In Feburary 2016 02,
How to Connect to the MySQL ServerIn Feburary 2016 02,
In Feburary 2016 02,
Connect to a MySQL server running on localhost. The MySQL command-line client's default behavior is to connect to a server running on localhost. This will connect to the server on localhost as the root user with no password. Example:
mysql -u root
Connect to a MySQL server using a password by adding the -p switch. This will connect to localhost as root and prompt you for a password. Example:
mysql -u root -p
Connect to a remote host using the -h switch. A remote host is any server other than localhost. Using the -h switch will connect to a MySQL server running on example.com as root and prompting for a password. Example:
mysql -u root -p -h example.com
Connect to a remote host running on a non-default port, using the -P switch. Note that this command uses a capital P. It should not be confused with the lowercase -p switch, which means prompt for a password. Using the -P switch will connect, as the root user, to a MySQL server running on example.com port 3330 and prompt for a password. Example:
mysql -u root -p -h example.com -P 3330
Connect to a server and use a database. Specify the database to use on the command-line in place of connecting and manually issuing a USE command. It's faster and makes automated scripts work better. Simply add the name of the database onto the end of the MySQL client command-line. This example connects to the database as root and uses the customers database. Example:
mysql -u root -p -h example.com -P 3330 customers
In Feburary 2016 02,
Connect to a MySQL server running on localhost. The MySQL command-line client's default behavior is to connect to a server running on localhost. This will connect to the server on localhost as the root user with no password. Example:
mysql -u root
Connect to a MySQL server using a password by adding the -p switch. This will connect to localhost as root and prompt you for a password. Example:
mysql -u root -p
Connect to a remote host using the -h switch. A remote host is any server other than localhost. Using the -h switch will connect to a MySQL server running on example.com as root and prompting for a password. Example:
mysql -u root -p -h example.com
Connect to a remote host running on a non-default port, using the -P switch. Note that this command uses a capital P. It should not be confused with the lowercase -p switch, which means prompt for a password. Using the -P switch will connect, as the root user, to a MySQL server running on example.com port 3330 and prompt for a password. Example:
mysql -u root -p -h example.com -P 3330
Connect to a server and use a database. Specify the database to use on the command-line in place of connecting and manually issuing a USE command. It's faster and makes automated scripts work better. Simply add the name of the database onto the end of the MySQL client command-line. This example connects to the database as root and uses the customers database. Example:
mysql -u root -p -h example.com -P 3330 customers
In Feburary 2016 02,
How to Flush a Slow Query Log in MySQLIn Feburary 2016 02,
In Feburary 2016 02,
Connect to a remote MySQL server through SSH, or open a terminal window if you are located with the physical server.
Type “cd mysql-data-directory” at the command prompt, replacing mysql-data-directory with the path to the location of the mysql data files on your server. By default, the data directory is located in /var/lib/mysql .
Rename the current log files if you want to keep a copy for analysis, by typing the following at the command line.mv mysql.log mysql.old
mv mysql-slow.log mysql-slow.old
Flush the log files by typing at the command prompt:mysqladmin flush-logsMySQL closes any existing log files, and then reopens them as new files with the same names.
In Feburary 2016 02,
Connect to a remote MySQL server through SSH, or open a terminal window if you are located with the physical server.
Type “cd mysql-data-directory” at the command prompt, replacing mysql-data-directory with the path to the location of the mysql data files on your server. By default, the data directory is located in /var/lib/mysql .
Rename the current log files if you want to keep a copy for analysis, by typing the following at the command line.mv mysql.log mysql.old
mv mysql-slow.log mysql-slow.old
Flush the log files by typing at the command prompt:mysqladmin flush-logsMySQL closes any existing log files, and then reopens them as new files with the same names.
In Feburary 2016 02,
Monday, 1 February 2016
How to Tell if MySQL Is 32In Feburary 2016 01,
In Feburary 2016 01,
Open a terminal or access the command line on the server your MySQL database is installed on.
Type 'which mysqld' to locate where the database is installed. The command line will return a path similar to '/bin/mysql.'
Type 'file ' into the command line and press 'Enter.' Replace '' with the installation path found in the previous step.
Examine the data returned by the system. If you have a 32-bit version of MySQL installed, the line will begin 'ELF 32-bit LSB executable.' If you have a 64-bit version of MySQL, the line will read 'ELF 64-bit LSB executable.'
Query the Database Version from Within MySQL
Run MySQL and use the MySQL query command line to determine the installation version.
Type 'SHOW GLOBAL VARIABLES LIKE 'version_compile_machine';' into the prompt and press 'Enter' to execute the query.
Examine the query results to determine the version of MySQL you are running. A 32-bit version will display 'i686' in the results next to 'version_compile_machine.' A 64-bit version will display 'x86_64' in the results next to 'version_compile_machine.'
In Feburary 2016 01,
Open a terminal or access the command line on the server your MySQL database is installed on.
Type 'which mysqld' to locate where the database is installed. The command line will return a path similar to '/bin/mysql.'
Type 'file ' into the command line and press 'Enter.' Replace '' with the installation path found in the previous step.
Examine the data returned by the system. If you have a 32-bit version of MySQL installed, the line will begin 'ELF 32-bit LSB executable.' If you have a 64-bit version of MySQL, the line will read 'ELF 64-bit LSB executable.'
Query the Database Version from Within MySQL
Run MySQL and use the MySQL query command line to determine the installation version.
Type 'SHOW GLOBAL VARIABLES LIKE 'version_compile_machine';' into the prompt and press 'Enter' to execute the query.
Examine the query results to determine the version of MySQL you are running. A 32-bit version will display 'i686' in the results next to 'version_compile_machine.' A 64-bit version will display 'x86_64' in the results next to 'version_compile_machine.'
In Feburary 2016 01,
Subscribe to:
Comments (Atom)