Search found 194 matches

Go to advanced search

by mister_v
Wed Sep 05, 2012 3:07 pm
Forum: SQL
Topic: How do I find the size of my database?
Replies: 1
Views: 18383

How do I find the size of my database?

Hi,

does anyone knows the command to show the size of the SQL-database?

thanks,
by mister_v
Sat Sep 01, 2012 9:05 pm
Forum: Servers
Topic: Where does MySQL store it database files
Replies: 2
Views: 31647

Re: Where does MySQL store it database files

Thanks for the info
by mister_v
Sat Sep 01, 2012 9:05 pm
Forum: MySQL
Topic: Where does MySQL store it database files
Replies: 2
Views: 24676

Re: Where does MySQL store it database files

Thanks for the info
by mister_v
Sat Sep 01, 2012 8:52 pm
Forum: Servers
Topic: convert MySQL db from Latin1 to UTF8
Replies: 1
Views: 30301

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 ...
by mister_v
Sat Sep 01, 2012 8:52 pm
Forum: MySQL
Topic: Solved: convert MySQL db from Latin1 to UTF8
Replies: 7
Views: 134300

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 ...
by mister_v
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

Code: Select all

CREATE TABLE test
(
  id VARCHAR(40) PRIMARY KEY,
  value BIT DEFAULT 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?
by mister_v
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...
by mister_v
Wed Aug 22, 2012 7:28 am
Forum: Servers
Topic: Where does MySQL store it database files
Replies: 2
Views: 31647

Where does MySQL store it database files

Hi,

does anyone knowns where MySQL stores the database files?

Thanks,
by mister_v
Wed Aug 22, 2012 7:28 am
Forum: MySQL
Topic: Where does MySQL store it database files
Replies: 2
Views: 24676

Where does MySQL store it database files

Hi,

does anyone knowns where MySQL stores the database files?

Thanks,
by mister_v
Thu Aug 16, 2012 6:19 pm
Forum: PHP
Topic: Solved: How to open 2 mysql databases in php
Replies: 2
Views: 23109

Re: How to open 2 mysql databases in php

Thanks
Didn't know about the 4th parameter true.

Go to advanced search