Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 40129

An open-source, relational database management system.

2
votes
1answer
Can this command be scripted? $ mysqladmin -u username -p create databasename I'd like to do it for multiple names all at once? Also I'd like to then set permissions for all of them at once as well …
asked Oct 27 '13 by cea
0
votes
1answer
I have six different sites set up with their respective databases on my server all linking to one localhost ip. Three of those users I set up from root have access only to the one database associated …
asked Jul 4 '13 by cea
0
votes
2answers
When show databases there is the information_schema below it listing my created databases but what is 'USER' and 'mysql' listed in there? I don't know if ages ago I made a mistake and created them or if they are default listings which reveal something? …
asked Oct 27 '13 by cea
2
votes
. To export mysql database table to CSV file you log in to admin then use following commands. SELECT * INTO OUTFILE '/tmp/products.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES …
answered Nov 6 '14 by cea
0
votes
2answers
How do I do this in command line? Below is code i saw imported to PhpmyAdmin but i don't use any interface... CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_ …
asked Feb 24 '16 by cea
2
votes
1answer
How do I export from MYSQL to CSV in mariadb on Centos 7? I am using: Server version 5.5.37-MariaDB Protocol version 10 Connection Localhost via UNIX socket UNIX socket … /var/lib/mysql/mysql.sock on CentOS Linux release 7.0.1406 (Core) I tried the following: mysql> SELECT * -> INTO OUTFILE 'cd /var/foo.csv' -> FIELDS TERMINATED BY …
asked Nov 5 '14 by cea