Premium Essay

Mysql

In: Computers and Technology

Submitted By marianontulan
Words 704
Pages 3
|

Handy MySQL Commands | Description | Command | To login (from unix shell) use -h only if needed. | [mysql dir]/bin/mysql -h hostname -u root -p | Create a database on the sql server. | create database [databasename]; | List all databases on the sql server. | show databases; | Switch to a database. | use [db name]; | To see all the tables in the db. | show tables; | To see database's field formats. | describe [table name]; | To delete a db. | drop database [database name]; | To delete a table. | drop table [table name]; | Show all data in a table. | SELECT * FROM [table name]; | Returns the columns and column information pertaining to the designated table. | show columns from [table name]; | | | | | Show certain selected rows with the value "whatever". | SELECT * FROM [table name] WHERE [field name] = "whatever"; | | | | | Show all records containing the name "Bob" AND the phone number '3444444'. | SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444'; | | | | | Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field. | SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number; | | | | | Show all records starting with the letters 'bob' AND the phone number '3444444'. | SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444'; | | | | | Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a. | SELECT * FROM [table name] WHERE rec RLIKE "^a$"; | | | | | Show unique records. | SELECT DISTINCT [column name] FROM [table name]; | | Show selected records sorted in an ascending (asc) or descending (desc). | SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC; | | Count rows. | SELECT COUNT(*) FROM...

Similar Documents

Free Essay

Mysql Cluster

...MySQL Cluster Quick Start Guide – LINUX This guide is intended to help the reader get a simple MySQL Cluster database up and running on a single LINUX server. Note that for a live deployment multiple hosts should be used to provide redundancy but a single host can be used to gain familiarity with MySQL Cluster; please refer to the final section for links to material that will help turn this into a production system. 1 Get the software For Generally Available (GA), supported versions of the software, download from http://www.mysql.com/downloads/cluster/ Make sure that you select the correct platform – in this case, “Linux – Generic” and then the correct architecture (for LINUX this means x86 32 or 64 bit). If you want to try out a pre-GA version then check http://dev.mysql.com/downloads/cluster/ Note: Only use MySQL Server executables (mysqlds) that come with the MySQL Cluster installation. 2 Install Locate the tar ball that you’ve downloaded, extract it and then create a link to it: [user1@ws2 ~]$ tar xvf Downloads/mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23.tar.gz [user1@ws2 ~]$ ln -s mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23 mysqlc Optionally, you could add ~/mysqlc/bin to your path to avoid needing the full path when running the processes. 3 Configure For a first Cluster, start with a single MySQL Server (mysqld), a pair of Data Nodes (ndbd) and a single management node (ndb_mgmd) – all running on the same server. Create folders to store the......

Words: 848 - Pages: 4

Free Essay

Benefits of Mysql Carrier Grade Edition for

...------------------------------------------------- Benefits of MySQL Carrier Grade Edition for Subscriber Databases * Standards Based, Open Source database allows vendors and users of subscriber data management solutions to easily integrate their applications with MySQL Carrier Grade Edition using their preferred database-independent Subscriber API, e.g., LDAP, SQL, C++, Java, HTTP, etc. * High Performance with a Shared-Nothing, Distributed Database that provides realtime access to in-memory subscriber data with just a few milliseconds latency for reads and writes, and can be scaled out by adding additional resources or by storing data on disk. * 99.999% Availability achieved by synchronously replicating in-memory data across active nodes in the cluster with recovery data being asynchronously written to disk, and by optionally “geo”-replicating data off-site to a remote active or standby cluster. * Self-Healing of data nodes with sub-second fail-over times, and an optimized node recovery protocol that automatically re-synchronizes data across re-starting data nodes. Geo-replication enables self-healing across dispersed sites, where the system can continue functioning correctly in the event of site failure. * Distribution-Awareness in a Shared-Nothing Database is enabled in MySQL Cluster with the partitioning of tables by subscriber identifiers, and by using those identifiers when accessing subscriber data to ensure that reads/writes are localized to the......

Words: 407 - Pages: 2

Free Essay

Abc Ia S Aresume

...queries. This application also uses advanced mechanism of using UDF (User Data File) which is used to protect the health care dataset. Responsibilities: Moved all personal health care data from database to HDFS for further processing. Developed the Sqoop scripts in order to make the interaction between Hive and MySQL Database Wrote MapReduce code for DE-Identifying data. Loaded the processed results into Hive tables. Generated test cases using MRunit. Best-Buy – Rehosting of Web Intelligence project The purpose of the project is to store terabytes of log information generated by the ecommerce website and extract meaning information out of it. The solution is based on the open source Big Data s/w Hadoop .The data will be stored in Hadoop file system and processed using PIG scripts. Which intern includes getting the raw html data from the websites, Process the html to obtain product and pricing information, Extract various reports out of the product pricing information and Export the information for further processing. This project is mainly for the re platforming of the current existing system which is running on Web Harvest a third party JAR and in MySQL DB to a new cloud solution technology called Hadoop which can able to process large date sets (i.e. Tera bytes and Peta bytes of data) in order to meet the client requirements with the...

Words: 500 - Pages: 2

Premium Essay

First Essay

...configuration management, documentation and closure with cross-cultural teams, * Demonstrated excellence in development of various enhancements that not only facilitated development efforts but also made the product truly friendly to customer, * An energetic, self-motivated team member with hands on experience in programming skills, requirements gathering, designing etc. Skills Domain Skills | Web Based Applications | Java/J2EE Technologies | JDK, J2EE | Internet Technologies | HTML, CSS,jQuery | CMS Frameworks | Oracle Webcenter Sites (Fatwire), DOTCMS | ORM Frameworks | Hibernate | Web/App Servers | Apache Tomcat | Java I.D.E /Tools | Eclipse | RDBMS | MySql 5 | Logging | Apache Log4J, Commons logging | Operating Systems | Windows 98/XP/Windows7, LINUX | Database Tools | SQL Yog, MySql Query Browser....

Words: 966 - Pages: 4

Free Essay

Mysql

...Head: MySQL 1 MySQL University: Name: Course: Tutor: Date: Running Head: MySQL 2 Abstract MySQL is basically an open-source Relational Database Management System (RDBMS) which is moderately well-known for light-weight website application programs. Over the last few decades, the software tool has also included various functionalities which let it to be adopted for larger company resources. This document will provide a brief introduction to the particular software tool. MySQL does not possess as many functions as PostgreSQL, and majority of the more innovative functions are not as mature as well. Though, the software programmer would expect it to work considerably better than due to its thread-based architecture (PostgreSQL works on a process-based architecture). Summary of the Tool: MySQL MySQL is a well-known open source database. It is formally pronounced as “My Ess Que Ell”, not my sequel. MySQL is capable to manage very large databases and it has a highly efficient performance (Kofler, 2001). The software tool of MySQL is primarily written in the language C/C++. It is developed by following the client-server architecture. This particular tool is available for MS Windows, Solaris, Linux and some other operating systems. MySQL is widely used among individual students and larger Organizations due to the following reasons.   MYSQL is almost free of cost; it is much less expensive than Oracle (Petri, 2005). Each and every individual student can set up MySQL......

Words: 849 - Pages: 4

Free Essay

E-Commerce and System Design

...Unit 3 Individual Project Victoria Kane MGMT305-1301A-04 Management Information Systems March 3, 2013 American Intercontinental University Abstract The paragraphs below will detail the technicalities of an e-commerce website for Steve’s Used Appliances. Unit 3: E-Commerce and System Design When starting up an e-commerce website, the first thing to decide upon is the type of business model that will be used for the foundation of the website. The internet business model that best applies to Steve’s Used Appliances is affiliate marketing. In this model, a business pays off one or more affiliates for their marketing efforts to broaden the scope of customers. (Boris, 2011) This model will be the most helpful for a used appliance store because of the fact that appliances are not easy to sell. Having an affiliate model opens the door for other larger businesses to spread the word on this smaller business. Steve’s Used Appliances can definitely benefit from the creation of an e-commerce website. Having a website will make it possible for the company to get out information about their products and services without wasting money on postage, publicizing, or couriers. It also makes it possible for this small business to reach customers from cities farther away than they would with simple newspaper ads or commercials. An e-commerce website also provides several functions for a business. These functions are usually in reference to marketing, sales, customer support, and......

Words: 828 - Pages: 4

Free Essay

National Bookstore

...Parfait Payroll System Highly Customizable Payroll System   This payroll system have the ff feature : * web-based payroll ( cloud ready ) * free mysql database * runs on Linux,Windows and Mac * WAN / LAN / Single Connection ready * Designed for Philippine Settings * Unlimited number of employees * Unlimited number of users       * Multi Division / Department / Branch / Cost Centers ready * Multi-bank support * User maintainable updates on SSS, PhilHealth, Pagibig and Tax tables * Loan file maintenance, Unlimited Loan Type, automatic deduction with loan status monitoring * Unlimited Other Income Type * Batch Upload of Attendance, Loans, Deductions and Other Income via MS Excel * Leave Monitoring, Leave conversion available * Bonus,Mid-Year,13th month and others benefits available * Company Employees Cooperative available * HMO,COOP support available * Doctor and Nurses, Drivers and Helper support available * Employment agency / BPO support available. * Government payroll support available * support for biometric devices available ( part of  HRIS - Time and Attendance ) * Project Time Management System available as replacement for bio-metric  ( part of HRIS - Time and Attendace ) * Multiple option on Statutory Deduction * 100% Government Compliance * Sending Payslip via email this payroll is ideal for : Private, Government, Project Based Payroll, Employment Agency, Hospital, Trucking, Cooperative......

Words: 353 - Pages: 2

Free Essay

I Dont Know About This

...Technology from XYZ Institute of Technology, Indore. * Proficient in finding and resolving malfunctions, using exceptional technical and communication skills. * Ability to express technical concepts clearly to people with no technical background. * Worked on academic project Restaurant Billing System and Staff Management System. * Adept in database MySQL and Programming language JAVA and Internet Applications. * Conversant with Bootstrap 3, Drupal, Wordpress, Adobe Dreamweaver and Big Data Handoop. * An effective communicator with excellent interpersonal, logical thinking & analytical abilities. ------------------------------------------------- ACADEMIC PROJECTS Project Title : Restaurant Billing System Organization : Tata International Ltd. Platform Used : C++ Contribution : Analysis and Coding Description : This project dealt with avoiding paper work in restaurants and switching over to computerized billing of items for a well organized manner. Project Title : Staff Management System Organization : College Staff Management Platform Used : JAVA as programming language and MYSQL as database. Contribution : Analysis and Coding...

Words: 369 - Pages: 2

Premium Essay

Hostel

...Chapter-1 1.1 Introduction Android is an software platform and operating system for mobile devices. It is based on the Linux kernel. It was developed by Google and later the Open Handset Alliance (OHA). It allows writing managed code in the Java language. Due to Android here is the possibility to write applications in other languages and compiling it to ARM native code. Unveiling of the Android platform was announced on 5 November 2007 with the founding of OHA. It's a consortium of several companies 1.1.1 Introduction to Project Environment OPERATING SYSTEM: An operating system (OS) is software consisting of programs and data hostel management system project report runs on computers and manages computer hardware resources and provides common services for efficient execution of various application software. For hardware functions such as input and output and memory allocation, the operating system acts as an intermediary between application programs and the computer hardware, although the application code is usually executed directly by the hardware and will frequently call the OS or be interrupted by it. Operating systems | | Common Features: * Process management * Interrupts * Memory......

Words: 15019 - Pages: 61

Free Essay

My Resume

...Anik Mondal Email: anik28042012@gmail.com Permanent Address: Mobile No : +918697070645 Flat No 8,60/11,Andul 1st Bye lane,P.O – Danesh sk lane P.S – Shibpur,Dist – Howrah,West Bengal - 711109 |Career Objective | To work in a productive environment with ample opportunities to build strong technical and professional skills and to experience sustained career growth. |Professional Summary | • Having experience in developing client/server web application using Java/J2EE technology • Proficient in use of Struts , Spring and Hibernet Framework • Good knowledge in exposing and consuming Web services • Versatile in J2EE technologies specially Servlets, JSP, JDBC, EJB • Good Knowledge in Java server programming and MVC-architecture |Working Profile | . Worked at Platoon......

Words: 705 - Pages: 3

Premium Essay

First World Savings and Loan

...Industry - Data Security Standard (PCI-DSS), and the Gramm-Leach-Bliley Act (GLBA). We must comply with SOX, because we are a publicly-traded financial institution; PCI-DSS, because we process online credit card transactions; and GLBA, because we are a financial institution. All of the regulations of these three compliancy laws must be met, while still maintaining the Confidentiality, Integrity, and Availability (CIA) triad. All security requirements for SOX, PCI-DSS, and GLBA can be achieved using Linux and open source infrastructure. Some examples of open source software that we might use are: Web Server - Apache Web Filtering - DansGuardian Network Firewall - Turtle Firewall VPN - Endian Firewall Community IDS/IPS - Suricata Database - MySQL File Server - Samba SMTP Server - hMailServer I would recommend that we use a "Defense in Depth" strategy, having multiple layers of access protection. We need to have an IDS/IPS on both sides of our edge firewall. The inside IDS/IPS will be used as additional protection for our network and the outside IDS/IPS will serve as an early warning system from attacks. We will also use the outside IDS/IPS for additional protection and to monitor what types of attacks are occurring. Our web server and mail server should be completely separated from the rest of our network in a de-militarized zone (DMZ). We need to have a network firewall between our DMZ and our internal...

Words: 964 - Pages: 4

Free Essay

Analyst

...PHP PHP code can be included alone inside a file or can be embedded inside the html code and runs on webserver. The PHP files have extension of .php. The PHP code syntax is: <?php ‘code goes here’ ?> We have to use semi colon at the end of each command/line. If we only have php code in a file, then we need to make sure that there is no space before the opening php tags or after the closing php tag. If the file extension is .php then we can only view that file through web browser where php is installed even if the file does not have any php code. On our local servers we need to store the files in the root folder, which for WAMP is C:\wamp\www. We also need to make sure that the local server is running. The local port is 80, if we are using a different port than standard then we need to specify that e.g. http://localhost:8888/. We can have as many blocks of php codes inside html as we want. However, we cant nest one php code inside another. We can also insert php code above the html code and that works perfectly fine. The php code directly works with the database so if we are not outputting anything in html the code above html code works just fine. . Period: Period is used to concatenate two strings. Variable: In PHP all variable name start with ‘$’ sign e.g. $name = ‘Ali’;. Remember ‘$this’ is a reserved variable so don’t use this. Some people use parenthesis around variable but it is completely optional to use. String: The php string works the same......

Words: 5458 - Pages: 22

Premium Essay

Winsnort and Apache Installation Instructions

...setup c drive, 8000, set d drive for rest in windows setup Mandatory prerequisites Only use the support programs included our 'AIO Software Pak'! Fresh install of Windows 2000/XP/2003 All Service Packs and Patches applied Hard Drive Partition 'C:/' (System) - Min 5 Gigabytes Hard Drive Partition 'D:/' (System) - Min 60 Gigabytes Make SURE the sensor has a Static TCP/IP settings and can get to the Internet Deactivate any Firewall application on the Windows Intrusion Detection System (WinIDS)! The new WinIDS sensor MUST be allowed to see ALL the network traffic. We would strongly suggest that the Microsoft Baseline Security Analyzer (MBSA) is used to identify and correct common security miss configurations and resolve each issue prior to starting this install. Pre-installation Tasks -Make SURE that 'Internet Information Services' has been removed prior to starting this guide. If your unsure, go into the add/remove programs, select 'add/remove windows components', make SURE the 'Internet Information Services' radio box is unselected, if selected, unselect 'Internet Information Services', and remove the application, and all associated components. -Edit hosts file 127.0.0.1 winids Download the 'WinIDS - All In One Software Pak' and extract the contents into the d:\temp folder. Installing the Basic Windows Intrusion Detection System (WinIDS) Install WinPcap Navigate to the d:\temp folder, double left-click on the 'WinPcap...' file,......

Words: 4494 - Pages: 18

Free Essay

Data Protection

...AND DISASTER RECOVERY FOR THE BR-DB01 MySQL DATABASE SERVER by Francis Nicholas Introduction This document discusses the recommended option for a long-term strategy for data protection and disaster recovery for the Sentrana MySQL and Infobright databases. After extensive research, the following components will provide for a long-term strategy for data protection and disaster recovery for the MySQL database server: 1. MySQL Master-Slave database server replication[1]. 2. Full daily and a full weekly backup of all databases on the master and slave servers respectively. a. Differential/incremental backups plan is currently under investigation. This is because a lot of articles I came across during my research advised against it due to the nature of its complexity and the level of difficulty in it implementation. 3. A clean up plan[3] that includes the removal of any database backups older than 7 days on the master server and 7 weeks on the slave server respectively. MySQL Master-Slave Database Server Replication The MySQL Master-Slave database server replication enables one database server, called the master, to be replicated to one or more MySQL servers, called slaves[4]. In our case, the master server will start off as the BR-DB01 database server. The server currently acting as Appserver-05 in the MarketMover environment is upgradeable to meet the present system and storage requirements needed for the slave MySQL server and manual failover for the......

Words: 1031 - Pages: 5

Free Essay

Gut1 Task 4

...documentation of a student management system program testing. The application is java based and using a client/server model wherein which the client inputs, updates and queries to a MySQL database on server end. The database stores student information and data. The information stored by the database is first name, last name, student ID, mentor, GPA , student status, thesis title and thesis advisor for graduate students.. The program also determines tuition cost based on the type of student and enrolled credit hours. The tuition is calculated for undergraduate, graduate and part-time. The program is to provide a tool to add, modify, query and delete student records. There are many methods of testing software applications. The testing performed in this documentation is to test the functionality of the program. The testing did not go in depth as far as looking at the specific code. The testing checks the user interface, which is command line in the program, database(MySQL), client and server functionality. The testing is performed manually from the end user point as documented in the herein contained Test Cases. The following requirements must be met to run the program: Java Integrated Development Environment (IDE), MySQL database. Netbeans 7.0.1 was utilized in making the program and testing it . MySQL is open source SQL database. They both can be downloaded for free of charge. Windows 7 OS was used to host both pieces of software. There are minimum......

Words: 929 - Pages: 4