|
Hello;
This is the scenario:
I have a MySQL server with a database, let's call it consolidateddb . This database a consolidation of several tables from various databases I have another MySQL server, with the original databases, these databases are production...
Started by Moutaz on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
I don't think MySQL provides any built-in way to move replication statements between databases it by manually altering the....
MySQL statement-based replication (basic replication) works by running the exact same statements was in.
|
|
I am working on a project needing me to work with multiple database connections. From what I have read, I should be able to switch between connections in the query itself, something like:
mysql_query("SELECT * FROM user_types", $db_core)or die(mysql_error...
Started by kilrizzy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use the db.table syntax in the query:
mysql_query("SELECT * FROM databas_ename.table_name", $db_core) or die(mysql_error());
The code you have in your question should work, except when both databases are on the same server....
|
|
I have table in mysql database which have field with datatype is datetime.
I want to save the datetime in this minute, for this I use " Now() ", but it does not work,
It just save in databaes.
Started by Hashim Al-Arab on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For more options see http://php.net/manual/en/function.date.php
If you've got a timestamp in PHP ... .
(Now(), ...)
without additional quotes around the function Now() date("g") this will return 12-hour format of an hour without leading zeros .
INSERT ...
|
Ask your Facebook Friends
|
Hi, I have in the database words that include special character (in Spanish mostly, like tildes). In the database everything is saved and shown correctly with PHPmyAdmin, but when I get the data (using PHP) and display it in a browser, I get a weird character...
Started by Jonathan on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
"); $mysqli->query("SET NAMES 'utf8'");
Have MySQL translate it automatically
$conn = mysql_connect('host', 'user', 'password'); mysql_set_charset('utf8',$conn);
http://es.php.net/manual/en/function.mysql-set-charset.php
EDIT:....
|
|
Hello,
I read in the User Guide / Welcome / Big Picture / How it Works section that “content is stored in a database”.
Let me begin by saying that my knowledge of database technology is limited but improving.
Regarding the MySQL on EE’s sister company...
Answer Snippets (Read the full thread at expressionengine):
That begin said, MySQL can store a lot of data before.
But they are synced to the database as well.
|
|
For whatever reason, the "mysql" database on my windows mysql installation has been deleted. I now have a mysql install that cannot start because the system database is missing, but I cannot find any documentation on recreating this database.
How do I...
Started by Chris on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Unfortunately, according....
On Unix, you would move your existing database data directory out of the way and run mysql_install_db.
Here's an sql dump from my mysql table: http://www.box.net/shared/js92gum4gh .
Reinstall MySQL.
|
|
How do you create a database backup of a mysql database in VB.Net?
Answer Snippets (Read the full thread at stackoverflow):
I would write a stored proc, since MySQL 5 the mysql command instead....
You can read each table's data and write it to a new database.
You could invoke mysqldump, but you may need to be running your VB.NET on the Mysql server.
|
|
Well, I am going to design a database structure, but I don't know where to start. Can you guys help me by answering the following questions? My database is going to store about hundreds of thousands rows/data and serving 1000 ++ users at the same time...
Started by bbtang on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You guys design a mysql database structure? Must I study normalization first? I suck at this topic are the important things in designing mysql database structure?
Plan ahead, I would seriously consider creating, what are the....
|
|
Hejsan!
Det är så att jag jobbar på ett litet projekt på fritiden som kommer ha upp mot en 10-15 slutanvändare(bara kompisar). Och jag tänkte på det här med databaser, har inte mycket koll på mySQL så jag tänkte använda txt filer(eller dat?), frågan är...
Started by laekerowl on
, 11 posts
by 5 people.
Answer Snippets (Read the full thread at flashback):
databaser, har inte mycket koll på mySQL så jag tänkte använda txt filer(eller dat?), frågan är om det är stort nej på denna? Att man måste köra riktig databas för säkerhet osv?
Sen har jag en till bra idé att testa dig fram med ....
|
|
Hello there,
I'm confused when trying to fetch table rows in mysql using C++ with MySQL C API.
I can do it easily in PHP, just because C++ is a strongly-typed language so that we also need to take care of the dirty process..
This is how I done it in PHP...
Started by djzmo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
So, your code should be something like:
mysql_query(sqlhnd, "SELECT * FROM `my_table`"); MYSQL....
In the MySQL C API, mysql_fetch_row returns a MYSQL_ROW object, which is essentially an array of values in the current row.
|
