Tags » Mysql

Get Free Domain + Free Hosting

Looking to buy a domain?
Many hosting services throw in the name for free and even let users register it as part of the package. By offering the first year free of charge, these partners give their customers real value for money. 113 more words

Special

Add foreign key to existing mysql table

Example to add multiple foreign keys in one go:–

ALTER TABLE users_role_map

ADD CONSTRAINT FK_users_role_map1
FOREIGN KEY (email) REFERENCES usert(email)
ON UPDATE CASCADE
ON DELETE CASCADE,

ADD CONSTRAINT FK_users_role_map2
FOREIGN KEY (id) REFERENCES rolet(id)
ON UPDATE CASCADE
ON DELETE CASCADE; 45 more words
MySql

MySQL error 1449: The user specified as a definer does not exist

I faced this error when exporting the database from one server to other server, as the user doesn’t exist. So I changed the incorrect username into right one as given below. 244 more words

Errors

Connecting Windows Phone App with MySQL

This post explains how to connect Windows Phone application with a MySQL database. I explain this using hotels database.

The first step is to build the database. 525 more words

General

Por que eu gosto de programar

Eu sempre gostei de programar, desde moleque. Ganhei meu primeiro computador aos 10 anos e nunca mais parei. Na d├ęcada de 80 a linguagem amplamente utilizada era o Basic. 671 more words

Sobre O Que Penso

Why is "SELECT *" considered harmful?

There are three major reasons why “SELECT *” is considered harmful.

  1. Inefficiency in moving data to the consumer.When you SELECT *, you’re often retrieving more columns from the database than your application really needs to function.
  2. 311 more words

Export and Import with MySQLDump

Here is the syntax.

To export the database –


C:\xampp7\mysql\bin>mysqldump.exe --databases mydatabase --user myuser --password >mydatabase.dump.sql
Enter password: ************

To import the dump to database – 50 more words

Mysql