🔒 Closed Alter table

[avajbt]

hello PHC pa help ako

ano gamit code for sql command line ..

ano rin po ang code sa commandline na mag lilink sa table sa isang main table

SOLVED

 

[That Poppy]

ALTER table table_name
Add column column_name57 integer AFTER column_name56

 

[avajbt]

thank you sir i t try ko

 

[That Poppy]

edit mo nlng yan d ko alm ung nme ng column mo at table e

 

[xrein]

ALTER TABLE table_name
ADD COLUMN new_field VARCHAR(6) NOT NULL
AFTER last_field_name

 

[avajbt]

thank you sir

 

[avajbt]

edit mo nlng yan d ko alm ung nme ng column mo at table e

ERROR sa akin sir

 

[avajbt]

edit mo nlng yan d ko alm ung nme ng column mo at table e

error yung lumabas sir

You do not have permission to view the full content of this post. Log in or register now.

 

[That Poppy]

anong error

 

[avajbt]

anong error

You do not have permission to view the full content of this post. Log in or register now.

 

[xrein]

nilagay mo po ba ung "ALTER TABLE table_name" sa unahan? before ka mag ADD COLUMN?

dapat:

ALTER TABLE table_name ADD COLUMN SUBJECT_iD INT NOT NULL AFTER PREREQ;

 

[avajbt]

nilagay mo po ba ung "ALTER TABLE table_name" sa unahan? before ka mag ADD COLUMN?

yes sir

 

[xrein]

check mo po ito

You do not have permission to view the full content of this post. Log in or register now.

 

[avajbt]

check mo po ito

You do not have permission to view the full content of this post. Log in or register now.

YES IT'S WORKING THANK YOU SO MUCH SIRRRRR

 

[avajbt]

YES IT'S WORKING THANK YOU SO MUCH SIRRRRR

pero sir paano yung commandline para mag link ng table to another table?

 

[xrein]

no problem sir,

next time sir nanjan si friendly google natin

 

[xrein]

pero sir paano yung commandline para mag link ng table to another table?

JOIN ba tinutukoy mo?
iba iba way to join tables

You do not have permission to view the full content of this post. Log in or register now.

yan for refference mo na sir

 

[avajbt]

JOIN ba tinutukoy mo?
iba iba way to join tables

You do not have permission to view the full content of this post. Log in or register now.

yan for refference mo na sir

thank you sir

 

[CrownJ]

up