Browsing articles in "MySQL Tutorial"

Insert into Select From Delete – Mysql

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I want to transfer 50 rows from table1 to table 2, how should I do this?
Read more >>

MySQL Special symbols

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

Is it possible to insert a special symbol like a checkmark or a filled circle into a MySQL table and then retrieve it through a SELECT?
Read more >>

Inserting data MySQL

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

To add new records to the database table
Read more >>

Rename a MySQL table using SQL statement

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I want to rename an existing table using SQL statement:
Read more >>

MYSQL – What is a primary key?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

A primary key is a column that is defined as uniquely identifying each row.
Read more >>

mysql group by uid which uid match another query

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I want get 10 rand result, which image !=”, group by uid and these uid are the same from select uid from user_table where type=’1′. but my query only return 2 result. where is the problem?
Read more >>

Mysql set to default?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

Use the keyword DEFAULT to set a column explicitly to its default value. This makes it easier to write INSERT statements that assign values to all but a few columns,
Read more >>

Datatype to Store Longitude/Latitude in Mysql

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I’m currently using the datatype spatial: geometry.
Read more >>

Mysql NULL field and php isset?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I have data in my mysql fields which are NULL
Read more >>

mysql echo does not retreive word after a space in textbox

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I have a textbox which i echo data from mysql. However if there is a space in the mysql database feild it does not show the word after the space.
Read more >>

Pages:123»

Share This Page

RSS Wordpress News