photo

Piyush Kumar


Active since 2024

Followers: 0   Following: 0

Statistics

  • Knowledgeable Level 4
  • 6 Month Streak
  • First Answer

View badges

Feeds

View by

Answered
Connecting Matlab to Redshift Databases
Hi, You can use the Database Toolbox in MATLAB. As mentioned in the documentation - "Database Toolbox connects to any relationa...

2 months ago | 0

Answered
How I can read .dat file and store its value in MYSQL table.
Hi, You can read the ".dat" file using the fopen and textscan functions. For example, % Create sample data data = {'John', ...

2 months ago | 0

Answered
Hello guys i m having trouble in making a database in matlab, can anyone guide me through..
Hi, Creating a database to store number plate data with timestamps and linking it with MATLAB can be achieved using several typ...

2 months ago | 0

Answered
Problem using SQL 'except' command in Matlab Datbase Toolbox
Hi, The error message suggests that there is a problem with the dimensions of the matrices being concatenated. This can happen...

2 months ago | 0

Answered
How to Deal with a jdbc4array?
Hi, To handle a jdbc4array in MATLAB more efficiently, you can directly convert the Java array to a MATLAB array using Java met...

2 months ago | 0

Answered
How can I insert image from Matlab to mysql database?
Check this link.

2 months ago | 0

Answered
How to handle large data using matlab ?
Hi, Check the documentation link of datastore in MATLAB. The datastore function creates a datastore, which is a repository for...

2 months ago | 0

Answered
date as parameter in sql query and today
Hi, To use a date as a parameter in an SQL query in MATLAB, you need to ensure the date is formatted correctly and passed into ...

2 months ago | 0

Answered
Using 'LIKE' in database explorer to select variables corresponding to substring.
Hi, The query you have shared should work as expected, selecting all records where the date column starts with ‘2014-01-01’. If...

2 months ago | 0

Answered
how check null value the text input at GUI?
Hi, To check if an EditText in a MATLAB GUI is empty and show a warning message if it is, you can use the following steps - G...

2 months ago | 0

Answered
ODBC problems at writing data in the Mysql database on windows 10
Hi, The issues you are facing might be due to various reasons. You can try the following troubleshooting steps - Check Data T...

2 months ago | 0

Answered
Protocol violation: [54] Database Toolbox
Hi, This error often occurs due to issues with the JDBC driver or the way the database connection is being handled. Here are so...

2 months ago | 0

Answered
Inserting data into MySQL
Hi, The error message "Row size too large" is a known issue with MySQL and MariaDB when dealing with large rows, especially whe...

2 months ago | 0

Answered
How to connect to MySQL with SSL certificates
Hi, To connect to a MySQL database with SSL certificates, the method depends on the tool or language you're using: Command Lin...

2 months ago | 0

Answered
Is there any way of counting the number of rows writtend to the database with sqlwrite?
Hi, To get the number of rows written to the SQL server database with sqlwrite, you can use sqlread before and after using sqlw...

2 months ago | 0

Answered
How Can I connect matlab with my sql in other pc
Hi, To connect MATLAB to a MySQL database on another PC, you’ll need to ensure a few things are set up correctly. 1. Find the ...

3 months ago | 0

Answered
how to establish a connection of oracle10g database with MATLAB?
Please check this JDBC Connection to Oracle DB - MATLAB Answers - MATLAB Central.

3 months ago | 0

Answered
JDBC Connection to Oracle DB
Hi, The error you're encountering may be due to the JDBC driver not being included in the MATLAB search path. To resolve this,...

3 months ago | 0

Answered
Selecting fields from a sql stored procedure
Hi, I couldn't find a way to write a SQL query that directly achieves the desired filtering. However, If you want to call a st...

3 months ago | 0

Answered
How to create MySQL Database using matlab?
@Naseef Rahman, To programmatically create a MySQL database using MATLAB, follow these steps: Establish a Database Connection:...

3 months ago | 0

Answered
Get foreign keys for database table
Hi, To get foreign keys for a table in a MySQL database, you can query the INFORMATION_SCHEMA.KEY_COLUMN_USAGE table. Here's t...

3 months ago | 0

Answered
Matlab JDBC drivers - How to pass a table variable equivalent to an SQL stored procedure
Hi, Please check the list of data types supported by MySQL. Passing MATLAB Data to MySQL Stored Procedure Using JSON If you n...

3 months ago | 0

Answered
executeSQLScript maximum allowable character vector length error
Hi, The error you're encountering is due to a limitation in the executeSQLScript function, which cannot process SQL scripts ex...

3 months ago | 0

Answered
Varaibles types in MATLAB and SQL
Hi, To control the number of decimal places when exporting data from MATLAB to a SQL database, you can use MATLAB's sprintf fu...

3 months ago | 0

Answered
Adding Geo-referenced Map as Background in MATLAB Plot
@Elio, To add a geo-referenced map as a background to your MATLAB plot, you can follow these simple steps - Load the Geo-refe...

3 months ago | 0

Answered
connecting to a remote mysql database using jdbc connector (Mac)
Hi, Database Toolbox connects to any relational ODBC-compliant or JDBC-compliant database using ANSI SQL. To connect to Databas...

3 months ago | 0

Answered
how i can change my color of picture i want yellow one?
@salim saeed, To plot a figure you have shared, you would need the function that is plotted. There is an inset plot in the figu...

3 months ago | 1

Answered
Simultaneously get output and plot using RF Propagation Toolbox functions
@Alex B, As per the documentation for the link function, there are 2 different ways of calling the same function to display the...

3 months ago | 0

| accepted

Answered
How to store Image along with data in MySQL database?
Hi, To store an image along with other data in a MySQL database, follow these steps: 1. Create the Table CREATE TABLE images ...

3 months ago | 0

Answered
Can I connect to cloud sql from google cloud platform (Mysql)
Connecting to AWS RDS from MySQL Workbench and MATLAB Database Explorer You can easily connect to databases hosted on cloud ser...

3 months ago | 0

Load more