Meta tags:

Headings (most frequently used words):

programming, mysql, basic, commands, reply, posts, logic, algorithms, computer, science, and, puzzles, one, thought, on, post, navigation, leave, cancel, about, the, author, find, me, elsewhere, popular, categories, recent, archives,

Text of the page (most frequently used words):
the (39), and (20), from (15), mysql (15), you (14), table (12), 2014 (11), commands (11), 2013 (10), basic (10), database (10), all (9), users (9), #programming (8), server (8), email (8), your (8), select (8), create (8), with (7), name (7), where (7), user (7), 2012 (6), that (6), use (6), com (5), september (5), 2016 (5), facebook (5), using (5), daniel (5), not (5), key (5), column (5), test (5), add (5), password (5), january (4), node (4), for (4), find (4), this (4), are (4), will (4), date_column (4), int (4), creating (4), varchar (4), hostname (4), november (3), april (3), june (3), february (3), october (3), javascript (3), code (3), heroku (3), list (3), puzzles (3), algorithms (3), client (3), website (3), reply (3), can (3), hosting (3), entry (3), delete (3), parent_id (3), displaying (3), alter (3), new (3), first (3), root (3), 2011 (2), december (2), march (2), may (2), july (2), 2017 (2), example (2), getting (2), data (2), another (2), php (2), how (2), event (2), locally (2), connect (2), posts (2), sql (2), linux (2), java (2), cup (2), challenges (2), sockets (2), algorithm (2), profile (2), scocco (2), about (2), comment (2), address (2), get (2), one (2), t_table (2), notice (2), because (2), rows (2), have (2), entries (2), month (2), year (2), t_salary (2), employee_id (2), t_employee (2), deleting (2), information (2), columns (2), update (2), set (2), column_name (2), replace (2), foreign (2), value (2), default (2), adding (2), primary (2), null (2), into (2), values (2), tables (2), inside (2), show (2), dbname (2), databases (2), now (2), here (2), log (2), logged (2), db_name (2), db_user (2), privileges (2), login (2), install (2), access (2), cpanel (2), case (2), make (2), sure (2), writing (2), logic (2), copyright, programminglogic, rights, reserved, august, 2015, archives, modern, development, jsonp, domain, webhook, integration, git, deploy, app, driven, resources, tutorials, express, mondodb, ffmpeg, mongodb, timezone, problems, date, objects, running, apps, port, recent, uncategorized, tricks, tools, python, project, euler, probability, oop, number, theory, networking, lisp, scheme, google, jam, games, hackers, combinatorics, codechef, book, reviews, bitwise, stuff, assembly, categories, udp, datagrams, program, tcp, fast, exponentiation, simple, poker, game, computers, represent, negative, binary, numbers, gdb, regex, patterns, perl, shell, powerset, sieve, eratosthenes, implemented, implementing, huffman, coding, knapsack, problem, dynamic, popular, stackoverflow, github, danielscocco, elsewhere, programmer, entrepreneur, located, brazil, hobby, projects, samples, interesting, solutions, come, across, author, save, browser, next, time, required, fields, marked, published, leave, cancel, let, imagine, planning, together, friends, track, details, thought, basics, permutations, hacker, alphabet, soup, solution, post, navigation, was, posted, disconnecting, quit, above, query, very, slow, though, does, indexes, need, parse, lot, much, better, specific, selecting, based, replacing, table_name, search, payments, status, performing, join, child, index, par_ind, references, parent, cascade, last, order, desc, limit, updating, changing, modify, work, auto_increment, inserting, insert, 12345, etc, describe, tablename, selected, selection, usage, available, play, arround, asked, type, connection, successful, see, welcome, message, prompt, username, should, out, normal, just, created, localhost, grant, identified, db_password, finally, while, once, then, sudo, apt, don, prefer, command, line, process, machine, assuming, remote, account, rent, company, via, write, down, names, after, ips, allowed, remotely, recommend, terminal, forces, learn, hand, gui, tool, like, phpmyadmin, makes, job, easier, but, removes, learning, curve, below, some, improve, skills, minutes, day, newsletter, daily, tips, computer, science,

Text of the page (random words):
mysql basic commands programming logic programming logic algorithms computer science and programming puzzles mysql basic commands improve your writing skills in 5 minutes a day with the daily writing tips email newsletter below you ll find some basic mysql commands in case you are new to it first of all i recommend using the mysql terminal to connect to your database server because it forces you to learn the commands by hand using a gui tool like phpmyadmin makes the job easier but removes the learning curve i am assuming your mysql server is on your remote server i e on the hosting account you rent from a hosting company in that case you can login to your server via cpanel and create a database and a user with all privileges for that database make sure to write down the names and password after that make sure to add your ip address to the list of ips allowed to access the mysql server remotely if you don t have access to cpanel or prefer to use the command line here s the process first of all install the mysql client on your machine sudo apt get install mysql client then login to the mysql server using the root user mysql h hostname u root p once logged in create the database create database db_name create the user create user db_user and finally add all the privileges while creating a password to the user grant all on db_name to db_user hostname identified by db_password notice that if you are logged in locally the hostname will be localhost now you should log out as root and log in as the normal user you just created mysql h hostname u username p you ll be asked to type the password of the user if the connection is successful you ll see a welcome message and the mysql prompt now here s a list of commands you can use to play arround 1 creating a database create database dbname 2 displaying all available databases on the server show databases 3 selection a database for usage use dbname 4 creating a table inside the selected database create table users name varchar 30 password int email varchar 30 5 displaying all tables inside a database show tables 6 getting information about the table columns key null values etc describe tablename 7 inserting an entry into a table insert into users name password email values daniel 12345 daniel test com 8 deleting an entry from a table delete from users where name daniel 9 adding a new column alter table users add facebook varchar 30 10 adding a new id column to work as the primary key alter table users add id int not null auto_increment first add primary key id 11 changing the default value of a column alter table users modify column email varchar 30 default test test com 12 updating the value of a column update users set email test test com where id 5 13 displaying the last 5 rows of a table select from users order by id desc limit 5 14 creating a table with a foreign key create table child id int parent_id int index par_ind parent_id foreign key parent_id references parent id on delete cascade 15 performing a join select a id a name from users a payments b where b status 1 and a id b id 16 replacing information on columns update table_name set column_name replace column_name search replace 17 selecting and deleting from one table based on data from another select from t_salary where employee_id not in select id from t_employee delete from t_salary where employee_id not in select id from t_employee 18 select entries from a specific month or year select from t_table where month date_column 10 and year date_column 2014 notice that the above query is very slow though because it does not use indexes so the db will need to parse all the rows if you have a lot of entries it will be much better to use this select from t_table where date_column 2014 10 00 and date_column 2014 10 40 19 disconnecting quit this entry was posted in sql on january 31 2012 by daniel scocco post navigation facebook hacker cup 2012 alphabet soup solution basics of permutations one thought on mysql basic commands hosting september 25 2016 at 12 17 pm let s imagine that we are planning a get together of friends we can use mysql to track the details of the event reply leave a reply cancel reply your email address will not be published required fields are marked comment name email website save my name email and website in this browser for the next time i comment about the author my name is daniel scocco and i am a programmer and entrepreneur located in brazil on this website you ll find my hobby programming projects code samples i find interesting and solutions to programming puzzles and challenges i come across find me elsewhere danielscocco com github profile stackoverflow profile popular posts knapsack problem dynamic programming algorithm implementing huffman coding in c the sieve of eratosthenes implemented in c powerset algorithm in c mysql basic commands basic linux shell commands basic regex patterns in java perl gdb basic commands how computers represent negative binary numbers simple poker game in c fast exponentiation algorithms example of client server program in c using sockets and tcp sockets programming in c using udp datagrams categories algorithms assembly bitwise stuff book reviews c c challenges codechef combinatorics facebook hackers cup games google code jam heroku java javascript linux lisp scheme networking number theory oop php probability project euler puzzles python sql tools tricks uncategorized recent posts running heroku apps locally on port 80 with facebook connect mongodb and node js timezone problems with date objects list of basic ffmpeg commands resources and tutorials for node js express js and mondodb event driven programming with node js how to deploy a node js app to heroku git basic commands facebook webhook integration code in php jsonp example getting data from another domain with javascript modern javascript development archives october 2017 september 2017 november 2016 october 2016 september 2016 june 2016 february 2015 september 2014 august 2014 july 2014 may 2014 april 2014 march 2014 february 2014 january 2014 december 2013 november 2013 october 2013 september 2013 july 2013 june 2013 may 2013 april 2013 february 2013 january 2013 june 2012 april 2012 march 2012 january 2012 december 2011 november 2011 copyright programminglogic com all rights reserved