Category: MYSQL
-
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…
-
Access denied for user ‘root’@’localhost’

Are you PHP/MySql programmer may be in your programmer life accidentily you came across following error : “Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@’localhost’ (using password: YES) in C:\xampp\htdocs\daytrader\login.php on line 4 Access denied for user ‘root’@’localhost’ (using…
-
Import large files mysql phpmyadmin localhost

I had this problem when i’m try to upload 8MB file into the localhost, I had the following When trying to import large SQL files into mysql using phpmyadmin, the phpmyadmin documentation offers a few solutions, but I find the…
-
Simple Dot net Application with Database Connection

Following code loads data form database into dropdown box during pageload event and when you select data from dropdown box page is postbacked and data in the database populated in the Grid view control.. using System; using System.Collections.Generic; using System.Linq; using…