Saving the output of a dynamic query that uses refcursor into a table
postgresql,plpgsql,dynamic-sql,create-table
This is solved more easily than your previous question, because we don't get in trouble with dynamic return types here. You just need to concatenate the query string correctly before passing it to EXECUTE. For a new table: DO $$ BEGIN EXECUTE 'CREATE TABLE mydaughtertable AS ' || myresult('dkj_p_k27ac','enri'); END...
Databse migration throws error while seeding two timestamp columns laravel 5
php,mysql,laravel-5,create-table,laravel-migrations
timestamps() method adds both created_at and updated_at columns. Also this method doesn't accept any arguments. http://laravel.com/api/5.0/Illuminate/Database/Schema/Blueprint.html#method_timestamps http://laravel.com/docs/5.0/schema...
Two query in mysqli prepared? [closed]
php,mysqli,prepared-statement,create-table
You have error in your sql query, try below code $sql = "CREATE TABLE $rooms ( `id` BIGINT(255) UNSIGNED AUTO_INCREMENT PRIMARY KEY, `ip` VARCHAR(255) NOT NULL, `time` VARCHAR(255) NOT NULL, `image_path` VARCHAR(255), `smiley_path` VARCHAR(255), `text_input` VARCHAR(255), `current_date` DATETIME )"; ...
Naming for contraints when creating a table
You can let your system assign a system-generated name for your constraints but then it becomes very difficult, from a maintenance perspective, if you want to alter or drop a constraint later - you generally have to perform such operations by name and if you let the system auto-generate the...
SQL - Create table from Select + user defined columns and values
Just add the columns to the select: CREATE TABLE TEST AS SELECT ROW_ID, PROM_INTEG_ID, INTEGRATION_ID, BILL_ACCNT_ID, SERV_ACCT_ID, CFG_STATE_CD, CAST('Test123Value' AS VARCHAR2(30)) as PRODUCT_HIERARCHY FROM PRODUCTS WHERE PROD_ID = 'TestProduct' AND STATUS_CD = 'Active'; Note that the cast() is not necessary. But it is a good idea if you want the...
SQL, creating date column with milliseconds
In Oracle, timestamp stores the date and time down to (and beyond) milliseconds. Oracle date...
Create Table - Time Statement
sql,datetime,ms-access,ddl,create-table
Time and procedure are reserved words, and therefore should be escaped: Create Table Appointments (DocID char(4) not null primary key, PatID char(8) not null, [Day] varchar(8) not null, [Time] datetime not null, [Procedure] varchar(50) null); Or better yet, find names that aren't reserved words: Create Table Appointments (DocID char(4) not...
CREATE MySQL TABLE in PHP with “utf8_unicode_ci”
php,mysql,unicode,create-table
Add COLLATE=utf8_unicode_ci after the CHARSET=utf8 option
Firebird: Adding Index in Create Table Statement
indexing,firebird,create-table
No, this doesn't work. If you want to create an index, you need to do that in a separate create index statement. The only indexes that can be created in a create table are those created automatically for primary, unique and foreign keys. The using-clause in your question is to...
How to specify input format in SQL create table?
Try this: http://sqlfiddle.com/#!6/3974b create table test ( field1 char(5), check (field1 like '[a-z][a-z][a-z][0-9][0-9]') ); insert into test values ('ttt09'); --this will succeed If you were to change the insert to: insert into test values ('testi'); -- this will fail insert into test values ('12345'); -- this will fail ...
Extract Values from records with max/min values
mysql,max,greatest-n-per-group,min,create-table
SELECT tmin.Name, tmin.ValueA, tmax.ValueA, tmin.ValueB1, tmin.ValueB2, tmax.ValueB1, tmax.ValueB2 FROM ( SELECT Name, MAX(ValueA) AS ValueAMax, MIN(ValueA) AS ValueAMin FROM `foo` GROUP BY Name ) AS t JOIN `foo` AS tmin ON t.Name = tmin.Name AND t.ValueAMin = tmin.ValueA JOIN `foo` AS tmax ON t.Name = tmax.Name AND t.ValueAMax = tmax.ValueA;...
Can I use parameters in a CREATE query?
sql,sql-server,parameters,create-table
For #1, use ALTER TABLE command. For #2, how are you executing the query? You can create a string variable first with the complete command and table name as parameter and then execute the query. Something like: declare @ CustomerID int set @ CustomerID = 3262833 declare @sql nvarchar(1000) set...
Create Table SQL query - select table name from string
c#,sql,database,datatable,create-table
Change the dashes to underscores or surround the entire table name with [square brackets]
how to copy a table without importing data and constraints in Oracle?
The answer can be found in the question create table with select union has no constraints. If the select is a union, Oracle will not add any constraints, so simply use the same select twice, and be sure not to include any records in the second select: create table2 as...
Getting an ORA - 00907 error on the following at ON UPDATE
database,oracle,constraints,create-table
Oracle RDBMS does not support ON UPDATE CASCADE.
how to set column type with create-select statement
How about: create table C as( select a.pid, b.date, ((select a.count(cost)*1.000 where cost > '10')/(select a.count(cost))) AS percent from A a join B b on a.pid = b.pid group by 1,2,3); Edit: nevermind the above The following was tested and appears happy as a float. create table i1 ( h...
MySQL: How to create table with auto incrementing column via script
mysql,auto-increment,create-table
In your SQL what the problem is auto increment must be primary key. Otherwise it will not work. You can use like these. i think your problem will solve. CREATE TABLE TranslationsMain ( de VARCHAR(100) NOT NULL, tID INT UNSIGNED NOT NULL AUTO_INCREMENT, location VARCHAR(50) NOT NULL, classes VARCHAR(100) NOT...
How can I parameterize the tablename in a CREATE TABLE expression?
DECLARE @MyTableName NVARCHAR(50); SET @MyTableName = 'AccountSummary'; DECLARE @Sql NVARCHAR(MAX); SET @Sql = N'CREATE TABLE '+ QUOTENAME(@MyTableName) + N' ( Id int NOT NULL IDENTITY(1,1), AccountId int NOT NULL, Amount REAL )' EXECUTE sp_executesql @Sql OR DECLARE @MyTableName NVARCHAR(50); SET @MyTableName = 'AccountSummary'; DECLARE @Sql NVARCHAR(MAX); SET @Sql = N'CREATE...
error in SQL syntax creating a database table
index is a reserved word in MySQL (and any other relational database I can think of). It's used to create, well, indexes. In MySQL you can escape object names by enclosing them with ` characters: CREATE TABLE mytable ( tag MEDIUMTEXT, `index` BIGINT(20) ) ENGINE MyISAM; But it's generally considered...
Database CREATE TABLE for 2 similar tables
mysql,database,mysql-workbench,create-table
I would use one table and use a primary key with no business value, e.g. id INT AUTO_INCREMENT PRIMARY KEY in your create table statement. You'd end up with data similar to: id file_id descrip Date file_heat_value_1 1 1 ABC 2015-02-11 1.02500 2 1 ABC 2014-11-19 0.85500 3 1 ABC...
Foreign Key Unexpected
mysql,sql,foreign-keys,create-table
Your syntax is wrong. Try: create table employee_position ( ePID int primary key, ePName varchar(45) not null, eID int, foreign key (keyname) references employee_profile(eID) ) For more information see the mysql documentation...
Why Is MySQL Bridge Table Not Working?
mysql,create-table,bridge,mysqladmin
Order is a reserved word. You should either change it or you can escape the name with backticks: CREATE TABLE `Order` ( .... ) ...
How to create table after create database using shell_script in PHP?
php,mysql,sql,shell-exec,create-table
This code only creates the database, but not creates the table. My question is how accomplish this task using shell_exec()? The only one solution I can find for your problem is to write your whole SQL query in one line (without breaking it into several lines). It will affect...
Why am I receiving an ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR when using a boolean field in a rails app with Postgresql?
ruby-on-rails,postgresql,heroku,boolean,create-table
Victory is mu is too short's! Thanks for your insightful comment! It seems the problem is that the original db:migration run when I was using mysql was unacceptable to postgres. Commenting out the fields from the migrations and the schema and then adding them back in under a new migration...
Android SQLite Create table statement [duplicate]
android,mysql,sqlite,oncreate,create-table
Why you didn't post the error? Can you post it? Also if you did changes in the db table then you have to increase the db version
variable name into CREATE TABLE IF NOT EXISTS on php
A variable in a single quoted string will not be parsed. However, it will be parsed in a double-quoted string: "CREATE TABLE IF NOT EXISTS $tabla ( `ID` int(2) NOT NULL AUTO_INCREMENT, `Grupo` varchar(1), `Local` char(30), PRIMARY KEY (`ID`) ) COLLATE=utf8_spanish_ci"; http://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.double Alternatively you can always concatenate it: "CREATE TABLE...
Specify Date/Time Field Format through SQL in MS Access
sql,datetime,ms-access,create-table
The DDL in Access is useful but pretty limited and I don't think you can define a field's format with it. To access all of the properties on a table, you'll need to drop down to VBA, using DAO: Public Sub UpdateFormat(tableName As String, fieldName As String, format As String)...
Creating Table in Oracle, SQL
sql,oracle,oracle11g,sqldatatypes,create-table
PHONE VARCHAR2(25) There's your missing comma....
MySQL 1064 Error Creating a Linking Table (Many-to-Many)
mysql,sql,mysql-error-1064,create-table
You are missing commas after each declaration: CREATE TABLE Party_Library ( Party INT(11), Library varchar(40), PRIMARY KEY (Library,Party), FOREIGN KEY (Party) REFERENCES Party(PartyKey) ON DELETE CASCADE, FOREIGN KEY (Library) REFERENCES MusicLibraries(MusicSource) ON DELETE CASCADE ); ...
Error while creating a table in oracle 11g
date CHAR(11) Date is a reserved word in SQL. It cannot be declared as a column in the way you did. Please change the column name and it will work.