Trực tuyến Hạ Trường hợp chuyển đổi

I've just compiled the version MySQL 8.0.12 in a Ubuntu 16.0.4.

After following the instructions in the website and making the following my.cnf file:

[mysqld]datadir=/usr/local/mysql/datasocket=/tmp/mysql.sockport=3306log-error=/usr/local/mysql/data/localhost.localdomain.erruser=mysqlsecure_file_priv=/usr/local/mysql/mysql-fileslocal_infile=OFFlog_error = /var/log/mysql/error.log# Remove case sensitive in table nameslower_case_table_names=1

I get the following error:

2018-08-11T19:45:06.461585Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').

What should I change so that data dictionary is aligned to server settings?

So this is the brief:i need to input something like:

BaSe fOO ThE AttAcK

and return:

attack the base.

As you can see to decode this i need to start by reading the words in reverse order and if the first letter of the word isupper() then make it lowercase and append it to a list which i will later print. This is what i have so far:

# Enter your code for "BaSe fOO ThE AttAcK" here.default = input('code: ')listdefault = default.split()uncrypted = []for i in range(len(listdefault)):  if listdefault[:-i].istitle(): # doesn't work    i = i.lower() # dont know if this works, Should convert word to lower case.    uncrypted.append(i)solution = ' '.join(uncrypted)print(solution)

Can someone show me how to get this program to work? Says that i can't use the istitle() method on a list type..

I have a table like this on postgres. the table below is a part of a CSV file which has been imported into a postgresql Database using "fast-csv" library via node.js:

------------------------------------names            | slug------------------------------------St.John          |                  ------------------------------------Prince-Duke Ed   |------------------------------------

I'm trying to generate the data from column "name" and put it in column "slug" by lowercasing it, replacing spaces with dashes, and cleaning special characters like dots.

I couldn't find any syntax in Knex.js to do this duplicating and manipulating data . How can I do this using Node.js dynamically?

I am trying to run a query using Eloquentthe $vars['language'] is in lower case but the language column is not necessarily in lower case. How can i do this search using eloquent but still have the lower case in the query

Item::where('language', $vars['language'])

What i want to do is this even though i can't find anywhere how to do this

Item::where('LOWER(language)', $vars['language'])

so that they are both in lowercase and then i can get them to match.

Here's my data:

Id   var_map1    {'email_count': 3.0, 'outgoing': 90.0}2    {'Email_Count': 5.0, 'outgoing': 91.0}

What I did is

df['var_map'] = score_data['var_map'].str.lower()

The result is different with why I expected, the error is are this

Id   var_map1    NaN2    NaN

How do I suppose to solve this