How to fetch the first 2 or 3 rows from Mysql DB using Mysql PHP function?
How to fetch the first two rows from Mysql DB using Mysql PHP function? Is there any function which can give me first 2 or 3 rows from the select query we fired? ...
mysql
Architectural advice on connecting multiple diverse sites into a single community.
Hi SO, I've been given a task to connect multiple sites of the same client into a single network. So i would like to hear an architectural advice on connecting these sites into a single community. These sites include: 1. Invision Power Board Forum (the most important site) 2. 3 custom made cms-s (changes to code allowable) 3. 1 drupal s...
How to handle transaction process in Mysql database. When my database gets interrupted?
I have executing 10 query in my stored procedure. In case after executing the 5 Th query my database get interrupted and its stooped the execution. My first 5 query updated in database.so i have to rollback all the 5 query's execution. How to solve this kind of problems? ...
MySqlDataReader giving error at build
Hey there. I have a function in VB.net that authenticates a user towards a MySQL DB before launching the main application. Here's the code of the function: Public Function authConnect() As Boolean Dim dbserver As String Dim dbuser As String Dim dbpass As String dbserver = My.Settings.dbserver.ToString dbuser = My...
Database choices
I have a prickly design issue regarding the choice of database technologies to use for a group of new applications. The final suite of applications would have the following database requirements... Central databases (more than one database) using mysql (must be mysql due to justhost.com). An application to be written which accesses the...
MySQL: Blank row in table after LOAD DATA INFILE
Hi, I'm uploading a large amount of data from a CSV (I'm doing it via MySQL Workbench): LOAD DATA INFILE 'C:/development/mydoc.csv' INTO TABLE mydatabase.mytable CHARACTER SET utf8 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r'; However, I'm noticing that it keeps adding an empty line full of nulls/zeros...
PHP/ MySQL: What is the best way to get filtered data from a database that has been inputted by a logged in user?
I am trying to create a page that displays a preview of all the data that each individual user has put into the database. Each user must only be able to see their own data. I have been using $SESSION's to post which logged in user is inputting what, and have tried to get my brain to think about the reverse action. I first wondered whe...
Need help with some complex SQL query
Hello guys, I need some help with a complex SQL query. Here's my setup: there are two tables, one with authors, and another with books. The books table contains a field named "author" which holds author's id. If a book has more than one author, then the "author" field will contain all the authors ids separated by ";" (something like 2;3...
How to Bookmark a query in PHPMyAdmin
I'm trying to bookmark a query for another user in PHPMyAdmin using the built in bookmarking feature and I don't have the option to save the current query I'm viewing the results for. It works on my local host but not on the live server. I've setup a database for PHPMYAdmin and an authenticated user with permissions. Is there an on sw...
T-SQL OPENQUERY to MySQL - Insert ID
I am using OPENQUERY to do an insert from MSSQL 2005 to MySQL. How do I get at the last inserted id on the MySQL db back into my MSSQL procedure? ...
PHP PEAR updating record with unique or primary fields
I have a PHP script that uses PEAR to access and update a MySQL table (below). The table has 2 primary key pair: code_class & code_value. I'm trying to update a table record with a code_value of "APP" to "APPL". A relatively simple task, right? But with PEAR, it seems like the primary key is throwing a wrench into task and rather tha...
MySQL 5 left join unknown column
I had the below query working in mysql 4.1, but does not in 5.0: SELECT * FROM email e, event_email ee LEFT JOIN member m on m.email=e.email WHERE ee.email_id = e.email_id The error: 1054 (Unknown column 'e.email' in 'on clause') ...
howto have condition in a nested SQL query?
here is my SQL statement , i would like to find all the games that have the status 0 and names of teams that are like key_word or the sport's name that are like the key word. The problem is that all the games that are displayed don't have status 0 . What am i doing wrong? sql="select * from games where games.status=0 and games.team_2_id...
SQL with HAVING and temp table not working in Rails
I can't get the following SQL query to work quite right in Rails. It runs, but it fails to do the "HAVING row_number = 1" part, so I'm getting all the records, instead of just the first record from each group. A quick description of the query: it is finding hotel deals with various criteria, and in particular, priortizing them being pa...
access: implementing autonumber type in mysql
i have a database that is in access and i am converting it to mysql in access there is a type called autonumber. is there such a thing in mysql? if not, what would be an easy way to implement such a type (or not necessarily implement the type but to have the same functionality) ? ...
Trouble creating stored procedure
I'm messing around with stored procedures for the first time, but can't even create a simple select! I'm using phpMyAdmin and this is my SQL: DELIMITER // CREATE PROCEDURE test_select() BEGIN SELECT * FROM products LIMIT 10; END // DELIMITER ; After submitting that, my localhost does some thinking for a loooong time and eventuall...
Maximum capabilities of MySQL
How do I know when a project is just to big for MySQL and I should use something with a better reputation for scalability? Is there a max database size for MySQL before degradation of performance occurs? What factors contribute to MySQL not being a viable option compared to a commercial DBMS like Oracle or SQL Server? ...
php, mySQL - how to create a table?
Hi guys, I have written a code that should check weather there is a table called imei.$addimei and, if not, create it... $userdatabase = mysqli_connect('localhost', 'root', 'marina', 'imei'); ... $result = mysqli_query($userdatabase, "SELECT * FROM imei".$addimei."" ); if ( !$result ) { echo('creating table...'); /// if no such table, m...
mysql: inserting data and autoincrement
i am converting from access to mysql i have a table in access where one of the columns is an autonumber when i transfer the data into the mysql database (where i also have a column that is auto_increment), should i be transfering the auto_increment data into the auto_increment column, or will it auto_increment itself? how do i ensure...
best way of importing data into mysql
i have a table with 500,000 rows and about 10 columns that is in access how do i import it into mysql? ...