I have a table in database. I want to add like 50 columns into the table. What query can i write to create the 50 columns at the same time. i don't want to start creating the columns 1 by 1.

Thanks

Do you know sql and which dbms is that?

50 rows of data or 50 columns that represent attributes of your entity.What kind of entity will have 50 attributes? am not saying that their cant be.

50 fields

What DBMS you using? You can just create all the columns alongside the table at once but then you gonna type quite a lot of DDL and DML code.

What DBMS you using? You can just create all the columns alongside the table at once but then you gonna type quite a lot of DDL and DML code.

I guess you using access which is easy to create rows and columns, state your DBMS and you will get help!

50 columns for one dB table is rather too much & bad design, but if u still want to go ahead, just write the sql instructions for all 50 columns at once, separating them with semicolons [;].

Thanks all, i later built a query string like this and it worked. the DBMS is mysql.

<?php
// Connects to your Database
mysql_connect("host", "username", "password" or die(mysql_error());
mysql_select_db("dbname" or die(mysql_error());
$sql="CREATE TABLE table namet (";
for($i=1; $i<=50;$i++)
{
$sql.="col_".$i." VARCHAR(255), ";
}
$sql = rtrim($sql,', ').' )';
//echo $sql;
if(mysql_query($sql)) echo 'Successful';
else echo mysql_error();

?>

rukie:

<?php
// Connects to your Database
mysql_connect("host", "username", "password" or die(mysql_error());
mysql_select_db("dbname" or die(mysql_error());
$sql="CREATE TABLE table namet (";
for($i=1; $i<=50;$i++)
{
$sql.="col_".$i." VARCHAR(255), ";
}
$sql = rtrim($sql,', ').' )';
//echo $sql;
if(mysql_query($sql)) echo 'Successful';
else echo mysql_error();

?>

hmm, that's very good concept. i don't have a php/mysql system to run it but it looks great to me. i'd never have approached it like this.
though this 50 column table will be more useful as a spreadsheet, not as a database table.

i still cant picture a scenario where a "lazy" approach like this will work

maybe deadline is so close

webdezzi:

i still cant picture a scenario where a "lazy" approach like this will work

maybe deadline is so close

So you think

webdezzi:

i still cant picture a scenario where a "lazy" approach like this will work

maybe deadline is so close

I use a similar method all the time. I have just generated a project with 538 classes. I started just a week ago with some barely related XML.
The week was spent designing the app, mapping the relationships between the classes and interfaces, sorting out inheritances, generating a database and writing the generation code. After that? Press the button.

It would have taken me months and an untold amount of frustration and misery with any other approach.

Please can 1 retrieve its account password. I registered an account with my school and i forgot the password likewise the security question. Please will i have it back if i go to the ITC centre? Please help me out on this

Onyeasi:

Please can 1 retrieve its account password. I registered an account with my school and i forgot the password likewise the security question. Please will i have it back if i go to the ITC centre? Please help me out on this

go to your itc and ask them.

The approach isn't lazy, like Beaf I use the technique a lot also , but on the command prompt. You use code/sql to generate template like code/sql.

Though wrapping it with PHP probably isn't as flexible as simply storing it as .sql for later use.

What sort of database structure is that that requires 50 columns?

Perhaps you should restructure your database.