This query keeps failing with Integrity constraint violation: 1048 Column 'login_name' cannot be null My insert statement is... $insertUserQuery = 'INSERT INTO `users` ( `login_name`, `password`, `first_name`, `last_name`, `company_n...
Is it possible to create more than one table at a time using single create table statement. ...
Hello All, I've just moved a forum from BradPPresents.com to BradP.com. May not be SFW. It's located at forum.bradp.com. I'm getting a Database connection error, despite being absolutely sure about the username and password of the database. Here's the VBulletin Configuration file, with the username and password masked. <?php ...
What is the maximum size of a MySQL database in version 5 and up? I do not mean the maximum size of row or table, but the maximum size of the whole database. ...
There is requirement in application which states that find out all the objects that are bounded to specific country and/or city into the google map. We have objects with respective latitude and longitude precalucated using google map api and stored in database. Some times these objects are provides service withing certain service range/...
I need to use PHP to copy data from one MySQL database to another. I can build and array of all the values to go into the other database but first I want to make sure the database has the correct fields before inserting. For example say I am going to be copying data from tableA to tableB. I can set up tableB to look just like table...
I'm trying to configure nHibernate to use a MySql database. I found examples for mssql and sqlite but none for mysql. So, how do I change this so it uses mysql: Fluently.Configure().Database( MsSqlConfiguration.MsSql2005.ConnectionString( c => c.FromConnectionStringWithKey("ConnectionString") ) ) .Map...
I'm having trouble connecting CS3 Dreamweaver to the mySQL db running inside Sun Virtual Box ...
Hi, I need to retrieve data from several rows and then insert the results into an enumerated array so then I can use a "for" loop to echo it... I have this (I already connected to the database): $genres_sql = 'SELECT genreID FROM genres WHERE imdbID = ?'; if ($stmt->prepare($genres_sql)) { // bind the query parameters $stmt->bind_par...
According to the MySQL .Net connector docs, when running prepared statements, the @ symbol is used to defined a paramter. When trying this I got an error. Then the user comment at the bottom of the page says if you have problems, substitute the ? for the @ character. Is there any way to control what character MySQL expects for prepare...
I am writing a PHP/MySQL program and I would like to know how to search across multiple tables using MySQL. Basically, I have a search box as in the top right of most sites, and when user's search something in that box, it needs to search in users.username, users.profile_text, uploads.title, uploads.description, sets.description and com...
I'm creating a MySQL Stored Procedure with a few cursors. I want to make sure the Insert/Update statements it will ultimately generate are correct before making it live. I searched and could not find a PRINT or similar method to have it just send output back to the client, in my case SQLyog Enterprise. I tried declaring a variable as T...
I have a datetime column in a MySQL table and I'd like to select records that have the same year, month, and day (but perhaps different hour and minutes). In other cases, I'd select ones with the same year and month. Is there a way to do that? ...
Hi, It will be easier to explain with the next code (It's wrong, by the way): $selectGenre_sql = 'SELECT genreID FROM genres WHERE dbGenre = ?'; if ($stmt->prepare($selectGenre_sql)) { // bind the query parameters $stmt->bind_param('s', $genre); // bind the results to variables $stmt->bind_result($genres); // execute the ...
I'm looking to scale an existing phpBB installation by separating the read queries from the write queries to two separate, replicated MySQL servers. Anyone succeeded in doing this, specifically with phpBB? The biggest concern I have so far is that it seems like the queries are scattered haphazardly throughout the code. I'd love to hear ...
I have always hoped and assumed that it is not - that set theory (or something) provides a shortcut to the result. I have created a non-updateable view that aggregates data from several tables, in a way that produces an exponential number of records. From this view, I query one record at a time. Because the underlying dataset is small, ...
How can I show a date popup box that formats the date so it will fit in the mySQL date field? Also, how can I check or format time to fit in the mySQL time field? ...
I am developing a Digg like site and I want the title of the comments page to match the link title, here its the comments file code: class CommentsPage extends Page { function __construct($title = '') { $this->setTitle($title); } function header() { parent::header(); } function showAllComme...
We have a MySQL database (mostly read-only, so MyISAM tables) living in the data center that talks to a SQL Server DB living on-site. There is some significant latency in the WAN (upwards of 100ms); in about 6 months the SQL Server DBMS will be moving up to the data center (e.g. same gigabit LAN). In the MySQL DB, I have several thousan...
What is is the best SQL data type for currency values? I'm using MySQL but would prefer a database independent type. ...