Hello mysql,
When trigger on table uses select from same table, then bulk insert into
this table cause error.
How to repeat:
create table t(i int not null, j int not null, n numeric(15,2), primary
key(i,j));
create table s(i int not null, n numeric(15,2), primary key(i));
delimiter //
crea
Hello.
> [ERROR] Fatal error: Can't open privilege tables: Can't find file:
> './mysql/host.frm' errno: 13)"
perror 13
OS error code 13: Permission denied
Check that mysql user has rights on mysql directory.
Charles Gambrell wrote:
> I am running Whitebox linux 4 and have MyS
Hello.
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
Put Area in backticks ('`'). See:
http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
Nabegh Al-Thalji wrote:
> When I execute the following query
>
> CREATE TABLE Sponsor (
> sNum INTEGER UNSIGNED NOT NULL,
> sAdr
I need to be able to add a foreign key that will allow a constant is
possible.
I have a table named Campers that has a field named ID. I also have another
table called Counselors that has a field named ID as well. There is a
detailed table called ActivitySelections that I use for both Camper
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am
I doing wrong?
2. The 3rd to the last line:
and (p.value - t.amount) < -1000
I wanted to say
diff < -1000
but mysql
Joseph Alotta wrote:
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am I
doing wrong?
> set @maxdate = select max(date) from positions where account =
> "111200512343222";
select (