Pages
(Move to ...)
Home
About me
htaccess
Robots.txt
MySQL
PHP
▼
Showing posts with label
alter table
.
Show all posts
Showing posts with label
alter table
.
Show all posts
17 Feb 2014
Reset auto increment initial value in mysql
›
Auto_ increment is used to increase by 1 while insert a new data to mysql table. The auto increment column must be def...
6 comments:
12 Feb 2014
Primary key in mysql
›
The primary key in mysql is used to identify the unique values in table. It don't allow duplicate entries in ...
1 comment:
6 Feb 2014
Remove auto_increment from column in mysql
›
You created a table in which the column with specific definitions in mysql. You created table column with auto incre...
3 comments:
26 Jan 2014
Add auto_increment to existing column in mysql
›
Auto_ increment is used to increase by 1 while insert a new data to mysql table. The auto increment column must be def...
4 comments:
23 Jan 2014
Add primary key to existing column in mysql
›
Primary key is used to avoid duplicate entries in mysql table. A mysql table can have only one primary key. Creat...
1 comment:
19 Jan 2014
Change column with NOT NULL to NULL in mysql
›
You created a table in which the column with 'NOT NULL'. Suppose you want to change mysql column definition ...
1 comment:
29 Dec 2013
Change column datatype in mysql
›
You created a table with column in specific datatype. Sometimes you need to change datatype of column. At the time...
1 comment:
27 Dec 2013
Move columns in mysql table
›
You can change the column name and change the column size in mysql. But can you rearrange the column order in mysql ...
25 Dec 2013
Changing the column size in mysql
›
You created a table with specific size of column. Sometimes you need to increase the size of column, if the size is ...
22 Dec 2013
Changing column name in mysql table
›
You created a table with specific column name. Sometimes you need to change the column name. At the time, you can ch...
19 Dec 2013
Delete column in mysql table
›
You created a table with number of columns. Sometimes you don't need to specific column. At the time, you can ...
17 Dec 2013
Add column after specific field in mysql
›
When you try to add add new column to your table, by default the column should be added to end of your table. But yo...
13 Dec 2013
Copy values from one column to another within table in mysql
›
Mostly we had copied only particular values from one table to another. Similarly we had copied only particular values...
2 comments:
›
Home
View web version