? Critique my MySQL Database Design for Unlimited DYNAMIC Fields

Looking for a scalable, flexible and fast database design for 'Build your own form' style website - e.g Wufoo.Rules:User has only 1 Form they can buildUser can create their own fields or choose from '
 ? dynamic database columns?

Suppose that I've a website where I'm offering the user to link his social network accounts like facebook, twitter, ... with his account on my website. Now I'm supporting facebook and twitter in the
 ? Optimize a UNION mysql query

I'm using a UNION query to extract data from two tables based on date. Query belowSELECT title, id, date as date_added FROM test1 WHERE test1.idUNION SELECT title, customer as id, date_added FROM t
 ? MySql - Union across different Servers

Is there any way to do something like this?select * from server1.database_name.tableunion allselect * from server2.database_name.tableThanks. You can create a table on server1 that uses the FEDERAT
 ? MySQL select inner join and union

I have this two tables. I have current player id_player, I want to select all games from this player (id_player) and his opponents info. Current player and opponent player are connected with same id_g
 ? MySQL Union (or similar) query

I have some booking data from a pair of views in MySQL. They match columns perfectly, and the main difference is a booking code that is placed in one of these rows.The context is as follows: this is f
 ? Mysql UNION with dynamic query

i have the following problem. I inherited a software that uses a database prefix for every customer.All tables have the same structure and columns. For a data migration to new version i want to union
 ? MYSQL: UNION results between two tables where omitting records from first table if PK found in second table

I have two tables products and product_edits which hold product information on the pricelist. My app works in a way that if user changes any product info in products table it inserts it into product_e
 ? extract a pattern number from url mysql or python

I have a bunch url that has a string either has hotel+4 digit number: hotel1234 or slash+4digit.html: /1234.htmlIs there a regex to extract 4 digit number like 1234 either use python or mysql?I'm thin
 ? STS JPA Tools not generating all Entities from Tables

I have created a few tables in my DB and a demo project in STS which I have converted to a JPA project. I then right click on it and select JPA Tools -> Generate Entities from Tables.It works perfectl
 ? Batch Insert with generated keys deals duplicate entry on unique

I am using MySql with JDBC...the below is my table definitionCREATE TABLE `A` ( `id` int(255) NOT NULL AUTO_INCREMENT, `type` varchar(255) NOT NULL, `value` varchar(255) NOT NULL, PRIMARY KEY (`id
 ? Subquery as generated column in mysql?

Can I create a generated column in table A which sums up a column in table B with a tableA_id of the row in table A?Suppose I have a table of of families, and a table of children. I want a sum of the
 ? Subquery as generated column in mysql?

Can I create a generated column in table A which sums up a column in table B with a tableA_id of the row in table A?Suppose I have a table of of families, and a table of children. I want a sum of the
 ? Subquery as generated column in mysql?

Can I create a generated column in table A which sums up a column in table B with a tableA_id of the row in table A?Suppose I have a table of of families, and a table of children. I want a sum of the
 ? MySQL: Sum Subqueried Columns

Is there an elegant way to do this in MySQL:SELECT (subquery1) AS s1, (subquery2) AS s2, (s1+s2) AS s3or must I resort to SELECT (subquery1) AS s1, (subquery2) AS s2, ((subquery1)+(subquery2)) AS s3?T
 ? calculate two columns in MySQL

I have a MySQL database, where I have 3 columns:Day_hoursDay_minutesAll_day_hoursI am gonna have some different form fields in a JSP page, where I can put in how many hours I work. On a day I work in

Page 1 of 2011  |  Show More Pages:  Top Prev Next Last