All Questions
5 questions
2
votes
1
answer
908
views
Change in datatype?
I have a table on which rows are inserted on hourly basis. The row contains id, installation, product_id and hit_allowed. all of them were mediumint in the beginning. but few days back id reached it ...
- 565
2
votes
3
answers
1k
views
How to get all non deleted messages from one user
I have two tables one for messages called default_messages and the other for recipients called default_recipient. This is how SQL for those table looks like:
CREATE TABLE IF NOT EXISTS `...
- 1,888
4
votes
1
answer
11k
views
MySQL UPDATE to replace text in LONGTEXT field
I have a WordPress table wp_posts and I'd like to run an UPDATE that will replace a url from my old domain to my new domain.
For example, let's say that one record in the field post_content has the ...
- 227
2
votes
1
answer
3k
views
how do I limit the characters in selected row and con-cat with '...'
I have a query which return a column named comment. I want to limit the number of characters returned by select statement to 50 and if the comment row contain more than 50 characters, I want to append ...
- 565
3
votes
2
answers
167
views
How do I configure MySQL '5.1.49-1ubuntu8' to show multibyte characters?
I am using MySQL version 5.1.49 and I have now enabled UTF8 character encoding. The default character-set for MySQL is latin1. How can I change it show UTF8 characters?
Even when I query a table ...
- 33