Results 1 to 7 of 7

Thread: Basics of My SQL

  1. #1
    Join Date
    Jan 2011
    Posts
    26

    Basics of My SQL

    I have just taken an admission in Java crash course where I need they people tend to use My SQL database along with the java programs. Now I don't have any idea about how My Sql works and how to make tables and etc in it. I mean to say I am totally new to My Sql thing. Can you guys guide me through the basics of My Sql?

  2. #2
    Join Date
    Apr 2009
    Posts
    569

    Re: Basics of My SQL

    MySQL is an SQL based RDBMS that executes only on a broad array of operating systems. MySQL is often used by PHP and Perl scripts. You need to get the SQL commands that apply to MySQL operating under all operating systems. But these instructions are according to the Windows OS. The spotlight is on Windows XP Professional and Windows 2000 Professional based computer machines. If you are running Windows 95, 98 or Me then please do not run mysqld installation because those operating systems are not capable to host a "service." So, you need to run MySQL as a standalone application by executing the command mysqld --standalone .

  3. #3
    Join Date
    May 2009
    Posts
    543

    Re: Basics of My SQL

    As soon as you finish activating the "MySQL 50 Shortcut" that you have created then starts typing the following.

    Code:
    mysql-u root-p
    then enter your password when prompted. You will then see the following output:
    Code:
    Welcome to the MySQL monitor.  Commands end with; or \ g.
     Your MySQL connection id is 1 to server version: 5.0.51b
    
     Type 'help;' or '\ h' for help.  Type '\ c' to clear the buffer.
    If you have got any error states that the client is not having support authentication protocol asked by server then you need to upgrading SQL client while trying to connect, This means that your client is using an older version then 4.1 whereas the server you are connecting to is using version 4.1 or later. The best resolution is to install a current version of the MySQL client.

  4. #4
    Join Date
    May 2009
    Posts
    637

    Re: Basics of My SQL

    Instruct to setup a new MySQL database
    Code:
    mysql 5.0.51b> create database database01; 
     Database database01 "created.
    Ultimately it would be creating a new subdirectory in your M: \ mysql50 \ data directory. Now Open the database
    Code:
    mysql 5.0.51b> use database01 
     Database changed
    To Create a table
    Code:
    mysql 5.0.51b> create table table01 (field01 integer, field02 char (10)); 
     Query OK, 0 rows affected (0.00 sec)

  5. #5
    Join Date
    May 2009
    Posts
    529

    Re: Basics of My SQL

    The MySQL command line interface will let you to put a command on single line or stretch it across numerous lines. There's no dissimilarity in syntax among both of them. With various lines you would be able to break down the SQL statement into steps so that you can comprehend them easily. In multiple line mode, the interpreter reads those all lines as it should be reading. This will go on till a semicolon ";" comes to end the SQL statement. As soon as you press enter key after semi-colon then statement gets executed.

  6. #6
    Join Date
    Feb 2011
    Posts
    40

    Re: Basics of My SQL

    Creating a Database in MySQL-
    The CREATE statement is used to create a database.
    Syntax:
    CREATE DATABASE tablename;
    e.g.
    CREATE DATABASE database1;

    Creates a database named database1.

  7. #7
    Join Date
    May 2009
    Posts
    539

    Re: Basics of My SQL

    Once you are aware of some rudimentary commands in order to run a database in MySQL. As MySQL is operated by running SQL calls, you have a large array of extremely powerful tools at your disposal. For example, you're capable of showing data from more than a few tables at the same time by joining related fields. Likewise, SQL lets you run complex displays, updates or deletions of several records that fits detailed criteria.

Similar Threads

  1. Basics of accounting
    By Baijnath in forum Off Topic Chat
    Replies: 4
    Last Post: 19-11-2010, 03:23 PM
  2. Basics of PL/SQL programs
    By Laquan in forum Software Development
    Replies: 5
    Last Post: 15-02-2010, 04:35 PM
  3. Basics of NetBeans IDE
    By - Empty Shell - in forum Software Development
    Replies: 4
    Last Post: 14-02-2010, 04:56 AM
  4. PHP Course : Basics
    By Gyan Guru in forum Guides & Tutorials
    Replies: 1
    Last Post: 20-11-2008, 01:10 PM
  5. Java Programming Language Basics: Reflection Basics and Class Class
    By mayuri_gunjan in forum Guides & Tutorials
    Replies: 6
    Last Post: 29-08-2005, 12:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,659,698.53561 seconds with 17 queries