create a table of 900 attributes in mysql

advertisements

Im trying to create a really big sql table that consists of 900 attributes. Is there an easy way to create a table in mysql that consists of 900 attributes without having to manually type them in? I have the name of attributes in a text file

Get each "attribute" into an array.

Do a foreach loop on the array which builds your query string.

Copy and paste that query string into phpMyAdmin or insert it into the database however you want.

Related Articles

to create a table in a column in MYSQL

Apologies if I am mistaken, but is there any way to create a table inside a column in MySql? Brief: I have a table named test_table which contains a column named name test_column. Now I want to create a table inside test_column. Is this possible? Tha

How to join two tables on common attributes in mysql and php?

i have 2 tables: table1 id message user 1 testing 23 2 testing again 44 3 test.. 23 5 lol 12 6 test.. 6 and table2 id user friend 1 23 44 2 23 6 3 19 12 4 23 32 5 23 76 6 23 89 i am trying to get the messages of all users that are friends with 23 inc

SQL Create multiple tables at once

I need to create multiple tables at once. Im having a hard time figuring out the correct method for accomplishing this. Currently my script looks like this: private function buildDB() { $sql = <<<MySQL_QUERY CREATE TABLE IF NOT EXISTS headings (

How to create a select option in Zend Framework + MySQL Table

How to create a select - option in Zend Framework +MySQL Table COntroller: $persons = new Application_Model_DbTable_Persons(); $data_persons = $persons->findPersons(); Controller and View? How to? o.OIn Controller $this->view->dataPerson = $data_

MySQL Creates a Table for an Internal Join UNION right join

In my SQL 5.5: Trying to create a table which is a result of a INNER JOIN of table A & B, and (UNION) RIGHT JOIN of table C & B. CREATE TABLE IF NOT EXISTS TABLE_NAME AS ( (SELECT a.column1, b.column2 FROM TABLEA AS a INNER JOIN TABLEB AS b ON a.c

Unable to create a table in mysql

I want to create table which is having 216 fields but when I am trying to create it I got below error in mysql. #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to

Create a table in Mysql dynamically with PHP, ajax, jQuery

I am trying to create a table in MySQL dynamically from PHP. User inputs should be inserted into that table using jQuery,AJAX and PHP. my code is looking like this. var toServer = brandname+','+prodname+','+qty; $.ajax({ type: 'POST', url: 'sample.ph

Create a table with a space in the name in mySQL

I want to create a table in mySQL with the name of "123 Product", with numbers in the beginning and a space in between. I can do this using phpmyAdmin but I want to make this table using php. But, unfortunately, I am unable to do this. I tried s

The MySQL user created temporary table is full

I have a created a temporary table using the memory engine as followed: CREATE TEMPORARY TABLE IF NOT EXISTS some_text ( id INT DEFAULT 0, string varchar(400) DEFAULT '' ) engine = memory; When I insert rows into it I run into a #1114 error because t