Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
2answers
20 views
MySQL - Error Code: 1005. Can't create table 'database_name.#sql-776_f23d' (errno: 150)
I have the following:
CREATE TABLE afil2 (
id bigint(20) NOT NULL AUTO_INCREMENT,
`apellido` varchar(30),
`nombre` varchar(30),
documento varchar(30),
PRIMARY KEY (`id`)
);
ALTER ...
0
votes
1answer
23 views
Get result from two mysql tables using group
I'm looking for a solution to get result from two MYSQL tables
First table is: rate_table
`id` int(11) NOT NULL auto_increment,
`rate` float(5,4) NOT NULL,
`amount` float(12,2) NOT NULL,
INSERT ...
-2
votes
2answers
16 views
select and determined by multiple row value
Say I have a table people, a table fruit and a table likes.
People fruit likes
+-----+--------+ +-----+---------+ +-----+-----+
| pid | people | | fid | name | ...
0
votes
1answer
11 views
build setup file for Windows application by including DB?
I have created windows application using windows c#.net and ms sql server 2008. And i am going to build setup file including database. Is that possible to build a setup including DB with out ...
0
votes
2answers
14 views
Unable to insert values to mysql using python
I am trying to insert values to mysql using python but the code is not working, its returning a blank page & no values written in database table, Please help me
import MySQLdb as mdb
con = ...
0
votes
3answers
21 views
Vertical Menu using mysql wont display data
I am by no means an exoert I am just trying to get my head round php and mysql to create a blog for our animal rescue centre. I am trying to create a verticle menu using a 'title' and 'link' field ...
0
votes
1answer
12 views
Applet JDBC Connection Failed on Client Machine
My self-signed applet perfectly works on applet viewer and my local web browser. However, when I change connection strings according to the db name, user and password for the mysql database on the ...
0
votes
1answer
14 views
How to find the first and last ID of MYSQL Table Enteries for a specific date?
I want to get the range of entries by their IDs created in a MYSQL table on a specific date in a PHP file. How can this be achieved? If required, assume there is a column in the database that lists ...
0
votes
0answers
10 views
Insert Ignore implementation using jpa
My application allows users to either manually enter an id in my javafx form or allows them to pick an automatic id checkbox so the system (database) may generate the id for them.
The mysql table has ...
0
votes
1answer
14 views
PHP If mysql INSERTS record then refresh parent page from iframe
I have an iframe which submits data to the database using MYSQL (an insert query). Is it possible to refresh the parent frame (not the iframe) if something is submitted to the database?
I was ...
1
vote
0answers
25 views
Safe and secure Object Oriented insertion with PDO
Safe and secure Object Oriented insertion with PDO
is this code secure against SQL injection?, it uses prepared and parametrized statement. if not then what should i do because i only want to use it ...
-2
votes
1answer
26 views
UTF 8 (unicode) not working
I made the mistake in generating my tables with the standard collation.
After switching to utf8 german letters are not displayed correctly.
I already made followging steps with no effect:
In Header:
...
0
votes
3answers
25 views
Cannot insert into database using php and mysqli_query
I'm having a really weird issue as well as a stressful time trying to figure this out.
Using a form, I was trying to insert data into my database. The initial SQL query had variables for values, but ...
1
vote
3answers
26 views
Create an ID based on integer with letter
I have a database containing messages with an "id" column in integer auto increment. Classical. But I would like to create a "visual" id based on this integer id. This is what I want :
A0001
A0002
...
2
votes
3answers
20 views
CodeIgniter Fetching Records From More Than Two Tables
I'm developing an application, Where in I've defined following tables.
storytags
id cover_title user_id
1 love happens two times? 1
2 revolution 2020 2
3 ...
