58
votes
11
answers
1.8K
views
How can I find all the tables in MySQL with specific column names in them?
I have 2-3 different column names that I want to look up in the entire database and list out all tables which
58
votes
26
answers
1.9K
views
How do you set a default value for a MySQL Datetime column?
How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(). What is the eq
54
votes
14
answers
2.1K
views
How do I specify unique constraint for multiple columns in MySQL?
I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want
58
votes
20
answers
480
views
MySQL error code: 1175 during UPDATE in MySQL Workbench
I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writi
51
votes
17
answers
682
views
How to get the sizes of the tables of a MySQL database?
I can run this query to get the sizes of all tables in a MySQL database: show table status from myDatabaseNam
60
votes
30
answers
1.7K
views
How do I quickly rename a MySQL database (change schema name)?
The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This
55
votes
8
answers
2.4K
views
What's the difference between utf8_general_ci and utf8_unicode_ci?
Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?
51
votes
26
answers
318
views
How do I connect to a MySQL Database in Python?
How do I connect to a MySQL database using a python program?
56
votes
13
answers
783
views
Which MySQL data type to use for storing boolean values
Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse&ap
50
votes
30
answers
1.4K
views
How can I output MySQL query results in CSV format?
Is there an easy way to run a MySQL query from the Linux command line and output the results in CSV format? He
54
votes
15
answers
1.7K
views
How can I get a list of user accounts using the command line in MySQL?
I'm using the MySQL command-line utility and can navigate through a database. Now I need to see a list of
61
votes
11
answers
518
views
Installing specific package versions with pip
I'm trying to install version 1.2.2 of the MySQL_python adaptor, using a fresh virtualenv created with th
52
votes
30
answers
922
views
Should I use the datetime or timestamp data type in MySQL?
Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP
54
votes
2
answers
1K
views
Logically select categories and subcategories (php,joomla,javascript,ajax)
Hello I have installed jbusinessdirectory component for joomla, and I have module named mod_jbusinessdirectory
73
votes
5
answers
2.4K
views
Joomla Database - How to use LIMIT in getQuery?
I want to build the below query using joomla inbuilt database class. SELECT * FROM table_name ORDER BY id DE
53
votes
4
answers
2.3K
views
SQL query to prepend prefix to existing value in a field
I have searched and searched for an answer to this, and I think this must be child's play for anyone who
48
votes
6
answers
2.4K
views
What is Drupal's default password encryption method?
I am trying to figure out what is the security that Drupal 6/7 uses by default to store passwords. Is it MD5,
55
votes
7
answers
2.1K
views
Securing php api to use in android application
I am newbie to android development. I am using android studio for developing an application. Things i have don
54
votes
4
answers
1.4K
views
"Invalid parameter number: parameter was not defined" Inserting data
I've been using Yii's active record pattern for a while. Now, my project needs to access a differen
55
votes
8
answers
1.5K
views
Yii2 How to perform where AND or OR condition grouping?
I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models
