Hello,
On 4/17/2019 10:29 AM, Turritopsis Dohrnii Teo En Ming wrote:
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL
Injectable using sqlmap?
Good evening from Singapore,
Our customer (company name is Confidential/not disclosed) reported that their
MySQL
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL
Injectable using sqlmap?
Good evening from Singapore,
Our customer (company name is Confidential/not disclosed) reported that their
MySQL database has been found missing or was deleted a few times. They are
using
Hi there,
In MySQL 8, how can you figure out if an entry in the mysql.user table is a
role or a user?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB
Good morning from Singapore,
You can read my step-by-step tutorial on How to Setup Your Own e-Commerce
Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP)
in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were
configured in RAID 1 mirroring array
for num_of_day); expecting the
output: certain_day, pigId;from certain_day, pigId'weight increasing
continuously for num_of_day. How to select the records in one sql
statement?
thanks
I've thought about this a bit (since your question appeared on the list)
and I break down the tasks you
certain_day, pigId'weight increasing
continuously for num_of_day. How to select the records in one sql
statement?
thanks
;>> with no problems. The exception is mysql, the MySQL Command-Line
>>> >>> Tool. When I execute a SELECT statement to see rows in a table
>>> >>> containing the Venus and Mars Unicode characters, here is what I
>see
>>> >>> on the screen:
>>> &
ute a SELECT statement to see rows in a table
>>> containing the Venus and Mars Unicode characters, here is what I see
>>> on the screen:
>>>
>>> || Venus | ♀ | | Mars | ♂ | |
>>>
>>> What I should see in the right column are the standard glyphs for
> containing the Venus and Mars Unicode characters, here is what I see
>>> on the screen:
>>>
>>> || Venus | ♀ | | Mars | ♂ | |
>>>
>>> What I should see in the right column are the standard glyphs for
>>> Venus and Mars.
>>>
&
haracters, here is what I see
>>> on the screen:
>>>
>>> || Venus | ♀ | | Mars | ♂ | |
>>>
>>> What I should see in the right column are the standard glyphs for
>>> Venus and Mars.
>>>
>>> Any ideas about how to get the MySQL Com
see
on the screen:
|| Venus | ♀ | | Mars | ♂ | |
What I should see in the right column are the standard glyphs for
Venus and Mars.
Any ideas about how to get the MySQL Command-Line Tool to display
Unicode properly?
what operating system
what terminal
all recent Linux systems have UTF8
rows in a table containing the Venus
and Mars Unicode characters, here is what I see on the screen:
|| Venus | ♀ | | Mars | ♂ | |
What I should see in the right column are the standard glyphs for Venus
and Mars.
Any ideas about how to get the MySQL Command-Line Tool to display
Unicode
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use
Hi,
In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users
But how does one distinguish between roles and users?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL
uot; under Windows, see what others had to do for other
programs:
https://stackoverflow.com/questions/388490/unicode-characters-in-windows-command-line-how
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with
mysql itself.
Any ideas about how to get the MySQL Command-Line Tool to display Unicode
properly?
--
MySQL General Mailing List
For list archives: http
().
Best,
/ Carsten
On 08-10-2015 15:48, Richard Reina wrote:
If I insert a record into a table with an auto increment ID how can I get
that records ID value? I have read about SELECT LAST_INSERT_ID() statement,
however, do not two statements introduce the risk that another insert may
occur
If I insert a record into a table with an auto increment ID how can I get
that records ID value? I have read about SELECT LAST_INSERT_ID() statement,
however, do not two statements introduce the risk that another insert may
occur in the interum? Is there a full proof way of getting the ID
supplying a password. How is this possible although there is a password
for each user and for root in the user-table ?
I found it out by myself: I have a .my.cnf in my home-directory. I forgot.
Bernd
Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH
| *1939D66C9255EE78C765CD91B5FB465C7A9472D9 |
++--+---+
I know that this is not the best solution, I will change it.
Using mysql on a Linux-system I can login with mysql -u root without
supplying a password. How is this possible although
Yes, normally convert from latin1 to binary, and from binary to utf8 (which
would also be the recipe to convert actual utf8 data which accidentally
ended up in latin1 columns to the proper definition without changing the
content). I would not know why that would take overly long for you.
An
Hi there,
I am looking for a way to convert about 40GB of InnoDB tables from latin1
character set to utf8. As true conversion will take ages, I had the idea of
just changing the character sets (and preferably collation, too) of the tables
without actually converting the data. Conversion could
Reindl,
I am sorry, in my original post, I forgot to mention that the OLD box and
the NEW box are the same physical machine. I need to be able to save all
data into files on a memstick or portable disc and restore them to the newly
staged machine (with the new version of mysql).
-Grant
--
Hi Grant,
On 12/26/2014 11:18 AM, Grant Peel wrote:
Reindl,
I am sorry, in my original post, I forgot to mention that the OLD box and
the NEW box are the same physical machine. I need to be able to save all
data into files on a memstick or portable disc and restore them to the newly
staged
Shawn all,
Thank you for taking to time to reply.
So, to be clear, what I understand from your post is that replacing the
new build's grant/system tables with the archived ones from the previous
version, generally works fine, upgrade issues not withstanding. This is the
answer I
Am 26.12.2014 um 20:52 schrieb Grant Peel:
Shawn all,
Thank you for taking to time to reply.
So, to be clear, what I understand from your post is that replacing the
new build's grant/system tables with the archived ones from the previous
version, generally works fine, upgrade issues not
Hi all,
I was wondering if anyone knows of a concise tutorial on how to upgrade (by
moving from one box (old) to another box (new) mysql in a virtual
environment (many mysql users, many databases).
Example:
Mysql 5.x setup on freebsd 8.x (x86/32b), call this box A.
Want to move
Am 25.12.2014 um 16:01 schrieb Grant Peel:
I was wondering if anyone knows of a concise tutorial on how to upgrade (by
moving from one box (old) to another box (new) mysql in a virtual
environment (many mysql users, many databases).
Mysql 5.x setup on freebsd 8.x (x86/32b), call this box
Date: Thu, 11 Dec 2014 14:07:33 -0800
Subject: Re: How to retrieve next record?
From: mussa...@csz.com
To: larry.mart...@gmail.com
CC: mysql@lists.mysql.com
On Thu, December 11, 2014 13:43, Larry Martell wrote
, thanks.
BR, Hans.
Johan De Meersman schreef op 11-12-14 om 23:44:
- Original Message -
From: Wm Mussatto mussa...@csz.com
Subject: Re: How to retrieve next record?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = SELECT * FROM kentekenlogtest WHERE
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain. I have a DB with lots of columns, one is labeled as
'kenteken' and it is also the primary key in the DB. I poke into this DB
with the command
$sDBQuery1 = SELECT * FROM kentekenlogtest
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain. I have a DB with lots of columns, one is labeled as
'kenteken' and it is also the primary key in the DB. I poke into
On Thu, December 11, 2014 13:43, Larry Martell wrote:
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain. I have a DB with lots of columns, one is labeled as
'kenteken'
want, e.g.:
SELECT * FROM kentekenlogtest WHERE kenteken = $firstOneYouWant and
kenteken = $lastOneYouWant
Or if you know how many you want you could do:
SELECT * FROM kentekenlogtest WHERE kenteken = $firstOneYouWant limit
$howManyYouWant
--
MySQL General Mailing List
For list archives: http
Trianon 33 schreef op 11-12-14 om 23:20:
Wm Mussatto schreef op 11-12-14 om 23:07:
On Thu, December 11, 2014 13:43, Larry Martell wrote:
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com
wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
Date: Thu, 11 Dec 2014 14:07:33 -0800
Subject: Re: How to retrieve next record?
From: mussa...@csz.com
To: larry.mart...@gmail.com
CC: mysql@lists.mysql.com
On Thu, December 11, 2014 13
- Original Message -
From: Wm Mussatto mussa...@csz.com
Subject: Re: How to retrieve next record?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = SELECT * FROM kentekenlogtest WHERE kenteken
'$sActueelkenteken' limit 1
might work
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=* --user=wybo
I get:
ERROR 1045
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse
Yes, that worked - thank you very much!
On 2014-08-20 22:51, shawn l.green wrote:
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
when i used mysql as the keystone's backend in openstack ,i found that the
'token' table saved 29 millions record (using myisam as engine,the size of
token.MYD is 100G) and have 4 new token save per second. That result to the
slow query of a token .since of inserting new token frequently,how
On Thu, Jul 10, 2014 at 10:33:04AM +0800, 娄帅 wrote:
In the C API, we can call mysql_query(select 1; select 2);
which just send the command once to the server, and server
return two result sets, So i want to know if there is a command in the
mysqltest framework to do the job?
I want to write a
Hi.
mysql describe unions_data;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| ID | int(11) | NO | PRI | NULL|
Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
-Original Message-
From: Surya Savarika
Sent: Wednesday, July 09, 2014 3:56 PM
To: mysql@lists.mysql.com
Subject: Cannot Update, at least not how I'm telling it to!
Hi.
mysql describe unions_data
Hi, all,
In the C API, we can call mysql_query(select 1; select 2);
which just send the command once to the server, and server
return two result sets, So i want to know if there is a command in the
mysqltest framework to do the job?
I want to write a test case like that.
Thank you for your
don't use GTID is my suggestion :)
2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com:
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this version. Now i check the bugfix section in MySQL 5.6.19 and above
version. Am i doing the right thing? Or Do
Why do not use GTID? Just curious...WB
2014-07-07 3:18 GMT-03:00 louis liu yloui...@gmail.com:
don't use GTID is my suggestion :)
2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com:
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this
Am 07.07.2014 12:37, schrieb wagnerbianchi.com:
Why do not use GTID? Just curious...WB
just read the changelogs and endless count of bugreports
it's a new feature and it works as buggy as replication
years ago where you had the rebuild the slave all the
time and maybe still if temporary
bugs. Our development teams
have limited resources. We triage and prioritize what they can work on
based on how severe the bug is, how often is may be encountered, and how
easy it may be to work around.
http://bugs.mysql.com/search.php?search_for=status[]=Activeseverity=limit=Allorder_by
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this version. Now i check the bugfix section in MySQL 5.6.19 and above
version. Am i doing the right thing? Or Do you have a better method?
Any input will be appreciated!
Hi:
I tried to get a S-lock using following SQL:
1. start transaction;
SELECT * FROM test.t1 where id=1;
But I found this way does not work. I changed it as following:
2. start transaction;
SELECT * FROM test.t1 where id=1 lock in share mode;
I am wondering why the
2014-05-15 14:26 GMT+02:00 Antonio Fernández Pérez
antoniofernan...@fabergroup.es:
Hi,
I have in my server database some tables that are too much big and produce
some slow query, even with correct indexes created.
For my application, it's necessary to have all the data because we
- Original Message -
From: Manuel Arostegui man...@tuenti.com
Subject: Re: Big innodb tables, how can I work with them?
noSQL/table sharding/partitioning/archiving.
I keep wondering how people believe that NoSQL solutions magically don't need
RAM to work. Nearly all of them slow
2014-05-19 11:49 GMT+02:00 Johan De Meersman vegiv...@tuxera.be:
- Original Message -
From: Manuel Arostegui man...@tuenti.com
Subject: Re: Big innodb tables, how can I work with them?
noSQL/table sharding/partitioning/archiving.
I keep wondering how people believe that NoSQL
What kind of queries is this table serving? 8GB is not a huge amount of
data at all and IMO it's not enough to warrant sharding.
On Thu, May 15, 2014 at 1:26 PM, Antonio Fernández Pérez
antoniofernan...@fabergroup.es wrote:
Hi,
I have in my server database some tables that are too
support this amount but in this case and thinking in the
future, I have this problem with my architecture; how can I grow in
database servers without delete rows in the tables.
I have checked slow queries and now there aren't.
These tables are serving queries from FreeRADIUS service. For example
Hi,
I have in my server database some tables that are too much big and produce
some slow query, even with correct indexes created.
For my application, it's necessary to have all the data because we make an
authentication process with RADIUS users (AAA protocol) to determine if one
user can
Am 15.05.2014 14:26, schrieb Antonio Fernández Pérez:
I have in my server database some tables that are too much big and produce
some slow query, even with correct indexes created.
For my application, it's necessary to have all the data because we make an
authentication process with RADIUS
Dear all,
After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing
error:
how to set SET SQL_BIG_SELECTS=1 ?
Error is
*Warning*: The SELECT would examine more than MAX_JOIN_SIZE rows; check
your WHERE and use SET SQL_BIG_SELECTS=1 or SET
Am 28.02.2014 12:17, schrieb Madan Thapa:
After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing
error:
how to set SET SQL_BIG_SELECTS=1?
just type it before your query in question?
as you can see below if you try such things
and they are not supported or you have a typo
:
Am 28.02.2014 12:17, schrieb Madan Thapa:
After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing
error:
how to set SET SQL_BIG_SELECTS=1?
just type it before your query in question?
as you can see below if you try such things
and they are not supported or you have a typo
upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing
error:
how to set SET SQL_BIG_SELECTS=1?
just type it before your query in question?
as you can see below if you try such things
and they are not supported or you have a typo
you get a crear error, otherwise OK
MariaDB [(none
How to make multiple master replicate to single slave in mysql?
Tell me some approaches?
Thanks
Zhigang
On 2/25/2014 9:55 PM, Zhigang Zhang wrote:
How to make multiple master replicate to single slave in mysql?
Tell me some approaches?
Put your masters in a replication ring, hang a slave from one of them
(as suggested by Mr. Van der Westhuizen)
Use an external product
OK!
Thank you very much!
Zhigang.
-Original Message-
From: shawn l.green [mailto:shawn.l.gr...@oracle.com]
Sent: Wednesday, February 26, 2014 11:57 AM
To: mysql@lists.mysql.com
Subject: Re: How to make multiple master to single slave in mysql?
On 2/25/2014 9:55 PM, Zhigang Zhang
--databases, methinks.
- Original Message -
From: Daevid Vincent dae...@daevid.com
To: mysql@lists.mysql.com
Sent: Thursday, 21 November, 2013 10:44:39 PM
Subject: How do I mysqldump different database tables to the same .sql file?
I'm working on some code where I am trying
There is a good reason that the USE database is not output in those dumps..
it would make the tool very difficult to use for moving data around.
If I might suggest, a simple workaround is to create a shell script along
these lines.. you might to do something a little more sophisticated.
wanting a backup/dump of a database to restore).
Thanks for the shell script suggestion, that is what I've done already to
work around this silliness.
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Thursday, November 21, 2013 1:59 PM
To: MySql
Subject: Re: How
I'm working on some code where I am trying to merge two customer accounts
(we get people signing up under different usernames, emails, or just create
a new account sometimes). I want to test it, and so I need a way to restore
the data in the particular tables. Taking a dump of all the DBs and
=
I want the url is unique when inserting it.
I googled and found
http://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
this post suggests use md5 of url. But in theory, there will be
conflict that two different urls will have the same md5(even it's
probablitiy
.
-Original Message-
From: Dan Nelson [mailto:dnel...@allantgroup.com]
Sent: Tuesday, November 05, 2013 7:56 AM
To: Li Li
Cc: mysql@lists.mysql.com
Subject: Re: how to create unique key for long varchar?
In the last episode (Nov 05), Li Li said:
I want to create a table with a long
I want the url is unique when inserting it.
I googled and found
http://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
this post suggests use md5 of url. But in theory, there will be
conflict that two different urls will have the same md5(even it's
probablitiy
=
I want the url is unique when inserting it.
I googled and found
http://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
this post suggests use md5 of url. But in theory, there will be
conflict that two different urls will have the same md5(even it's
://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
this post suggests use md5 of url. But in theory, there will be
conflict that two different urls will have the same md5(even it's
probablitiy is very small). I want to a absolute correct solution.
one method i can come up with is using
when inserting it.
I googled and found
http://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
this post suggests use md5 of url. But in theory, there will be
conflict that two different urls will have the same md5(even it's
probablitiy is very small). I want to a absolute correct
in the HotelRegion table.
Basically how can I update the City table with the correct RegionId where
the HotelId in the HotelRegion table matches the City table's CityId.
This is my UPDATE statement at the moment
UPDATE City cSET c.RegionId = (SELECT DISTINCT(HotelRegion.RegionId)
FROM HotelRegion INNER JOIN
I have the following four MySQL tables
Region
RegionId
City
CityId
RegionId
Hotel
HotelId
CityId
HotelRegion
HotelId
RegionId
I'm struggling to write a UPDATE statement to update the City table's
RegionId field from data in the HotelRegion table.
Basically how can I update the City table
On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote:
how to get the levels of a table or a index in Mysql 5.6?
Level? What is level supposed to be in that context?
Cardinality? Or something completely different?
/me confused ...
--
Hartmut Holzgraefe hart...@skysql.com
Principal Support Engineer
Or maybe the number of levels in the BTree?
Rule of Thumb: logarithm base 100
-Original Message-
From: Hartmut Holzgraefe [mailto:hart...@skysql.com]
Sent: Monday, July 08, 2013 6:38 AM
To: mysql@lists.mysql.com
Subject: Re: how to get the levels of a table or a index in Mysql 5.6
The level is the height of a B-tree table or a B-tree index in mysql 5.6.
My question is how to get the height(blevel) of a B-tree table or a B-tree
index in mysql 5.6?
Thanks.
In oracle database,we can use the following statement to query the blevel of a
index
select index_name,blevel
Hi
how to get the levels of a table or a index in Mysql 5.6?
thanks
The information in this email is confidential and may be legally privileged. If
you have
If a crash occurs in the middle of an ALTER, the files may not get cleaned up.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, June 20, 2013 12:57 PM
To: mysql@lists.mysql.com
Subject: Re: How can I drop a table that is named “logs/#sql-ib203
that is what we all know
but how to get rid of them?
but *why* they are not cleaned up?
* the global tablespace knows about them
* nothing is using them really
* so why can mysqld not cleanup this mess?
if you delete them all works fine but each start
the error-log is cluttered
Am 25.06.2013
Hi Frank,
On 20/06/2013 05:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table
Franck,
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
A table `logs/#sql-ib203` appeared after a MySQL crash
the #sql-ibtableID tables are temporarily created during an
ALTER TABLE operation for recovery purposes. Apparently these
temporary tables might stay in certain circumstances
display 'logs/#sql-ib203', which is the table name
MySQL complains it exists when I try to do ALTER.
I use innodb_file_per_table. There was a mysql_datadir/logs/#sql-ib203.ibd
file (or maybe .frm, sorry I forgot) that I deleted.
Any idea how to get rid of this ghostly table `logs/#sql-ib203`?
I use
On Thu, Jun 20, 2013 at 7:13 AM, Denis Jedig d...@syneticon.net wrote:
If you already tried enclosing the table name in backticks (DROP TABLE
`#sql-ib203`) and using the DROP TEMPORARY TABLE syntax without success,
Yep, no success with:
DROP TEMPORARY TABLE `logs/#sql-ib203`;
DROP TEMPORARY
On Thu, Jun 20, 2013 at 3:28 PM, Rick James rja...@yahoo-inc.com wrote:
#sql files are temp tables that vanish when the ALTER (or whatever)
finishes. If you find one sitting around, it sounds like a crash happened
in the middle of the ALTER.
Yes the crash happened during an ALTER: the table
i know what happened but how get rid of these two bullshit files
after *three years* not touched and used by mysqld
Am 20.06.2013 21:28, schrieb Rick James:
#sql files are temp tables that vanish when the ALTER (or whatever) finishes.
If you find one sitting around, it sounds like a crash
To: mysql@lists.mysql.com
Subject: Re: How can I drop a table that is named “logs/#sql-ib203” and
appeared after MySQL crash?
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
`USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`,
but when trying to `ALTER` the table
deleted.
Any idea how to get rid of this ghostly table `logs/#sql-ib203`?
I use MySQL 5.6.12-winx64 and InnoDB.
Thanks,
Franck Dernoncourt
fran...@mit.edu
http://francky.me
Error Code: 1051.
Unknown table 'logs.logs/#sql-ib203', Error Code: 1051. Unknown table
I use innodb_file_per_table. There was a mysql_datadir/logs/#sql-ib203.ibd
file (or maybe .frm, sorry I forgot) that I deleted.
Any idea how to get rid of this ghostly table `logs/#sql-ib203
2013/06/13 23:08 +, Rick James
FIND_IN_SET might work the cleanest...
WHERE FIND_IN_SET('action', genres) OR/AND [NOT] ...
And have genres look like 'action,drama,foobar', that is comma-separators, and
no need for leading/trailing comma.
That would also work for genres = '1,3,10,19,38' and
2013/06/11 12:59 -0700, Daevid Vincent
Also, just for SG this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while clever is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare substrings
2013/06/11 12:59 -0700, Daevid Vincent
Also, just for SG this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while clever is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare substrings
, 2013 4:17 PM
To: mysql@lists.mysql.com
Cc: 'shawn green'
Subject: RE: How do I select all rows of table that have some rows in
another table (AND, not OR)
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, June 11, 2013 2:16 PM
To: mysql
Hello Daevid,
On 6/11/2013 7:17 PM, Daevid Vincent wrote:
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, June 11, 2013 2:16 PM
To: mysql@lists.mysql.com
Subject: Re: How do I select all rows of table that have some rows in
another table
: 'shawn green'
Subject: RE: How do I select all rows of table that have some rows in
another table (AND, not OR)
Thinking out of the box... (And posting my reply at the 'wrong' end of the
email.)...
Are there fewer than 64 genres? Use a SET or BIGINT UNSIGNED
Oh! I must have misread. I didn't see how you had a solution for 64 bits.
I may have to experiment with that!
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Wednesday, June 12, 2013 11:26 AM
To: mysql@lists.mysql.com
Subject: RE: How do I select all rows
1 - 100 of 6661 matches
Mail list logo
