Improve company productivity with a Business Account.Sign Up

x
?
Solved

what command to updata tables in mysql??

Posted on 2006-06-09
5
Medium Priority
?
250 Views
Last Modified: 2010-08-05
Hello, I have a mysql db and I need to update some table from a .sql file. This server is running on a linux box. How do I do this??

Thanks,

A
0
Comment
Question by:aej1973
  • 2
3 Comments
 
LVL 19

Expert Comment

by:Nick Upson
ID: 16872859
isql databasename < file.sql
0
 

Author Comment

by:aej1973
ID: 16873110
wher do i insert the statement?

mysql>

or

user/local/mysql#

??
0
 
LVL 19

Accepted Solution

by:
Nick Upson earned 500 total points
ID: 16873391
user/local/mysql#
0

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question