Questions tagged [mysql-error]
5 questions
1
vote
1 answer
MySQL: Insert special character in a string
I'm using the mysql client c library to insert values into my database. I'm inserting a special character (0xFF) as a separation char in my strings:
char buffer[256];
char name[64] = "my_name";
char path[64] = "path/path";
path[4] = 255; //…
Cedric
- 11
- 3
0
votes
1 answer
MySQL showing error 1175: You are using safe update mode in updating the table
I have a table in MySQL created using:
CREATE TABLE cats (
cat_id INT AUTO_INCREMENT,
name VARCHAR(100),
breed VARCHAR(100),
age INT,
PRIMARY KEY (cat_id)
);
I have inserted below values into this table:
INSERT INTO cats(name,…
Latika
- 3
- 1
0
votes
2 answers
update database in asp.net
i'm biulding a web application and when the users log in and trying to buy somthing from web for another time this error apears
SqlException: Cannot insert explicit value for identity column in table 'orderFactors' when IDENTITY_INSERT is set to…
0
votes
0 answers
Mysql - BIGINT value is out of range in error using substring_index
select substring_index(SUBSTRING_INDEX(title, ' ', title+1), ' ',-1) as word ,
COUNT(*) AS counter
from feed_collections
group by word
ORDER BY counter DESC;
The table has 1785123 rows and I thing this is the problem.
This is the error query…
Sergiu
- 61
- 8
0
votes
0 answers
MySQL, Error 1175 when executing an UPDATE using a JOIN and including the PK in the WHERE clause
Before I start I know that this can be solved by first executing the query. SET SQL_SAFE_UPDATES = 0; However, I am wanting to perform the update without having to first change the database's configuration every time.
I am attempting to update the…
Brook Julias
- 2,085
- 9
- 29
- 44