Stack Overflow
Stack Overflow

Questions tagged [mysql-error-1235]

Error 1235 - This version of MySQL doesn't yet support ...

Error 1235 - This version of MySQL doesn't yet support ...

Cause:

You tried to use functionality that your MySQL instance doesn't support.

Solution:

Re-write the query to use functionality that the version of MySQL you are using supports.

9 questions
17
votes
2 answers

MySQL error code 1235

In MySQL I tried to define a trigger like this: DELIMITER $$ CREATE TRIGGER vipInvite AFTER INSERT ON meetings FOR EACH ROW BEGIN IF(NOT EXISTS (SELECT * FROM participants WHERE meetid = NEW.meetid AND pid ='vip')) THEN …
user2817052
  • 171
  • 1
  • 1
  • 3
12
votes
4 answers

Problem with LIMIT & IN/ALL/ANY/SOME subquery

I have this query: SELECT count(cp.CxID) as intSmokers FROM CustPrimarySmoking cp JOIN Customer c ON cp.CxID = c.CustomerID WHERE cp.CxID IN (SELECT CxID FROM CustPrimarySmoking WHERE CxID = cp.CxID LIMIT 1, 9999) The idea being that the count…
TheBounder
  • 407
  • 2
  • 5
  • 9
8
votes
3 answers

Is there a workaround for using LIMIT in a subquery in MySQL?

Here is my original query... SELECT `id` FROM `properties` LIMIT 10, 20 The LIMIT condition is for pagination. Now, I have to get all like before, but I need to get only a third of rows where a condition is present. I came up with this, just…
alex
  • 479,566
  • 201
  • 878
  • 984
6
votes
2 answers

Deleting the nth row mysql

I'm using MySQL v5.0.45 and trying to delete the nth row in a table irrespective of its ID number. I set up a prototype in PHP before integrating it into my web development project where I set up the following in my database: CREATE TABLE…
Riyan
  • 187
  • 2
  • 5
  • 9
5
votes
3 answers

Why do I get an "This version of MySQL doesn't yet support '...'" error?

I have a query like following: delimiter $$ DROP TRIGGER IF EXISTS TR_SCIN_BANK_UPD$$ CREATE TRIGGER TR_SCIN_BANK_UPD AFTER UPDATE ON SCIN_BANK FOR EACH ROW BEGIN IF OLD.BANK_NAME != NEW.BANK_NAME THEN INSERT into SCIN_BANK_LOG SET…
Ganesh
1
vote
2 answers

MySQL Trigger creation

I have an application where I need to INSERT an auto_increment value from a PK in another table. I know how to do this in PHP, but I need to have this done at the DB level, since I cannot change the program logic. I am new to triggers, so I'm sure…
bgarlock
  • 117
  • 2
  • 8
0
votes
1 answer

Writing Triggers in MySQL in regards to BEFORE UPDATE

I am very new to Triggers and so this is a very beginner question. I am trying simply to, before a row updates, store its id, old and new values, and the current date into a new table. I have tried the following: DELIMITER // DROP TRIGGER IF…
id2341677
  • 319
  • 6
  • 13
0
votes
0 answers

MySQL Error 1235

I am getting MySQL error 1235, and have already tried all the solutions I could find on SO. -- -- Trigger `buying_tasks` -- DELIMITER $$ CREATE TRIGGER `lock_user_of_task_buying_task` BEFORE INSERT ON `buying_tasks` FOR EACH ROW UPDATE `users`…
Jame
  • 1
  • 1
0
votes
1 answer

How to create a trigger with multiple actions in MySQL 5.0.45?

I'm working in phpMyAdmin and I'm new to creating MySQL 5.0.45 triggers. I'm trying to create a trigger that will help me validate data by throwing an error when a value it out of range. This works just fine: create trigger t1 before insert on…
kmcamara
  • 187
  • 3
  • 5
  • 16