Database Archives - Page 36 of 44

MongoDB or CouchDB – fit for production? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Closed 7 years ago. Locked. This question and its ...

May 4, 2022
0 Comments

How can I do three table JOINs in an UPDATE query?

I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.join_col = b.join_col AND a.column_a = ...

May 4, 2022
0 Comments

What’s the Hi/Lo algorithm?

What’s the Hi/Lo algorithm? I’ve found this in the NHibernate documentation (it’s one method to generate unique keys, section 5.1.4.2), but I haven’t ...

May 4, 2022
0 Comments

MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

I’m importing a MySQL dump and getting the following error. $ mysql foo < foo.sql ERROR 1153 (08S01) at line 96: Got a ...

May 4, 2022
0 Comments

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I ...

May 4, 2022
0 Comments

Run MySQLDump without Locking Tables

I want to copy a live production database into my local development database. Is there a way to do this without locking the ...

May 4, 2022
0 Comments

MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)

First let me mention that I’ve gone through many suggested questions and found no relevent answer. Here is what I’m doing. I’m connected ...

May 3, 2022
0 Comments

How to declare a variable in MySQL?

How to declare a variable in mysql, so that my second query can use it? I would like to write something like: SET ...

May 3, 2022
0 Comments

Maximum length for MySQL type text

I’m creating a form for sending private messages and want to set the maxlength value of a textarea appropriate to the max length ...

May 3, 2022
0 Comments