Is it possible to specify the schema when connecting to postgres with JDBC?
Is it possible? Can i specify it on the connection URL? How to do that? 8 Answers 8
database-schema
Difference between database and schema
What’s the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. If a Schema is deleted, then are all the tables contained in that schema also deleted automatically or are they deleted when the Database is deleted? 5 Answers 5
How can I initialize a MySQL database with schema in a Docker container?
I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: FROM mysql MAINTAINER (me) <email> # Copy the database schema to the /data directory COPY files/epcis_schema.sql /data/epcis_schema.sql # Change the working directory WORKDIR data CMD mysql -u $MYSQL_USER -p $MYSQL_PASSWORD $MYSQL_DATABASE < epcis_schema.sql … Read more
How to get all columns’ names for all the tables in MySQL?
Is there a fast way of getting all column names from all tables in MySQL, without having to list all the tables? 11 Answers 11
What are OLTP and OLAP. What is the difference between them?
Actually what do they mean? All articles I find about them don’t give me an idea, or my knowledge is too insufficient to understand it. Will some one give me some resources with which I can learn this from scratch. 5 Answers 5
Difference Between Schema / Database in MySQL
Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing in MySQL, which leads me to believe that schemas and databases are different words for … Read more
How do I show the schema of a table in a MySQL database?
From the MySQL console, what command displays the schema of any given table? 5 Answers 5
How to see indexes for a database or table in MySQL?
How do I see if my database has any indexes on it? How about for a specific table? 14 s 14 To see the index for a specific table use SHOW INDEX: SHOW INDEX FROM yourtable; To see indexes for all tables within a specific schema you can use the STATISTICS table from INFORMATION_SCHEMA: SELECT … Read more
How to rollback a specific migration?
I have the following migration file db\migrate\20100905201547_create_blocks.rb How can I specifically rollback that migration file? 15 s 15 rake db:rollback STEP=1 Is a way to do this, if the migration you want to rollback is the last one applied. You can substitute 1 for however many migrations you want to go back. For example: rake … Read more
