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

  • The WordPress.com Year in Review (and Resolutions for 2018) January 3, 2018
    It was quite a year for the WordPress.com community, and we've got a lot to look forward to.
  • Managing Your Blog On a Mobile Device December 13, 2017
    A few enhancements we've added to the iOS and Android apps for easier blogging.
  • New Premium Themes: Small Business and Photo Blog December 7, 2017
    Introducing two new premium themes: Small Business, made for your entrepreneurial endeavors, and Photo Blog, designed to make your photography shine.
  • Updated Privacy Policy December 4, 2017
    As part of our commitment to privacy and transparency, we’re updating our Privacy Policy. We want to give you more information about how we collect and use personal information — in a more organized and readable format. “Your privacy is critically important to us.” These are the first words of …
  • Update Your Avatar on WordPress.com October 12, 2017
    Manage, upload, and edit your profile photo at wordpress.com/me.
  • A New Media Picker for the iOS WordPress App October 9, 2017
    Sometimes it’s the extra touches that make all the difference; on your website, that’s the photos and video that give your content life. You asked for streamlined access to your media library and the camera and photos on your device, to make uploading and inserting photos and videos easier. We …