Category: MYSQL
-
SmartFoxServer 2x Custom User Registration and Login
In multi player gaming development there is requirement like custom user registration and custom user login which is some what tricky in smartfoxserver 2x or smartfoxserver pro. In smartfoxserver 2x for custom user registration and login, we need two zones for…
-
Find Rank of player in MySQL table
Mostly in games we have a requirement like to find rank’s of the player in the last week or month. In MySQL there is no default MySQL function to find out rank’s of the player from the player table. To…
-
Date condition in between function MySql Query
Mostly in games we have requirement like information of player, those who are played in the last week. Here is the simple mysql query to check players who are played last week. We use simple mysql function to fetch result…
-
How to select only uppercase or lowercase records from mysql table
The table A contains following two records ‘111a’ and ‘111A’, if you want to select only ‘111A’ record using following those queries it will outputs both the records instead outputting single records. Queries are SELECT * FROM table_A WHERE value…
-
Delete a column from an existing MySQL table
Drop column MySql command used to delete a column from an existing MySQL table. Syntax for deleting particular column for the able is : ALTER TABLE tablename DROP column-name for example ALTER TABLE moviesite DROP movie_name where moviesite – Table…
-
How To Build WordPress Theme From Scratch…….
This tutorials deals with hello world WordPress theme development. If you are new to the wordpress development, this tutorial will be starting point to your wordpress development carrier. Before continue your wordpress development please refer my previous tutorials on how to “Install…