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 and
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
y 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 dow
from certain_day, pigId'weight increasing
continuously for num_of_day. How to select the records in one sql
statement?
thanks
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:
>>> >>>
>>> &g
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.
>>>
&
aracters, 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 a
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
cmd" 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
| ♂ |
I get the same 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 M
RT_ID().
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
occ
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 of the
gt; ++--+---+
>
> 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 there is a pa
.0.1 | root | *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 po
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 altern
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 b
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 wit
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
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 mach
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
--
MySQ
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 A
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 to
theless a good start, thanks.
BR, Hans.
Johan De Meersman schreef op 11-12-14 om 23:44:
- Original Message -
From: "Wm Mussatto"
Subject: Re: How to retrieve next record?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = "SELECT *
$con!=null
Martin Gainty
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
- Original Message -
> From: "Wm Mussatto"
> 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
l
Martin Gainty
> 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.
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
wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain.
o select the rows you want
>> and control the order with a sort or within your program.
>
> Hello Larry, hm.
>
> My rows are ordered.
No, the data in the database is not ordered.
> 0001ES, comes before 0002ES, etc. But so far that
> doesn't really matter.
>
&g
On Thu, December 11, 2014 13:43, Larry Martell wrote:
> On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 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 i
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 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 this DB
> with
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 WH
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
phpMysqlAdmin
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 th
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 --pass
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 (2
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
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 w
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 repl
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 uni
Hi.
mysql> describe unions_data;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| ID | int(11) | NO | PRI | NULL| au
rtant high-impact 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[]=Active&s
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 table
Why do not use GTID? Just curious...WB
2014-07-07 3:18 GMT-03:00 louis liu :
> don't use GTID is my suggestion :)
>
>
>
> 2014-07-07 7:42 GMT+08:00 娄帅 :
>
> > 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"
don't use GTID is my suggestion :)
2014-07-07 7:42 GMT+08:00 娄帅 :
> 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
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 fi
know that MySQL 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
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 ar
2014-05-19 11:49 GMT+02:00 Johan De Meersman :
>
> - Original Message -
> > From: "Manuel Arostegui"
> > Subject: Re: Big innodb tables, how can I work with them?
> >
> > noSQL/table sharding/partitioning/archiving.
>
> I keep wondering how
- Original Message -
> From: "Manuel Arostegui"
> 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
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 be
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 RA
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
ot;,
> $type);
>
> ./includes/bootstrap.inc: elseif (db_is_active() && (($file =
> db_result(db_query("SELECT filename FROM {system} WHERE name = '%s' AND
> type = '%s'", $name, $type))) && file_exists($file))) {
>
> On Fri, Feb 2
RE name = '%s' AND
type = '%s'", $name, $type))) && file_exists($file))) {
[root@server public_html]#
please advise.
thanks
On Fri, Feb 28, 2014 at 4:57 PM, Reindl Harald wrote:
>
> Am 28.02.2014 12:17, schrieb Madan Thapa:
>
> > After up
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 s
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_SELECT
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
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)
Us
How to make multiple master replicate to single slave in mysql?
Tell me some approaches?
Thanks
Zhigang
--databases, methinks.
- Original Message -
> From: "Daevid Vincent"
> 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 co
21, 2013 1:59 PM
> To: MySql
> Subject: Re: How do I mysqldump different database tables to the same .sql
> file?
>
> 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
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.
###
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 table
bb
>>> 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
g params such as
> >> a.html?q=&fl=
> >> I want the url is unique when inserting it.
> >> I googled and found
> >> http://stackoverflow.com/questions/6800866/how-to-store-urls-in-mysql
> >>
a&fl=
>> 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
>> conflic
.
> -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:
> >
aaa&fl=
> 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 differ
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 is very small). I
ata 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 HotelRe
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
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
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
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
Principal Support Engineer (EMEA)
SkySQL
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
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
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 n
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 `logs/#sql-i
12:19 PM
> 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`
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
On Thu, Jun 20, 2013 at 3:28 PM, Rick James 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 `logs/#sql-ib203`
On Thu, Jun 20, 2013 at 7:13 AM, Denis Jedig 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 TABLE `/#sql-ib20
wn table 'logs.sql-ib203'). Interestingly none of
these error messages 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,
Franck,
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
A table `logs/#sql-ib203` appeared after a MySQL crash
the #sql-ib tables are temporarily created during an
ALTER TABLE operation for recovery purposes. Apparently these
temporary tables might stay in certain circumstances even after
either do some name variants
> `/#sql-ib203`, `#sql-ib203`, `sql-ib203`. (respectively 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
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 MySQL 5.6.12-winx64 and InnoDB.
Thanks,
Franck Dernoncourt
fran...@mit.edu
http://francky.me
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,
>>>> 2013/06/11 12:59 -0700, Daevid Vincent >>>>
Also, just for S&G 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 requ
>>>> 2013/06/11 12:59 -0700, Daevid Vincent >>>>
Also, just for S&G 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 requ
I am so, so glad that someone finally said what I think each time I see a
message from you Mr. James.
Original message
From: Rick James
Date: 06-12-2013 8:45 PM (GMT-04:00)
To: Daevid Vincent ,mysql@lists.mysql.com
Subject: RE: How do I select all rows of table that have
ent: Wednesday, June 12, 2013 11:26 AM
> To: mysql@lists.mysql.com
> Subject: RE: How do I select all rows of table that have some rows in
> another table (AND, not OR)
>
> This idea is so fancy pants and clever I *wish* it could have worked for
> me.
> I checked and we actual
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:
ne 12, 2013 9:39 AM
> To: Daevid Vincent; 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)
>
> Thinking out of the box... (And posting my reply at the 'wrong' end o
1 - 100 of 6935 matches
Mail list logo