Search found 192 matches

Go to advanced search

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

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: 30044

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: 134031

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: 17819

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: 17605

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: 31425

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: 24454

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: 22851

Re: How to open 2 mysql databases in php

Thanks
Didn't know about the 4th parameter true.
by mister_v
Thu Aug 16, 2012 6:50 am
Forum: PHP
Topic: Solved: How to open 2 mysql databases in php
Replies: 2
Views: 22851

Solved: How to open 2 mysql databases in php

Hi,

I want to access 2 MYSQL databases from the same php script.
Without closing one and opening the other one.
I want to select queries from both databases at the same time.

Thanks
by mister_v
Fri Jun 15, 2012 1:54 pm
Forum: HTML
Topic: max width of a table
Replies: 1
Views: 23361

max width of a table

Hi, The content of my HTML-pages are always in table, because it is easy to place the content, the menu and other stuff. I used to set the width of the table to 100% so the entire page is filled. This was ok for screens of 1024x768 and 1280x960. But it doesn't look so good on 1600x900 and bigger scr...

Go to advanced search