MySQL on Linux to configure Bunch of Rows in a Table
-
I am new to mySQL and i need to install MySQL in linux and create a table after the insert a row into the table.Then,I have to insert bunch of rows at a time in the table.How to do this?Any tutorial link available to understand this concept.I am using the Ubuntu 14.04 LTS as Linux machine.What are the basic to be learned to do the above mentioned things?
-
Let's get this installed before we discuss putting rows in. Two very different and discrete tasks.
To install should be this easy...
apt-get install mysql-serverThat's it, nothing more to do.
-
Let us know what then is working.
-
@scottalanmiller The installation of mysql took place
-
Okay, so now to input rows is really easy, assuming that you have the SQL commands ready. What format is your data in currently?
-
@scottalanmiller I dont have data my senior gave me this thing to do and make sure whether it is possible
-
@Lakshmana said:
@scottalanmiller I dont have data my senior gave me this thing to do and make sure whether it is possible
What rows do you have to add, then? What help are you looking for if you have no rows to add?
-
@scottalanmiller I have personal data to be added
-
@Lakshmana My job time finished at my office.So going to my room.So i will continue this process at tommorrow morning
-
@Lakshmana said:
@scottalanmiller I have personal data to be added
Okay, so you DO have data then? What form is it in?
-
@Lakshmana said:
@Lakshmana My job time finished at my office.So going to my room.So i will continue this process at tommorrow morning
Okay, talk to you tomorrow
Have a good evening. -
@scottalanmiller i need to create Registration page with table.Like Facebook pages Sign up and Registration with first name password
-
@Lakshmana said:
@scottalanmiller i need to create Registration page with table.Like Facebook pages Sign up and Registration with first name password
That's no simple task from scratch.
-
@thecreativeone91 Whether any links available to study and implement the things
-
@Lakshmana said:
@thecreativeone91 Whether any links available to study and implement the things
What exactly are you trying to do? something like that from scratch could take several months of studying. You might be able to use/customize some FOSS projects for it. not sure if @scottalanmiller has a better idea for this one.
-
@thecreativeone91 My whole idea is to do a project with many queries in command line.That is I am having 1800 users in From and 1800 users in To.For this whole users i need to give the queries in separate manner.I need to give bunch of queries to the table for the whole users such as 3600 users in a whole company.I need to do this query script in command line only.How to do this.I am new to MySql?
-
@Lakshmana Since you are new to mysql, I would suggest not to jump on projects, but to learn the basics, commands, try adding sample tables, enter data and check it. Once you learn the basics, then you can start working on the projects.
Seems like a good site http://www.mysqltutorial.org/basic-mysql-tutorial.aspx
https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial
-
@Lakshmana said:
@scottalanmiller i need to create Registration page with table.Like Facebook pages Sign up and Registration with first name password
Okay, that's what you need to do when you are programming. I'm unclear how it relates here. I understand that you want this data to be in the database, but that's not a task you do with the database. This is something your application does. Are you saying that you want to "learn to be a software developer" but asked "how do I import rows"?
-
@Lakshmana said:
@thecreativeone91 Whether any links available to study and implement the things
It sounds like you want to change careers and be a software developer. It's a whole new field. Most people go to university for that. That's certainly not the only way, but you'll want to start with some books. This is a HUGE undertaking that you are talking about.
Why do you want to leave IT so quickly?
-
@scottalanmiller I dont want to leave IT.But it is one of the project came to my senior and he gave to solve this
