Top "Mysql" questions

Get table names using SELECT statement in MySQL

In MySQL, I know I can list the tables in a database with: SHOW TABLES However, I want to insert …

mysql

A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1

public class LoginCumReg implements ActionListener,KeyListener { private JFrame form; private JTextField txtunm; private JTextField txtnm; private JTextField txteml; private JButton …

java mysql eclipse java-native-interface

Access mysql remote database from command line

I have a server with Rackspace. I want to access the database from my local machine command line. I tried …

mysql shell mysql-error-2003

MySQL show status - active or total connections?

When I run show status like 'Con%' it shows the number of connections, which is 9972 and constantly growing. Is …

mysql connection

Select last row in MySQL

How can I SELECT the last row in a MySQL table? I'm INSERTing data and I need to retrieve a …

mysql

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_…

php mysql database phpmyadmin localhost

Cannot delete or update a parent row: a foreign key constraint fails

When doing: DELETE FROM `jobs` WHERE `job_id` =1 LIMIT 1 It errors: #1451 - Cannot delete or update a parent row: a …

mysql sql

Cannot add or update a child row: a foreign key constraint fails

table 1 +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | UserID | …

mysql

JSON encode MySQL results

How do I use the json_encode() function with MySQL query results? Do I need to iterate through the rows …

php mysql json

MySQL query to get column names?

I'd like to get all of a mysql table's col names into an array in php? Is there a query …

php mysql