Aug 8, 2008

Looking For Command Line Based Sql Modification - Program Needed For SQL?

Free Web Hosting, No Ads > CONTRIBUTE > Computers > Programming Languages > PHP Programming

free web hosting

Looking For Command Line Based Sql Modification - Program Needed For SQL?

alex1985
How I use Windows command prompt client and do modifications to my SQL database. If yes, please write the commads I should know for that. If no, please get me the software with which I can do it.

Notice from BuffaloHELP:
Topic title modified. Proper English is always required when posting in our forum.

Reply

jlhaslip
You need to have a Mysql (or similar) server installed on your machine. The best way to do that is with a one-click installer like XAMPP or WAMP which adds an Apache server, MySql, and PHP along with other stuff.
One of the 'other stuffs' will be phpMyAdmin, which is a graphical User Interface for your MySql databases.

The other method is to use the MySql Command Line Interpreter (CLI) from a DOS prompt, but that is terribly out of date.

MySql also has a GUI package, but I have never used it, so do not have an opinion.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. dos command creating mysql database with xampp - 431.69 hr back. (1)
Similar Topics

Keywords : command, line, based, sql, modification, program, needed, sql,

  1. Sending E-mails Based On Intervals?
    (7)
  2. Tutorial Needed?!
    PHP+Ajax (11)
    I need many tutorials based on PHP programming language and AJAX technology. Those tutorials might
    be of any kind. Please post only the links to the trusted and working tutorials!....
  3. Creating Something With Co-ordinates With Php.
    Something like you see in those web-based php games, like a map or som (12)
    Well, i was just wondering if something simple and basic could be made (like a small map where you
    could move around on, like you click up, and your position moves up and reports it to the
    database..etc) with co-ordinates in php . Taking the x-axis and the y-axis into consideration.
    Things like maps which online games have such as web-based space games or legacy-game.net. Thanks
    for any feedback, ~Aldo....
  4. Admin Page
    Tutorial Needed? (4)
    I need to look at a nice tutorial how do you create an admin access page with many functions as many
    as possible.....
  5. Tools Needed!
    PHP & MySQL (9)
    Hello, everyone! I need some tools for those two things to test PHP scripts coming together with
    database on my laptop, instead checking them on a web-server which takes time.....
  6. Php Code Needed Iii
    (10)
    Hello, everyone. I need your help again! Who might create the PHP code, the picture is
    above this text. Basically, I want when the user fill in all the information in this form, it
    automatically was sent to my email. And, then, the dialog box appears or on the same window, it was
    said that your request has been sent. Moreover, if the user did not fill the entire information,
    the dialog box appears stating that you did not fill some field. Thanks, for help. You always do
    that.....
  7. Php Code Needed
    Working Together? (5)
    Hello, everyone. I need your help again. This forum is quite good for it. Well, I need create a
    registration form for my web-site using PHP and SQL. The information it should contain: 1) User
    Name 2) First Name 3) Last Name 4) Password 5) e-mail Address 6) Security Image: that images helps
    to protect a random registration, for instance, 56+2=where user have to type an answer in order to
    finish registration. That's all for today. Anymore things, I will post another post over here.
    ....
  8. Php Code
    Needed?! (15)
    Well, I am a novice in PHP programming, so there is a script which I wanna get: 1. You go the
    web-site 2. On the main screen, there is a some kind of field windows, the one you get used to type
    in, when you go to google, for instance. 3. He or she types her email address and it's going to
    be saved in my SQL database. 4. That's it. Help me if you can.....
  9. Slaed Cms
    Book Needed!!! (2)
    Hello, everyone! I need some tutorial for Slaed Engine for any version you might find. I wanna
    learn how you can make modules or blocks for this CMS. Especially, library functions and other
    things that will make the web-site works like virtual library.....
  10. Remove A Value From A Php Array Based On Its Value
    (5)
    I have an index array CODE $array[0] = 10; $array[1] = 12; ...
    Its kinda late and I'm falling asleep now but I had a quick look through PHP.net, and could not
    find what I'm after, Maybe I'm too sleepy, sorry, but if anyone knows off the top of their
    head a way to removed members in that array based on its value, i.e. I wanna remove values 12. I
    don't really want to do a loop but if I cant find any existing function to do it, then I may
    have to. Thanks for any help.....
  11. Php And Irc
    PHP-based IRC web client (5)
    I am wondering whether or not you could create a basic client for IRC using PHP. I know that PHP
    does have IRC functions which I read about on php.net. I am not quite sure whether or not a client
    could be built around this. I do know that there is a CGI IRC client on the web. I use this while I
    am on my Wii I am wanting to incorporate a PHP IRC client into my website and use AJAX to
    automatically reload the chat. Well, if anybody could help that would be great.....
  12. Wamp Packages Needed To Test Scripts
    Set up Apache, PHP, etc on your machine (1)
    In order to test php scripts on your localhost machine, you require a system that includes php
    parsing. A WAMP set-up 'usually' includes a database server, and a database manager, too.
    For Windows machines, theses are usually referred to as WAMP because they include Apache, Mysql, and
    PHP for Windows, hence the acronym WAMP. Wikipedia has a listing of the available packages with
    details about the included versions and often a link to the wikipedia article describing them. The
    list can be found at http://en.wikipedia.org/wiki/Comparison_of_WAMPs Personally, I....
  13. Dynamically Select From 2 Tables Based On Id
    dynamically select from 2 tables based on id (1)
    hi there, im working on a performance request system, and i have three tables that im working with
    right now. the performances table holds the info about the performance (date, times, status, etc.),
    and has two columns, org_type and org_id, which both hold an int value to tell me where the
    organization info is. there are two org types which have respective tables, because we collect
    different information based on the type of org that is registering. is there any way to select info
    from all three tables (dynamically selecting between the two org tables based on org_type,....
  14. Creatting A Playlist Through Php
    script help needed (5)
    Hi I am trying to make a script so that i can insert songs into a playlist, but i need a script in
    which it opens the playlist file and removes the closing tag at the end, so before i can add more
    entrys. e.g CODE <atx> <entry>Location 5</entry> <entry>Location
    4</entry> <entry>Location 3</entry> <entry>Location
    2</entry> <entry>Location 1</entry> <atx> But to add more entrys
    i would have to get rid of the atx, then use the fputs to place the new entry into the file. ....
  15. Ipetsite Related Programming Help Needed
    iPetSite screwed me over (0)
    Ok so i you are anyone here who would like to hlp me with these files, please pm me your email. Here
    is what i need help with: Replacement of lost files Repair of corrupt files Configuring said files
    Help with setting up the site If you can help me, please let me know. If you would like to be an
    admin on my site, also let me know. Just I request that you don't post here unless you plan or
    intend to help some how.....
  16. Php Help Needed Including File In A Page.
    (2)
    i'm a noob in php programming, i can understand and modify php programs, but i dont know to
    write on my own. So please somebody who is well versed in php help me. My need is, I'm
    currently builiding a knowledge base website , i've my own design for the website, check here,
    http://laschatz.info/kzone/ Each page in the left hand site has a tree navigation of all the
    topics available. Since this information must be same in all the pages, presently I need to change
    all the pages after adding a new category. Could you please help me in such a way that I can ad....
  17. Add Users On Email Program With Php?
    (1)
    First of all Marry Christmas, Well so i am in some kind of a problem, i can't find out how to
    add users to my mail service, i have no idea what SMTP/IMAP program the server runs, neither does
    the system administrator. But it should be kinda the same thing for all of them if i am not wrong,
    Anyways i have full access to server so i can do whatever i want to do, i have SSH access too (Root
    access /rolleyes.gif" style="vertical-align:middle" emoid=":rolleyes:" border="0"
    alt="rolleyes.gif" /> )....
  18. Help Needed With Directory/file Listing Code Infinite Loop
    Made an infinite loop but why is this so? (5)
    Hi all ive got a small and simple (for the moment atleast /unsure.gif"
    style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> )file and directory
    listing script in php as follows CODE $dir = "."; $num = 0; $file =
    scandir($dir); while($file = scandir($dir)){     echo
    $file[$num];     echo "<BR>";     $num = $num + 1;     
    }; the concept is simple enough, the directory to start with is the current one, so scan this
    directory and wh....
  19. Php - Fsockopen, Get, Etc - Help Needed
    (1)
    Hi I am writing a PHP script that gets the search results from here . I can get the results from
    the first page fine, but when I try to get the next page, it doesn't return the correct results.
    Try comparing the results from here , and searching for "Vampire" (In the "Name" text box) here .
    The first page of results is the same, but when you go on the the second page of results, they are
    totally different. This I think is because the "persist_search" (see the URI on the Planet Elder
    Scrolls Search) always seems invalid. Is there any reason why the PHP would get....
  20. A Very Simple Album Problem, Help Needed.
    (3)
    Hey, I created a page album.php, it shows all the images of a user xxx. and its url is like
    album.php?nick=xxx. Now suppose there are 2 images in this user album, one image id is 111 and
    second image id is 112.now how i can link to the each image of the album so that it looks like ,
    album.php?nick=xxx&image_id=111. and album.php?nick=xxx&image_id=112. I hope you understand it.....
  21. Help Needed With Silly Error
    (8)
    Hi i have made a stupid error on one of my pages and having trouble finding it. It says unexpected
    ')' on line 114 can anyone please help me find it? Here is the page: CODE <? /** *
    * @package TibiaME Clan/Download Site * @version 1.00 2006/09/27 00:04:37 wappy * @copyright
    (c)2004-2006 wappyCULT * @home http://hack.s-60.org * @license You can use/modify this
    script but distributing it without permisinn, or removing the "Script By: wappy" link
    will invalidate your license and give wappy (wappyCULT) FULL RIGHTS to ....
  22. Php Post Command
    (6)
    Hello I've been trying to connect two PHP scripts that have their separate logins. I want to
    create a PHP script that will use POST to send the username/password to another PHP script. I tried
    a lot of scripts but I can't seem to make it work. I have no idea how to find out what is wrong,
    has anybody any experience in this field?....
  23. Question: Anybody Know How To Make Print Command?
    (23)
    I want my site (with PHP) to enable PRINT command. The usual print, with printer as output I mean.
    So, how can I do it? I've seen my college site use ASP and they can give me a PRINT xommand box,
    when I click it the printer will print the page.....
  24. Show Users Logged In
    Some help needed.. (5)
    I need some help if somebody can help me out please doit /smile.gif" style="vertical-align:middle"
    emoid=":)" border="0" alt="smile.gif" />.. Ok here is the thing - I have an login box (works
    perfect) and I have MySQL database (works perfect).. Now I need to make thing like a list where
    shows everyone who is logged on.. But making it I need to use the same MySQl database and the same
    login box.. Example: when your write tour Login and password and press "Log-in!" opens page
    where is list of all logged in member.. If there is ant tutorial aor scripts/codes please....
  25. php header() function help needed
    automatic re-direct (4)
    hey ppl, u seem to have real gud knowledge about php, i just wanted a little help...i designed this
    website, but i want that if i click on certain page, it should open for some few seconds and then
    browser should automatically redirect me to some other page....i tried this with header() function
    but i couldnt do the wait n redirect part, ... so somebody plz help.... -thanx in advance!....
  26. Visitors Online
    With PHP (no MySQL is needed) (9)
    Another script, which shows the visitors onlineat the moment in your site. This script was not made
    by me, I just think it will be very usefull to u. CODE <? $timeout = 15; // change
    it. It is the timer which will delete the member of  online list (in minutes) if
    (!$datei) $datei = dirname(__FILE__)."/online.txt"; $time
    = @time(); $ip = $REMOTE_ADDR; $string =
    "$ip|$time\n"; $a = fopen("online.txt", "a+");
    fputs($a, $s....
  27. Visitors Counter
    With PHP (no MySQL needed!) (4)
    Well, here we will make an hit counterusing php and an *.txt file. This script is so simple, but
    very usefull. First, le'ts make an file called counter.php, with the following codes inside:
    CODE <? $file = 'counter.txt'; // this is the file where the number of visitors
    will be written $fopen = fopen("$file", "r"); // open the text
    file $count = fread($fopen, 1024); // read the text file fclose($fp);
    // close the text file $count = $count + 1; // add one more hit echo &#....
  28. Phpeditor
    A php web development program. (8)
    Hello all, I am making a php powered program that will eventually have a file manager and all kinds
    of cool stuff. What it does is its an online php/html editor thats half WYSIWYG and half text. Right
    now nothing works really except the code previewer. Which right now only previews html. But I will
    put java scripts and guides and what not when its finished. Also when its finished you will have to
    pay for it and buy a lisence. But for now anyone can use it threw the testing stages.
    /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> http://ww....
  29. Restarting Apache With Exec Command
    apache restart (0)
    Hey im trying to restart apache throug a script and so far none of the php or perl scripts have
    worked and its just driving me mental restarting apache in the command window in windows is a
    simple as just typing apache -k restart and when i do that i works , but when i create a script to
    execute that command it fails, and when i try to create a script to execute a batch file that does
    exactly that it still fails, so im stranded will someone help me out please, coz this is really
    getting annoying.....
  30. I Will Provide You With A Php Code That..
    ..enable you to use the 'echo' command. (0)
    **YOU DO NOT NEED ANY HTML TAGS FOR THIS SCRIPT**** Enter all values between the ' ' quotes
    //Define The Variables $cfg = array('sitename' => '', //Your Sites Name
    'footer' => '', //OPTIONAL, if you want your footer stored so that the
    echo command can display it. Ex: Copright ©2005 - Michael Fratello (the © is will turn
    into the copyright 'c') 'board_dir' => '', //Link to your
    message boards. (If you have any) ); ?> I recommend saving this file ....

    1. Looking for command, line, based, sql, modification, program, needed, sql,

Searching Video's for command, line, based, sql, modification, program, needed, sql,
advertisement



Looking For Command Line Based Sql Modification - Program Needed For SQL?



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE