Hi,
does anyone knows the command to show the size of the SQL-database?
thanks,
Search found 194 matches
- Wed Sep 05, 2012 3:07 pm
- Forum: SQL
- Topic: How do I find the size of my database?
- Replies: 1
- Views: 18384
- Sat Sep 01, 2012 9:05 pm
- Forum: Servers
- Topic: Where does MySQL store it database files
- Replies: 2
- Views: 31668
Re: Where does MySQL store it database files
Thanks for the info
- Sat Sep 01, 2012 9:05 pm
- Forum: MySQL
- Topic: Where does MySQL store it database files
- Replies: 2
- Views: 24686
Re: Where does MySQL store it database files
Thanks for the info
- Sat Sep 01, 2012 8:52 pm
- Forum: Servers
- Topic: convert MySQL db from Latin1 to UTF8
- Replies: 1
- Views: 30323
convert MySQL db from Latin1 to UTF8
Hi, My MySQL-database is set to latin1, but I want to convert it to UTF8. I already added default-character-set=utf8 to /etc/mysql/my.cng But I still get the following: Connection id: 371 Current database: db Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using ...
- Sat Sep 01, 2012 8:52 pm
- Forum: MySQL
- Topic: Solved: convert MySQL db from Latin1 to UTF8
- Replies: 7
- Views: 134314
Solved: convert MySQL db from Latin1 to UTF8
Hi, My MySQL-database is set to latin1, but I want to convert it to UTF8. I already added default-character-set=utf8 to /etc/mysql/my.cng But I still get the following: Connection id: 371 Current database: db Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using ...
- Wed Aug 29, 2012 8:16 pm
- Forum: SQL
- Topic: Set bit to TRUE/FALSE
- Replies: 1
- Views: 17853
Set bit to TRUE/FALSE
Hello,
I'm trying to store a value in a BIT data type as True/False
But I have troubles to set it to True.
It also doesn't show FALSE when I do a select.
Anyone know how to solve this?
I'm trying to store a value in a BIT data type as True/False
Code: Select all
CREATE TABLE test
(
id VARCHAR(40) PRIMARY KEY,
value BIT DEFAULT FALSE
);
It also doesn't show FALSE when I do a select.
Anyone know how to solve this?
- Wed Aug 22, 2012 3:18 pm
- Forum: SQL
- Topic: SQL count results from group by
- Replies: 1
- Views: 17635
SQL count results from group by
Hi, I would like to know the total rows returned by a "Group by"-query. SELECT table1.id, table2.name,table3.name FROM table1, table2, table3 WHERE (associate table1, table2 and table3 to each other) GROUP BY table1.id I could use count() but together with GROUP BY , it gives the subtotals...
- Wed Aug 22, 2012 7:28 am
- Forum: Servers
- Topic: Where does MySQL store it database files
- Replies: 2
- Views: 31668
Where does MySQL store it database files
Hi,
does anyone knowns where MySQL stores the database files?
Thanks,
does anyone knowns where MySQL stores the database files?
Thanks,
- Wed Aug 22, 2012 7:28 am
- Forum: MySQL
- Topic: Where does MySQL store it database files
- Replies: 2
- Views: 24686
Where does MySQL store it database files
Hi,
does anyone knowns where MySQL stores the database files?
Thanks,
does anyone knowns where MySQL stores the database files?
Thanks,
- Thu Aug 16, 2012 6:19 pm
- Forum: PHP
- Topic: Solved: How to open 2 mysql databases in php
- Replies: 2
- Views: 23124
Re: How to open 2 mysql databases in php
Thanks
Didn't know about the 4th parameter true.
Didn't know about the 4th parameter true.