Database Archives - Page 34 of 44

What is the difference between utf8mb4 and utf8 charsets in MySQL?

What is the difference between utf8mb4 and utf8 charsets in MySQL? I already know about ASCII, UTF-8, UTF-16 and UTF-32 encodings; but I’m ...

May 6, 2022
0 Comments

Error renaming a column in MySQL

How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to ...

May 6, 2022
0 Comments

Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have tried this: ALTER ...

May 6, 2022
0 Comments

List of standard lengths for database fields

I’m designing a database table and asking myself this question: How long should the firstname field be? Does anyone have a list of ...

May 5, 2022
0 Comments

How to select the nth row in a SQL database table?

I’m interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting ...

May 5, 2022
0 Comments

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using ...

May 5, 2022
0 Comments

MySQL error: key specification without a key length

I have a table with a primary key that is a varchar(255). Some cases have arisen where 255 characters isn’t enough. I tried ...

May 5, 2022
0 Comments

How can I stop redis-server?

I apparently have a redis-server instance running because when I try to start a new server by entering redis-server, I’m greeted with the ...

May 5, 2022
0 Comments

MySQL Error: : ‘Access denied for user ‘root’@’localhost’

Consider: ./mysqladmin -u root -p** '_redacted_' Output (including typing the password): Enter password: mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied ...

May 5, 2022
0 Comments

What is the error “Every derived table must have its own alias” in MySQL?

I am running this query on MySQL SELECT ID FROM ( SELECT ID, msisdn FROM ( SELECT * FROM TT2 ) ); and ...

May 5, 2022
0 Comments