Stack Overflow
Stack Overflow

Questions tagged [database-create]

21 questions
8
votes
4 answers

How to create mysql database with sequelize (nodejs)

I am trying to automate the process of creating db and tables as much as possible. Is it possible to create database via sequelize? Can I make a connection string that connects just to server, not to db directly?
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
3
votes
2 answers

Using NHibernate to execute DDL statements

How can I execute a DDL statement via NHibernate? To be clear, I don't want to auto-generate my schema from my mapping files. My DDL is stored in plain text files along the lines of: CREATE TABLE Foo (Bar VARCHAR(10)) GO CREATE TABLE Hello (World…
Steve
  • 2,073
  • 4
  • 27
  • 39
2
votes
1 answer

Why mysql "ENGINE=InnoDB" doesn't work with joomla 3 installation

I got the solution for joomla 3 installation problem(installation stucks in creating databases) in stackoverflow. The solution that to replace "ENGINE=innoDB" with "ENGINE=MyIsam" in joomla-folder\installation\sql\mysql\joomla.sql, it works…
Muthu kumar
  • 162
  • 1
  • 2
  • 12
2
votes
1 answer

Remove On Delete Cascade MySQL

I've created 2 tables one named (Config) and the other one (Records): CREATE TABLE Config( configID VARCHAR(100) NOT NULL, featureID VARCHAR(100) NOT NULL, bpID VARCHAR(100), PRIMARY KEY (configID, featureID) ); CREATE TABLE Records( …
Alice
  • 117
  • 5
  • 16
2
votes
1 answer

How to get table names in capital letters in MySQL 5.6

I want to create table whose name starts with capital letter in MySQL version 5.6 . In version 5.0 we can use lower_case_table_names=0 in my.ini file and restart MySQL it works. But in 5.6 version I am not able to get it to work.
skb
  • 1,148
  • 2
  • 9
  • 17
2
votes
1 answer

Identity Problems During Database Creation

Using SQL Server Management Studio, my issue stems from a database creation script. The script is written to create a database, many of whose tables have an identity column: CREATE TABLE Workshop ( WorkshopID int IDENTITY, WorkshopName…
Valevalorin
  • 390
  • 1
  • 3
  • 18
1
vote
1 answer

can't find sqlite file, not sure what c# is doing

I have a program that works correctly and I can access the database from within the program... But my issue is this... The db is no where on my computer... at least where I can find it. I have tried searching for all .db files and it wasn't there.…
Bear
  • 486
  • 2
  • 8
  • 16
1
vote
0 answers

"timeout: timed out" when creating database using PyOrient

I've had a local instance of OrientDB (version:2.2.20) which i'm using it as graph database. When i tried to create new database from DB Client instance it gives time out error. The code is shown below, import pyorient ####establishing connection…
kavin
  • 96
  • 6
1
vote
1 answer

Cpanel MySQL Create/Drop database remotely

Using cpanel, I was able to create a FTP user with limited access to allow our technical support team to upload files to the server. Now, I'm kind of stuck since they also need to be able run script to create and populate databases each time we…
Jonathan Parent Lévesque
  • 1,902
  • 1
  • 25
  • 35
1
vote
1 answer

checking data before SQL update

I'm switching from using a framework's model handling to using straight sql for the purpose of improving the performance. The framework would handle the model update and insert, and now I'm having a hard time with the validation aspect. I'm updating…
Daniel
  • 34,125
  • 17
  • 102
  • 150
1
vote
3 answers

Creating a database in SQL Server 2005

After installing SQL Server 2005, I tried to create a new database (command: create database database_name). But the message was an error: permission denied to create a database in 'master' database. My question is 1.) how to exit this master…
Arun
  • 43
  • 1
  • 2
  • 12
1
vote
1 answer

create and fill VistaDB database programmatically using c#

Is it possible to create a VistaDB database programmatically using C#. My requirement is that I have a SQL Server database with some thousand rows and I want to programmatically create the same schema and export some hundred rows to an embedded…
jeff
  • 684
  • 1
  • 11
  • 30
0
votes
1 answer

Entity Framework Core code-first approach: database not being created automatically

I'm having an issue with Entity Framework Core while trying to use the code-first approach. I want the database to be automatically created when I run the code, but it's not happening. If I don't create the database beforehand, I get an error…
Mert Atmaca
  • 63
  • 10
0
votes
0 answers

multiple database creation script in sql

I want to create multiple database at one go almost 120 in MS SQL. I have tried by using script but that is not working. --Create Variables Declare @DataFilePath VARCHAR(100) Declare @LogFilePath VARCHAR(100) Declare @SubPartDBName…
Sadamh Hussain
  • 1
  • 2
  • 6
0
votes
1 answer

How to configure audit_trail='db,extended' at the time of oracle database creation?

Objective: to configure audit_trail='db,extended' at the time of oracle database creation Environment: CentOS7 Scenario: Oracle11gXE (binaries installed but not database…
AVA
  • 2,474
  • 2
  • 26
  • 41
1
2