Recent questions tagged MySQL:

0 votes

562 views

1 answer

mysql: select, insert, delete and update in one query

i need in one query use select, insert, delete and update. (I need copy data from old table in to new, then ... FROM news WHERE id > 21 Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

457 views

1 answer

mysql: select all items from table A if not exist in table B

I am having problem with selecting values from table a (id, room_name) where there are no corresponding events ... all rooms having NO events. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

470 views

1 answer

mysql: select all items from table A if not exist in table B

I am having problem with selecting values from table a (id, room_name) where there are no corresponding events ... all rooms having NO events. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

565 views

1 answer

mysql: What is the right syntax for NOT LIKE?

Hi I am trying to show tables with names not like a pattern by mysql is throws an error: SHOW TABLES NOT ... is the right syntax? Thanks Arman. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

617 views

1 answer

mysql: how to truncate the length of a field

Alter table merry_parents change mobile mobile char(10). When I do the above I'm getting error: #1265 - Data ... Currently it is char(12). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

441 views

1 answer

mysql: select max(score) doesn't return the relevant row data

if i have for example a scores table: user game score timestamp 1 50 50 date 2 60 40 date 3 70 25 date ... returned are not from that same row. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

926 views

1 answer

mysql: Cant we create triggers on system tables?

I am trying to audit the privilege changes in mysql.user table by writing a trigger on it. insert trigger: will ... .61] ? Thanks in advance. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

617 views

1 answer

mysql: SOURCE error 2?

When I tried to source for a particular .sql file, namely 'metropolises.sql' that I created and saved previously ... Any idea what went wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

743 views

1 answer

mysql: connection refused when trying to connect to localhost using remote IP

When I try to connect to a local mysql database using it's remote ip-address I get a access denied. When I try ... the MySQL version is 5.5.23. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

642 views

1 answer

mysql: see all open connections to a given database?

With administrative permissions im mysql, how can I see all the open connections to a specific db in my server? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

626 views

1 answer

mysql: why comparing a 'string' to 0 gives true?

I was doing some MySQL test queries, and realized that comparing a string column with 0 (as a number) gives TRUE! select ... = 0 ? why is that? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags