Hot answers tagged schema
It looks like you'll need to change the user's default database, as it appears this is currently set to DB1, which no longer exists. exec sp_defaultdb @loginame='user1', @defdb='DB2' OR ALTER LOGIN <login_name> WITH DEFAULT_DATABASE = <default_database>
You can compare checksum of output of SHOW CREATE TABLE product_today # mysql -NBe "SHOW CREATE TABLE sakila.actor"| sed -r 's/AUTO_INCREMENT=[0-9]+/AUTO_INCREMENT=XXX/g' | md5sum # 1bc0d72b294d1a93ce01b9a2331111cc -
This can be done. The column default for your serial primary key is typically defined as: ALTER TABLE schema_a.tbl ALTER COLUMN tbl_id SET DEFAULT nextval('schema_a.tbl_tbl_id_seq'::regclass); Two options: 1. Move sequence (my preference) to the public schema - or any schema with sufficient privileges: GRANT USAGE ON SCHEMA public TO public; -- or: ...
Your comment about intensive dropping and creating and the notice you received regarding increasing max_locks_per_transaction hint that you're dropping and creating many objects in the same transaction. Each of those results in a lock, which each requires a small amount of shared memory. Because of this, max_locks_per_transaction limits the number of locks ...
What I would suggest to you before putting a lot of work into designing a system, is to take a leaf from the book of the great Issac Newton - "If I have seen further it is by standing on the shoulders of giants". By this I mean take a long hard look at what's been done already - there are systems that could be of interest to you in this domain - take a ...
Neo4j is a schema-optional graph database. You could choose to enforce a full schema and reap the benefits.
Check this out, and links within (1, 2). InnoDB has a limit of 4 billion tables. There is no compelling reason to use the file system to store data that is better stored in a database. Take a look here to see that virtually every form of social networking software uses an underlying database - normally MySQL or PostgreSQL (which I would recommend). 2 ...
TWO TABLES IN THE CURRENT DATABASE If you want to know if two tables are different, run this SELECT IF(COUNT(1)>0,'Differences','No Differences') Comparison FROM ( SELECT column_name,ordinal_position, data_type,column_type,COUNT(1) rowcount FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name IN ...
Only top voted, non community-wiki answers of a minimum length are eligible