Jump to content

Basic Mysql Help


Recommended Posts

sorry if this is a newby question, but im new to mysql. So I installed MySQL, but i dont know how to access the mysql command-line utility. how do i get there?I also installed XAMPP on my other computer and am using phpmyadmin to create a mysql database. does that have a mysql command line prompt instead of teh GUI?Thanks!

Link to post
Share on other sites

.sql files are basically pre-written lists of SQL queries, that can be executed all at once. They are in text/plain format - you can open them in notepad and have a look.

Link to post
Share on other sites

An SQL file will have all the SQL commands to edit, update, delete, insert, etc.You can use these commands in a GUI for MYsql (example phpmyadmin). Simply cut and paste the code into the SQL input area within phpmyadmin's SQL tab.

Link to post
Share on other sites
An SQL file will have all the SQL commands to edit, update, delete, insert, etc.You can use these commands in a GUI for MYsql (example phpmyadmin). Simply cut and paste the code into the SQL input area within phpmyadmin's SQL tab.
in php/mysql development, do most people use the GUI or the command line utility?
Link to post
Share on other sites

You can run a file with SQL commands using the command line like this:mysql < c:\path\to\file.sqlIf you need to specify a database, username, and password, it's like this:mysql -h localhost -D [database_name] -u [user_name] -p[password] < c:\path\to\file.sql

do i use these to create the db examples?
The best way to figure that out is to open the files and see what the code says.
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...